Senior Cloud Data Engineer — AWS Modernisation & Analytics

Whizdom; Sydney; On-site; AUD 150,000 - 190,000; Full time

Job summary

Whizdom is seeking a Senior Data Engineer to lead cloud data modernisation efforts in Sydney, migrating legacy SQL Server platforms to AWS-native services and modernising analytics workloads. The role requires strong SQL skills, data modelling, and experience delivering ETL pipelines in a cloud environment.

You will design scalable data solutions, collaborate with cross-functional teams, and contribute to the transformation programme across enterprise and government clients.

Qualifications

• 5+ years of experience in Data Engineering and Database Engineering.
• Strong SQL development and database performance tuning.
• Hands-on experience with AWS data services including Aurora PostgreSQL, Glue, Redshift, QuickSight.
• Experience with Git and CI/CD pipelines, DevOps practices, and Agile methodologies.
• Knowledge of data governance, security, and operational support requirements.

Responsibilities

• Modernise SQL Server databases to AWS-native equivalents.
• Analyse and convert SSIS ETL workflows into AWS Glue jobs and workflows.
• Migrate workloads to Amazon Redshift and rebuild reporting on AWS.
• Design and build scalable data ingestion, transformation, and reporting solutions.
• Develop and optimise database structures, schemas, and performance.
• Implement CI/CD pipelines for data and database deployments.
• Establish data quality, monitoring, and operational support frameworks.
• Collaborate with architects, developers, business stakeholders, and reporting teams.
• Support testing, reconciliation, cutover activities, and post-production support.

Skills

Data engineering

SQL development

Database tuning

Python/PySpark

Git

CI/CD

AWS data services

Tools

Git

CI/CD

Job description

Whizdom is seeking a Senior Data Engineer to lead cloud data modernisation efforts in Sydney, migrating legacy SQL Server platforms to AWS-native services and modernising analytics workloads. The role requires strong SQL skills, data modelling, and experience delivering ETL pipelines in a cloud environment.

You will design scalable data solutions, collaborate with cross-functional teams, and contribute to the transformation programme across enterprise and government clients.