Job Description

Company description:

The Clinix Health Group (CHG) assists communities to live longer, healthier lives through the provision of quality and affordable healthcare. The group provides integrated world-class healthcare systems both internally and externally to the broader ecosystem as a trusted local citizen.

Job Title : Senior Data Engineer

Location : Clinix Head Office (Hyde Park)

Reports to : Head of Data Science and Analytics

JOB SUMMARY

We are seeking a Senior Data Engineer to lead the design, development, and optimization of scalable data pipelines and platforms. This is a hands-on technical role with strategic impact, ideal for someone who is passionate about building robust data infrastructure that powers analytics, automation, and decision-making in a hospital group.

REQUIREMENTS

Minimum Qualifications

Bachelor's degree in computer science, Information Systems, or related field.

Minimum Experience

Minimum 5+ years in data engineering, with proven experience in data warehouse design and development. Experience in building scalable data infrastructure and integrations. Advanced SQL knowledge and working with RDBMS such as SQL Server, and Strong understanding of data governance, security, and compliance. Excellent communication and documentation skills.

TECHNICAL SKILLS

SQL Server (Advanced): T-SQL, CTEs, window functions, schema design, performance tuning. SSIS: Lookup, Merge Join, Conditional Split, Derived Column, incremental loads. Python: pandas, SQL alchemy, API integration, automation scripting. Workflow Automation: SQL Server Agent, Windows Task Scheduler, PowerShell. Cloud & DevOps (Bonus): Azure Data Factory, CI/CD pipelines. Deliver & Mentor: Build and enhance robust data pipelines, manage real-time and historical data migrations, and guide junior data engineers. Strong SQL development, data modelling, and data governance skills.

DELIVERABLES

Design, build, and maintain ETL/ELT pipelines using SQL Server, SSIS, and Python. Automate data ingestion from SAP, APIs, and external databases into a centralised data warehouse. Optimize SQL Server performance through indexing, partitioning, and execution plan analysis. Develop and manage SSIS packages with advanced transformations and dynamic workflows. Implement orchestration using SQL Server Agent, PowerShell, and Python scripts. Collaborate with cross-functional teams to support analytics, reporting, and machine learning workflows. Reverse-engineer and document data lineage across systems for governance and traceability. Drive performance tuning, monitoring and continuous improvement initiatives across all data platforms. * Mentor and guide junior data engineers.