Join our community of growth stage businesses

We are seeking a passionate Senior Data Operations Engineer. The Senior Data Operations Engineer owns and evolves the technical infrastructure powering Tripleseat's data pipelines and analytics platforms. This role is responsible for building reliable data flows from production systems into our Snowflake data warehouse, developing data models that enable business insights, and integrating data from across the organization.

The ideal candidate combines strong database fundamentals with modern data engineering practices, bringing a mindset of automation, reliability, and operational excellence to everything they build.

Travel Expectations: If 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.

What You Will do:

Pipeline Engineering & Automation

• Build, operate, and maintain reliable ETL/ELT pipelines moving data from MySQL and other source systems into Snowflake using Dagster, Stitch, and dbt Core.

• Create data pipelines that read from external APIs and write to Snowflake, integrating data from business systems across the organization (Salesforce, etc.).

• Optimize the dbt project build to enhance build times and reduce warehouse costs.

• Automate ingestion, transformation, validation, and monitoring processes to increase reliability.

• Ensure pipelines meet SLAs for data availability, latency, and accuracy.

Data Modeling & Analytics

• Design and build data models in Snowflake that support analytics, reporting, and business intelligence needs.

• Partner with Developers and Product teams to build data products that drive business value.

• Contribute to data platform roadmap and technical strategy.

• Scale and optimize data platforms as data volumes, concurrency, and business demand grow.

• Identify and resolve performance bottlenecks: query optimization, indexing, warehouse sizing, and workload management.

Quality, Governance & Documentation

• Implement and maintain data quality frameworks, schema validation, and drift detection.

• Partner with analytics teams to ensure upstream schema changes and downstream models remain aligned.

• Create and maintain documentation, runbooks, and operational procedures for data pipelines and systems.

Infrastructure & Operations

• Manage data-related infrastructure: cloud resources, Snowflake warehouses, access controls, and pipeline orchestration.

• Work with DevOps/Engineering to integrate data workflows into CI/CD pipelines and infrastructure-as-code environments.

• Support incident response and root-cause analysis for data pipeline or platform issues.

Technical Leadership

• Drive technical direction and best practices for the data platform.

• Mentor team members on data engineering practices and tooling.

• Proactively identify opportunities to improve data architecture, reliability, and efficiency.

What We are Looking For:

Required

• 5+ years in data engineering, analytics engineering, or similar data-focused technical roles.

• Strong experience with relational databases, especially MySQL, including schema design and SQL proficiency.

• Experience building and maintaining ETL/ELT pipelines connecting application databases to cloud data warehouses.

• Hands-on experience with Snowflake—warehouse configuration, performance tuning, cost optimization.

• Proficiency with dbt for data transformation and modeling.

• Experience with pipeline orchestration tools, preferably Dagster.

• Comfortable working with Git for version control and collaborative development.

• Experience working in AWS cloud environments.

• Experience leveraging AI-assisted development and analysis tools (e.g., GitHub Copilot, Cursor, Claude) to accelerate workflows and improve productivity.

• Strong communicator who can partner effectively with engineering, product, and analytics teams.

Preferred

• Experience with data modeling methodologies and dimensional design.

• Familiarity with infrastructure tools (Terraform, Docker, CI/CD).

• Experience integrating data from CRM and business systems (Salesforce, HubSpot, etc.).

• Background in advanced MySQL internals: query optimization, replication, slow query analysis.

• Experience with data cataloging, lineage tracking, or metadata systems.

• Background working in a fast-growing SaaS company or startup environment

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 its success and strive to create a positive and supportive work environment. We love what we do and who we get to do it with! Here are some of the awesome benefits that Tripleseat offers to its employees:

• Competitive Medical, Dental, and Vision Insurance: Tripleseat provides its employees with comprehensive medical, dental, and vision insurance coverage, ensuring that their health and well-being are taken care of.

• Company Paid Life Insurance, Short- and Long-Term Disability Plans: Tripleseat takes care of its employees by providing them with life insurance coverage, as well as short and long-term disability plans to protect them in case of unforeseen circumstances.

• 401(k) with Company Match: Tripleseat offers a 401(k) retirement plan to its employees, and also provides a company match, helping employees save for their future and plan for retirement.

• Parental Leave: Tripleseat understands the importance of work-life balance and offers parental leave to employees who become parents through birth, adoption, or foster care, allowing them to bond with their new family members without worrying about their job security.

• Flexible Paid Time Off: Tripleseat believes in the importance of work-life harmony and offers flexible paid time off to its employees, giving them the flexibility to take time off when needed and maintain a healthy work-life balance.

• Pet Insurance: Tripleseat recognizes the importance of pets in employees' lives and offers pet insurance to help them take care of their furry friends and ensure their well-being.

Here at Tripleseat, we make sure that everyone has a seat at the table. That’s why we’re proud to be an equal-opportunity employer. We do not discriminate on the basis of 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 committed to fostering a company-wide culture centered around inclusion, diversity, and equity. Tripleseat empowers all team members to realize the full potential of themselves and others. Everyone Valued – Everyone Included.