Impact Starts at UNICEF Canada
Instructions to apply at the bottom of posting)
Position Details
Position Title :
Employment Type :
Permanent, Full-timeReports to :
Deputy Director, Business Intelligence – Business Solutions & Technology TeamDirect Reports :
NoneSalary Range :
70,500 to $85,500 annually with benefits and 3 weeks paid vacationWork Location :
TorontoWork Environment :
UNICEF Canada currently operates under a Flexible-Hybrid model that requires team members to attend the office at least 2 days / week.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.
Responsibilities
Data Delivery & Insights (40%)
Build, test, and run SQL queries to deliver accurate and actionable data extracts for engagement and solicitation activities (e.g., Direct Mail, Telephone, Email).Work closely with business stakeholders to analyze fundraising and donor data, provide data-driven insights including trends, patterns, and opportunities for growth, and recommend technology solutions to improve efficiency in donor engagement and fundraising operations.Coordinate and manage data request processes to ensure requested audiences, segmentations, and exclusions are clearly defined and understood.Deliver data that follows agreed-upon data format and protocols.Follow standards and best practices when developing queries and data extracts, ensuring data accuracy and completeness.Business Intelligence Reporting (50%)
Create clear and compelling visualizations (charts, graphs, dashboards) using Power BI to communicate key metrics and insights.Build, maintain, and optimize Power BI reports / dashboards, data models, and data pipelines.Work with key stakeholders to map and refine business processes related to donor acquisition, retention, and stewardship.Maintain SSRS reports in UNICEF Canada’s reporting portal and drive the report migrations to Power BI platform.Generate ad hoc insight reports as required, following standards and best practices when developing reports, datasets, data models, ensuring reusability, and troubleshoot all BI reports.Use advanced Excel skills and other tools to further manipulate and present data effectively.Develop and maintain system documentation and deliver user training for new BI products and system updates.System Maintenance and Administration (10%)
Manage and maintain Power BI systems, including published reports / dashboards, data models, pipelines, data refreshing schedules, gateways, access, etc.Maintain UNICEF Canada’s back-end reporting SQL Server database as a source of business insight.Manage and maintain databases, ensuring data integrity and security.Ensure scheduled data automation and update tasks run correctly and carry out first-level troubleshooting & fixes.Collaborate with data integration developer and IT teams to optimize data collection and storage processes.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 scriptsProficient working with data warehouse, creating data models based on reporting needsStrong 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 Employer of Choice : What We Offer
UNICEF Canada is where diverse talent & passion come together to create extraordinary impact for every child. We are committed to being an employer of choice and building a culture that is inclusive, ambitious, compassionate, and high impact.
Members of the UNICEF Canada team have access to the following employee benefits :
A ROBUST COMPENSATION PACKAGE
Extended Health / Dental benefits, Healthcare Spending Account, and Wellness AccountLife, AD&D, & Long-Term disability insurance coverageEmployer match contributions (5%) to a Group Pension PlanAccess to parental leave top-upA COMMITMENT TO WELLNESS
Flexible-hybrid work environment to support the work-life integration needs of our teamMinimum 3 weeks of annual vacation (increases with time served) & 1 additional day per year of service (max 30)10 paid sick days & 2 personal days9 to 11 employee wellness days – an additional series of pre-set days off, given annually to further extend long weekendsDiscounted rate for a GoodLife gym membershipAccess to an Employee and Family Assistance ProgramA CULTURE OF LEARNING & GROWTH
Access to a comprehensive global learning platform with over 1600 courses, webinars & resourcesInternal leadership development, training, & mentorship programs that integrate Anti-Racism and diversity, equity and inclusion principlesOpportunities to access both local & global stretch assignmentsAN INCLUSIVE & PURPOSE-DRIVEN WORKPLACE
Centrally located head office in mid-town Toronto with satellite offices in Calgary & MontrealEasily accessed by public transit and a short walk from several parking locationsInclusive & accessible co-working and meeting spaces designed to foster purpose at every turn and accommodate the diverse needs of employeesA CHANCE TO DO MEANINGFUL & LIFE-CHANGING WORK
Under the leadership of a dynamic, accomplished, and experienced executive leadership team, you’ll be part of a diverse & talented Canada team committed to creating meaningful impact while fostering an inclusive and supportive work environment.You’ll join a global UNICEF family with a shared commitment to impact the lives of childrenOur Commitment to Inclusive Workplaces & Recruitment
UNICEF Canada is an inclusive workplace and is committed to championing diversity, equity, inclusion and accessibility. Requests for accommodation can be made at any stage of the recruitment process.
At UNICEF Canada, we believe strongly in personal connections and our hiring process is entirely human-driven. We do not use AI or automated systems to review applications or conduct interviews. Each candidate is evaluated by our experienced team to ensure a fair and thoughtful hiring experience.
How to Apply
Please submit your resume and cover letter as one document to by Friday, February 7, 2025. Please include your salary expectations in your cover email and reference Senior Data Analyst in the subject heading.
UNICEF Canada thanks all applicants for their interest in this opportunity, however, only those selected for an interview will be contacted. Consistent with our Child Safeguarding Policy, all successful candidates must receive clearance by a police background check (including a vulnerable sector screen).
About UNICEF & UNICEF Canada
UNICEF is the world’s farthest-reaching humanitarian organization for children. Across 190 countries and territories, and in the world’s toughest places, we work to help children survive, defend their rights, keep them protected, healthy and educated, and give them a fair chance to fulfill their potential.
UNICEF Canada is one of 32 National Committees located in countries around the world. Our team exists to fundraise for UNICEF’s highest priorities, and to work neutrally with governments and the private sector in Canada and internationally to advance the rights and well-being of children and youth.