Job Summary:

The Software Developer - ETL - Intermediate will play a key role in supporting the Ontario Data Platform's enterprise reporting and analytics capabilities. This role focuses on designing, developing, and maintaining Power BI dashboards and reports, integrating diverse data sources, and ensuring data quality and governance. The successful candidate will collaborate with technical teams and business stakeholders to enable data-driven decision-making through insightful visualizations and analytics within a public sector environment.

Responsibilities:

- Design, develop, and maintain interactive Power BI dashboards and reports to meet business and operational needs.
- Create data models, measures, and calculations using DAX for meaningful business insights.
- Implement best practices in data visualization to ensure reports are intuitive and actionable.
- Gather and analyze business requirements and translate them into effective reporting solutions.
- Develop and maintain enterprise semantic models, datasets, and reusable reporting assets.
- Integrate data from various enterprise sources including databases, APIs, and cloud platforms.
- Develop and optimize Power Query (M) transformations for productive data preparation.
- Collaborate with data engineering teams to maintain data quality, governance, and consistency.
- Support ad hoc data analysis, validation, reconciliation, and user acceptance testing (UAT).
- Monitor and optimize report performance, data refresh schedules, and workspace administration.
- Apply security models including row-level security (RLS) and adhere to governance standards.
- Troubleshoot data, visualization, and performance issues and provide ongoing user support.
- Develop and maintain documentation for reports,



datasets, metadata, and reporting standards.
- Ensure compliance with organizational data governance, security, privacy, and accessibility standards.
- Engage with business users to understand needs and provide training on Power BI capabilities.
- Participate in Agile delivery teams and contribute to continuous improvement initiatives.

Required Skills:
- Degree or diploma in Computer Science, Information Systems, Data Analytics, Business Intelligence, or related field.
- Proven experience developing dashboards, reports, and visualizations using Microsoft Power BI.
- Strong proficiency in DAX, Power Query (M), and Power BI data modeling concepts.
- Experience with SQL and relational databases.
- Understanding of data warehousing, dimensional modeling, star schema design, and BI best practices.
- Ability to work with large datasets and translate complex business requirements into reporting solutions.
- Strong analytical, problem-solving, and communication skills.
- Ability to collaborate effectively with both technical and non-technical stakeholders.
- Knowledge of data governance, metadata management, and data lineage principles.

Desired Skills:
- Experience 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 in large public sector or enterprise environments.
- Exposure to Agile delivery methodologies and DevOps practices.

Rated Criteria:
- Technical Expertise (Power BI, DAX, Power Query, SQL) - 50 Points
- Data Integration & Warehousing Knowledge (ETL, Azure, Databricks) - 30 Points
- Communication & Stakeholder Engagement - 10 Points
- Public Sector Experience and Governance Understanding - 10 Points

Total: 100 Points Deliverables:
- Interactive and insightful Power BI dashboards and reports aligned with business requirements.
- Enterprise semantic models, datasets, and reusable reporting assets.
- Optimized data transformations and integrations from multiple data sources.
- Documentation for reports, datasets, metadata, and governance standards.
- Training materials and guidance for report consumers and business teams.
- Support and troubleshooting records ensuring report accuracy and performance.

Must Haves:
- Degree or diploma in a relevant technical field.
- Strong experience with Microsoft Power BI development including DAX and Power Query.
- Proficiency in SQL and understanding of data warehousing and BI modeling concepts.
- Analytical and problem-solving skills with effective communication abilities.
- Ability to collaborate with diverse stakeholders and maintain data governance standards.
- Willingness to work onsite for up to 5 days as required.

Public Sector Experience:

Preferred

📌 Power BI Developer (Ontario)
🏢 vTech Solution
📍 Ontario