A Career Opportunity 

UNICEF is the world’s farthest-reaching humanitarian organization for children. Across 190 countries and territories, and in the world’s toughest places, we workday in and day out to help children survive. To defend their rights. To keep them protected, healthy and educated. To give them a fair chance to fulfil their potential. Our work for every child relies entirely on voluntary support, including donations from generous Canadians.

Senior Data Analyst

(Permanent; Full time; Flexible Hybrid, based in Toronto)

The Senior Data Analyst is responsible for delivering accurate and actionable data to support programs that drive fundraising growth and strengthen supporter engagement.

This position is a member of Business Solutions, a multi-disciplinary team whose responsibilities include managing our Constituent Relationship Management system and using it as a source of data to support program management and performance measurement.

The Senior Data Analyst uses their strong SQL and BI visualization skills to build and maintain a variety of reports, develop BI dashboards, as well as generate sophisticated data pulls to provide audience lists for supporter engagement activities

The responsibilities of the position will include:

Delivering data (40%)

  • Build, test, and run SQL queries to deliver data extracts to support engagement and solicitation activities, including:
    • Direct Mail
    • Telephone
    • Email
  • Work closely with business stakeholders to understand business needs and provide data-driven insights.
  • Coordinate the data request process 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 findings to stakeholders.
  • Build and maintain Power BI reports/dashboards, data models, and data pipelines.
  • 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.
  • Follow standards and best practices when developing reports, datasets, data models, ensuring reusability, and troubleshoot all BI reports.
  • Use advanced Excel skills to further manipulate and present data.
  • Develop and maintain system documentation.
  • 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, 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, Competencies & Skills 

  • 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.
  • Strong SQL skills, including performing complex data querying for data extraction and manipulation.
  • Strong hands-on experience with Power BI, including designing and implementing reports, dashboards, and data models (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, including formulas (e.g., 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) would be an asset.
  • Knowledge of machine learning and predictive modeling would be an asset.
  • 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 engineers, analysts, IT, and business stakeholders.
  • Experience in planning and delivering user training for new BI systems.
  • Ability to create and maintain process-related documentation.

Salary Range: $80,000 to $85,000 per year.

What we Offer: 

UNICEF Canada strongly supports workplace wellness and offers the following benefits:

  • Extended Health and Dental Benefits with a Health Care Spending Account
  • Life insurance and AD&D
  • Short-Term Disability (STD)
  • Long-Term Disability (LTD)
  • Employer contributions (5%) to the Group Pension plan
  • Employee and Family Assistance Program (EFAP)
  • 2 paid personal days.
  • 10 paid sick days
  • Maternity and Parental leave top-up
  • 3 weeks of annual leave (vacation time increases with time served)
  • One additional day of vacation on the anniversary of each year of service, up to a maximum of 30 days.
  • Staff Appreciation Days.
  • Currently offering Flexible – Hybrid work option. 
  • Learning and Development Opportunities.
  • Discounted rate for a GoodLife membership.

For consideration, please submit your resume and cover letter, including salary expectations, to careers@unicef.ca by June 24th, 2024. Please attach your cover letter and resume as one document and reference “Senior Data Analyst” clearly in the subject heading.

UNICEF Canada sincerely thanks all applicants for their expressed interest in this opportunity; however, only those selected for an interview will be contacted. Consistent with our Child Safeguarding Policy, the successful candidate must receive clearance by a police background check, including a vulnerable sector screen.

UNICEF Canada is an inclusive workplace and is committed to championing accessibility, diversity, and equal opportunity. Requests for accommodation can be made at any stage of the recruitment process, providing the applicant has met the requirements for the position.