Cast & Crew · 21 hours ago
Data Engineer, Data & Analytics
United States
Full-time
Onsite
Senior Level
$135K/yr - $155K/yr
7+ years expCast & Crew has empowered creativity and supported the global entertainment industry for decades. They are seeking a Data Engineer to build and evolve the data foundation that supports various aspects of their business, enabling intelligent customer interactions and driving insights across the company.
AccountingBookkeeping and PayrollSoftware
Responsibilities
Build, maintain, and optimize ETL pipelines that integrate and transform data from varied first- and third-party sources into analytics-ready models
Work with both structured data (e.g., relational tables) and unstructured event data (e.g., clickstream, telemetry) to create coherent, user-level datasets and customer journeys
Partner with analytics, finance, marketing, and product teams to design data models that reflect real business logic and connect customer behavior across systems
Transform event-level telemetry data into actionable customer journeys aggregated across time windows for product and marketing insight
Develop and manage data integration pipelines, including reverse ETL workflows using tools like Hightouch
Define audience segments, customer profiles, and attribution logic using SQL and dbt in a modern cloud data warehouse (e.g., Redshift)
Implement and maintain CI/CD, version control, and automated data quality tests to ensure consistent, trustworthy reporting
Collaborate with marketing and BI to design dashboards in Looker and Amplitude that track campaign performance, segmentation, and ROI
Document data models and transformation logic for transparency and scalability
Balance short-term delivery with long-term maintainability, evolving models to support new business questions efficiently
Monitor data compliance impacts on tracking and reporting, ensuring alignment with privacy standards (such as GDPR and CCPA)
Qualification
Required
7+ years of professional experience in data engineering, analytics engineering, or related roles supporting marketing or product analytics
Expert-level SQL skills, demonstrated through real-world examples of complex transformations and business logic implementation
Strong understanding of event-based data structures and experience modeling user-level metrics from raw telemetry or clickstream data
Proficiency in modern ELT tools and frameworks (dbt), including writing modular, tested transformations
Experience configuring and optimizing large-scale cloud data warehouses (Redshift, Snowflake, or BigQuery)
Hands-on experience with customer behavior event tracking and marketing attribution
Familiarity with reverse ETL patterns, marketing activation, and identity resolution workflows
Strong data governance mindset — aware of naming conventions, semantic definitions, and data lifecycle management
Excellent written and verbal communication skills; able to translate complex transformations into accessible explanations for technical and non-technical audiences alike
Driven by curiosity and a desire to help others make smarter, faster decisions through data
Benefits
Medical
Dental
Vision
PTO
Health and wellness programs
Employee discounts
And more!
Company
Cast & Crew
Cast & Crew began modestly as a small business that provided payroll services to the commercial and the music business.
501-1000 employees
H1B Sponsorship
Cast & Crew has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (6)
2024 (2)
2023 (3)
2022 (7)
2021 (5)
2020 (11)
Funding
Current Stage
Late StageTotal Funding
unknownKey Investors
Veronis Suhler Stevenson
2018-12-10Acquired
2013-02-05Private Equity
Leadership Team
S
Sally Knutson
CFO
Recent News
2025-11-26
The Hollywood Reporter
2025-10-03
Company data provided by crunchbase