Data Engineer

Data EngineerThe Data Engineer builds and maintains the pipelines that move data from Tripleseat's business applications and product databases into Snowflake, and shapes that data into trustworthy, well-modeled tables using dbt. This role is the foundation of Tripleseat's data platform: the pipelines and models you build power reporting, business intelligence, and product analytics across the company.You'll spend most of your time writing Python and SQL to extract data from source systems (via Stitch and custom scripts) and transforming it in dbt. As you grow in the role, you'll have the opportunity to stretch into Snowflake/dbt infrastructure, semantic layer design, and hands-on business and product analytics.LocationThis position is open to remote candidates eligible to work in the United States.Travel ExpectationsIf the ideal candidate is located outside the Concord, MA area, they will be required to complete initial onboarding at our Concord, MA office, followed by quarterly in-office visits.Core Responsibilities:Pipeline Engineering & AutomationBuild and maintain data pipelines that move data from business applications and product databases into Snowflake, using Stitch, Dagster and Snowpipe for extraction and loading.Write custom Python scripts to pull data from APIs and systems not covered by off-the-shelf connectors.Transform raw data into clean, reliable models using dbt, following consistent modeling and testing conventions.Monitor pipeline health, troubleshoot failures, and resolve data quality issues as they arise.Document data sources, pipeline logic, and dbt models so others can understand and extend them.Data Modeling & Semantic LayerDesign dbt models that organize raw data into clear, well-tested staging, intermediate, and mart layers.Contribute to semantic layer definitions—metrics, dimensions, and business logic—so teams across the company work from consistent, trusted numbers.Partner with analytics, product, and business stakeholders to understand reporting needs and translate them into data models.Infrastructure & Operations (Occasional)Support Snowflake warehouse configuration, access controls, and cost/performance tuning as needed.Contribute to dbt project structure, CI checks, and build optimization to keep the pipeline fast and maintainable.Analytics (Occasional)Dig into business and product data directly to answer ad hoc questions and surface insights for stakeholders.Build or support dashboards and reports that help teams track key business and product metrics.Skills & ExperienceRequired2+ years in data engineering, analytics engineering, or a similar data-focused technical role.Proficiency in Python for building and maintaining data pipelines.Strong SQL skills and comfort working with relational databases (e.g., MySQL) and their schemas.Hands-on experience with Snowflake or another cloud data warehouse.Experience with dbt (or a similar transformation tool) for data modeling.Experience with ELT/ETL tools such as Stitch, Fivetran, or similar.Comfortable working with Git for version control and collaborative development.Experience with pipeline orchestration tools (e.g., Dagster, Airflow).Experience leveraging AI-assisted development tools (e.g., GitHub Copilot, Cursor, Claude) to accelerate workflows.Strong communicator with business and technical acumen who can partner effectively with engineering, product, and business teams.PreferredFamiliarity with semantic layer or metrics-layer tooling, including experience with the Snowflake MCP server.Experience building dashboards or conducting business/product analytics.Familiarity with AWS or another cloud environment.Experience integrating data from CRM or business systems (Salesforce, HubSpot, etc.).Background working in a fast-growing SaaS company or startup environment.The salary for this role is $100,000 to $120,000 annually. Compensation is based on a variety of factors including relevant experience, technical skill set, AI development fluency, and geographic location, in alignment with our internal compensation framework. This role is also eligible for additional benefits and incentives.Tripleseat truly values its employees and places a high emphasis on their well-being and happiness. We understand that our people are the driving force behind our success and strive to create a positive and supportive work environment. We love what we do and who we get to do it with!Competitive Medical, Dental, and Vision Insurance: Comprehensive coverage to support health and well-being.Company Paid Life Insurance, Short- and Long-Term Disability Plans: Protection and peace of mind in unforeseen circumstances.Supplemental Insurance Options: Optional critical illness, accident, and hospital plans.Commuter Benefits: Transit and parking benefits, where applicable.401(k) with Company Match: Helping employees save and plan for retirement.Parental Leave: Support for new parents through birth, adoption, or foster care.Flexible Paid Time Off: Encouraging work-life harmony and balance.LinkedIn Learning Access: On-demand professional development courses.Pet Insurance: Supporting the well-being of furry family members.Employee Discount Programs: Exclusive savings through employee perk platforms.At Tripleseat, we place a high value on our employees' well-being and happiness, recognizing that they are the driving force behind our success. We are committed to fostering a positive and supportive work environment. We take pride in our work and the collaborative spirit of our team.We are proud to be an equal-opportunity employer and do not discriminate based on race, color, ethnicity, ancestry, religion, sex, national origin, sexual orientation, age, citizenship status, marital status, disability, gender identity, gender expression, veteran status, or genetic information. We are dedicated to fostering a culture of inclusion, diversity, and equity. Everyone Valued – Everyone Included.