Software Developer - Developer

Project Overview

The Community Services I&IT Cluster (CSC) of the Ontario Public Service serves the Ministries of: Colleges and Universities (MCU), Education (EDU); Municipal Affairs and Housing (MMAH) and Tourism, Culture and Sport (MTCS). DDSB supports the ministries by providing information management tools that help enable public policy decision making, business and strategic planning, and program support and improvement. This role will provide the necessary support, for project activities for the Early Years Integration Analytics (EYIA). This position will be responsible for performing business transformations to the information management tools, as well as implement change requests for business enhancements and incremental new functionality releases.

Key Responsibilities

• Develop BI solutions using Microsoft Power BI for varying business needs, following all applicable GO-ITS standards and industry best practices while adhering to the existing technological solution framework.
• Work with various technology teams to translate business needs and work through the analysis and lead the development phases.
• Ensure seamless integration of new and existing systems, applications, and platforms.
• Evaluate and recommend technology stacks, platforms, and tools to support business goals.
• Design systems with a focus on security, compliance, and data privacy standards.
• Work closely with stakeholders such as business units, development teams, IT infrastructure teams to ensure alignment with project goals.
• Ensure solutions are scalable, reliable, and can be optimized for future growth.
• Provide technical support and participate in the development, package creation, code merge, testing and release activities.
• Serve as primary interface between technical teams (Dev, QA) and business stakeholders, focusing on requirements clarification and UAT.
• Develop and manage solutions using Power BI, Oracle, MS-SQL, Visual Studio, SSIS, Attunity, ODAC, .NET framework, GIT and SQL-based reporting tools.
• Support CSC release and infrastructure solutions support project activities, urgent priorities, changing needs, or time-sensitive infrastructure upgrades.

Qualifications & Requirements

REQUIRED

• Must be able to work 5 days onsite per week.
• 10+ years of experience as a Power BI Developer
• Strong expertise in Power BI Desktop and Power BI Service
• Advanced knowledge of DAX (Data Analysis Expressions)
• Proficiency in Power Query (M Language) for data transformation
• Strong SQL skills for querying and managing data
• Experience in data modeling (Star Schema, Fact & Dimension tables)
• Ability to create interactive dashboards and reports
• Knowledge of ETL processes and data integration
• Experience connecting to multiple data sources (databases, APIs, cloud platforms)
• Understanding of performance optimization for reports and datasets
• Implementation of Row-Level Security (RLS) and data governance
• Familiarity with Microsoft Fabric, Azure, and cloud analytics platforms
• Strong analytical and problem-solving skills
• Ability to translate business requirements into actionable insights
• Excellent data visualization and storytelling capabilities
• Good stakeholder communication and documentation skills
• Experience with report deployment, sharing, and workspace management
• Knowledge of data warehousing and BI best practices
• Relevant certifications such as PL-300 Power BI Data Analyst

NICE TO HAVE

• Prior OPS or public sector experience

EVALUATION CRITERIA

Technical Experience - 50%

