Senior Data Analyst: Health Insurance Data & Transformation

Teachers Health Fund; Sydney; Hybrid; AUD 130,000 - 170,000; Full time

Benefits offered by this job

Hybrid working model (flex your work/l

Subsidised private health insurance

Discounts on our products and services

Generous employee wellbeing program

Easily accessible by public transport

Job summary

Teachers Health Fund is seeking a Senior Data Analyst to drive data definition, mapping, validation and reconciliation across end-to-end customer and operational journeys as part of the Irongate Program and Civica Ensure implementation.

You will partner with business, technology and vendor stakeholders in a complex transformation to deliver high-quality health insurance data and insights. This hybrid role offers a mix of office presence and flexible work arrangements in Sydney.

Qualifications

• 5+ years’ experience in Data Analysis within complex transformation, migration or technology delivery environments.
• Experience with Civica Ensure is a must.
• Knowledge of Private Health Insurance data (membership, claims, benefits, billing, policy administration).
• Strong experience in enterprise data mapping, profiling, reconciliation and data quality management.
• Advanced SQL skills to analyse, validate and troubleshoot data.
• Experience with reference data, transformation rules and test data preparation.
• Exposure to Agile delivery methodologies and Jira/Confluence.
• Tertiary qualifications in Data Analytics, IT, CS, Statistics or related discipline.

Responsibilities

• Translate product designs and business rules into data definitions, mappings, reference data and validation rules.
• Develop and maintain source-to-target mappings, data dictionaries and transformation logic.
• Profile, validate and reconcile data to identify and resolve quality issues.
• Design and execute pre- and post-load reconciliations and exception analysis.
• Write SQL queries to investigate defects and support data validation activities.
• Support SIT, UAT, regression and end-to-end testing through test data preparation and validation.
• Investigate data issues, identify root causes and coordinate remediation efforts.
• Maintain traceability between requirements, mappings, testing outcomes and business acceptance.
• Support deployment, production validation, product launch and hypercare activities.

Skills

Data analysis in transformation/migrat

SQL skills

Agile delivery

Data profiling

Data quality management

Data mapping

Data reconciliation

Stakeholder partnering

Education

Data analytics/IT-related degree

Tools

Civica Ensure

Jira

Confluence

Job description

Teachers Health Fund is seeking a Senior Data Analyst to drive data definition, mapping, validation and reconciliation across end-to-end customer and operational journeys as part of the Irongate Program and Civica Ensure implementation.

You will partner with business, technology and vendor stakeholders in a complex transformation to deliver high-quality health insurance data and insights. This hybrid role offers a mix of office presence and flexible work arrangements in Sydney.