Data Engineer - 12 Month Max Term Contract

Salary: Flexible working opportunity

• A great opportunity to work with one of Australia’s largest general insurers

• Be part of a collaborative and innovative data team

• Open to Sydney candidates only - Hybrid working

About Hollard

Hollard Insurance is part of the Hollard Group of Companies and one of Australia’s largest general insurers Australia and New Zealand. We underwrite a broad range of general insurance products, including motor, home, contents, business, bicycle and pet, in proud partnership with some of Australia's biggest consumer brands and broker businesses. As an independent and privately owned company, we believe we can go further together – for our people, customers, communities and partners – through an innovative approach to providing insurance.

Our state-of-the-art facilities in North Sydney reflect our commitment to providing innovative workspaces that support hybrid and remote work.

Your Team

You will be part of a multi-disciplinary technology team, working closely with our customers (business, software vendors and partners) and strategic project teams. The team is responsible for the development, implementation and maintenance of the Hollard Data Platform that support our customers through all aspect of the insurance value chain. The team is involved in all aspects from design through to testing, implementation, maintenance and support. You will be surrounded by data professionals that strive for excellence and implement data best practices to realise business value.

Your Role

As a Data Engineer, you will report to the Product Owner your key focus areas will be to design, build, and support the delivery of modern data engineering solutions in the Azure data platform and legacy SAS platform, balancing the enhancement of ETL/ELT processes while supporting short term data requirements from across the business.

You will work collaboratively with cross-functional teams within Hollard, including the Infrastructure DevOps team, solution architects, subject matter experts, data modelers, Finance, Underwriting, Operations, etc. This collaboration aims to ensure that Hollard’s data platform ecosystem is optimal in supporting business needs. Additionally, you will work collaboratively with vendors and partners to ensure that data engineering delivery and practices meet Hollard’s standards.

Your duties and responsibilities

• Develop, maintain, and enhance SAS 9.4 programs (Base SAS, SAS Macros, PROC SQL, and DI Studio/Enterprise Guide where applicable) for ETL, data preparation, and analytics.

• Load and refresh data in SQL Server from SAS, using SAS/ACCESS, LIBNAME, and pass through SQL, with attention to load performance and data integrity.

• Monitor and support production SAS jobs and schedules, resolve failures, and meet data quality standards and business SLAs

• Optimise SAS code and SQL (including T-SQL and stored procedures) for performance and efficient resource use.

• Maintain related Python scripts and SQL Server stored procedures as part of the data pipelines.

About You

• Hands on experience in SAS 9.4 development within data warehousing or analytics environments.

• Strong Base SAS and SAS Macro skills, and proficiency in PROC SQL and commonly used procedures

• Experience integrating SAS with SQL Server, including SAS/ACCESS, ODBC/OLE DB, LIBNAME engines, pass-through SQL, bulk loading

• Proven experience in data validation, reconciliation, and quality controls

• Clear communicator who can explain data and analytical outputs to non-technical stakeholders

• Experience with SAS Data Integration Studio, SAS Enterprise Guide, or SAS Management Console is preferred

Working at Hollard

At Hollard, you'll discover an environment where you can truly make an impact. We offer the best of both worlds – the opportunity, agility and creativity of a company growing with scale, alongside a focus on becoming a catalyst for enduring, positive, social change.

We're a tight-knit team, where authentic voices and unique perspectives matter. We work supportively, collaboratively and inclusively to help shape our future and create shared value for our communities.

Hollard proudly promotes flexible work including remote work, non-traditional work patterns, and work-family balance. We're also unapologetically committed to creating a workplace that values your diversity with a true sense of inclusion. We actively seek to hire for your different lived experiences, including as it relates to disability, ethnicity, faith, Aboriginal and Torres Strait Islander Peoples, gender diversity, sexual orientation, age, neurodiversity.

We're building something special. Working closely with our industry partners to reshape insurance for the better, we're people changing insurance.

Please note: Even if you don't meet all our selection criteria, we encourage you to apply.

A full background check will be completed on the successful applicant.

Australian work rights are required for this position.

Visit the Hollard careers page to learn about how Hollard will collect, store and handle your personal information.

We are NOT engaging Recruitment Agencies for this role and ask agencies to respect our policy of no unsolicited contact regarding advertised vacancies.