Data Engineer, Data & Analytics

About the role

Backstage is seeking a Data Engineer to help build and evolve the data foundation that supports many aspects of our business. You will join our Data & Analytics team, which includes Data Engineers, a Data Scientist, a Data Analyst, and a Director, and sits within the larger Product & Engineering department.

Responsibilities

• Build, maintain, and optimize ETL pipelines that integrate and transform data from varied first- and third-party sources into analytics-ready models.
• 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.
• Maintain 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.

Qualifications

• BS/BA in Computer Science, Statistics, Mathematics, or a related field.
• Experience with data warehousing technologies such as Redshift, Snowflake, or BigQuery.
• Experience with cloud platforms such as AWS, Google Cloud, or Azure.
• Experience with data visualization tools such as Looker, Amplitude, or Tableau.
• Experience with data modeling and database design.
• Experience with data governance and data quality practices.

Skills

• Advanced SQL skills.
• Experience with modern ELT tools and frameworks (dbt).
• Experience with cloud data warehouses (Redshift, Snowflake, or BigQuery).
• Experience with customer behavior event tracking and marketing attribution.
• Experience with reverse ETL patterns, marketing activation, and identity resolution workflows.
• Strong data governance mindset.
• Excellent written and verbal communication skills.
• Curiosity and a desire to help others make smarter, faster decisions through data.

Benefits

Cast & Crew provides a comprehensive package of employee benefits including: Medical, Dental, Vision, PTO, health and wellness programs, employee discounts, and more!

Pay

$135,000.00 - $155,000.00 per year.

Schedule

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.