Data Engineer, Data & Analytics

Cast & Crew is an entertainment technology and services provider that empowers creativity in the global entertainment industry. They are seeking a Data Engineer to build and evolve the data foundation that supports various business aspects, enabling intelligent customer interactions and driving insights across the company.

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)

Requirements:

• 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