• Design and build ETL processes and data pipelines.
• Develop data models and reporting datasets in Azure.
• Create Power BI dashboards and interactive visualizations.
• Perform ad hoc analysis to answer business and operational questions.
• Work with modern analytics and AI tools in a real-world healthcare environment.
• Contribute to data-driven decision-making that supports mental health services across the community.

(Please note: project activities will depend on current business needs.)

The placement is paid and 4 months long, for students looking to complete preferably 300 or more placement hours, beginning in January 2027. This placement runs between 9:00 AM to 5:00 PM, Mon - Fri.

Status: 37.5hrs/ week Paid Post-Secondary Student Placement, for January 2027 - April 2027

Hourly : $18.60 per hour

Location: 601-7700 Hurontario St., Brampton. Due to the nature of this program, this role is hybrid.

• Gather and document reporting and analytics requirements from business stakeholders.
• Conduct ad hoc analysis and develop insights to support operational and strategic decision-making, and/or data quality improvement.
• Assist with data extraction, transformation, validation, and quality improvement activities.
• Support reporting automation initiatives using Microsoft technologies, including Power Automate.
• Document technical solutions, reporting logic, and data processes.
• Develop and maintain data pipelines, ETL processes, and data tables using SQL and Python in Microsoft Azure.
• Design and support data models used for reporting and analytics.
• Create and maintain Power BI dashboards, reports, and visualizations.
• Other duties as assigned.

This posting description indicates the key responsibilities and core functions of the position. It is not designed to cover or contain a comprehensive listing of activities, duties, or responsibilities.

• Currently enrolled in a post-secondary program in Data Analytics, Data Science, Computer Science, Health Informatics, Business Analytics, Information Systems, or a related field.
• Experience with SQL and relational databases.
• Experience using Python for data analysis, visualization, automation, or data processing.
• Experience developing reports and dashboards using Power BI.
• Strong analytical and problem-solving skills.
• Strong communication skills and ability to work with both technical and non-technical stakeholders.
• Proficiency with Microsoft Excel and Microsoft 365 applications.
• Interest in data engineering, analytics, automation, and AI technologies.
• Experience with Microsoft Azure data services is an asset.
• Experience developing ETL processes and data pipelines is an asset.
• Experience with Microsoft Power Automate is an asset.
• Experience working with APIs or integrating data from multiple sources is an asset.
• Experience in healthcare, mental health, community health, or social services environments is an asset.
• Strong communication, conflict resolution and crisis intervention skills
• Strong interpersonal skills with proven ability to approach, listen, build trust, and communicate across diverse cultures and intersectionality. Willingness to continually improve understanding around cultural competence
• Openness to operate from an anti-racist, anti-oppressive, 2SLGBTQ+ affirming and intersectional framework
• Willingness to learn and apply practical understanding of different elements of diversity, such as gender identity/expression, race/cultural background, religion, sexual orientation, disability, immigration and precarious status, family status, etc.
• Some evenings required and an ability to travel within Peel Region from time to time
• Satisfactory vulnerable sector screening
• Satisfactory references

Deadline to Apply: Open Until Filled

At the Canadian Mental Health Association – Peel Dufferin Branch, we provide a wide array of community services, resources, and care for people with mental illness. In your role, you’ll support people to assist clients who are struggling, helping to them return to good health and reintegrate into the community. In everything we do, we work together to make the world a better place – one person at a time.

Apply Now and EMPOWER your career

CMHA Peel Dufferin strives to be an equitable employer. We are committed to supporting inclusive recruitment and selection processes, work environments and a qualified workforce reflective of the diverse populations we serve. We acknowledge that removing existing barriers and preventing new barriers is required to foster dignity and independence for people of all ages, genders, cultures, and abilities. We encourage applications from members of groups that have been historically disadvantaged and marginalized, including but not limited to, First Nations, Métis, Inuit and Urban Indigenous (FNIMUI) populations, ethno-racial communities, people with disabilities, *2SLGBTQIA+ communities, women and gender diverse people, low-income communities, and all equity-deserving groups.

*2SLGBTQIA+ (Two-Spirit, Lesbian, Gay, Bisexual, Trans, Queer, Intersex, Asexual, and a range of gender and sexual diversity categories not listed).

Accessibility Statement

Use of Artificial Intelligence (AI) in Recruitment

To streamline our recruitment process, we utilize an applicant tracking system (ATS) to manage and organize applications. While the ATS aids in efficiency, the essential review and evaluation of candidates is carried out by members of our People and Culture team. This approach ensures a personalized assessment that allows us to gain a comprehensive view of a candidate’s experience, skills and potential. AI is not used to make any decisions in our recruitment process.

Next Steps

We thank all those who apply. Only those selected for further consideration will be contacted. We retain all applications submitted for one (1) year after the closing date of the posting for consideration in future career opportunities.