Data Analyst- Data & Insights

CAMH; Toronto; On-site; CAD 60,000 - 89,000; Full time

Benefits offered by this job

HOOPP defined benefit pension plan

Professional development opportunities

CAMH Benefits Package

Job summary

CAMH is seeking a Data Analyst to support the 9-8-8 Suicide Crisis Helpline by analyzing data, building dashboards, and improving reporting infrastructure. You will work with data engineers, scientists, and operational teams to ensure data quality and actionable insights.

The role focuses on Azure data services, ETL/ELT support, and governance, delivering clear data to funders and partners while advancing analytics capabilities.

Qualifications

• Bachelor’s degree in Data Science, Statistics, Computer Science, Information Systems, or related field; equivalent experience considered.
• 3+ years in data analytics, BI, reporting, or data operations.
• Strong proficiency in SQL and Python for analysis and automation.

Responsibilities

• Analyze large datasets to identify trends, service gaps, and improvement opportunities.
• Develop and maintain dashboards using Tableau/Power BI.
• Monitor KPIs and provide actionable insights for decision-making.
• Collaborate with data engineers and stakeholders to support ETL/ELT processes and new data integrations.
• Document data definitions, calculations, and processes.

Skills

SQL

Python

Tableau

Power BI

Data analysis

Stakeholder communication

Education

Bachelor's degree in Data Science/CS/Statistics

Tools

Azure Data Factory

Azure Data Lake Storage

Azure SQL

Git

Job description

Job Description

Position Description: Reporting to the Manager, Data Operations, the full-time contract Data Analyst will support the analysis, reporting, and continuous improvement of data for Canada’s 9-8-8 Suicide Crisis Helpline. The Data Analyst will work closely with data engineers, data scientists, operational teams, and external partners to ensure data is accurate, accessible, and translated into meaningful insights. The role will also support the continued development of the 9-8-8 Azure data environment and reporting infrastructure.

Key Accountabilities

Data Analysis & Reporting

• Analyze large and complex datasets to identify trends, patterns, service gaps, and opportunities for improvement.
• Develop and maintain reports, dashboards, and visualizations using Tableau and other reporting tools.
• Monitor key service performance indicators and provide actionable insights to support operational and strategic decision-making.
• Perform ad hoc analysis and respond to internal and external data requests.
• Use SQL and Python to query, transform, validate, and analyze data.
• Ensure accuracy, consistency, and timeliness of reporting.

Data Operations & Azure Support

• Work with data in the 9-8-8 Microsoft Azure environment, including Azure Data Lake Storage, Azure Data Factory, and Azure SQL/SQL Managed Instance.
• Collaborate with data engineers to support ETL/ELT processes, data pipelines, and new data integrations.
• Monitor and investigate data quality, completeness, reconciliation, and transformation issues.
• Support the development and maintenance of data models, reporting tables, and curated datasets.
• Assist with testing and validating changes to data pipelines, business rules, and reporting logic.
• Maintain clear documentation of data definitions, calculations, and processes.

Data Governance & Stakeholder Support

• Support data quality, governance, privacy, and security practices for sensitive crisis service data.
• Work with internal teams and external partners to understand reporting and analytical requirements.
• Prepare and validate data for funders, provinces/territories, service partners, and other stakeholders.
• Communicate technical findings and analytical insights clearly to both technical and non-technical audiences.
• Collaborate with research teams, project teams, clinical teams, and principal investigators to meet research goals, evaluate statistical data, and translate findings.

Qualifications

• Bachelor’s degree in Data Science, Statistics, Computer Science, Information Systems, or a related field; equivalent experience will be considered.
• 3+ years of experience in data analytics, business intelligence, reporting, or data operations.
• Strong proficiency in SQL and experience using Python for data analysis and automation.
• Experience developing dashboards and visualizations using Tableau, Power BI, or similar tools.
• Experience working with relational databases, data warehouses, or data lake environments.
• Experience with Microsoft Azure data services, particularly Azure Data Factory, Azure Data Lake Storage, and Azure SQL, is highly desirable.
• Strong understanding of data quality, validation, reconciliation, ETL/ELT processes, and data modeling.
• Strong analytical, problem-solving, communication, and organizational skills.
• Ability to manage multiple priorities and work effectively with technical and non-technical stakeholders.

Assets

• Experience with healthcare, mental health, crisis services, or contact centre data.
• Experience working with JSON, Parquet, APIs, or large transactional datasets.
• Familiarity with Git, source control, or development/testing environments.
• Experience supporting advanced analytics, machine learning, or unstructured text analysis.
• Bilingualism in French and English and/or proficiency in another language.

Location

This position is based at CAMH's Queen Street West location.

Compensation & Benefits

• Hiring Salary Range: $59,598.75 – $74,498.44 per year ( based on qualifications and experience )
• Full Salary Range: $59,598.75 – $89,398.13 ( reflecting potential growth within the role )
• CAMH Benefits Package: Includes HOOPP defined benefit pension plan and professional development opportunities.

This role offers job stability, career development, and the chance to contribute to meaningful healthcare initiatives that improve patient and community well-being.

AHR & Credentialing

At time of hire, CAMH will require all new hires and rehires to provide proof of educational qualifications relevant to the position they hold with CAMH and as required by the specifications in the job posting, in accordance with policies

AHR 3.1.3 Recruitment and Selection and AHR 3.1.15 Credentialing of Professional Personnel.

Internal transfers** will be required to provide proof of educational qualifications for any additional qualifications relevant to their new position.

About Us

CAMH is a fully affiliated teaching hospital and research institute of the University of Toronto. As a CAMH employee, you will contribute to our mission by supporting teaching, research, and clinical care across the hospital.

CAMH is dedicated to equity, diversity, and inclusion. Our commitment is to foster a workplace, teaching, and learning environment that is inclusive, respectful, and free from discrimination or harassment.

CAMH strongly encourages applications from candidates who reflect the diversity of the communities we serve, including First Nations, Métis, and Inuit Peoples; Black and other racialized communities; LGBTQ2S+ communities; women; and people with disabilities, including those with lived experience of mental health and substance use challenges.

We welcome applicants from all backgrounds. Thank you to all who apply; however, only those selected for an interview will be contacted. If you require accommodations during the application or recruitment process, please let us know.

Through our core values

Through its core values of Courage, Respect and Excellence, CAMH is implementing its Strategic Plan: Connected CAMH, to transform lives, ignite innovation and discovery, revolutionize education and drive social change. CAMH is more than a hospital, it is a cause. CAMH is on a mission to change the way society thinks about and responds to mental illness. They aim to eliminate prejudice and discrimination and shape a world where mental illness is central to our healthcare system - a world where Mental Health is Health.

To learn more about CAMH, please visit their website at: www.camh.ca .

To view our Land Acknowledgment, please click here .