Senior Data Engineer

Front is seeking a Senior Data Engineer to build and maintain end-to-end pipelines that move and transform data from GTM + Marketing systems into our warehouse for analytics and operational use. The role will involve designing and owning trusted, well-documented data models for marketing + GTM concepts, partnering with cross-functional teams to define metrics and align definitions, and improving data quality and observability.

Requirements

• 7+ years of dedicated data engineering, analytics engineering, or related experience building and debugging production data pipelines and data models at scale
• Strong SQL plus experience writing clean, testable code in Python (or a similar language used for data engineering)
• Experience building data models and pipelines on top of large datasets (hundreds of TB through petabyte scale), with attention to performance and cost
• Experience with modern data stacks and warehouses/lakes (e.g., Snowflake, Redshift, Databricks) and orchestration tools (e.g., Airflow) as well as modern SQL transformation practices (e.g., dbt)
• Ability to navigate ambiguity: translating vague, complex, or competing goals from executive stakeholders into clear, actionable, and robust data solutions
• Strong fundamentals in data quality, testing, and debugging, including the ability to trace issues across sources, transforms, and downstream dashboards
• Experience designing and implementing access control patterns at scale (RBAC, masking policies, row access policies, role hierarchies) in Snowflake or similar platforms
• Mentorship & engineering excellence: raising the technical bar, establishing team standards for dbt/SQL quality and CI/CD, and supporting others through reviews and pairing
• Strong collaboration and empathy: you listen, ask the right questions, and build solutions that balance stakeholder needs with platform integrity
• You champion data privacy and integrity, and act in the best interest of data consumers

Benefits

• Competitive salary
• Equity
• Private health insurance, including plan options at no cost to employees
• Paid parental leave
• Flexible time off policy
• Flexibility to work from home Monday and Friday, unless posted as a fully remote role
• Mental health support with Workplace Options
• Family planning support with Maven
• $100 per month Lifestyle Stipend to spend on fitness, health and wellness, and other activities
• Wellness Days – Fronteers get an additional day off on months with no holidays
• Winter Break – Our offices are closed from Christmas to New Year’s Day!

Tagged as: Python, Snowflake, SQL