Title: Senior Data Analyst - Information Management, Humanitarian Services

Employee Working Location: Partially Virtual / Hybrid

Employment Status: Permanent Full-time

The Canadian Red Cross (Red Cross) - an inspirational not for profit organization, helps people and communities in Canada and around the world in times of need and supports them in strengthening their resilience. As a Canada's Best Employers 2024, we are committed to having an accessible, diverse, inclusive, and barrier-free work environment.

The Senior Data Analyst plays a critical role in driving data-informed decision-making by performing advanced data analysis, developing reports, and optimizing data processes. This position works with large datasets, designs dashboards and other data visualizations, and provides analytics results to support business strategies. They collaborate with cross-functional teams, gather requirements, ensure data quality, provide meaningful insights, and contribute to the development of best practices in humanitarian data and analytics.

In this role, you will:

• Design and implement data-driven solutions to optimize processes, performance and leverage technology using a variety of data tools such as Power BI, SQL, Python, Microsoft Power Platform, Databricks
• Collaborate with cross-functional teams and leaders to identify and document data requirements and ensure data deliverables are accurate, efficient and align with business objectives
• Develop sophisticated visualizations and dashboards to communicate data insights to stakeholders and make data accessible
• Develop reports and presentations to communicate findings and insights to partners and leadership.
• Apply advanced analytical techniques to identify trends, insights, and areas for improvement.
• Create and maintain accurate and up-to-date documentation of data processes, requirements, and specifications.
• Build relationships with clients and partners and collaborate to identify and solve problems and implement solutions.
• Partner with data engineers to optimize data structures, improve accessibility and standardize cross-platform data analysis
• Act as a data ambassador, promoting a data-driven culture across the organization and implementing best practices for data governance, data quality assurance, and documentation based on established organizational standards

What we are looking for:

• 4-7 years of experience in a relevant data analysis role and a 3-year college diploma or university degree and/or an equivalent combination of education and experience.
• Fluency in English is required, French is an asset.
• Advanced experience and skills in data visualization techniques and software (e.g., Power BI or similar)
• Advanced proficiency in SQL for data extraction, transformation, and optimization.
• Experience using Python or R for data manipulation, automation, and statistical analysis.
• Understanding of ETL (Extract, Transform, Load) processes and data pipeline automation.
• Deep understanding of statistical concepts and data analysis techniques.
• Experience with and understanding of best practices around data management concepts, including data quality, data cleansing, standardization, metadata management, privacy, and security governance
• Communication and influence skills to gather perspectives, understand needs, and present information to reach consensus in a fast paced and changing environment
• Proficiency in standard computer applications (Microsoft Office Suite) and Excel (e.g. macros, VBA, functions, pivot tables, formulas, and charts).

Working Conditions:

• Work will be conducted in an office-like setting.
• May require travel to safe locations; limited exposure to adverse conditions.
• Work requires the ability to work to deadlines.
• Requires significant attention to detail and concentration and ability to mentally process large amounts of information.
• The work pace is often unpredictable with significant time pressures.
• Ability to adapt to frequent and often urgent changes in priorities, and make decisions under pressure, work at an unpredictable pace.
• As we work with and support people (managers, colleagues, beneficiaries/customers, volunteers, donors and external partners) and communities in Canada and around the world, applicants whose first language is not English may be required to perform the responsibilities of the role in English.
• Eligibility to work in Canada. At this time, we welcome applications from candidates eligible to work in Canada. If you are not a citizen or permanent resident of Canada, we encourage you to carefully review your visa to find out whether you are eligible to work in the job you are considering applying for. Refer to our FAQ for more information.
• If you are selected for this role, you will be required to complete a successful pre-employment screening process which includes a satisfactory Enhanced Police Information Check (E-PIC).