onsite
Data Specialist - City of Toronto
Software Engineer
Data Specialist responsible for extracting, transforming, and analyzing program eligibility data, building dashboards, and ensuring data quality and governance for income support services.
About the role
Key Responsibilities
- Extract, clean, and transform data from multiple municipal systems to support eligibility assessments.
- Develop and maintain interactive dashboards and reports using Power BI or Tableau for program stakeholders.
- Implement data quality checks and governance procedures to ensure accuracy and compliance.
- Collaborate with analysts, program managers, and IT teams to define data requirements and improve data flows.
- Document data definitions, lineage, and standard operating procedures.
Requirements
- Proven experience with SQL and relational databases (e.g., PostgreSQL, SQL Server).
- Strong programming skills in Python for data manipulation and automation.
- Hands‑on experience building visualizations in Power BI or Tableau.
- Knowledge of data governance, data quality frameworks, and privacy regulations.
- Excellent analytical, problem‑solving, and communication skills.
Skills
sqlpythondata analysis