Senior Application Component Developer - Data Developer

Public & Business Services & Procurement | Services au public et aux entreprises & Approvisionnement

Toronto

On-site

CAD 110,000 - 140,000

Full time

4 days ago

Be an early applicant

Application generator

Stand out for this role — generate a tailored resume and cover letter in about a minute.

Get past ATS filters

Job summary

Public & Business Services & Procurement | Services au public et aux entreprises & Approvisionnement in Ontario is seeking a Senior Application Component Developer to lead data analytics initiatives that support Emergency Health services and drive digital transformation across the province.

You will collaborate across the Health Services I&IT Cluster, Emergency Health I&IT Solutions, and Technology Management Branch, leveraging Power BI, Azure, and SQL Server to deliver real-time dashboards and

Qualifications

Thorough knowledge of large-scale systems analysis, design and development.
Proficiency with SQL Server, T-SQL, and SSMS for data querying and transformation.
Experience developing ETL pipelines, data warehousing, and analytics data integration.
Proven experience designing, developing and deploying dashboards and reports using Power BI.
Experience with real-time data integration and streaming technologies.
Expertise in DAX and Power Query for BI solutions.
Familiarity with data governance, quality standards and securing sensitive data.
SDLC/ALM expertise and strong senior-level software development lifecycle experience.
Experience with web services and API integrations.

Responsibilities

Provide senior technical consulting for interactive applications and BI solutions using Power BI and Azure.
Design, develop and maintain data solutions with Azure SQL, Functions, Event Hub, Streaming Analytics, Data Factory and Databricks.
Develop and maintain SQL Server objects, data structures, and transformation processes.
Lead the design and implementation of data models, dashboards, reports and analytics for decision-making.
Provide technical leadership on software development and data integration initiatives.
Evaluate emerging technologies and support enterprise data and reporting solutions.
Identify training and knowledge transfer requirements for project teams and stakeholders.
Coordinate collection and interpretation of system and business data for improvements and deliverables.

Skills

Senior technical consultant

SDLC/ALM

Team leadership

Stakeholder collaboration

Problem solving

Tools

Power BI

Azure

Azure SQL

SQL Server

SSMS

Data Factory

Databricks

Event Hub

Power Query (M)

DAX

APIs

Job description

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 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

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

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

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.

Additional information

Address