Job Title

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.ResponsibilitiesDevelop 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 standardsAnalyse 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 reportingCollaborate 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 terminologyProduce 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 governanceDefine and enforce data modelling standards, naming conventions, and data definitions.Support data governance efforts by ensuring models comply with privacy, security, and regulatory requirementsIntegrate data modelling and analysis tasks into automated CI/CD pipelines.Implement version control for data models and analysis code using different tools like Azure DevOpsExplore and implement AI and GEN AI/LLM capabilities to enhance data mapping and modelling effortsPerform work in a manner that complies with relevant regulatory standards including Work Health & Safety (WHS) legislationEssentialBachelor''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 proceduresAdvanced 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 techniqueExperience 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 desirableAbout 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 passionWe''re united by a common purpose: to make healthcare affordable, understandable, high quality and member-focused.Wellness and work-life balanceWe''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 arrangements50% subsidy on HCF hospital and/or extras coverFamily-friendly certified employer18 weeks of parental leave for all new parentsMental health and wellbeing programs, including workshops, fitness classes, flu vaccinations, skin checks and moreDiscounts 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 inclusivityWe 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 growthWe 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 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.