• Back to search results

Apply By: Tuesday, May 19, 2026 11:59 pm EDT

Data Solutions Developer

Job ID:

242255

Posting status:

Open

Organization:

Ministry of Children, Community and Social Services

Division:

Business Intelligence and Practice Division / Data Strategy and Solutions Platform Branch

City:

Toronto

Position(s) language:

English

Job term:

1 Temporary contract/assignment up to 12 months with possible extension

Job code:

17162 - Systems Officer 6

Salary:

$1,852.71 - $2,314.51 Per week*
*Indicates the salary listed as per the OPSEU Collective Agreement.

Build modern analytics for Ontario's Social Assistance programs

This role is part of the Data Strategy and Solutions Platform Branch at the Ministry of Children, Community and Social Services (MCCSS). The team is modernizing how Social Assistance data is modeled, governed, and used to support evidence-based decision-making across the ministry.

You'll work mainly on Power BI dashboards and semantic models built on a new, cloud-based Social Assistance data platform. The focus is on delivering reliable, well-designed analytics products that people trust and actively use.

This is not a report-factory role. You'll work closely with business users, data modelers, and platform teams to turn policy and operational questions into scalable analytics solutions.

How someone on the team would describe the role:“I build Power BI dashboards on top of a new cloud data model. I spend as much time understanding the data and user needs as I do building reports. We care a lot about correctness, version control, validation, and long-term maintainability.”

Core tools and technologies: Power BI (DAX, Power Query/M, Report Builder), Databricks (SQL), Git, Azure-based cloud data services

Why you might want this role

• You want to own the full analytics lifecycle

• You care about semantic models, metric definitions, and data correctness

• You want to work in an environment where reports are treated as products

• You prefer a team where engineering discipline (version control, testing, standards) is expected

Why this work matters
The analytics products you build will:

• Support analysts, managers, and front-line staff

• Improve confidence in Social Assistance data

• Inform decisions at both provincial and municipal levels

• Contribute to better program delivery for vulnerable populations

About Us:
We are a part of the Data Strategy and Solutions Platform Branch. Our branch strengthens the ministry's data capabilities by advancing data strategy, governance, policy, legislation, and analytics planning. We build and maintain modern data infrastructure and integrated reporting platforms, ensuring strong standards for privacy, security, and data quality. Using a user-centric approach, we deliver digital data solutions and analytical tools that enhance data access, reporting, and insights across MCCSS programs and partners, enabling evidence-based decision-making across the ministry.

About the job

As a Data Solutions Developer, you will:

• Design enterprise data solutions by translating complex business needs into data models, ETL processes, data architecture, and analytical reporting solutions.
• Lead and contribute to major I&IT initiatives, delivering analytics and data solutions using agile and DevOps practices across cross-ministry projects.
• Enhance and support the analytics data warehouse, providing technical expertise across data infrastructure, applications, and integration layers.
• Develop high-quality data and analytics products, including statistical outputs, research datasets, and dashboards that are user-centred, accessible, and support effective data storytelling and decision-making.
• Collaborate with and advise stakeholders, eliciting requirements, aligning definitions and standards, applying data governance practices, and optimizing data solutions.
• Provide technical leadership, supporting project teams and ministry partners while contributing to continuous improvement in data and analytics capabilities.

What you bring to the team

Information Technology Knowledge

You can demonstrate:

• hands-on experience designing and delivering business intelligence and reporting solutions using Power BI workspaces
• experience with Azure data and analytics services, such as Data Factory, Databricks, SQL Database, and Managed Instance
• strong SQL, Python/PySpark, and DAX skills, with experience optimizing queries, data access modes, and model performance
• experience designing OLAP and tabular models, including semantic and metadata layers
• experience building data pipelines and ETL solutions using Power Query, Dataflows, and Azure Data Factory
• familiarity with IBM Cognos report development
• proven ability to work with large, complex datasets and optimize access across relational and non-relational data sources
• data modelling experience using tools such as PowerDesigner and Visio, and knowledge of RDF concepts
• experience implementing CI/CD for Power BI and using the Power BI REST API
• advanced DAX expertise, including filter and row context, time intelligence, and reusable measure patterns for consistent KPIs
• practical Power Query (M) experience, including data profiling, transformations, and parameterization
• demonstrated performance-tuning skills across semantic models and DAX, including managing cardinality, avoiding inefficient patterns, and using tools such as Performance Analyzer

Business Analysis Knowledge

You can demonstrate:

• experience conducting business and systems analysis, including defining requirements, interpreting design documents, and working with enterprise data models and systems
• knowledge of modern development practices, including DevOps, agile delivery, source control, change management, and automated build and deployment
• a solid understanding of IT concepts, including application and system design, architecture, data modelling, and database management
• awareness of current and emerging technologies and industry trends, particularly cloud-based analytics and data platforms
• experience translating analytics requests into measurable outcomes, including defining KPIs, data grain, assumptions, and success criteria

Communication, Advisory and Presentation Skills

You can demonstrate:

• strong written and verbal communication skills to clearly explain technical concepts and provide sound advice to technical and non-technical audiences
• experience presenting analysis, options, and recommendations tailored to different stakeholder groups
• professionalism, tact, and sound judgment when handling sensitive or complex discussions
• the ability to design and present insight-driven dashboards, structured around decision-making (KPIs > drivers > details), with clear titles, annotations, and intentional interactivity
• knowledge of data visualization best practices, including visual selection, consistent formatting, effective use of colour and contrast, and accessibility and inclusivity considerations

Project Management Skills

You can demonstrate knowledge of or familiarity with:

