Назад
Company hidden
7 дней назад

Production Data & Insights Engineer (dbt/SQL)

Формат работы
remote (только Australia)/hybrid
Тип работы
fulltime
Грейд
senior
Английский
b2
Страна
Australia
Вакансия из списка Hirify.GlobalВакансия из Hirify Global, списка международных tech-компаний
Для мэтча и отклика нужен Plus

Мэтч & Сопровод

Для мэтча с этой вакансией нужен Plus

Описание вакансии

Текст:
/
TL;DR
Production Data & Insights Engineer (dbt/SQL): Building the data layer, warehouse models, semantic definitions and decision-support dashboards for multi-show animation production with an accent on ShotGrid and Dynamics 365 ingestion, historical snapshots, metric governance and data quality. Focus on reconciling source systems, detecting cost and schedule drift, and operating monitored, tested and observable data workloads for production, finance and leadership.

Location: Australia; remote workplace type with a hybrid approach and flexible work-from-home days

Company

hirify.global is an independent animation studio producing family-focused 2D and 3D feature films and television series across three studios.

What you will do

  • Own ingestion from ShotGrid, Dynamics 365 and additional production or business systems, including incremental sync, reconciliation and point-in-time snapshots.
  • Build and maintain the warehouse and semantic layer using SQL and dbt, including entity models, status normalisation, metric definitions, snapshots and slowly changing models.
  • Create curated dashboards and reporting for production, finance and leadership, and interpret findings such as cost drift, schedule slip and variance against assumptions.
  • Define measures with stakeholders, resolve metric ambiguity, document assumptions and present findings to producers, department leads and executives.
  • Implement data-quality checks, freshness, volume and schema-change monitoring, alerting, scheduling, CI and containerised transformation runs.
  • Report platform coverage, quality and adoption, while surfacing data gaps, source limitations and governance blockers.

Requirements

  • Strong SQL and hands-on dbt modelling experience in a production warehouse.
  • Experience configuring and operating managed ELT tooling against business and operational source systems.
  • Working knowledge of AWS and RDS/Postgres, including warehouse performance and cost considerations.
  • Experience building semantic layers and normalising inconsistent source statuses into defensible metric definitions.
  • BI development experience with Metabase or an equivalent such as Looker, Power BI or Superset.
  • Experience with data quality, testing, pipeline observability, version control, CI and containerised execution for data workloads.
  • Demonstrated analytical judgement, including finding and communicating previously unknown business insights.
  • Awareness of role-based data scoping, sensitive cost and personnel data, and IP and asset protection.
  • Ability to work with incomplete, inconsistent and undocumented source data and communicate credibly with producers and executives.

Nice to have

  • Python for data engineering and orchestration.
  • Experience in VFX, animation, broadcast or post-production, or experience delivering data into deadline-critical operational environments.
  • Familiarity with ShotGrid, Dynamics 365 or comparable production and ERP systems.
  • Experience replacing an incumbent reporting platform.

Culture & Benefits

  • Full-time max-term employment with remote work and a hybrid approach offering flexible work-from-home days.
  • Training and career-development support, mental-health resources and free counselling through Support Act.
  • Discounted health insurance, financial-wellbeing initiatives, Mental Health First Aid support and access to the Flare Benefits Platform.
  • Breakfast is provided daily, with additional employee social activities and a studio space in Alexandria.
  • Some benefits are available to permanent employees and fixed-term contractors on contracts of 12 months or more.

Будьте осторожны

Если работодатель просит войти в их систему, используя iCloud/Google, прислать код/пароль, запустить код/ПО, не делайте этого. Это мошенники. Обязательно жмите «Пожаловаться» или пишите в поддержку. Подробнее в гайде →