Data and Analytics Engineer

EG Australia; Sydney; Hybrid; AUD 83,000 - 124,000; Full time

Benefits offered by this job

Hybrid work arrangement

Well-being programs

Employee discounts

Equal opportunity workplace

Job summary

EG Australia is seeking an experienced Data & Analytics Engineer for a 6-month contract in North Sydney. You will design and maintain scalable Azure data pipelines and data models to enable data-driven decision making across the organisation.

You will work on Azure Data Factory, Synapse Analytics and Power BI, while contributing to governance, documentation and cross-functional collaboration during a period of business integration.

Qualifications

• Minimum 4 years in an Azure data engineering role.
• Proficiency in Azure Synapse Analytics and advanced SQL scripts.
• Experience with ETL and scheduling tools in Azure Data Factory, Logic Apps and Power Automate.
• Knowledge of star-schema data warehousing modelling and data governance practices.
• Experience documenting standards and technical guidance.
• Background in DB design, ETL, and MDM using Azure to optimize pipelines.

Responsibilities

• Design, test and implement scalable data pipelines in Azure Data Factory.
• Enhance and maintain data storage and processing in data warehouses/data lakes on Azure.
• Automate data analysis and reporting processes with various tools and scripts.
• Build and deploy data quality checks and models; perform data model impact assessments.
• Assess data-related integrations and propose solutions to the business.
• Support data governance with documentation, naming conventions and glossaries.
• Collaborate with stakeholders to translate business problems into scalable data pipelines and models.

Skills

Azure data engineering

SQL scripting

Data warehousing

MDM

Data governance

Documentation

Tools

Azure Data Factory

Azure Synapse Analytics

Power BI

Azure Logic Apps

Power Automate

Job description

Career Opportunities: Data and Analytics Engineer (119364)

• 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, PowerAutomate
• 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 Workfromhome
• Access to employee well-being programs& employee discounts
• Equal opportunity workplace with a commitment to diversity & inclusion and gender-diverse policies