Data & Insights Engineer

_{16th August, 2026}

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-on SQL experience in a production data warehouse environment
• Strong 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 recommendations
• 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

• 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

• 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