Mid to Senior ETL Developer

CSK Nexus; Melbourne; Hybrid; AUD 110,000 - 150,000; Full time

Job summary

CSK Nexus is hiring a data engineer to design and operate data pipelines and models supporting reporting, analytics, and Tableau visualisations. You will apply expert SQL (Redshift) and Python to build scalable ETL processes across multiple data sources, including SAP CRM/Billing integrations.

Work is in a hybrid model based in Melbourne, Australia, requiring collaboration with business stakeholders and IT teams to deliver reliable data solutions in a fast-paced environment.

Qualifications

• Minimum 3 years in data & analytics.
• Experience with ETL tools (Matillion, AWS Glue, SSIS).
• Strong Python for automation.
• Experience with Redshift, SQL Server, PostgreSQL.
• Knowledge of data warehousing and dimensional modelling.
• Experience documenting data models and ETL processes.
• Exposure to SAP CRM or Billing is a plus.
• Australian/NZ citizen or permanent residency preferred.

Responsibilities

• Design, build and test data transformation jobs.
• Develop ETL loading patterns (near real-time, batch, historical, incremental).
• Write complex SQL queries to manage data feeds.
• Develop Python scripts for ETL orchestration.
• Design and support large-scale data pipelines (batch, incremental, near real-time).
• Identify efficiencies and optimise data transformation practices.
• Document designs, specifications, requirements and test plans.
• Collaborate with stakeholders to translate requirements into specs.
• Validate data accuracy and end-to-end pipeline reliability.
• Integrate AI/automation to enhance ETL workflows.

Skills

ETL development

Python scripting

SQL querying

Data modelling

Stakeholder engagement

Tableau integration

Education

Tertiary IT degree

Tools

Matillion

AWS Glue

SSIS

Redshift

Job description

About the role

This role will involve development of data pipelines and data models to support the integration of new and existing data source systems used in business critical processes including operational reporting, analytics and support of Tableau data visualisation/reports.

Expert SQL skills with Redshift and Python capabilities who can cope and work in a fast-moving outcome-based delivery environment. This role requires a strong understanding of relational database concepts, database design, dimensional modelling and data warehousing, with exposure to systems such as SAP CRM and/or Billing.

The client is following a hybrid working model.

Typical Responsibilities

• Design, build and test data transformation jobs, including modelling of very large data sets.
• Design, engineer and support various ETL data loading patterns such as near real time, batch, historical and incremental.
• Write complex SQL queries to manage, manipulate and automate complex data feeds.
• Develop Python scripts to manage ETL jobs and orchestrate job schedules for near real time and batch
• Designing, developing, testing and supporting large scale data pipelines, including batch, incremental, historical and near real‑time processing
• Identify and implement efficiencies and optimisation of data transformation using industry best practice methods and tools.
• Exceptional documentation authoring skills of business and technical documents including but not limited to Design specifications, Technical specifications, Requirements and Test documents.
• Collaborate and work with Stakeholders to understand business requirements and translate into technical specifications.
• Evaluate ETL requirements for completeness, accuracy, and feasibility.
• Ensure product assurance across all ETL processes by validating data accuracy, completeness, transformations, and end‑to‑end pipeline reliability before release to downstream systems.
• Conduct analysis to estimate project timeframes for deliverables.
• Contribute to the design and implementation of the ETL framework and data model.
• Ability to gather requirements but suggest alternative better solutions to stakeholders and end users.
• Integrate AI and automation into ETL workflows to enhance data validation, anomaly detection, pipeline optimisation, and operational efficiency.
• Distil complex information and be able to communicate simply and in language that non technical staff understand.

Skills and experience required

• Minimum of 3 years' working experience in the data & analytics domain
• Strong experience with ETL technologies such as Matillion, AWS Glue/Data Pipeline, SSIS or similar with a flair for building complex SQL queries
• Extensive experience with Python (preferably 3+ years) for automation and integration
• Demonstrated working knowledge of databases such as Redshift, SQL Server or PostgreSQL
• Good understanding of RDBMS principles, database design, and query optimisation
• Experience documenting ETL processes and data models (e.g. entity relationship diagrams)
• Strong data modelling skills with the ability to transform staged data into conformed models and BI Datasets
• Strong stakeholder engagement experience including requirements analysis, solution design, gap identification and ability to clearly communicate technical concepts
• Experience working with SAP CRM or Billing
• Knowledge of the utility industry highly desirable
• Strong analytical and interpretative skills
• Tertiary qualification in an IT related discipline

To be eligible to apply, you must be an Australian / New Zealand citizen or hold permanent residency status in Australia. Please only apply if you meet the above skills