Cast & Crew

Data Engineer, Customer Data & Analytics (Backstage)

United States

Not SpecifiedCompensation
Mid-level (3 to 4 years), Senior (5 to 8 years)Experience Level
Full TimeJob Type
UnknownVisa
Entertainment Technology, Talent Marketplace, Data & AnalyticsIndustries

Requirements

Candidates should have experience in marketplace ecosystems and a passion for transforming raw data into actionable, scalable solutions. A Bachelor's degree in a relevant field is likely required, along with experience working with large-scale, session-level customer and event data. Experience with dbt, Redshift, PostgreSQL, and reverse ETL workflows is also expected.

Responsibilities

The Data Engineer will build, optimize, and maintain dbt-based data transformation pipelines in Redshift and PostgreSQL. They will develop and manage data integration pipelines, including reverse ETL workflows, to connect cleaned data to martech tools. The role involves working with large-scale customer and event data to enable user journey analysis, attribution modeling, and behavioral analytics, ultimately tying behavioral and web metrics to revenue and retention.

Skills

Data Engineering
Customer Data
Analytics
Marketplace Ecosystems
Data Transformation
Scalable Solutions
SQL
Python
ETL
Data Warehousing
Cloud Platforms (AWS, GCP, Azure)
Data Modeling
Business Intelligence
Data Visualization

Cast & Crew

Digital solutions for entertainment production management

About Cast & Crew

Cast & Crew provides a range of digital solutions tailored for the entertainment industry, focusing on production management for film, television, and live events. Their tools help streamline administrative tasks such as payroll, human resources, and production management, making it easier for production companies, studios, and independent filmmakers to operate efficiently. The company's offerings include payroll management tools, purchase order management, screenwriting software, and digital onboarding solutions, all designed to simplify complex processes. Unlike many competitors, Cast & Crew emphasizes a comprehensive suite of services that integrate various aspects of production management, ensuring accurate and timely payments, efficient document handling, and insightful data reporting. The goal of Cast & Crew is to enhance the operational efficiency of entertainment productions while supporting the industry, including initiatives for the Canadian entertainment sector.

Burbank, CaliforniaHeadquarters
1976Year Founded
ACQUISITIONCompany Stage
Data & Analytics, Enterprise Software, EntertainmentIndustries
1,001-5,000Employees

Benefits

PTO
Family-leave time off
401(K)
Hybrid & remote work flexibility
Health, dental, & vision insurance
Employee referral program
Tuition reimbursement
Health and wellness programs

Risks

Shift towards blockchain solutions may disrupt traditional services like Cast & Crew.
WGA strike in 2023 causes production delays, impacting Cast & Crew's revenue.
AI-driven scriptwriting tools threaten traditional software like Final Draft.

Differentiation

Cast & Crew offers 24/7 online support and electronic payroll interfacing.
PSL3 software integrates internet convenience into production accounting.
Cast & Crew's staff expertise is a hallmark of their service quality.

Upsides

Increased demand for remote production tools boosts Cast & Crew's digital solutions.
Expansion of tax incentive programs enhances demand for tax credit management services.
Rise of independent creators increases need for scalable production management solutions.

Land your dream remote job 3x faster with AI