Cloud Data Engineer: Ab Initio to Redshift & AWS ETL

Zone IT Solutions Pty Ltd; Sydney; On-site; AUD 120,000 - 150,000; Full time

Job summary

Zone IT Solutions Pty Ltd is seeking an experienced Ab Initio Developer with strong SQL and cloud data migration expertise in Australia. The role involves modernising SQL Server databases to Amazon Aurora PostgreSQL, converting SSIS workflows to AWS Glue, migrating SSAS models to Redshift, and rebuilding reports with AWS QuickSight.

You will design scalable data ingestion pipelines, develop data models, and establish CI/CD for deployments, while adhering to governance and security practices.

Qualifications

• 5+ years in Database and Data Engineering.
• Strong SQL and performance tuning expertise.
• Experience with AWS data services (Glue, Redshift, QuickSight).
• DMS and Schema Conversion Tool desirable.
• Strong SQL and data modelling skills.
• Proficiency in Python and/or PySpark.
• Experience building ETL/ELT pipelines in the cloud.
• Familiar with Git, CI/CD, DevOps, and Agile delivery.
• 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/workflows.
• Migrate SSAS models/workloads to Amazon Redshift.
• Rebuild SSRS reports/dashboards using AWS QuickSight.
• Design and develop scalable data ingestion, transformation, and reporting solutions.
• Develop and optimise data models, schemas, and DB performance.
• Build and maintain CI/CD processes for 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

Performance tuning

AWS Glue

Amazon Redshift

AWS QuickSight

DMS

Schema Conversion Tool

Python

PySpark

ETL/ELT

CI/CD

Git

DevOps

Agile

Data governance

Tools

AWS Glue

Amazon Redshift

AWS QuickSight

AWS DMS

Schema Conversion Tool

SSIS

SSAS

SSRS

SQL Server

Aurora PostgreSQL

Job description

Zone IT Solutions Pty Ltd is seeking an experienced Ab Initio Developer with strong SQL and cloud data migration expertise in Australia. The role involves modernising SQL Server databases to Amazon Aurora PostgreSQL, converting SSIS workflows to AWS Glue, migrating SSAS models to Redshift, and rebuilding reports with AWS QuickSight.

You will design scalable data ingestion pipelines, develop data models, and establish CI/CD for deployments, while adhering to governance and security practices.