Senior Data Engineer

AC3; City of Melbourne; Hybrid; AUD 185,000 - 195,000; Full time

Job summary

AC3 in Melbourne is seeking a Senior Data Engineer to own and modernise the data environment. You will manage Microsoft SQL Server, develop complex SQL and SSIS ETL, and shape the enterprise data warehouse and BI reporting landscape.

The role offers a hybrid Melbourne setup with an office in Kew and two days work from home, targeting a senior, hands-on expert who can drive the data platform forward.

Qualifications

• 5+ years in a senior data engineering or DBA/warehouse-focused role.
• Strong expertise in Microsoft SQL Server environments.
• Experience designing and implementing enterprise data warehouses.

Responsibilities

• Administer, maintain, secure and optimise Microsoft SQL Server environments.
• Develop and optimise complex SQL, stored procedures, functions, views and database objects.
• Design and maintain enterprise data warehouse solutions and dimensional models.
• Build and support ETL/ELT pipelines including SSIS development.
• Develop and optimise Power BI semantic models, datasets, reports and dashboards.
• Support integrations across APIs, XML/JSON and business systems.
• Troubleshoot complex database, data warehouse and reporting issues.
• Support SQL Server upgrades, migrations and data-platform modernisation.
• Apply data security, privacy, governance and quality practices.

Skills

SQL Server administration

SQL development

Data Warehouse

SSIS/ETL/ELT

Power BI

PowerShell

XML/API integrations

Troubleshooting

Tools

SQL Server

Job description

Senior Data Engineer – SQL Server | Data Warehouse | Power BI

• Salary Package: $185,000 - $195,000
• Melbourne
• Office in Kew, with 2 days working from home

We are partnering with an established healthcare provider to recruit an experienced Senior Data Engineer to join their Melbourne-based technology team.

This is a hands-on senior role for someone who is genuinely strong across Microsoft SQL Server, database administration and development, enterprise data warehousing, ETL/SSIS and Power BI.

You'll take ownership across the existing data environment while also playing an important role in its future modernisation, including a planned SQL Server 2019 to SQL Server 2025 upgrade and the evaluation and phased adoption of Microsoft Fabric.

What you'll be doing

• Administer, maintain, secure and optimise Microsoft SQL Server environments
• Develop and optimise complex SQL, stored procedures, functions, views and database objects
• Design and maintain enterprise data warehouse solutions and dimensional data models
• Build and support ETL/ELT pipelines, including advanced SSIS development
• Develop and optimise Power BI semantic models, datasets, reports and dashboards
• Support integrations across APIs, XML/JSON and business systems
• Troubleshoot complex database, data warehouse and reporting issues
• Support SQL Server upgrades, migrations and broader data-platform modernisation
• Apply strong data security, privacy, governance and quality practices

The role covers the full data lifecycle rather than being purely a reporting or BI position.

What we’re looking for

You will ideally have 5+ years' experience as a Senior Data Engineer, Database Administrator, Data Warehouse Developer or in a similar hands-on role, with:

• Expert Microsoft SQL Server administration
• Advanced SQL development, query tuning, indexing and performance optimisation
• Strong enterprise Data Warehouse experience
• Advanced SSIS / ETL / ELT experience
• Experience supporting business-critical production environments
• Experience with major SQL Server upgrades or migrations
• Practical experience with PowerShell and XML/API-based integrations
• Strong troubleshooting, documentation and stakeholder communication skills

Exposure to Microsoft Fabric, Azure data technologies or broader Microsoft data-platform modernisation will be highly regarded.

Experience within healthcare, private health insurance, hospitals or health data would be a strong advantage, but is not essential. Candidates coming from other complex, highly regulated or data-intensive environments are encouraged to apply.

Why consider this opportunity?

This is an opportunity to step into a genuinely senior, hands-on position where you can influence the organisation's data environment rather than simply maintain one component of it. You'll work across SQL Server, Data Warehouse, integration and Power BI, while contributing to a significant technology modernisation roadmap.