- Company Name
- eHealth Saskatchewan
- Job Title
- Internal to eHS - Senior Data Engineer
- Job Description
-
**Job title**
Senior Data Engineer – Internal to eHS
**Role Summary**
Design, develop, and maintain the data infrastructure powering analytics, reporting, and research across Saskatchewan’s health system. Build scalable ETL/ELT pipelines, architect relational and dimensional models, and ensure high‑quality, secure data flow into the Provincial Data Platform, while mentoring junior staff and collaborating with health partners.
**Expactations**
- Deliver robust, well‑governed data products that support health‑system decision‑making and research.
- Lead technical initiatives, ensuring compliance with data sharing agreements and legislative requirements.
- Provide expert guidance to Information Analysts and junior resources.
**Key Responsibilities**
- Design and build ETL/ELT pipelines using IDMC, SQL, SSIS, Python, APIs, Fabric integration tools, Git, and deployment pipelines.
- Architect relational and dimensional models (star/snowflake, fact tables, cubes, slowly changing dimensions) aligned to platform standards.
- Optimize and automate data processes for scalability, performance, reliability, and timeliness.
- Monitor, troubleshoot, debug, and perform backup/recovery of ETL environments.
- Validate and analyze datasets against architecture guidelines and compliance requirements.
- Translate business requirements from eHealth teams and health system partners into technical solutions.
- Mentor Information Analysts and junior data resources.
**Required Skills**
- Strong SQL expertise and performance‑tuning knowledge (Oracle and/or SQL Server).
- Proven ETL experience (IDMC, SSIS, SQL, Python, APIs, Fabric tools, Git).
- Programming/scripting (PL/SQL, Python, R, shell) for automation and transformation.
- Technical leadership, with excellent communication, problem‑solving, and organizational skills.
**Required Education & Certifications**
- Bachelor’s degree in Computer Science, Health Informatics, Biomedical Statistics, Epidemiology, Statistics, Mathematics, or related discipline.
- Minimum 5 years as a Data Engineer or equivalent role.
- Microsoft Certified: Azure Data Engineer Associate (or comparable cloud certification) considered an asset.
- Knowledge of Saskatchewan health data and cloud data platforms is advantageous.