Data Engineer

Summary

Tripleseat is seeking a Data Engineer to build and maintain the data platform that supports reporting, business intelligence, and product analytics. The role focuses on developing Python and SQL pipelines, transforming data with dbt, modeling data in Snowflake, and partnering with stakeholders to deliver trusted data solutions.

Responsibilities

• Build 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
• Design 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
• 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
• 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

• 2+ 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
• Familiarity 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

Qualifications

Must Haves

• 2+ 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

Nice to Haves

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

Benefits

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