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 different 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 Bachelor’s or Master’s degree in Computer Science, Engineering or a related discipline 7 years of commercial experience in a Data Modeller role. Python and Advanced SQL experience, including fluency with PL/SQL procedures Advanced data mapping and modelling skills – dimensional modelling (star/snowflake schemas, fact/dimension models), Normalisation and Denormalisation (for logical and physical model design) and Modelling Tools (e.g. Erwin, SQL Server Data Tools, Visio). Experience in 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. We want to be true health partners to our members, easily guiding the healthcare choices that are right for them. At HCF, our values are the way we do things and create the necessary culture to help us realise our purpose and deliver our Strategy. Living our values in action we step forward, walk in their shoes, stay human, make it better and get there together. Culture & Benefits Purpose-driven passion We’re united by a common purpose: to make healthcare affordable, understandable, high quality and member-focused. Wellness and work-life balance We’ll empower you with the necessary skills and tools to support your personal wellbeing journey, ensuring you perform at your best. Our offerings include: Flexible working arrangements 50% subsidy on HCF hospital and/or extras cover Family-friendly certified employer 18 weeks of parental leave for all new parents Mental health and wellbeing programs, including workshops, fitness classes, flu vaccinations, skin checks and more Discounts on HCF’s products, including life, pet and travel Insurance, as well as discounts at Fitness First gyms and on our eyecare products. Collaboration and inclusivity We embrace diversity as our strength and are committed to maintaining an inclusive and collaborative work environment. Our workplace is welcoming and safe for all our employees, irrespective of their unique characteristics including age, ethnicity, cultural or spiritual background, gender identity, disability, education and socio-economic status. Continuous learning and growth We believe in lifelong learning. HCF provides opportunities for personal and professional development. From workshops to mentorship programs, we encourage your growth and curiosity. 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 – peopleservices@hcf.com.au to discuss. We encourage applicants to submit their applications at their earliest convenience, as at HCF, we review applications as they are submitted, and may have filled the role prior to the job closing date.