Data Analytics Engineer | Contract | Sydney
My client is a consultancy providing resources for a privately owned infrastructure operator in the NSW ports and logistics sector, backed by a consortium of major Australian institutional investors. They manage key import and export gateways and intermodal freight assets, and they are building out their data and analytics capability to support self-service reporting and future AI initiatives.
They are looking for a Data Analytics Engineer to join the Data Analytics & BI team on a short-term contract, reporting to the Lead of Data Analytics & BI.
Location:
Sydney (on site, driver's licence and car required)
Contract:
4 months (initial term)
Reports to:
Lead, Data Analytics & BI (no direct reports)
The role
You will design and deliver modern data solutions that support decision making and self-service analytics across the business. The work covers advanced SQL, data quality, data cataloguing, semantic modelling and enterprise Power BI dashboards, with a strong focus on usability and design.
Key responsibilities
- Write and optimise SQL queries to extract, transform and model data for analytics, reporting and future AI use cases
- Build and maintain high-performance Power BI datasets, semantic models and interactive dashboards, connecting to SQL Server, SharePoint, Excel and APIs
- Perform data profiling, implement data quality rules and maintain data quality metrics
- Build data catalogue tools, data mapping and technical data quality checks
- Establish consistent business definitions, metrics and data standards
- Produce documentation covering lineage, transformation logic, calculations and user guides to support handover and knowledge sharing
- Streamline reporting workflows to reduce manual effort, including automated reporting and alerts
- Support the preparation of AI-ready datasets and business metadata
- Work with stakeholders from technical teams through to senior leadership to gather requirements, present insights and train business users
Essential skills and experience
- 5 to 7 years in relevant data analytics roles
- Strong Power BI and MS SQL experience, including data modelling, DAX, calculation groups, visual design and publishing
- Proficiency in data profiling, SQL and data validation
- Experience delivering automated reporting, alerts, and report UX/UI and dashboard design
- Understanding of data governance and documentation best practice
- Excellent written and verbal communication, with strong attention to detail
- Tertiary degree in data analysis, supply chain or a similar field
Desirable
- Supply chain or logistics experience
- Microsoft Purview
- Azure Synapse and Microsoft Fabric
- Azure Storage and Azure SQL
- Data warehousing, data lakes, Medallion architecture and ETL/ELT
- SQL Server data warehouse and Synapse data lake environments
