Data engineering student building Azure, SQL, Python, and Power BI solutions for CMHA Peel Dufferin’s mental health services. Supporting reporting, ETL pipelines, dashboards, automation, and data-driven decisions.
Responsibilities
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
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
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
Senior Data Engineer scaling blockchain, product analytics, and experimentation infrastructure for Phantom’s global open - markets trading app. Driving data quality and architecture across a remote team.
Data engineering intern supporting ETL, data quality, and transformation projects at Canadian asset manager PICTON Investments. Collaborating across business teams using SQL, Python, databases, and cloud platforms.
Senior Product Architect guiding AWS, SaaS, data and financial technology at FCC, a Canadian agriculture lender. Shaping secure enterprise roadmaps and integrations across financial applications.
Data Engineer designing warehouse models, Python pipelines, and Power BI reporting for Silk & Snow’s sleep products. Transforming raw data into actionable business insights.
Senior Data Engineer building SQL, dbt, and Airflow data pipelines for Penn Interactive’s online gaming and sports platforms. Delivering trusted analytics and recommendations to business stakeholders.
Data Architect governing World Vision Canada's nonprofit enterprise data architecture. Defining cloud data standards, governance, security and reusable platforms remotely within Canada.
Senior software engineer building backend data services, APIs, microservices, and pipelines for Akamai’s distributed cloud platform. Optimizing databases and reliability across high - scale workloads.
Principal Data Architect defining scalable, governed data platforms for Robots & Pencils’ enterprise AI systems. Setting architecture direction, supporting clients, and mentoring senior technical teams.
Principal Architect leading scalable data platform architecture, solution sales, and client workshops for Long View, a North American IT provider. Mentoring data teams and driving outcomes across Databricks, Microsoft Fabric, and Snowflake.
Senior Data Engineer building Azure pipelines, data platforms, and ML workflows for Manulife’s retirement operations. Supporting trusted analytics across North American teams.