Senior Data Engineer: AWS Data & Analytics (Sydney)

Tata Consultancy Services; Sydney; On-site; AUD 160,000 - 210,000; Full time

Job summary

Tata Consultancy Services Australia is seeking a Senior Data Engineer in Sydney to drive migration of on-premises data workloads to AWS. You will modernise SQL Server databases to Aurora PostgreSQL, convert SSIS workflows to Glue, and migrate SSAS workloads to Redshift, while building scalable data ingestion and reporting solutions.

You will work with architects, developers and business stakeholders in an Agile, DevOps environment, delivering high-quality data platforms and enabling analytics

Qualifications

• 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

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

Skills

Database & Data Engineering

SQL

Python

PySpark

ETL/ELT pipelines

Git

CI/CD

DevOps

Agile delivery

Data modelling

Data governance

Security

Operational support

Tools

AWS Glue

Amazon Redshift

AWS Quick

AWS DMS

Schema Conversion Tool

SSIS

SSAS

Job description

Tata Consultancy Services Australia is seeking a Senior Data Engineer in Sydney to drive migration of on-premises data workloads to AWS. You will modernise SQL Server databases to Aurora PostgreSQL, convert SSIS workflows to Glue, and migrate SSAS workloads to Redshift, while building scalable data ingestion and reporting solutions.

You will work with architects, developers and business stakeholders in an Agile, DevOps environment, delivering high-quality data platforms and enabling analytics