XPT Software Australia Pty Ltd | Contract Sydney , Melbourne , Brisbane, Australia | Posted on 10/06/2026 XPT SoftwareAustralia PTY Ltd, incorporated in 2016, is a Software Services company

XPT works with topclients across Australia in Banking, Insurance, Telecom,Retail, Energy, Mining and Manufacturingdomains.

We have 120+technocrats in Australia working at our clientlocations.

XPT SoftwareAustralia is part of group companies which has globalpresence across India & Europe.

We have served100+ clients globally, fulfilling their onsite-offshoreneeds.

Job Description

Job Overview We are seeking an experienced

Redshift Data Engineer

with

8+ years of experience

in data engineering and solid hands-on expertise with

Amazon Redshift . The ideal candidate will be responsible for designing, developing, optimizing, and maintaining scalable data platforms and ETL/ELT pipelines on AWS.

Key Responsibilities Design and develop scalable

data pipelines and ETL/ELT workflows

using AWS services.

Develop and optimize complex

SQL queries, stored procedures, views, and data models

in Amazon Redshift.

Perform

Redshift performance tuning , query optimization, distribution/sort key optimization, and workload management.

Build and maintain data ingestion pipelines from multiple sources into

Amazon Redshift .

Work with

AWS Glue, S3, Lambda, Step Functions, and CloudWatch

for data integration and orchestration.

Develop robust data transformation processes using

Python and SQL .

Implement data quality, validation, reconciliation, and monitoring frameworks.

Design and maintain

dimensional data models , including fact and dimension tables.





Work with large datasets and optimize data processing for performance and cost.

Implement incremental data loading and CDC (Change Data Capture) strategies.

Troubleshoot data pipeline failures, performance issues, and production incidents.

Collaborate with Data Architects, Business Analysts, Developers, and other stakeholders.

Follow best practices for

data security, governance, access control, and AWS IAM .

Participate in code reviews, technical design discussions, and Agile delivery processes.

Mandatory Skills 8+ years of experience in Data Engineering

Strong hands-on experience with

Amazon Redshift

Advanced

SQL

skills

Strong

Python

programming/scripting experience

Strong experience with

AWS

Hands-on experience with

Amazon S3

Experience with

AWS Glue

Experience with data warehousing and

dimensional data modeling

Strong knowledge of

Redshift performance tuning

Experience with large-scale data processing

Experience with CI/CD and

Git

Good understanding of data quality and data governance

Good to Have Experience with

AWS Lambda, Step Functions, EMR, Athena, and CloudWatch

Experience with

Apache Spark / PySpark

Experience with

Airflow

Knowledge of

Kafka / streaming data

Experience with CDC tools such as

AWS DMS, Debezium, or equivalent

Experience with

Terraform / Infrastructure as Code

Exposure to

Databricks, Snowflake, or other cloud data platforms

Experience working in

Agile/Scrum

environments

Technical Skills Cloud:

AWS, S3, Glue, Lambda, Step Functions, CloudWatch

Programming:

Python, SQL

DevOps:

Git, CI/CD, Terraform

Data Modeling:

Star Schema, Snowflake Schema, Dimensional Modeling

#J-18808-Ljbffr

📌 Data Engineer -RedShift (Haymarket)
🏢 Zoho
📍 Haymarket