[Hiring] Data Engineer @Cast & Crew

Role Description

Backstage is seeking a Data Engineer to help build and evolve the data foundation that supports many aspects of our business — enabling intelligent customer interactions, powering customer-facing products, and driving insights for fast-moving teams across the company.

You will join our Data & Analytics team, which currently includes two Data Engineers, a Data Scientist, a Data Analyst, and a Director, and sits within the larger Product & Engineering department of high-performance engineers, designers, product managers, analysts, and QA specialists. We value curiosity, trust, and impact, and we foster a culture of constant learning and improvement where teammates work together to accomplish user-focused initiatives in a supportive, open, and respectful environment.

As a Data Engineer, you’ll play a key role in maintaining and expanding this foundation with an unwavering commitment to data quality, consistency, and scalability. You’ll own major parts of Backstage’s analytics data stack and partner closely with the BI, marketing, and product teams.

You’ll transform complex, raw data from multiple systems into clean, meaningful models that drive actionable insight across a growing global organization. This role requires top-tier SQL capabilities — someone skilled at writing advanced queries with layered business logic and translating ambiguous requirements into structured, reusable datasets.

You’ll report to Backstage’s Director of Data and Analytics, and work cross-functionally to build sustainable, future-proof data infrastructure for marketing attribution, customer analytics, and operational reporting.

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

Qualifications

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

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

• Comprehensive package of employee benefits including: Medical, Dental, Vision, PTO, health and wellness programs, employee discounts, and more!
• Note: Cast & Crew benefits are subject to eligibility requirements.

Compensation

The compensation range for this position is: $135,000.00 - $155,000.00 per year.