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 Analytics and Data Science

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.