Specialist, Data Modelling - 12 months

At IAG, we’re ready for you. We're the largest general insurance group in Australia and New Zealand. Our family of brands turns the IAG purpose of making your world a safer place into action by helping everyday Aussies and New Zealanders, supporting their ambitions and making insurance accessible. 
 
Shape the data foundations that bring smarter and more relevant customer experiences to life. As a Specialist, Data Modelling, you'll turn complex information into trusted, reusable models that support personalisation, analytics and strategic decision making. Working alongside data engineers and other business stakeholders, you'll help a growing squad deliver new initiatives within Retail Australia Insurance (RIA).  Your technical judgement, curiosity and collaborative approach will strengthen data quality, improve performance and help teams confidently turn ideas into meaningful outcomes.  

We have 2 x full-time fixed term roles (12 months) based in either Gadigal Country (Darling Park 2, Sydney) or Naarm (Melbourne). 
 
What You'll Do 
 
• Design and implement reusable data models using DBT and SQL to support personalisation, reporting, analytics and predictive modelling. 
• Optimise SQL queries, strengthen data quality checks and maintain the integrity and consistency of information across data processes. 
• Regularly review and fine-tune SQL queries and stored procedures, assisting in maintaining optimal data process performance 
• Maintain clear documentation of data models, ETL processes, DBT models, and SQL scripts, ensuring adherence to data security standards. 
• Explore emerging tools and approaches, recommending opportunities to improve performance, standards and ways of working. 
 
What You'll Bring 
 
• Strong capability designing and maintaining reusable data models using DBT, SQL and Python. 
• Experience working with cloud data platforms such as BigQuery, Snowflake or AWS. 
• Confidence translating complex requirements into scalable data structures and practical solutions. 
• A collaborative approach to working with technical teams, business partners and diverse stakeholders. 
• Experience supporting personalisation, marketing, analytics or predictive modelling initiatives would be valuable. 
• Exposure to Adobe, Java, Cloud Run, insurance or financial services would be beneficial. 
 
What We Offer 
 
• Boosted superannuation with 13% as standard. 
• 20 days annual leave + 5 days MyLeave (extra leave for what’s important to you). 
• Work from home and many more flexibility options with myFlex. 
• Up to 50% off personal insurance, including home and motor insurance. 
• Partner discounts on private health insurance, tech & appliances, and many more. 
• Access to LinkedIn Learning, the award-winning IAG Academy, study assistance and secondment opportunities. 
*employment type eligibility criteria apply 
 
 
Adjustments and Support  
 
If you require any support or adjustments to participate equitably in our recruitment process, we encourage you to reach out to [email protected] for a confidential conversation.  
 
More About Us  

As part of IAG you'll enjoy a world of career opportunities, a purpose-led place focused on creating connection and belonging, and where you can create meaningful impact every day and grow your career beyond the expected. That’s not just words. It’s our people promise. We're ready for you with unexpected opportunities for your career, your work-life and your ability to make a difference. We celebrate all viewpoints shaped by life experiences and culture, and are guided by the knowledge and voice of Aboriginal and Torres Strait Islander peoples, businesses, and communities. We collaborate on Indigenous-led solutions that enable growth and create meaningful change for our customers and employees.