Senior Data & Insights Analyst - Power BI & AI

Elections Ontario; Toronto; On-site; CAD 75,000 - 105,000; Full time

Job summary

Elections Ontario seeks a Senior Research & Data Analyst to join the Design & Strategic Innovation division, turning operational data into intuitive reporting tools, apps, and automated workflows. You will collaborate with research, innovation, and operations teams to design scalable solutions that empower users to access, interpret, and act on information.

You will design digital reporting and operational solutions, build analytics tools using Power BI, Power Apps, and Power Automate, and

Qualifications

• Advanced experience designing and developing Power BI dashboards, semantic models, DAX measures, and interactive reporting solutions.
• Experience developing business applications using Microsoft Power Apps and workflow automation using Power Automate.
• Advanced SQL skills for querying, transforming, and validating large operational datasets.
• Demonstrated experience using Python for data preparation, automation, API integration, and analytical workflows.
• Experience working with relational databases, data modelling, ETL processes, and enterprise data integration.
• Experience designing user-centered digital solutions for non-technical audiences.
• Familiarity with version control, testing, documentation, and maintainable software development practices.

Responsibilities

• Lead discovery sessions with business partners to understand operational challenges and identify opportunities for digital solutions.
• Translate complex business requirements into scalable dashboards, applications, and workflow automation.
• Design intuitive reporting experiences that enable non-technical users to confidently access and interpret information.
• Develop solutions that are easy to maintain, well-documented, and have reusable components.
• Analyze operational and transactional data using SQL, Python, and business intelligence tools.
• Develop Power BI semantic models, dashboards, and performance reporting solutions.
• Build Power Apps applications and Power Automate workflows that improve operational efficiency.
• Integrate data from multiple enterprise systems to support reporting and decision-making.
• Apply technologies—including scripting, automation, AI-assisted development, and low-code platforms—to deliver high-value solutions.
• Mentor colleagues and promote data literacy and self-service reporting.

Skills

Power BI dashboards

Power Apps

Power Automate

SQL

Python

Data modelling

ETL processes

User-centered design

Version control

Documentation

Tools

Power BI

Power Apps

Power Automate

SQL

Python

Relational databases

Job description

Elections Ontario seeks a Senior Research & Data Analyst to join the Design & Strategic Innovation division, turning operational data into intuitive reporting tools, apps, and automated workflows. You will collaborate with research, innovation, and operations teams to design scalable solutions that empower users to access, interpret, and act on information.

You will design digital reporting and operational solutions, build analytics tools using Power BI, Power Apps, and Power Automate, and