RQ11676 – Software Developer - ETL - Intermediate

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)

Supplier Comments / MSP Notes

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

· Max submission: 1 (one)

· 5 days onsite

Project Description 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 up-to-date and scalable data environment that supports data ingestion, storage, processing, governance, quality, marketplace capabilities, and advanced analytics across ministries and government organizations.

Must Haves

· 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.

Description / Responsibilities / Skills

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.

Experience & Skill Set Requirements

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.

📌 Software Developer - ETL - Intermediate (Toronto)
🏢 InnosysTech
📍 Toronto