Title: Senior Data Provisioning & Reporting 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 Provisioning & Reporting 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. This position will also 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:

• Collaborate with leaders to identify data requirements and ensure data deliverables are accurate, efficient and align with business objectives
• Lead and coordinate data analysis, reporting, and audit activities for assigned clients or projects
• 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
• Design and implement data-driven solutions to optimize processes, performance and leverage technology.
• 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.
• Collaborate to rationalize and standardize cross-platform data analysis
• Manage assigned risks and monitor potential impacts.
• Develop reports and presentations to communicate findings and insights to partners and leadership.
• 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
• Provide coaching and mentorship to team members and technical review of the work of others.
• Provide technical expertise to clients and colleagues in data analysis methodologies and tools
• Build relationships with clients and partners and collaborate to identify and solve problems and implement solutions.
• Work with vendors and external partners to exchange information on processes, data usage, enhancements, etc.
• Partner with TG data engineers to optimize data structures and improve accessibility.
• Stay current on, and ensure compliance with relevant legislation, policies, and regulations related to data management and privacy.
• Identify emerging trends and opportunities in the data analytics field and provide recommendations on how to leverage these to enhance the organization's data analytics capabilities.
• Identify opportunities for continuous improvement and provide recommendations to automate data processes, improve quality and efficiency
• Actively participates in and contributes to data governance and management forums

What we are looking for:

• minimum of 6-9 years experience and a 3-year college diploma or university degree and/or an equivalent combination of education and experience.
• Deep understanding of basic statistical concepts and data analysis techniques.
• Proficiency in standard computer applications (Microsoft Office Suite) and Excel (e.g. macros, VBA, functions, pivot tables, formulas, and charts).
• Advanced proficiency in SQL for data extraction, transformation, and optimization.
• Advanced experience and skills in data visualization techniques and software (e.g., Power BI or similar)
• Experience using Python or R for data manipulation, automation, and statistical analysis.
• Knowledge of cloud-based data platforms (e.g., Azure, AWS).
• Understanding of ETL (Extract, Transform, Load) processes and data pipeline automation.
• Experience with and understanding of best practices around data management concepts, including data quality, data cleansing, standardization, metadata management, privacy, and security governance.
• Knowledge of the business area, to inform design of meaningful and focused analytics, KPIs and visualization
• Ability to identify complex problems, analyze interrelated factors, assess and mitigate risks, and develop solutions using specialized skills
• Communication and influence skills to gather perspectives, understand needs, and present information to reach consensus, often in somewhat sensitive situations.
• Ability to provide guidance to others and ensure work is completed in compliance with applicable data and privacy policy and legislation

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