Note: The job is a remote job and is open to candidates in USA. 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)
Skills
- 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
Company Overview
Company H1B Sponsorship