Data Engineer, Data & Analytics

What You’ll Do

• 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).

• 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 Big Query).
• 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.

• Sedentary – Involves sitting most of the time but may involve walking or standing for brief periods of time.
• Some positions may entail exerting up to 15 lbs. of force occasionally and/or a negligible amount of force to lift, carry, push, or pull.

• Medical
• Dental
• Vision
• PTO
• Health and wellness programs
• Employee discounts
• And more!

The compensation range for this position is: $ - $ per year.

Your personal information may be collected in connection with certain services provided by Cast & Crew or its affiliated companies. A summary of your California privacy rights can be found at:

Cast & Crew is an equal opportunity employer committed to hiring a diverse workforce and sustaining an inclusive culture. It is our policy to provide equal employment opportunities to all individuals based on job‑related qualifications and ability to perform a job, without regard to age, gender, gender identity, sexual orientation, race, color, religion, creed, national origin, disability, genetic information, veteran status, citizenship or marital status, and to maintain a non‑discriminatory environment free from intimidation, harassment or bias based upon these grounds.