Consultant, Integrated Analytics (Data Engineer)

St. Joseph's Health Care London; London; On-site; CAD 80,000 - 100,000; Full time

Job summary

A leading health care organization is seeking a Consultant, Integrated Analytics (Data Engineer) to design and maintain scalable data platforms. This role involves developing data solutions, optimizing ETL processes, and ensuring data governance in a collaborative environment. Ideal candidates will have a strong background in data engineering, cloud platforms, and health care data systems.

Qualifications

• Minimum 5 years related work experience.
• Proven experience as a Data Engineer.
• Solid understanding of data warehousing and modeling concepts.

Responsibilities

• Design and implement data platforms and warehouses.
• Develop and optimize data pipelines using SSIS and Azure tools.
• Ensure data integrity, quality, and compliance.

Skills

Data Infrastructure

Data Warehousing

Data Modeling

Data Governance

Data Security

AI Workflows

Project Management

Collaboration

Analytical Skills

Education

Four-year Bachelor's degree in computer science

Tools

Microsoft SQL

Oracle

Azure

Power BI

SSIS

SSRS

Job description

Consultant, Integrated Analytics (Data Engineer)

Join to apply for the Consultant, Integrated Analytics (Data Engineer) role at St. Joseph's Health Care London

Consultant, Integrated Analytics (Data Engineer)

Join to apply for the Consultant, Integrated Analytics (Data Engineer) role at St. Joseph's Health Care London

Quality Measurement and Clinical Decision Support

St. Joseph's Hospital - London, ON

Full Time

Salary Range: $53.51 - $62.96 /hour

Quality Measurement & Clinical Decision Support (QM&CDS) provides leadership and expertise in the development of integrated analytics and methodologies for measurement to support quality improvement, patient safety, performance measurement, and initiatives supporting the strategic plan. QM&CDS manages key information systems including the Patient Safety Reporting System, National Rehabilitation Reporting System, Resident Assessment Instruments, Informed Workload Measurement System, and Case Costing System.

The Integrated Analytics Consultant / Data Engineer is responsible for designing, building, and maintaining scalable data platforms and pipelines for SJHC London. The position will provide a broad range of data engineering functions including data modeling, data quality, data profiling, data acquisition and ingestion, extract transform load (ETL), metadata enrichment and management, data provenance and lineage, and other specialized data management functions.

On a Daily Basis, You Will Work On

• Data Solution Development: Design and implement data platforms and warehouses using Microsoft SQL, Oracle, Fabric, ensuring seamless integration with current and future data repositories and analytics platforms.
• ETL/ELT Processes: Develop and optimize data pipelines using SSIS and Azure tools to support data ingestion, transformation and integration from in-house data sources and cloud service providers via APIs.
• Analytics Product Development (Reports, Dashboards, data exchange): Microsoft Reporting Technologies (SSRS, PowerBI) and other reporting tools and data/information exchange technologies.
• AI Integration: Leverage AI capabilities to automate data preparation, transformation, and analysis tasks, enhancing data engineering workflows
• Data Governance: Ensure data integrity, quality, and compliance within our on-premises DWH and Microsoft Fabric environments, implementing best practices for data management
• Performance Optimization: Monitor and enhance the performance of data models, queries, and ETL processes to ensure scalability and efficiency
• Optimize data workflows, ensuring reliability, scalability, and performance
• Collaborate with internal stakeholders to understand data needs and deliver tailored solutions
• Ensure data security and compliance with industry standards and best practices
  
  

Essential Qualifications

• Four-year Bachelor's degree in computer science
• Minimum 5 years related work experience
• Proven experience as a Data Engineer with a focus on data infrastructure
• Solid understanding of data warehousing and modeling concepts
• Demonstrated experience with cloud platforms including Azure and Microsoft Fabric and Power BI
• Advanced technical skills with SSAS/SSRS/SSIS and other business intelligence tools, T-SQL coding abilities and experience with MDX and DAX
• Experience in optimizing databases; solid understanding of referential integrity and the use of indexes
• Demonstrated experience with security best practices for data handling and storage.
• AI and Machine Learning Familiarity: Understanding of AI workflows
• Familiarity with version control systems
• Project management skills and documentation skills
• Experience working with health care data and knowledge of hospital systems such as Cerner systems and other sector-specific clinical information systems such as the National Rehabilitation Reporting System
• Excellent organizational skills with the ability to prioritize and execute tasks while managing multiple projects
• Demonstrated skill and experience working in a team-oriented, collaborative environment
• An analytical nature, life-long learner and excellent written and oral communications skills are requirements for this position
• Demonstrated self-awareness and an understanding of personal strengths and weaknesses in pursuit of continuous improvement
  
  

Teaching and Research

• St. Joseph's Health Care London through its affiliation with Western University and Fanshawe College is a leading research and teaching hospital. As an employee of St. Joseph's, you will be expected to engage in role related teaching and research activities in addition to any of your clinical duties
  
  

Immunization Requirements

• Provide vaccination records or proof of immunity against measles, mumps rubella, varicella (chicken pox), Hepatitis B, COVID-19 and influenza.
• Provide documentation of the Tuberculosis skin testing

Seniority level

• Seniority level

  Mid-Senior level

Employment type

• Employment type

  Full-time

Job function

• Job function

  Research, Analyst, and Information Technology

• Industries

  Hospitals and Health Care

Referrals increase your chances of interviewing at St. Joseph's Health Care London by 2x

Sign in to set job alerts for “Analytics Consultant” roles.

Quantitative Modeling Analyst – Data Science

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.