Data Engineering Advisor

Role Overview

You will take the lead on designing, building, and maintaining the data integration pipelines that support our entire International Health Delivery Services operation. Your work ensures that data from policy administration systems is consistently transformed, validated, and delivered to the many downstream applications, including web portals and internal and external integrations. In this senior role, you will combine hands-on development with architectural oversight, resolving complex SQL Server and ETL issues while helping set the standard for how the team builds and supports its solutions.

Key Responsibilities

• Act as the principal technical designer for large-scale data integration initiatives, translating business requirements into reliable ETL and data modelling solutions.
• Develop, document, and test SSIS packages and SQL Server objects, ensuring robust performance and maintainability.
• Investigate and resolve complex SQL Server issues, performing root cause analysis to restore and improve data flows across all environments.
• Collaborate with business stakeholders and technical teams to define data mapping strategies and document the agreed approach.
• Own release support and monitoring of scheduled batch processes, proactively identifying failures and preventing disruption to downstream consumers.
• Continuously evaluate and improve existing code, tooling, and team practices, advocating for better ways of working.
• Provide technical leadership and mentoring to other developers, acting as an internal subject matter expert for the wider data engineering community.

Requirements & Qualifications

• Essential: 5+ years developing and supporting Microsoft SQL Server solutions, with advanced T-SQL skills covering stored procedures, views, functions, and query optimisation.
• Essential: Strong grasp of database design, data modelling, and performance tuning across both OLTP and OLAP environments.
• Essential: Proven experience delivering ETL solutions with SQL Server Integration Services, including debugging and performance tuning of packages.
• Essential: Ability to analyse complex business needs and turn them into technical specifications, data mappings, and scalable implementations.
• Essential: Hands-on experience with source control and CI/CD practices for database deployments, along with solid troubleshooting and root cause analysis skills.
• Essential: Comfort working in an Agile environment and collaborating across geographically distributed teams.
• Desirable: Programming experience in C# or Python, and familiarity with modern data platforms such as PySpark or Databricks.
• Desirable: Exposure to cloud data services and AI-assisted development tools like GitHub Copilot or Cursor AI.
• Desirable: Prior experience working with health insurance or healthcare data.

What We Offer / Why Join

This is a chance to shape how critical data infrastructure evolves, with the freedom to bring your own ideas and an expectation that you will keep your skills current through ongoing training and learning. You will gain broad visibility across multiple technical disciplines and global teams, building your reputation as a go-to expert while influencing decisions that affect the entire data landscape.