Data Engineering, Analytics Student

Canadian Mental Health Association Peel Dufferin

. Support development of reporting, analytics, and data solutions for evidence-informed decision-making across CMHA Peel Dufferin .

Posted 10/20/2026internshipBrampton • CanadaEntry Level💰 CA$19 per hourWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates expertise in data analytics, reporting automation, and data pipeline development using SQL and Python within Microsoft Azure. Proficient in creating Power BI dashboards and visualizations while supporting data-driven decision-making in healthcare environments.

Highest-signal resume keywords

SQL Database ManagementPython Data AnalysisPower BI Dashboard DevelopmentMicrosoft Azure Data ServicesETL Process Development

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

Data ExtractionData TransformationData ValidationReporting AutomationData ModelingData Quality ImprovementAd Hoc AnalysisAnalytics Requirements GatheringData VisualizationAPI Integration

Soft Skills

Analytical SkillsProblem-Solving SkillsCommunication SkillsInterpersonal SkillsCultural Competence

Tools & Technologies

Microsoft Power AutomateMicrosoft ExcelMicrosoft 365Power BIAI Technologies

Certifications & Qualifications

Satisfactory Vulnerable Sector Screening

Industry Keywords

HealthcareMental HealthCommunity HealthSocial ServicesData Engineering

Tech Stack

Tools & technologies

AzureETLPythonSQL

About the role

Key responsibilities & impact

Support development of reporting, analytics, and data solutions for evidence-informed decision-making across CMHA Peel Dufferin
Gather and document reporting and analytics requirements from business stakeholders
Conduct ad hoc analysis and develop insights for operational and strategic decision-making and data quality improvement
Assist with data extraction, transformation, validation, and quality improvement
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 for reporting and analytics
Create and maintain Power BI dashboards, reports, and visualizations
Work with modern analytics and AI tools in a real-world healthcare environment
Contribute to data-driven decision-making supporting mental health services across the community
Perform other duties as assigned

Requirements

What you’ll need

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 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 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 diversity, including gender identity/expression, race/cultural background, religion, sexual orientation, disability, immigration and precarious status, and family status
Some evenings required and ability to travel within Peel Region from time to time
Satisfactory vulnerable sector screening
Satisfactory references

Benefits

Comp & perks

Paid 4-month student placement
Hands-on experience with Azure, SQL, Python, Power BI, automation, and AI tools
Experience contributing to mental health and community services projects
Inclusive and equitable work environment
Reasonable accommodations during the recruitment process