Senior Data Analyst - Civica Ensure

Teachers Health; Sydney; Hybrid; AUD 120,000 - 150,000; Full time

Benefits offered by this job

Hybrid working model

Subsidised private health insurance

Discounts on our products and services

Generous employee wellbeing program

Easily accessible by public transport

Job summary

Teachers Health is delivering a major platform transformation (Irongate Program) and Civica Ensure implementation. We are seeking a Senior Data Analyst to ensure data is defined, mapped, validated and reconciled across the end-to-end journey.

You will partner with business, technology and vendor stakeholders to deliver quality outcomes in a complex environment, shaping data definitions, mappings and validation rules for health insurance products.

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, 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).

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

SQL

Data profiling

Data quality management

Agile delivery

Education

Tertiary qualifications in Data Analytics/IT/CS/Statistics/Business

Tools

Civica Ensure

Jira

Confluence

Job description

Senior Data Analyst

At Teachers Health, we are 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.

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