Apply By: Wednesday, July 17, 2024 11:59 pm EDT

Data Solutions Developer

Ministry of Children, Community and Social Services
Business Intelligence and Practice Division / Data Strategy and Solutions Platform Branch
Language of Position(s):
Job Term:
3 Temporary - up to 9 months with possible extension
Job Code:
17162 - Systems Officer 6
$1,852.71 - $2,314.51 Per Week*
*Indicates the salary listed as per the OPSEU Collective Agreement.
Posting Status:
Open Targeted
Job ID:
Are you an experienced data developer, data modeller, or data administrator who wants to improve the strategic use of data in the Ontario Public Service (OPS) in a fast-paced environment? Want to help us develop our cloud environment and migrate data and processes to it?

The Data Strategy and Solutions Platform Branch, Ministry of Children, Community and Social Services, is looking for highly skilled individuals to help implement the ministry's business intelligence and data analytics priorities.

You will be joining a dynamic, multi-disciplinary team that is building sophisticated data models and leading-edge reporting tools, within its own data warehouse environment, to support data-driven decision-making across the ministry.

Want to learn more about this opportunity?
Join us at our BIPD Careers Information Session where you will have a chance to find out more about the position, the team and the branch. If you would like to submit your question(s) in advance, please email

**This session is optional and will not influence the screening and selection process**

OPS Commitment to Diversity, Inclusion, Accessibility, and Anti-Racism:

We are committed to build a workforce that reflects the communities we serve and to promote a diverse, anti-racist, inclusive, accessible, merit-based, respectful and equitable workplace.

We invite all interested individuals to apply and encourage applications from people with disabilities, Indigenous, Black, and racialized individuals, as well as people from a diversity of ethnic and cultural origins, sexual orientations, gender identities and expressions.

Visit the OPS Anti-Racism Policy and the OPS Diversity and Inclusion Blueprint pages to learn more about the OPS commitment to advance racial equity, accessibility, diversity, and inclusion in the public service.

We offer employment accommodation across the recruitment process and all aspects of employment consistent with the requirements of Ontario's Human Rights Code. Refer to the "How to apply" section if you require a disability-related accommodation.

What can I expect to do in this role?

In this role, you will:
• Lead data modelling and development activities that support strategic initiatives and priority analytics projects across the ministry
• Participate in delivery of projects and analytics to enable evidence-based decision-making, while supporting efforts to enhance and maintain the current infrastructure and suite of applications (including Microsoft SQL Services, Microsoft Azure, Power Automate, Power BI, CI/CD, and DevOps), and advise on project feasibility, timelines, effort estimates, and dependencies
• Support and secure client access to data using metadata management tools, Databricks, Microsoft's Azure platform
• Work with data users across the ministry to define, evaluate and recommend data solutions via analytics requirements
• Develop critical stakeholder relationships with other ministries and Children, Youth and Social Services I&IT Cluster (CYSSC) areas, liaise with other ministries, central agencies and other governments to support broader data management activities

How do I qualify?

Information Technology Knowledge

• You have extensive knowledge of business intelligence and reporting development using cloud-based services, delta lake and lakehouse concepts.
• You have experience with Microsoft SQL Server (2017-2019) technology and other relational database systems such as Oracle 11g/12c/19c.
• You have strong SQL scripting skills, and knowledge of stored procedures, queries, and performance optimization.
• You have hands-on Python programming experience, using PySpark and other large-scale data processing libraries.
• You have extensive Extract, Transform and Load (ETL) experience, using tools such as Azure Data Factory, Databricks, SQL Server Integration Services (SSIS).
• You have familiarity with PowerBI semantic models and data access modes.
• You have experience using and configuring Azure platform tools such as Data Factory, Databricks, data connections using self-hosted integration runtime.
• You are able to work with, and analyze, large datasets containing millions of data points and optimize access to relational and non-relational data sources.
• You have hands-on dimensional data modelling experience, using design tools such as Power Designer, and can translate data requirements into conceptual, logical, and physical design
• You can present data process architecture and solution designs, demonstrating pros and cons for alternative options and making recommendations
• You have good knowledge of industry standards and best practices and their applicability to analytics projects.

Business Analysis Knowledge

