Data Engineer - 12 Month Max Term Contract

Hollard Insurance Company; North Sydney; Hybrid; AUD 120,000 - 150,000; Full time

Benefits offered by this job

Flexible work options

Hybrid work model

Diversity & inclusion

Job summary

Hollard Insurance in Sydney is seeking a Data Engineer to design, build and maintain modern data engineering solutions on the Azure data platform and SAS environments.

You will work with cross‑functional teams to deliver reliable data pipelines, optimise ETL/ELT processes, and support data requirements across the business while maintaining data quality and governance.

Qualifications

• Hands on SAS 9.4 development within data warehousing or analytics environments.
• Strong Base SAS and SAS Macro skills, and proficiency in PROC SQL.
• Experience integrating SAS with SQL Server using SAS/ACCESS and LIBNAME engines.
• Proven data validation, reconciliation, and quality controls.
• Clear communicator able to explain data outputs to non‑technical stakeholders; SAS tools preferred.

Responsibilities

• Develop, maintain, and enhance SAS programs for ETL, data preparation, and analytics.
• Load and refresh data in SQL Server from SAS; optimize load performance and data integrity.
• Monitor production SAS jobs, resolve failures, and meet data quality SLAs.
• Optimise SAS and SQL code for performance and resource use; maintain Python scripts.
• Collaborate with cross‑functional teams and vendors to ensure data platform standards.

Skills

SAS 9.4

SAS Base

SAS Macro

PROC SQL

SAS Enterprise Guide

Data warehousing

Python

SQL Server

Data validation

Stakeholder communication

Tools

SAS DI Studio

LIBNAME

SAS Management Console

SAS/ACCESS

ODBC/OLE DB

Job description

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.