Lead Data Engineering Consultant

Nixil; Sydney; On-site; AUD 120,000 - 160,000; Full time

Job summary

A leading Australian bank is looking for an experienced Lead Data Engineering Consultant to design and deliver financial reconciliation solutions. In this high-impact role, you will lead the reconciliation staging area, ensuring accurate data processing and quality. Ideal candidates will have 8-10 years in data engineering, strong AWS skills, and experience in financial services. Join a collaborative team and make a difference in a major financial institution.

Qualifications

• 8–10 years of relevant experience in data engineering or financial services.
• Experience in regulated financial environments, preferably banking.
• Exposure to reconciliation platforms such as FIS, Intellimatch, SmartStream.

Responsibilities

• Lead solution design and technical delivery for the reconciliation staging/data store.
• Coordinate and direct engineering tasks across internal and vendor teams.
• Define ingestion, cleansing, transformation, and quality-control patterns.

Skills

AWS: S3, Redshift, Glue, Lambda, Step Functions, IAM

Strong SQL skills

Data modelling experience

ETL/ELT tooling experience

Python or PySpark programming

Data quality and monitoring frameworks

Job description

Our client, a leading Australian bank, is seeking an experienced Lead Data Engineering Consultant to join their Institutional Banking & Markets team. This is a high-impact role for a hands-on technical leader who thrives in a collaborative environment, working across internal and vendor teams to deliver complex financial reconciliation solutions.

About the Role:

You will play a pivotal role in designing and delivering the reconciliation staging area/data store for securities products, ensuring external MT messages reconcile accurately against internal trade positions. This includes importing data, defining data structures, setting up reconciliation rules in Intellimatch, and producing reports for matched/unmatched items. You will lead engineering tasks, coordinate across onshore/offshore teams, and ensure alignment with architecture, engineering standards, and security requirements.

Key Responsibilities:

• Lead solution design and technical delivery for the reconciliation staging/data store
• Coordinate and direct engineering tasks across internal and vendor teams
• Work closely with architecture, reconciliation SMEs, and FIS Matching teams
• Define ingestion, cleansing, transformation, and quality-control patterns
• Ensure adherence to engineering patterns, security controls, and best practices

Mandatory Skills:

• 8–10 years of relevant experience in data engineering or financial services
• AWS: S3, Redshift, Glue, Lambda, Step Functions, IAM
• Strong SQL skills and data modelling experience (financial reconciliation preferred)
• ETL/ELT tooling experience (Glue, Airflow, or dbt)
• Data lake and warehouse design experience
• Experience in regulated financial environments (banking preferred)
• Exposure to reconciliation platforms such as FIS, Intellimatch, SmartStream, OneSumX
• Python or PySpark programming
• Experience with data quality and monitoring frameworks

This is an exciting opportunity for a technically strong, self-starting professional to make a significant impact in a major financial institution.

Apply today to join a team driving innovative reconciliation solutions in a dynamic banking environment.