Architect Solutions That Enable Better Health Outcomes!Technology is essential to ensuring children and youth receive timely, effective mental health services. As a Senior Application Specialist, you will support and sustain the Children and Youths Mental Health business application, a critical system relied upon by internal teams and external health-care partners across the province. In this role, you will provide senior-level technical expertise to maintain application stability, security, and compliance with ministry standards, while adapting to evolving business and user needs. By collaborating with stakeholders, vendors, and project teams, you will help ensure the application continues to enable high-quality service delivery in children's mental health.
About Us:The Health Services I&IT Cluster delivers information management and technology solutions that support the business needs of Ontario's health sector. We play a key role in advancing the Ontario government's I&IT Strategy, leading major transformation initiatives and infrastructure projects, and supporting the evolution toward a modern, shared IT infrastructure across government.
About the job
In this role, you will:
• Design, develop, troubleshoot and maintain Extract Transform and Load (ETL) processes.
• Participate to the data warehouse design process ensuring the data models can be efficiently loaded by ETL.
• Working closely with business and data architects, participate in preparation of detailed ETL technical specifications.
• Perform unit and integration ETL testing in order to ensure data quality and integrity.
• Develop technical documentation to facilitate future support.
• Monitor ETL processes in order to improve performance and error handling.
What you bring to the team
Technical Knowledge
You have:
• In-depth knowledge of Extract, Transform, Load (ETL) and data warehousing concepts.
• Experience building mappings and workflows using Informatica Powercenter and/or Intelligent Data Management Cloud and/or other data processing tools.
• Strong experience working with relational databases on prem and on cloud.
• Knowledge/experience working with public clouds (AWS or Azure) services.
• Solid experience using scripting languages (such as Linux shell, Python).
• Data management domain knowledge such as data quality, master data management, data virtualization, and data de-identification.
Analytical and Problem Solving Skills
You have:
• Analytical skills to assess the client needs and propose suitable technical solutions.
• Ability to analyze data and recommend improvements to related business processes.
• Ability to translate business requirements into data solutions.
Communication and Interpersonal Skills
You have:
• Demonstrated interpersonal, conflict resolution, team building and client relationship management skills.
• Excellent oral and written communication skills and are able to interact with both technical and non-technical people.
Project Management Skills
You have:
• Familiarity with traditional waterfall and agile project management methodologies.
• Knowledge of the Incident and Change Management processes.
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:
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