(INSTRUCTIONS TO APPLY AT THE BOTTOM OF POSTING)

Are you looking to use your data & technology expertiseto help drive insights that will have a direct impact on the lives of children?
Consider joining UNICEF Canada –* one of Canada’s most respected and historic charities – and be part of a high-impact, mission-driven team *working across Canada and globally to create a better world for children.
UNICEF Canada is seeking to recruit a talented & high-performing individual
in the role of Senior Business Analyst.

POSITION DESCRIPTION

The Senior Data Analyst is responsible for delivering accurate and actionable data to support programs that drive fundraising growth, strengthen supporter engagement, and inform organizational decision-making. This role combines technical expertise with strategic business analysis to optimize the organization’s use of technology, data, and fundraising systems.
A key member of the Business Intelligence team, the Senior Data Analyst contributes to managing UNICEF Canada’s Constituent Relationship Management (CRM) system, using it as a source of truth to support program management, performance measurement, and key donor insights.
The Senior Data Analyst uses their strong Structured Query Language (SQL) and Business Intelligence (BI) visualization skills to build and maintain dynamic dashboards, develop a variety of reports, and generate sophisticated data pulls to provide audience segmentation and identify supporter engagement activities. They work closely with our fundraising, marketing, and IT teams to identify trends, develop insights, and optimize donor engagement strategies.
This role is ideal for a data-driven professional who combines technical proficiency with a strategic mindset, ensuring that data and technology are leveraged to maximize fundraising impact and deepen supporter engagement.

QUALIFICATIONS

• Bachelor’s degree in a relevant field (e.g., Statistics, Mathematics, Computer Science, Engineering, IT, Business) with a minimum of 5 years’ work experience as a Data Analyst or in a similar role. Experience in fundraising and development is an asset.
• Strong SQL proficiency, including ability to perform complex data querying for data extraction and manipulation, building and maintaining SQL tables, views and stored procedures, and optimizing SQL scripts
• Proficient working with data warehouse, creating data models based on reporting needs
• Strong hands-on experience with Power BI, including designing, implementing, and automating reports, dashboards and apps (Power BI certification would be an asset).
• Proficiency in writing DAX formula and/or M code (Power Query) for measures creation and data transformation.
• Knowledge of Power BI Desktop and Power BI Service, and report/dashboard deployment, sharing, security, and maintenance.
• Experience working with SQL Server database and services (i.e., SSRS, SSIS) and troubleshooting database issues.
• Advanced Excel skills (e.g. formulas - VLOOKUP, nested IF statements), pivot tables, data validation.
• Familiarity with ETL processes and tools for data preparation and transformation.
• Experience in data analysis programming languages (e.g., Python, R) and good knowledge of machine learning and predictive modeling.
• Strong data analysis skills and the ability to quickly learn new data models and translate business requirements into actionable insights.
• Ability to create compelling and effective visualizations to convey complex information.
• Ability to work collaboratively with cross-functional teams, including data integration developers, data analysts, IT, fundraising teams and marketing.
• Experience in planning and delivering user training for new BI products.
• Ability to create and maintain process-related documentation.

AN INCLUSIVE & PURPOSE-DRIVEN WORKPLACE

• Centrally located head office in mid-town Toronto with satellite offices in Calgary & Montreal
• Easily accessed by public transit and a short walk from several parking locations
• Inclusive & accessible co-working and meeting spaces designed to foster purpose at every turn and accommodate the diverse needs of employees