Senior Data Engineer — AWS Data Platform Modernization

Zone IT Solutions Pty Ltd; Sydney; On-site; AUD 140,000 - 190,000; Full time

Job summary

Zone IT Solutions Pty Ltd in Sydney is seeking a Senior Data Engineer to support a large-scale SQL Server to AWS data platform modernization and migration.

You will modernise databases, migrate ETL/ELT workloads to AWS Glue and Redshift, and rebuild analytics and reporting workloads with cloud-native tools. Collaboration with architects, stakeholders and DevOps teams is essential, with CI/CD and data governance in scope.

Qualifications

• 5+ years' experience in Database and Data Engineering.
• Strong SQL and database performance tuning.
• Experience with AWS data services including Glue, Redshift, Quick, DMS and SCT desirable.
• Strong SQL and data modelling skills.
• Proficiency in Python and/or PySpark.
• Experience building ETL/ELT pipelines and cloud-native data solutions.
• Familiarity with Git, CI/CD, DevOps, and Agile delivery practices.
• Understanding of data governance, security, and operational support.

Responsibilities

• Modernisation of SQL Server databases to Amazon Aurora PostgreSQL.
• Analyse and convert SSIS ETL workflows into AWS Glue jobs and workflows.
• Migrate SSAS models and analytical workloads into Amazon Redshift.
• Rebuild SSRS reports and dashboards using AWS Quick.
• Design and develop scalable data ingestion, transformation, and reporting solutions.
• Develop and optimise data models, schemas, and database performance.
• Build and maintain CI/CD processes for database and data pipeline deployments.
• Implement data quality, monitoring, and operational support capabilities.
• Collaborate with architects, developers, business stakeholders, and reporting teams to deliver migration outcomes.
• Support testing, reconciliation, cutover, and post-production activities.

Skills

SQL

Data Modeling

Python

PySpark

ETL/ELT pipelines

Git & CI/CD

DevOps

Agile delivery

Data governance

Security

Tools

AWS Glue

Amazon Redshift

AWS Quick

AWS DMS

Schema Conversion Tool

Job description

Zone IT Solutions Pty Ltd in Sydney is seeking a Senior Data Engineer to support a large-scale SQL Server to AWS data platform modernization and migration.

You will modernise databases, migrate ETL/ELT workloads to AWS Glue and Redshift, and rebuild analytics and reporting workloads with cloud-native tools. Collaboration with architects, stakeholders and DevOps teams is essential, with CI/CD and data governance in scope.