• Required Skills (5-7 years): Power BI, MS SQL Server, SSIS, Informatica ETL, Cognos Development, Data Migration & Transformation
• Preferred Skills (2-4 years): Oracle, Visual Studio, .NET Framework, Java, Cloud Services, Data Warehousing, Advanced Data Analytics, Version Control
• Extensive experience designing and implementing BI solutions for both on-premise and cloud environments, ensuring scalability, performance, and maintainability.
• Led technology upgrade and migration projects to Microsoft BI Suite, determining which components to migrate, rebuild, or optimize.
• Over 5+ years of hands-on experience in ETL development and data warehousing, including large-scale data migrations and daily operational data loads.
• Deep knowledge of the Microsoft technology stack, including Azure Data Factory, SSIS, SSAS, SSRS, Power BI, and supporting tools like Visual Studio and SQL Server Management Studio.
• Experienced with data governance, role-based access control (Azure AD), and working with multiple database platforms including Oracle and MSSQL.
• Hands-on experience with Power BI Server (On-Prem) and Power BI Service (Cloud), including report deployment, administration, and publishing.
• Skilled in designing interactive dashboards, reports, and visualizations that meet business user requirements.
• Implemented row-level security, automated data refresh scheduling, and performance optimization for enterprise datasets.
• Knowledge of integrating Power BI with other MS BI tools and Azure services for end-to-end reporting solutions.
• Expertise in designing and developing semantic models, dimensional models, and data warehouse architectures aligned with analytics needs.
• Strong hands-on experience with ETL development using SSIS and Azure Data Factory, including debugging transformations, mappings, and unit testing.
• Skilled in data ingestion, staging, cleansing, and integration from multiple sources to support reporting and analytics.
• Experience with data modeling tools such as PowerDesigner and Erwin Data Modeler for creating and maintaining accurate and efficient data models.
• Hands-on experience automating ETL and Power BI deployments using CI/CD pipelines in Azure DevOps, GitHub Actions, or similar platforms.
• Proficient in scripting (PowerShell, Python, or command-line tools) to automate report publishing, ETL job execution, and environment promotion.
• Experienced in implementing automated testing, validation, and rollback mechanisms for smooth production deployments.
• Strong understanding of integrating version control into release workflows to maintain consistent environment and version management.
• Experience creating comprehensive release documentation (Release Book) and coordinating with Release and Operations teams.
• Capable of providing technical support, troubleshooting production issues, and implementing quick fixes in live environments.
• Knowledge of production deployment processes, version control, change management, and environment governance.
• Able to review and improve existing technical documentation, data dictionaries, and source-to-target mappings, providing guidance to development teams.
• Experienced in creating and maintaining comprehensive technical documentation, including data dictionaries, source-to-target mappings, and data flow diagrams.
• Skilled in documenting data models, ETL processes, and BI solution designs to ensure clarity, standardization, and maintainability.
• Provides guidance and feedback to teams on improving existing documentation and aligning it with organizational data governance standards.
• Able to produce clear release and deployment documentation (Release Books) for technical and operational stakeholders.
• Ensures documentation supports troubleshooting, auditing, and compliance requirements across BI and data warehouse environments.

Core Skills - 25%

• Long term vision: be able to work with stakeholders to define technical roadmap for current applications, and provide recommendation
• Working knowledge of systems design and development, and related methods, techniques, practices and standards enable you to analyze and define clients' business and information technology requirements pertaining to data flow and data integration; provide recommendation to business
• Demonstrates Analytical and problem-solving skills to assess clients' business priorities and needs; to evaluate business and technical design alternatives
• Demonstrates ability to guide the architecture leveraging Azure cloud services, including effective standard use of Microsoft Stack tools and services critical for the integrity, quality and pace of delivery.
• Working knowledge of technology, data, databases, applications, and networking techniques, tools and practices enable you to lead the design and development of infrastructure related projects.

Project Experience and Techniques – 10%

• Demonstrates lead design experience with technology upgrade/migration projects, and shows acumen in being able to evaluate and determine the best path going forward
• Demonstrates experience leading discussions with stakeholders to elicit requirements, developing/consulting on options and solutions, and facilitating the resolution of I&IT and Business issues. Ability to drill down on business pain points and determine the right solution, rather than delivering only the item that’s being requested by stakeholders
• Demonstrates development and design experience with SDLC processes, Agile and Waterfall methodologies

Communication Skills -10%

• Demonstrated experience in solving problems analytically, and making sound decisions based on
• Experience in negotiating using both verbal and written communication skills and should have worked in a team-based environment with a proven record of meeting deadlines
• Strong stakeholder engagement, facilitation, negotiation, and consensus building

Public Sector Experience: 5%

• Previous public sector experience in an organization of equivalent size or complexity in Public Service
• Demonstrates experience designing and developing applications that comply with GOITS standards and general processes would be an asset.

Key Skills & Competencies

Power BI, DAX, Power Query, SQL, Data Modeling, ETL, Dashboard Development, Performance Tuning, Row-Level Security, Microsoft Fabric, Azure Analytics, Oracle, MS-SQL, Visual Studio, SSIS, Attunity, ODAC, .NET, Git, Informatica, Cognos, Cloud Services, Data Warehousing, Azure Data Factory, SSAS, SSRS, PowerDesigner, Erwin, GitHub Actions, Azure DevOps, PowerShell, Python, Java, API, CI/CD, Data Governance, Release Automation