Software Developer

Job Title: RQ11676 - Software Developer - ETL - Intermediate

Client: Government Services Integration Cluster

Ministry: Ministry of Public and Business Service Delivery and Procurement

Location: 222 Jarvis St

Work Model: Onsite

Duration: 6 months (Sep 27, 2026 to Mar 30, 2027)

Extension: 1 Time

Security Clearance: No Clearance Required

No. of Positions: 1

Pay Rate: CAD 70/hour

Submission Deadline: 2026-11-10, 12:00 p.m. EST.

Max Submissions: 1 (one)

·        Closing Date/Time: 2026-11-10, 12:00 p.m. EST.

·        Max submission: 1 (one)

·        5 days onsite

The Government of Ontario is undertaking a large-scale Data & AI transformation initiative, with the Ontario Data Platform (ODP) serving as the enterprise technology ecosystem for data-driven decision-making, analytics, and artificial intelligence. ODP provides a modern and scalable data environment that supports data ingestion, storage, processing, governance, quality, marketplace capabilities, and advanced analytics across ministries and government organizations.

·        Degree or diploma in Computer Science, Information Systems, Data Analytics, Business Intelligence, or a related field.

·        Experience developing dashboards, reports, and visualizations using Microsoft Power BI.

·        Strong knowledge of DAX, Power Query (M), and Power BI data modeling concepts.

·        Experience working with SQL and relational databases.

·        Understanding of data warehousing, dimensional modeling, and business intelligence best practices.

·        Experience working with large datasets and transforming complex business requirements into reporting solutions.

·        Strong analytical, problem-solving, and communication skills.

·        Ability to work collaboratively with technical and non-technical stakeholders.

·        Strong understanding of dimensional modelling, star schema design, and analytical data modelling concepts.

·        Knowledge of data governance, metadata management, and data lineage principles.

Power BI Development & Reporting

·        Implement data visualization best practices to ensure reports are intuitive, accessible, and actionable.

·        Develop and maintain enterprise semantic models, datasets, and reusable reporting assets that support standardized analytics and reporting

Data Integration & Analytics Support

·        Connect and integrate data from various enterprise data sources, including databases, APIs, cloud platforms, and data warehouses.

·        Collaborate with data engineering teams to ensure data quality, governance, and consistency across reporting solutions.

·        Support ad hoc data analysis and reporting requests from business stakeholders.

·        Perform data validation, reconciliation, and user acceptance testing (UAT) activities to ensure reporting accuracy and integrity.

Performance, Governance & Support

·        Monitor and optimize report performance, data refresh schedules, and workspace administration.

·        Apply security models, row-level security (RLS), and governance standards within Power BI.

·        Troubleshoot data, visualization, and performance issues and provide ongoing support to users.

·        Develop and maintain documentation for reports, datasets, and reporting standards.

·        Maintain data lineage, metadata, and documentation for reporting assets and semantic models.

·        Ensure reporting solutions comply with organizational data governance, security, privacy, and accessibility standards.

Stakeholder Engagement & Knowledge Sharing

·        Work closely with business users to understand reporting requirements and identify opportunities for enhanced analytics.

·        Provide guidance and training to report consumers and business teams on Power BI capabilities and best practices.

·        Participate in Agile delivery teams and contribute to continuous improvement initiatives.

Nice to Have

·        Experience working with Databricks, including connecting Power BI to Databricks SQL Warehouses and Lakehouse data sources.

·        Familiarity with Azure Data Platform services such as Azure Data Lake Storage, Azure Synapse Analytics, Azure Data Factory, or Microsoft Fabric.

·        Experience with enterprise data governance and data quality initiatives.

·        Knowledge of Python, R, or other analytics tools.

·        Experience supporting data and analytics platforms within a large public-sector or enterprise environment.

·        Exposure to Agile delivery methodologies and DevOps practices.