Senior Application Component Developer - Data Developer

Fonction publique de l'Ontario; Toronto; On-site; CAD 96,000 - 120,000; Full time

Job summary

Ontario Public Service is seeking a Senior Application Component Developer – Data Developer to join the Health Services I&T cluster in Toronto. You will lead data analytics initiatives, build dashboards, and shape real-time reporting and data-driven decisions for emergency health services.

The role requires expertise in Power BI, Azure cloud technologies, SQL Server, and modern data integration practices. Expect collaboration across multiple teams to deliver scalable data solutions for Ontario’s

Qualifications

• Thorough knowledge of large-scale, complex systems analysis techniques and methodologies, design and development.
• Strong proficiency with Microsoft SQL Server, T-SQL and SSMS for data querying and transformation.
• Experience developing ETL pipelines, data warehousing solutions and integrating data from multiple sources.

Responsibilities

• Lead design and implementation of data models, dashboards, reports and analytics solutions using Power BI.
• Develop and maintain SQL Server objects, data structures and data transformation processes.
• Provide technical leadership on software development, data integration and solution design initiatives.

Skills

Power BI

Azure

SQL Server

ETL pipelines

Data Modeling

DAX

Data Governance

Tools

SSMS

Azure Functions

Event Hub

Databricks

Data Factory

Job description

Senior Application Component Developer - Data Developer

Ministry of Public and Business Service Delivery and Procurement

Division:

City:

Toronto

Position(s) language:

Job term:

1 Temporary contract/assignment up to 12 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.

Guide Strategic IT Projects That Support Ontario's Health Priorities!

If you are a seasoned IT professional passionate about making a meaningful impact in public health, then join a dynamic team where your technical expertise will help shape the future of healthcare delivery in Ontario. As a Senior Application Component Developer, you will lead innovative technology initiatives that support emergency health services and drive digital transformation across the province.

Showcase your technical knowledge and skills in the role of Senior Application Component Developer with the Health Services I&IT Cluster, Emergency Health I&IT Solutions and Technology Management Branch.

About Us

The Health Services I&IT Cluster provides information management and information technology solutions that support the business requirements of the Ministry of Public and Business Service Delivery and Procurement and its agents. The cluster enables the Ontario government's I&IT Strategy and plays a leadership role in major business transformation initiatives and infrastructure projects.

The Emergency Health I&IT Solutions and Technology Management Branch is responsible for supporting Emergency Health Ambulance Dispatch within the province. We are transforming our solutions and data analysis needs by building and supporting real-time dashboards, reporting solutions, and mobile applications.

Our large and mission critical operations supporting 9-1-1 ambulance communication results in close collaboration with ambulance dispatch operational managers, paramedic services, ORNGE, other first responders and hospital emergency departments to ensure communication technologies are running smoothly and are well integrated to support policies and programs under the Ontario Ambulance Act. EHSTMB plans for and implements new, best-in-class technologies that prioritize 9-1-1 calls and help dispatchers and first responders assure the right resources are assigned to the right place, with the right information, at the right time.

About the job

Bring your expertise in data analytics, business intelligence, cloud technologies, and application development.

In this role, you will

• provide senior technical consulting expertise designing, developing, implementing and supporting advanced interactive applications and business intelligence solutions using Microsoft Power BI and Azure cloud technologies
• design, develop and maintain data solutions utilizing technologies such as Azure SQL, Azure Functions, Event Hub, Streaming Analytics, Data Factory and Databricks
• develop and maintain SQL Server database objects, data structures, data transformation processes and reporting solutions
• lead the design and implementation of data models, dashboards, reports and analytics solutions that support operational and strategic decision-making
• provide technical leadership and guidance on software development, data integration and solution design initiatives
• evaluate emerging technologies, recommend improvements and support implementation of enterprise data and reporting solutions
• identify training and knowledge transfer requirements for project teams and stakeholders
• coordinate the collection, analysis and interpretation of system and business data to support ongoing improvements and project deliverables

Note: Occasional travel throughout the province may be required to provide technical support to stakeholders.

What you bring to the team

Technical Skills and Experience

You have:

• thorough knowledge of large-scale, complex systems analysis techniques and methodologies, design and development, programming concepts and languages, internet/intranet technology and emerging technologies
• strong proficiency with Microsoft SQL Server, T-SQL and SQL Server Management Studio (SSMS) for data querying and transformation
• strong proficiency in writing SQL queries, stored procedures and triggers
• experience developing ETL pipelines, data warehousing solutions and integrating data from multiple data sources for analytics and reporting
• proven experience designing, developing and deploying data models, dashboards and reports using Power BI
• experience creating and maintaining dimensional data models
• experience with real-time data integration, event processing and streaming technologies
• expertise in DAX and Power Query (M Language) for creating dynamic and optimized business intelligence solutions
• familiarity with data governance, data quality standards and best practices for managing sensitive information
• demonstrated senior-level experience across the Software Development Lifecycle (SDLC) and Application Lifecycle Management (ALM)
• experience working with web services and API integrations
• experience developing secure, scalable applications leveraging cloud platforms such as Azure or AWS
• demonstrated experience with testing methodologies and application quality assurance practices
• experience debugging, refactoring and optimizing both legacy and modern codebases
• experience supporting mission-critical operational environments and stakeholders.

Analytical and Problem-Solving Skills

You can:

• identify, analyze and coordinate resolution of complex technical issues
• assess client and business requirements and translate them into practical technology solutions
• evaluate technology options and develop recommendations that support operational effectiveness, security and quality.

Communication and Interpersonal Skills

You can:

• clearly communicate technical concepts and recommendations to technical and non-technical audiences
• build effective working relationships with project teams, stakeholders, vendors and partners
• prepare technical documentation, reports and presentations
• work collaboratively in a team environment and consistently deliver results.

Project Management and Leadership Skills

You have:

• experience providing technical leadership on large and complex IT initiatives
• experience leading technical work, coordinating project activities and supporting delivery of project outcomes within established timelines
• experience working on multiple concurrent initiatives and managing competing priorities
• experience providing guidance and mentorship to technical team members and project stakeholders.

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