Production Data & Insights Engineer
Core
Own the data layer for an animation studio, ingesting from ShotGrid and Dynamics 365, building the warehouse and semantic layer, and delivering curated dashboards and proactive insights to production and leadership.
Role type
Senior Data & Insights Engineer
Builds
Production data warehouse, semantic layer, and decision-support dashboards for animation production
Domain
Animation production / Entertainment
Required skills
SQL, dbt, managed ELT configuration, semantic layer design, BI development (Metabase/Looker/Power BI), data quality monitoring, CI/CD for data, Python
Preferred skills
AWS/RDS/Postgres, VFX/animation industry experience, ShotGrid/Dynamics 365 familiarity
Technologies
ShotGrid, Dynamics 365, SQL, dbt, Metabase, Looker, Power BI, Superset, AWS, RDS, Postgres, Python
Responsibilities
Configure managed ELT tooling and ingestion pipelines from ShotGrid and Dynamics 365; model warehouse and define semantic layer metrics; build and maintain role-specific dashboards; proactively analyze data to surface cost drift and schedule slip; implement data quality checks and pipeline observability; document metric definitions and resolve ambiguity across departments.
Seniority
Senior, hands-on IC