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 clear, 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-onSQLexperience in a production data warehouse environment
Strong experience withdata modelling, ideally usingdbt
Demonstrated ability to turn complex, inconsistent source data into reliable and well-defined datasets
Experience building and maintaining asemantic layer, including metric definitions and standardising inconsistent source data
Strong experience creatingdata insightsand translating analysis into clear, actionable recommendationsli>
Experience working withAWS, with a working understanding of services such as RDS / PostgreSQL and cloud-based data environments
Experience withmanaged ELT / data integration toolingand operational source systems
Experience developingBI dashboards and reporting, using tools such as Metabase, Looker, Power BI, Superset or equivalent
Strong understanding ofdata quality, testing,



monitoring and pipeline observability
Experience withGit/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 tosenior stakeholders, producers, managers and executives
Desirable skills and experience
Python experience for data engineering, analysis or orchestration
Experience working withShotGrid, Dynamics 365 or similar production / ERP systems
Experience inVFX, 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, includingsnapshots 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 influencesproduction and business decision-making
Work across a complex, multi-location data environment rather than a single reporting dataset
Have genuine ownership acrossdata modelling, insights, quality and the underlying data platform
Work hands-on withSQL, dbt, AWS and up-to-date 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