Data Engineer, Data & Analytics401 Cast & Crew LLC • New York, New York, United States

This job offer is no longer available

Data Engineer, Data & Analytics

401 Cast & Crew LLC

New York, New York, United States

New York, New York, United States

About

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 reverseETL 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). What We’re Looking For 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 reverseETL 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. Special Work Conditions 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. Benefits Medical Dental Vision PTO Health and wellness programs Employee discounts And more! The compensation range for this position is: $135,000.00 - $155,000.00 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: https://www.castandcrew.com/privacy-policy/ 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.
#J-18808-Ljbffr

New York, New York, United States

Languages

English

Notice for Users

This job was posted by one of our partners. You can view the original job source here.

Find similar jobs