Lead Data Engineer

Lead Data Engineer – Federal Government

📍 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

💼 Industry: Federal Government – Data Engineering & Analytics

🔒 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.