Data Modeller – HCF Australia
Join to apply for the Data Modeller role at HCF Australia
This role exists to design and maintain high-quality data models that accurately represent the complex relationships within private health insurance, including member data, claims, benefits, providers, and regulatory reporting.
Responsibilities
- Develop and maintain conceptual, logical, and physical data models that reflect core business domains such as members, policies, claims, providers, benefits, and regulatory reporting.
- Ensure models are scalable, reusable, performant, and aligned with enterprise and data architecture standards.
- Analyse source systems to understand data structures, relationships, and business rules.
- Create and maintain detailed data requirements and data mapping documentation to support integration, transformation, and reporting.
- Collaborate with business SMEs, data engineers, analysts, and architects to gather requirements and translate them into data models.
- Facilitate workshops and walkthroughs to align models with business processes and terminology.
- Produce and maintain comprehensive documentation including data dictionaries, entity‑relationship diagrams, and lineage diagrams.
- Contribute to metadata management and data cataloguing initiatives to improve data discoverability and governance.
- Define and enforce data modelling standards, naming conventions, and data definitions.
- Support data governance efforts by ensuring models comply with privacy, security, and regulatory requirements.
- Integrate data modelling and analysis tasks into automated CI/CD pipelines.
- Implement version control for data models and analysis code using tools like Azure DevOps.
- Explore and implement AI and Gen AI/LLM capabilities to enhance data mapping and modelling efforts.
- Perform work in a manner that complies with relevant regulatory standards including Work Health & Safety (WHS) legislation.
Essential Qualifications
- Bachelor’s or Master’s degree in Computer Science, Engineering or a related discipline.
- 7+ years of commercial experience in a Data Modeller role.
- Proficient in Python and Advanced SQL, including fluency with PL/SQL procedures.
- Advanced data mapping and modelling skills – dimensional modelling (star/snowflake schemas, fact/dimension models), Normalisation and Denormalisation, and modelling tools (e.g. Erwin, SQL Server Data Tools, Visio).
- Experience with ETL/ELT and data warehousing concepts.
- Experience with Data Lakes and Data Warehouses (platforms like Snowflake, Databricks, Synapse, Amazon S3).
- Knowledge of Data Vault modelling technique.
- Experience gathering and documenting data & reporting requirements, data catalogues, lineage tools and internal governance frameworks.
- Prior experience in the private health insurance or healthcare domain is highly desirable.
- Experience in Gen AI/LLM for data platforms is desirable.
About HCF
At HCF, our purpose is to bring our human touch to healthcare. Since 1932 we’ve been putting our members and their health first. As Australia’s largest not‑for‑profit health fund, we cover 2 million members with health, life, travel and pet insurance and our vision is to make healthcare understandable, affordable, high‑quality and member‑centric.
Culture & Benefits
- Purpose‑driven passion: to make healthcare affordable, understandable, high‑quality and member‑focused.
- Wellness and work‑life balance: fitness classes, flu vaccinations, skin checks and more.
- 50% subsidy on HCF hospital and/or extras cover.
- 18 weeks of parental leave for all new parents.
- Discounts on HCF’s products, including life, pet and travel insurance, as well as discounts at Fitness First gyms and on our eyewear products.
- Collaboration and inclusivity: inclusive and safe environment for all employees.
- Continuous learning and growth: workshops, mentorship programs and opportunities for personal and career development.
Next steps
If you require any adjustments to assist you in making your application or during the recruitment or onboarding process, please reach out to Talent Acquisition – to discuss. We encourage applicants to submit their applications at their earliest convenience, as the role may have been filled prior to the job closing date.
#J-18808-Ljbffr