Data Developer

As a Data Developer in the Digital Solutions, you will be part of a multi-disciplinary team that drive digital transformation using design thinking strategies and exploring new technology trends that continue to redefine IT, business and the way we service the citizens of Ontario. Working with a high-impact team, you will be constantly learning new technologies and techniques through research, experimentation and collaborating with other team members.

About Us
The Land and Resources I&IT Cluster (LRC) is one of eight clusters in the OPS formed to provide groups of ministry partners with all their information technology needs. LRC partners with the Ministries of: Indigenous Affairs; Agriculture, Food and Rural Affairs; Environment, Conservation and Parks; Northern Development, Mines, Natural Resources and Forestry; and Energy,

LRC works with program areas in each of the ministries to understand their business needs and develop technology solutions that enable business transformation and digital public service goals and objectives. Technology solutions range from new business applications to office productivity tools, from information management expertise to telecommunications support.

The LRC works closely with other clusters and the Office of the Corporate Chief Information Officer (OCCIO) within the Ministry of Government and Consumer Services to enable shared technology solutions (development tools) and common infrastructure for the benefit of all ministries.

About the Branch
The Digital Solutions Branch collaborates with cluster partner ministries to co-design, deliver and support digital solutions, providing leadership in emerging technologies and innovative delivery techniques to enable modern government services.

Want more Information?
Visit the  Ministry of Northern Development, Mines, Natural Resources and Forestry  website for additional information about our ministry.

Why work for the Ontario Public Service (OPS)?
We are re-thinking how we deliver services through various initiatives, modernization initiatives and how we access and deliver critical services remotely. We are striving to enable a future-ready OPS workforce through technology focused enterprise-wide strategies.

The OPS offers a competitive compensation package. We support career and leadership development, invest in learning opportunities, and recognize team and individual achievements, and support flexible work arrangements.

Note: The successful candidate will have the option of working from one of the following office locations:
• 40 St Clair Avenue West, Toronto
• 5775 Yonge Street, Toronto
• 77 Grenville Street, Toronto
• 33 King Street West, Oshawa

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:
• develop, execute and maintain administrate databases and to perform data analysis and intelligence solutions in support of the Ministry's application portfolio.
• work with project team and take part in development database design and dissemination of data from provincial natural resource and topographic databases
• monitor the health of databases and address issues as they arise as well as incidents raise by clients; provide expert advice and guidance to stakeholders on the use database management techniques and technologies.
• work with teams to improve delivery of service and introduce operational efficiencies to data pipelines and storage structure solutions
• develop, test, implement, and support advanced analytics (diagnostic, predictive, and prescriptive) ,self-serve analytics solution, and unified solution for corporate data automation, integration, and application programing interfaces (APIs)

How do I qualify?

Technical Expertise

You have:
• proven knowledge of relational/spatial database management, administration, and information architecture theory, principles and techniques of data modeling using computer aided software, and use of information engineering
• knowledge of a wide range of computer system technologies, including server-based technologies and personal computer systems, application and database management software (Oracle, ArcSDE, Oracle Enterprise Manager), and database development methodology, and relational database concepts
• knowledge of current and emerging coding/programming/scripting languages (SQL, PL/SQL, Python), platforms, methods, techniques for design, development, and implementation of data storage, extraction, transformation, processing, synthesizing, mining, and analytical solutions
• knowledge of analytical and data science methods and techniques, such as, but not limited to: statistical analysis and modelling, data mining, machine learning, deep learning, algorithms, natural language processing, artificial intelligence and other related disciplines.
• knowledge of range of current and emerging: coding/programming/scripting languages, platforms, methods, techniques, and tools for design, development, and implementation of big data, analytics, and data science solutions
• ability to create, maintain, support and operate large volume data, self-serve analytics, advanced analytics (diagnostic, predictive, and prescriptive)

Research, Analytical and Problem-solving Skills

You can:
• design databases, analyze and develop project plans, data management structures and overall database operation efficiencies, requirements and standards
• identify user problems, system and information bottlenecks and feasible solutions, develop security levels and security procedures
• apply and adapt precedents to solve problems
• develop and recommend standards and procedures for operating issues such as user access, security measures, data storage and retention, data manipulation and reporting capabilities
• research and assess potential use of new information engineering and data management techniques, methodologies, software and hardware such as, but not limited to ingestion, streaming, capture, storage, extraction, transformation, structuring, processing, synthesizing, loading, mining, profiling, wrangling, analysis, preparation visualization and other related disciplines

Communication and interpersonal Skills

You can:
• exchange information during development and operation of data lake and data warehouse, advise on technical requirements
communicate information to both a technical and non-technical audience
• written communication skills to prepare systems documentation and prepare reports on analyses
• obtain information from other staff, advise on technical requirements, and collaborate to achieve efficient collaborate to achieve efficient operation

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 Thursday, March 23, 2023 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.