Senior Data Engineer: Cloud Migration & Analytics

Umbrella Club; Sydney; On-site; AUD 140,000 - 190,000; Full time

Job summary

Umbrella Club is seeking a Senior Database & Data Engineer to lead migration of legacy SQL Server platforms to AWS, including Aurora PostgreSQL, Glue, Redshift and QuickSight. You will design scalable ETL/ELT pipelines, optimise queries and schemas, and build modern data architectures in a complex enterprise setting.

The role requires 5+ years of database/data engineering experience, hands-on SQL tuning, data modelling proficiency, and strong collaboration with architects, developers and

Qualifications

• 5+ years of Database / Data Engineering experience.
• Strong hands-on SQL development and database performance tuning.
• Strong data modelling and database design skills.
• Experience with Amazon Aurora PostgreSQL.
• Hands-on experience with AWS Glue.
• Experience with Amazon Redshift.
• Experience with Amazon QuickSight.
• Proficiency in Python and/or PySpark.
• Experience with SQL Server, SSIS, SSAS and SSRS.
• Experience with Git, CI/CD and DevOps practices.
• Understanding of data governance, security, data quality, and production support.
• AWS Database Migration Service (DMS)
• AWS Schema Conversion Tool (SCT)

Responsibilities

• Migrate and modernise SQL Server databases to Amazon Aurora PostgreSQL.
• Analyse and convert SSIS packages and ETL workflows to AWS Glue.
• Migrate SSAS models and analytical workloads to Amazon Redshift.
• Rebuild SSRS reports and dashboards using Amazon QuickSight.
• Design and develop scalable ETL/ELT pipelines and cloud data solutions.
• Develop and optimise SQL queries, database schemas, and data models.
• Perform database performance tuning and troubleshooting.
• Build and maintain CI/CD pipelines for database and data engineering deployments.
• Implement data quality, monitoring, reconciliation, and operational support processes.
• Support data migration testing, cutover, validation, and post-production activities.
• Work closely with architects, developers, business stakeholders, and reporting teams.

Skills

SQL development

Database performance tuning

Data modelling

Cloud data migration

Python

PySpark

Git & CI/CD

DevOps practices

Tools

Amazon Aurora PostgreSQL

Amazon Redshift

AWS Glue

Amazon QuickSight

SQL Server

SSIS

SSAS

SSRS

Python

PySpark

Git

CI/CD

Job description

Umbrella Club is seeking a Senior Database & Data Engineer to lead migration of legacy SQL Server platforms to AWS, including Aurora PostgreSQL, Glue, Redshift and QuickSight. You will design scalable ETL/ELT pipelines, optimise queries and schemas, and build modern data architectures in a complex enterprise setting.

The role requires 5+ years of database/data engineering experience, hands-on SQL tuning, data modelling proficiency, and strong collaboration with architects, developers and