Data Engineer

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

We are looking for a Senior Data Engineer with strong experience in database engineering, SQL, and AWS data services to support a large-scale SQL Server to AWS data platform modernisation and migration program.

• 5+ years' experience in Database and Data Engineering.
• Strong expertise in SQL and database performance tuning.
• Experience with AWS data services including :
• *AWS Glue
• *Amazon Redshift
• *AWS Quick
• *AWS DMS and Schema Conversion Tool (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.

Key Responsibilities :

• Modernisation 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.

About Us

We specialize in Digital, ERP, and larger IT Services. We offer flexible, efficient and collaborative solutions to any organization that requires IT, experts. Our agile, agnostic, and flexible solutions will help you source the IT Expertise you need.

Also follow ou r Linked In page for new job opportunities and more.

Zone IT Solutions is an equal opportunity employer and our recruitment process focuses on essential skills and abilities. We encourage applications from a diverse array of backgrounds, including individuals of various ethnicities, cultures, and linguistic backgrounds, as well as those with disabilities.