Lead Data Engineer

Hatchit Studios; Melbourne; Hybrid; AUD 120,000 - 180,000; Full time

Job summary

Hatchit Studios is seeking a Lead Data Engineer to support a major Federal Government agency. You will design, develop and optimise enterprise data warehousing, data lakes and data integration solutions to underpin reporting, BI and evidence-based decision making.

Bring strong Teradata EDW expertise, advanced SQL, and hands-on ETL/ELT capabilities, plus leadership to mentor data engineering teams. This role offers hybrid working from Melbourne with national travel occasional.

Qualifications

• Extensive experience in enterprise data engineering, data warehousing and data integration.
• Strong hands-on Teradata EDW and advanced SQL development, including optimization.
• Proven track record designing ETL/ELT pipelines for large-scale data environments.

Responsibilities

• Design, develop and maintain enterprise data warehouse, data lake and data integration solutions.
• Develop, optimize and maintain complex SQL programs within a Teradata EDW environment.
• Lead ETL/ELT pipelines across enterprise systems and ensure data quality.

Skills

Teradata EDW

Advanced SQL

ETL/ELT

Data Warehousing

Data Pipelines

Leadership

Stakeholder Engagement

Tools

Teradata Studio

SQL Assistant

Viewpoint

Control-M

Job description

Location: Melbourne, VIC (Hybrid) | Also available in Canberra, Brisbane and Perth

Contract Duration: Up to 12 months, with potential extensions of up to 24 months

Security Requirement: Must be an Australian Citizen and hold or be eligible to obtain Baseline Security Clearance

About the Opportunity

Hatchit Studios is seeking an experienced Lead Data Engineer to support a major Federal Government agency in the design, development and optimisation of enterprise data engineering solutions.

This role will focus on building and maintaining complex data integration solutions, enterprise data warehouses and data platforms to support operational reporting, business intelligence and evidence-based decision-making.

The successful candidate will bring strong technical expertise in Teradata Enterprise Data Warehousing (EDW), advanced SQL development and ETL/ELT processes, alongside the ability to provide technical leadership, improve data quality and collaborate with business and technical stakeholders.

Key Responsibilities

• Design, develop and maintain enterprise data warehouse, data lake and data integration solutions.
• Develop, optimise and maintain complex SQL programs within a Teradata EDW environment.
• Build and support ETL/ELT pipelines to extract, transform and load data across enterprise systems.
• Undertake data analysis, profiling, modelling, cleansing and validation to maintain data quality and integrity.
• Develop and maintain automated data integration solutions using tools such as SQL Assistant, Teradata Studio, Viewpoint and Control-M.
• Optimise data extraction processes, query performance and data structures to support analytics and business intelligence.
• Lead the design and implementation of scalable, secure and reusable data engineering solutions.
• Collaborate with cross-functional Agile teams, technical specialists and business stakeholders.
• Provide technical guidance, mentoring and support to data engineering teams.
• Maintain technical documentation and promote data governance, security and continuous improvement practices.

Skills & Experience Required

• Extensive experience in enterprise data engineering, data warehousing and data integration.
• Strong hands-on expertise in Teradata EDW and advanced SQL development, including query optimisation and performance tuning.
• Proven experience designing and developing ETL/ELT processes and complex data pipelines.
• Experience with enterprise data warehouses, data lakes and relational database management systems (RDBMS).
• Familiarity with Teradata utilities and tools, including SQL Assistant, Teradata Studio, Viewpoint and Control-M.
• Strong understanding of data modelling, metadata management, data quality and governance principles.
• Experience designing scalable data architectures and implementing data integration best practices.
• Demonstrated ability to lead technical delivery, mentor team members and resolve complex engineering challenges.
• Strong analytical, problem-solving and stakeholder engagement skills.
• Excellent communication skills, with the ability to explain complex technical concepts to non-technical audiences.
• Previous experience delivering data engineering solutions within Federal Government or large enterprise environments (highly regarded).

Why Apply?

• Work on high-impact Federal Government data transformation and modernisation initiatives.
• Competitive contractor rates based on experience and technical expertise.
• Opportunity to contribute to large-scale enterprise data platforms and analytics capabilities.
• Long-term contract opportunity with potential extensions.
• Hybrid working arrangements following an initial onsite period.
• Collaborate with experienced technical teams on complex data engineering challenges.