Senior Data Analyst - Civica Ensure

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

Role Title

At Teachers Health, we’re undertaking a significant platform transformation through the Irongate Program and the implementation of the Civica Ensure platform. We’re seeking a highly capable Senior Data Analyst to play a critical role in the successful delivery of new health insurance products by ensuring data is accurately defined, mapped, validated and reconciled across the end‑to‑end customer and operational journey.

This is an exciting opportunity for an experienced data professional who thrives in complex transformation environments and enjoys partnering with business, technology and vendor stakeholders to deliver quality outcomes.

What we have to offer?

We at Teachers Health have a lot to offer,

• Hybrid working model (flex your work/life balance)
• Subsidised private health insurance
• Discounts on our products and services
• Generous employee wellbeing program
• Easily accessible by public transport

What will you do?

• 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.

What are we looking for?

• 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, including membership, claims, benefits, billing and policy administration data.
• Strong experience in enterprise data mapping, profiling, reconciliation and data quality management.
• Advanced SQL skills with a proven ability to analyse, validate and troubleshoot data.
• Experience working with reference data, transformation rules and test data preparation.
• Exposure to Agile delivery methodologies and tools such as Jira and Confluence.
• Tertiary qualifications in Data Analytics, Information Technology, Computer Science, Statistics, Business or a related discipline (or equivalent experience).

Who are we?

Teachers Health was created by teachers for teachers over 70 years ago and is the only health fund exclusively for the education community. As a not‑for‑profit health fund, we exist for our members covering the lives of over 500,000 teachers, education staff & their families.

Due to the high number of applicants, only shortlisted candidates will be contacted.

Teachers Health values diversity and inclusion and encourages applications from people with diverse backgrounds including First Nations people, people with disability, people from diverse cultural and linguistic backgrounds, and people that identify as LGBTQIA+. Applicants can request an adjustment at any stage during the recruitment process by getting in touch with ****@teachershealth.com.au