Resume Score

Check how well your resume matches this job before you apply.

Sign in to check score

About the role

  • 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

Job title

Job type

Internship

Experience level

Entry level

Salary

CA$19 per hour

Degree requirement

No Education Requirement

Tech skills

AzureETLPythonSQL

Location requirements

HybridBramptonCanada

Report this job

Found something wrong with the page? Please let us know by submitting a report below.