Senior Data Analyst

Title: Senior Data Analyst

Employee Working Location: Partially Virtual / Hybrid (Canada)

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 visualizations, and provides analytics results to support business strategies. They collaborate with cross-functional teams, ensure data quality, provide meaningful insights, and contribute to the development of best practices in data management and analytics.

In this role you will:

• Qualifications include a minimum of 6-9 years experience and a 3-year college diploma or university degree and/or an equivalent combination of education and experience. May require a graduate diploma/degree in a related field and/or a professional degree, certification, or designation. Requires expertise in a specialized discipline or broad experience across fields, along with an understanding of interconnections between processes and business units.
• Proficiency in Python specifically for data manipulation, ETL automation, and processing large flat-file datasets (e.g., Pandas)
• Advanced proficiency in Power BI, including strong skills in Power Query (M) for data transformation and DAX for measure creation.
• Demonstrated experience establishing data governance frameworks, including creating data dictionaries, SOPs, and data quality standards.
• Understanding of ETL (Extract, Transform, Load) processes, specifically automating data pipelines from file-based sources (CSV, Excel, API exports) to reporting tools.
• Proficiency in standard computer applications (Microsoft Office Suite) and Excel (macros, VBA).
• Strong understanding of relational data modeling and database concepts.
• Ability to act as a technical mentor to junior analysts, specifically regarding documentation and coding best practices.
• Communication and influence skills to gather perspectives, understand needs, and present information to reach consensus, often in somewhat sensitive situations.
• Ability to identify complex problems, analyze interrelated factors, assess and mitigate risks, and develop solutions using specialized skills.
• Proficiency in SQL is considered an asset.

What we are looking for:

• Collaborate with leaders to identify data requirements and ensure data deliverables are accurate, efficient and align with business objectives.
• 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
• Create and maintain accurate and up-to-date documentation of data processes, requirements, and specifications.
• Perform source system data analysis in order to manage source to target data mapping and ensure that mapping is up to date.
• Build relationships with clients and partners and collaborate to identify and solve problems and implement solutions.
• Design and implement data-driven solutions to optimize processes, performance and leverage technology.
• Identify opportunities for continuous improvement and provide recommendations to automate data processes, improve quality and efficiency.
• Apply advanced analytical techniques to identify trends, insights, and areas for improvement.
• Develop sophisticated visualizations and dashboards to communicate data insights to stakeholders and make data accessible.
• Lead and coordinate data analysis, reporting, and audit activities for assigned clients or projects
• Collaborate to rationalize and standardize cross-platform data analysis.
• Support the development of performance indicators.
• Actively participates in and contributes to data governance and management forum.

Working Conditions :

• 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).