Expertech is exclusively partnering with a leading creative technology organisation to recruit a Data & Insights Engineer.This is a newly important role focused on turning complex operational data into explicit, trusted insights that help production, finance and leadership make better decisions.
You'll own the data layer that makes production data useful, bringing together information from multiple business systems, building robust data models and semantic definitions, and delivering insights through curated dashboards and reporting.
The core of the role is SQL, data modelling, data insights and AWS.
This is not a pure reporting or dashboard role. You'll work hands-on with SQL and dbt, managed ELT, warehouse modelling and AWS, while also being expected to interrogate the data, identify trends and anomalies, and proactively tell stakeholders what the numbers mean.
If you enjoy going beyond "here is the data" to answering "so what, and what should we do about it?", this is an opportunity to have genuine impact.
Essential skills and experience
Strong hands-on
SQL
experience in a production data warehouse environment
Robust experience with
data modelling
, ideally using
dbt
Demonstrated ability to turn complex, inconsistent source data into reliable and well-defined datasets
Experience building and maintaining a
semantic layer
, including metric definitions and standardising inconsistent source data
Strong experience creating
data insights
and translating analysis into clear, actionable recommendationsli>
Experience working with
AWS
, with a working understanding of services such as RDS / PostgreSQL and cloud-based data environments
Experience with
managed ELT / data integration tooling
and operational source systems
Experience developing
BI dashboards and reporting
, using tools such as Metabase, Looker, Power BI, Superset or equivalent
Strong understanding of
data quality, testing,



monitoring and pipeline observability
Experience with
Git/version control, CI and containerised data workloads
Strong analytical judgement, you don't simply build what has been requested; you investigate the data and identify what the business may not yet know
Excellent communication skills and the confidence to present insights to
senior stakeholders, producers, managers and executives
Desirable skills and experience
Python experience for data engineering, analysis or orchestration
Experience working with
ShotGrid, Dynamics 365 or similar production / ERP systems
Experience in
VFX, animation, broadcast, post-production or another deadline-critical operational environment
Experience working across multiple locations, teams or business units
Experience replacing or improving an existing reporting or data platform
Understanding of historical data modelling, including
snapshots and slowly changing dimensions
Experience with data reconciliation, source-system validation and data governance
Experience working with sensitive financial, personnel or commercially confidential data
Familiarity with production planning, scheduling, resource or workforce data
Why work here?
Own a meaningful data function that directly influences
production and business decision-making
Work across a complex, multi-location data environment rather than a single reporting dataset
Have genuine ownership across
data modelling, insights, quality and the underlying data platform
Work hands-on with
SQL, dbt, AWS and modern data tooling
Partner directly with production, finance, technology and senior leadership stakeholders
Have the opportunity to shape how data is defined, trusted and used across the organisation
Join a team where your analysis is expected to influence decisions, not simply populate dashboards
Work in a highly creative and technology-driven environment where data plays an increasingly important role
#J-*****-Ljbffr

📌 Data & Insights Engineer (New South Wales)
🏢 expertech
📍 New South Wales