Lead SQL Engineer

Triple Whale 🐳

Lead SQL Engineer driving analytics solutions for eCommerce at Triple Whale. Oversee a distributed team while ensuring high-quality deliverables and customer satisfaction in a fast-paced environment.

Posted 6/12/2026full-timeRemote • 🇺🇸 United StatesSenior💰 $145,000 - $175,000 per yearWebsite

Tech Stack

Tools & technologies

BigQuerySQL

About the role

Key responsibilities & impact

Lead, coach, and develop a distributed team of SQL engineers across the US and Eastern Europe.
Own the end-to-end service model for custom analytics requests, including intake, scoping, Jira execution, QA, customer review, feedback loops, and SLAs.
Serve as a customer-facing technical leader, joining calls to scope complex requests, present dashboards, explain data logic, and translate business questions into clear SQL deliverables.
Set the standard for delivery quality, ensuring dashboards and queries are accurate, well-documented, and QA’d against key Triple Whale data sources before reaching customers.
Improve the systems and processes that support the team, including ticket routing, request categorisation, capacity planning, documentation, and reporting.
Build a more thoughtful taxonomy of customer requests by product surface, segment, complexity, and use case to improve planning and surface product insights.
Partner with Customer Success, Solutions Architecture, Implementation, Sales, Product, and Engineering to support renewals, expansions, escalations, and strategic customer work.
Help identify which requests should be solved through self-serve product functionality, documentation, enablement, or Product/Engineering investment rather than custom SQL.
Continue the team’s partnership with Product and Engineering on internal platform work, including template libraries, Moby-related SQL work, migrations, and AI-enabled analytics workflows.
Balance customer-facing delivery with internal technical priorities, ensuring the team’s time is focused on the highest-impact work.
Act as the technical voice in conversations around Advanced Intelligence credits, customer value, and the role of custom analytics in retention and expansion.

Requirements

What you’ll need

6+ years of experience writing and shipping production SQL at scale, ideally with e-commerce, marketing, attribution, or customer analytics data.
Strong experience with BigQuery and/or ClickHouse, including performance optimisation, edge cases, and data quality considerations.
2+ years of experience managing data engineers, analysts, BI engineers, or a customer-facing technical delivery team.
Experience running or improving a request-driven service model with intake, ticketing, QA, SLAs, delivery standards, and feedback loops.
Strong customer presence, with the ability to lead calls with senior marketing, growth, or data stakeholders and turn ambiguous business questions into clear technical scope.
Hands-on familiarity with the modern e-commerce data stack, including Shopify, Meta, Google, TikTok, Klaviyo, attribution modelling, and the data joins required to connect them.
Strong systems thinking, with the ability to design scalable workflows, improve visibility, and create structure in a high-volume environment.
Comfort working in Jira, Slack, HubSpot, and other workflow tools to create clear, measurable, and repeatable processes.
Excellent written communication, with the ability to produce clear Jira updates, customer notes, documentation, team standards, and technical explanations.
A strong ownership mindset, with the ability to balance technical depth, customer empathy, team leadership, and operational execution.

Benefits

Comp & perks

Health insurance
401(k) matching
Flexible work hours
Paid time off

ATS Keywords

✓ Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

SQLBigQueryClickHouseperformance optimisationdata qualityattribution modellingdata joinsanalyticscustomer analyticse-commerce

Soft Skills

leadershipcustomer presencesystems thinkingcommunicationownership mindsetteam developmenttechnical deliveryproblem-solvingcollaborationprocess improvement