• project management practices, including planning, risk management and resource coordination
• I&IT project management policies, procedures, and financial administration, with experience supporting or leading multiple initiatives
• procurement and contract management requirements, including compliance with I&IT, privacy, security, and related legislation

Don't meet every qualification?

If you are excited about this position and meet most, but not all, of the listed qualifications, please still consider applying. We recognize that no one person might have every qualification in this job ad, and you just might be the right candidate!

How we support diversity, inclusion and accessibility

We are building an inclusive workforce that reflects the communities we serve. We encourage everyone interested in working with us to apply, including people with disabilities, Indigenous, Black and racialized individuals, as well as people from all ethnicities, cultures, sexual orientations, gender identities and gender expressions.

Our hiring process is accessible, consistent with Ontario's Human Rights Code and the Accessibility for Ontarians with Disabilities Act, 2005. We are working to prevent and remove barriers in our hiring processes and can offer accommodation to address specific needs related to Code-protected grounds such as disability, family status and religion. For more information about accommodation during the hiring process please contact us.

Learn more about the work the OPS is doing to create an inclusive, anti-racist, accessible and diverse workplace:

• diversity, equity and inclusion initiatives
• accessibility
• Anti-Racism Policy

What we offer

The Ontario Public Service is one of Ontario's largest employers. Employees work for 29 ministries, with offices in more than 70 cities across the province. We offer:

• a career that can grow across ministries and job functions

• flexible learning and developmental opportunities, including education and mentorship programs

• many employee networks offering support for and education about underrepresented groups

• comprehensive benefits that look after your holistic wellness needs

• base salary that aligns to market trends with scheduled salary progression

• tailored work arrangements, including opportunities like flex hours, self-funded leave and more

• a modern, friendly, and accessible physical work environment

What makes this work interesting

• Greenfield reporting: Most reports are being rebuilt following a migration from legacy systems

• Improved foundations: The new platform supports better automation, validation, and consistency

• Design influence: The team is still establishing patterns for semantic models, testing, and user experience

• Real impact: The data informs decisions that affect Social Assistance programs across Ontario

Growth and learning

• Ongoing exposure to new Power BI and cloud analytics capabilities as they are released

• Practical experience debugging issues across data ingestion, modeling, and visualization layers

• Experience working with large-scale administrative data used at both provincial and municipal levels

• A team culture that supports experimentation and incremental improvement

Team and ways of working

• A collaborative, supportive Social Assistance analytics team

• Agile Scrum delivery with an emphasis on transparency and shared ownership

• Regular knowledge-sharing across reporting, data modeling, design, and analysis

• Psychological safety and trust treated as foundational

Management approach

• Work is managed through a matrix structure with both an HR manager and a project sponsor. The focus is on delivery quality, professional growth, coaching, and clear decision-making in complex environments.

Location and work environment

• Downtown Toronto with excellent TTC access, including Line 1 and Union Station
• Easy access to the Gardiner Expressway
• Walkable area with food, cafés, and public spaces nearby
• Modern, open layout office space

Additional information:

Apply by:

Tuesday, May 19, 2026 11:59 pm EDT

Position details:

• 1 English Temporary, duration up to 12 months, 315 Front St W, Toronto, Toronto Region, Criminal Record and Judicial Matters Check (Fingerprint Based), Annual CRJMC, Canadian Border Services Check, Canadian Security Intelligence Services Check (CSIS), Credit History Check, Driver's License History, Intelligence, Local Police Databases Search, Social Networking Search

Compensation group:

Ontario Public Service Employees Union

Work hours:

Schedule 6

Category:

Information Technology

Posted on:

Monday, May 4, 2026

Note:

• About security checks:
  A criminal or other federal offence record does not automatically disqualify you from the position. We consider each situation based on the position's responsibilities.
  If a check is needed and you've lived outside of Canada in the past 5 years for 6 or more months in a row, or if you are not a Canadian resident, you'll need to provide an out-of-country police clearance certificate from the country you lived in.
  Employment screening checks are only reviewed and evaluated by the Transition and Security Office, which also maintains them and keeps them strictly confidential.
• The information that you provide for the purpose of this competition and the results from this competition may be used to fill other positions. These positions may be of various tenures including short-term assignments. Your information and the results from this competition will be retained for the purpose of filling vacancies in accordance with the applicable collective agreement or policy provisions.
• T-SS-242255/26

How to apply:

• You must apply online.

• Your cover letter and resume combined should not exceed five (5) pages. For tips and tools on how to write a concise cover letter and resume, review the Writing a Cover Letter and Resume: Tips, Tools and Resources.

• Customize your cover letter and resume to the qualifications listed on the job ad. Using concrete examples, you must show how you demonstrated the requirements for this job. We rely on the information you provide to us.

• Read the job description to make sure you understand this job.

• OPS employees are required to quote their WIN EMPLOYEE ID number when applying.

• If you require a disability related accommodation in order to participate in the recruitment process, please Contact Us to provide your contact information. Recruitment services team will contact you within 48 hours.

Language requirements and assessment:
All external Ontario Public Service (OPS) job ads are posted in English and French. Check the "position(s) language" section at the top of each job ad for the language requirements. For all roles, candidates are assessed in English, the business language of the OPS. If the position is bilingual (English/French), you'll also need to pass a French-language proficiency test.

Exigences en matière de langue et évaluation:
Toutes les offres d'emploi externes de la fonction publique de l'Ontario (FPO) sont affichées en français et en anglais. Consultez la section « Langue du ou des postes » en haut de chaque offre d'emploi pour connaître les exigences linguistiques. Pour tous les postes, les candidats sont évalués en anglais, la langue d'affaires de la FPO. Si le poste est bilingue (anglais/français), vous devrez également passer un test de compétences linguistiques en français.

Strengthening Ontario, together