RQ11676 – Software Developer – ETL – Intermediate

Role Overview:

• 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.
  
• We are seeking a Power BI Developer to support the
  development, maintenance, and enhancement of enterprise reporting and analytics
  solutions. The successful candidate will work closely with business
  stakeholders, data engineers, architects, and product teams to deliver
  insightful dashboards, reports, and data visualizations that enable
  evidence-based decision-making across government programs and services.
  

Requirements

Experience and Skill Set Requirements:

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.
  

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.
  

Skill Set Requirements:

Power BI Development & Reporting

• Design, develop, and maintain interactive Power BI
  dashboards and reports to support business and operational needs.
  
• Create data models, measures, and calculations using DAX to
  deliver meaningful business insights.
  
• Implement data visualization best practices to ensure
  reports are intuitive, accessible, and actionable.
  
• Gather and analyze business requirements and translate them
  into reporting solutions.
  
• 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.
  
• Develop and optimize Power Query (M) transformations for
  efficient data preparation and reporting.
  
• 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.
  

Evaluation breakdown:

• Technical(Azure/Databricks)
  
• Communication
  
• Public Sector