Data Engineering & Analytics Student

Why join CMHA Peel Dufferin?

Support your community. Advance your career. Fulfill your purpose.

Joining the Canadian Mental Health Association – Peel Dufferin Branch means you’ll be part of something meaningful. For starters, we’re honored to have received the Canadian Non- Profit Employer of Choice Award for our efforts to help people live better. Providing support and services to those who live with mental illness and addictions, we’re committed to increasing awareness and addressing the stigma surrounding mental health. That’s why we’ve made it a priority to create a diverse organization that represents the communities we serve – and the people we help.

We are looking for a Data Engineering & Analytics Student to join our Team!

The Data Engineering & Analytics Student will support the development of reporting, analytics, and data solutions that enable evidence-informed decision-making across CMHA Peel Dufferin. The student will work within a Microsoft-based analytics environment to help collect reporting requirements, develop data pipelines, build dashboards, and perform ad hoc analyses that support organizational priorities.

This role offers hands-on experience with Azure, SQL, Python, Power BI, automation, and AI tools while contributing to projects that support mental health and community services.

The successful candidate will have the opportunity to participate in projects that may include activities such as:

• 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.

What You Will Do:

• 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.

What You Need to Join Our Team:

• 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 is an Equal Opportunity Employer.

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

When contacted by CMHA Peel Dufferin for a placement opportunity, please advise the People and Culture Department of any accommodation needs that may make your experience through the recruitment process more comfortable. We are committed to working with you to meet these needs by providing reasonable accommodations, ensuring you have access to a fair and equitable process. We are continuously working to improve our accessibility practices and welcome any feedback or suggestions on how we can better accommodate candidates with accessibility needs. Should you have feedback, please email us at [email protected]

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.