Data and Analytics Engineer

EG Australia; North Sydney; Hybrid; AUD 120,000 - 150,000; Full time

Benefits offered by this job

Hybrid working

Well-being programs

Employee discounts

Job summary

EG Australia is seeking an experienced Data & Analytics Engineer for a 6‑month contract in North Sydney, NSW. You will design scalable data pipelines in Azure Data Factory, enhance data storage across warehouses and data lakes, and automate reporting.

You will collaborate with stakeholders to translate business problems into data solutions, ensuring data quality and governance. Hybrid work is offered with office and home days.

Qualifications

• 4+ years of experience in an Azure data engineering role.
• Proficiency in Azure Synapse Analytics and SQL scripting.
• Experience with ETL and scheduling tools: ADF, Logic Apps, Power Automate.
• Knowledge of data warehouse principles and star schema modelling.
• Experience documenting standards and data governance.

Responsibilities

• Design, test and implement scalable data pipelines in Azure Data Factory.
• Enhance data storage and processing across data warehouses and lakes.
• Automate data analysis and reporting processes with various tools.
• Build data quality checks and model impact assessments.
• Collaborate with stakeholders to translate business needs into data solutions.

Skills

Azure data engineering

SQL scripting

Data visualization

Stakeholder collaboration

Tools

Azure Data Factory

Azure Synapse Analytics

Power BI

Logic Apps

Power Automate

Job description

• Hybrid working, mix of office and working from home
• Location: North Sydney, NSW

ABOUT US:

We have been serving Australian customers since 2019, operating a network of more than 500 fuel and convenience locations nationwide. Following Ampol Group's acquisition of the EG Australia business we are embarking on an exciting period of transition with a continued focus on delivering quality fuel, everyday essentials, fresh food, meal solutions, and convenience products to our customers.

ABOUT THE ROLE:

We are seeking an experienced Data & Analytics Engineer to join our team on a 6‑month contract during an exciting phase of business integration. Reporting to the Data & Reporting Lead, you’ll play a key role in developing scalable data solutions that enable better decision-making, unlock business insights, and drive performance across the organisation.

In this role you will be responsible for:

• Design, test and implement effective and scalable data pipelines in Azure Data Factory
• Enhance and maintain data storage and processing solutions, across data warehouses and data lakes using Azure.
• Automate data analysis and reporting processes, utilizing various tools and scripts
• Build and deploy statistical checks and models to ensure best-in-class data quality and undertake data model impact assessments
• Proactively assess data-related system integrations and propose appropriate solutions to the business
• Support data governance through implementing best practices around code documentation, naming conventions, data glossaries and data mapping
• Partner with stakeholders to translate complex business problems into fit-for-purpose and scalable data pipelines and data models, to enable fast and efficient data-driven decision-making

WHAT ARE WE LOOKING FOR?

• Minimum 4 years of experience in an Azure data engineering role
• Proficiency in Azure Synapse Analytics and writing advanced SQL scripts / Stored Procedures, with an intermediate skill/understanding of Power BI
• Experience working with ETL and scheduling tools in Azure Data Factory, Azure Logic Apps, Power Automate
• Knowledge of and demonstrated experience with Data Warehouse (Star Schema) Modelling principles practice, techniques and methodologies
• Experience developing and maintaining standards, guidance and technical documentation
• Demonstrated experience in database design, ETL (Extract, Transfer, Load), MDM (Master Data Management) and optimizing data pipelines for high performance, utilizing Azure

WHAT’S IN IT FOR YOU?

• An opportunity to play an integral role in our IT team
• Hybrid working arrangement – North Sydney Office and Work from home
• Access to employee well-being programs & employee discounts
• Equal opportunity workplace with a commitment to diversity & inclusion and gender-diverse policies