• You can write and interpret business requirements, design documents and understand specifications, data models, and design of enterprise systems and data sources.
• You have knowledge of DevOps tools for source code control, system change management, team-based development, agile development methods and tools, database scripting, automated code builds, and automated deployment.
• You know systems analysis and design concepts, networks, architecture design, infrastructure, and data modelling and database management, and application development.
• You understand current and emerging technology solutions and industry trends for application development and maintenance, cloud-based systems, networks, communications and inter-connectivity.

Communication, Advisory and Presentation Skills

• You demonstrate strong oral and written communication skills to advise clients and management on general and specific technology products, and prepare submissions and planning documents, reports, briefing materials and correspondence.
• You know how to prepare and present information, options and recommendations to a variety of audiences and provide advisory services on IT-related issues.
• You demonstrate tact and diplomacy to resolve conflict.

Project Management Skills

• You have project management skills that include strategic and tactical project planning, resource and budget scheduling and risk management.
• You have knowledge of IT project management policies and procedures, budgeting and financial administration to lead concurrent large-scale projects.
• You can acquire and apply government procurement, tendering, purchasing and contract administration policies/guidelines, and legislation governing I&IT, access, security, privacy and client business activities to ensure compliance with requirements.

Additional Information:

  • 3 English Temporary, duration up to 9 months, 315 Front St W, Toronto, Toronto Region
Compensation Group:
Ontario Public Service Employees Union
Information Technology
Posted on:
Wednesday, June 26, 2024
  • 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.
  • W-SS-214870/24(2)

How to apply:

  1. You must apply online by visiting You must enter the job id number in the Job ID search field to locate the job ad.
  2. 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.
  3. 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.
  4. Read the job description to make sure you understand this job.
  5. OPS employees are required to quote their WIN EMPLOYEE ID number when applying.
  6. 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.

Please be advised that the results of this competition may be used to form an eligibility list of qualified candidates to potentially fill future vacancies represented by the Ontario Public Service Employees Union (OPSEU). In accordance with the Collective Agreement, eligibility lists are shared with OPSEU representatives. By applying to this competition, you are providing consent that your name may be shared with OPSEU representatives.
All external applicants (including former employees of the Ontario Public Service) applying to a competition in a ministry or Commission public body must disclose (either in the cover letter or resume) previous employment with the Ontario Public Service. Disclosure must include positions held, dates of employment and any active restrictions as applicable from being rehired by the Ontario Public Service. Active restrictions can include time and/or ministry-specific restrictions currently in force, and may preclude a former employee from being offered a position with the Ontario Public Service for a specific time period (e.g. one year), or from being offered a position with a specific ministry (either for a pre-determined time period or indefinitely). The circumstances around an employee's exit will be considered prior to an offer of employment.
Remember: The deadline to apply is Wednesday, July 17, 2024 11:59 pm EDT. Late applications will not be accepted.

We thank you for your interest. Only those selected for further screening or an interview will be contacted.

All Ontario Public Service external job advertisements are posted in English and French. To confirm the language requirements of a job, check the "language of position" information at the top of each job ad. For all positions, candidates will be assessed in English, the business language of the Ontario Public Service. For English/French designated bilingual positions, candidates will also be assessed through French-language proficiency testing.

Toutes les offres d'emploi externes de la fonction publique de l'Ontario sont affichées en anglais et en français. Pour connaître les exigences linguistiques, vérifiez les renseignements sur la « langue du poste » figurant dans le haut de chaque offre d'emploi. Pour tous les postes, l'évaluation des candidates et candidats se fera en anglais, la langue usuelle de la fonction publique de l'Ontario. En ce qui concerne les postes désignés bilingues, la maîtrise du français des candidates et candidats sera également évaluée.

The Ontario Public Service is an inclusive employer.
Accommodation is available under the Ontario's Human Rights Code .
Note: The only website where you can apply on-line for positions with the Ontario Public Service is

You must enable JavaScript in your browser to access full functionality on the OPS Careers website.

Vous devez activer JavaScript dans votre navigateur pour avoir accès à toutes les fonctionnalités du site Carrières dans la FPO.

Ontario Logo / Logo de l'Ontario
This site is maintained by the Government of Ontario
Ce site est mis à jour par le gouvernement de l'Ontario

Privacy | Important Notices
Confidentialité | Avis importants

© Queen's Printer for Ontario, 2007
© Imprimeur de la Reine pour l'Ontario, 2007