Lead SQL Engineer

What Do We Do? Triple Whale is the AI operating system built for modern ecommmerce. We help you see what's actually working in your business, what's not, and what to do next. Then we take action for you — pausing the underperforming ad, generating the next batch of creative, flagging the inventory risk before it bites. We pull every signal in your business into one place, and put it on the most trusted measurement foundation in the industry. And on top of that, we give you the most actionable AI in commerce — Moby 2 — letting you tap any LLM you want, grounded in the full context of your business. Moby 2 doesn't just surface insights, it executes decisions for you, with automations that make the rest of your stack smarter. The result: more than 60,000 brands like Pressed Juicery, OUAI, and True Classic turn mountains of complex data into actions that actually grow profit, at a speed and scale that is not humanly possible. What You're Applying For Triple Whale is hiring its first US-based Lead SQL Engineer to lead the team, service model, and delivery of custom analytics assets for our customers, including dashboards, queries, and bespoke data products. Today, our SQL team plays a critical role in customer outcomes. Custom dashboards are a paid product, a key retention lever for our highest-value accounts, and an increasingly important part of renewal and expansion conversations. This role will lead the team’s evolution from a behind-the-scenes ticketing function into a direct, customer-facing service organisation that partners with customers on strategic data work. As Lead SQL Engineer, you’ll own how work is requested, scoped, delivered, reviewed, and scaled. You’ll lead a distributed team, set the quality bar, partner closely with customers and internal teams, and ensure every deliverable is accurate, actionable, and loved by customers. What You'll Do 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. What You'll Bring 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. *Nice to have: Python for analysis or pipeline scaffolding, experience with LLM-assisted analytics workflows, or prior experience in a high-growth e-commerce SaaS environment. Our Values We Are Customer Obsessed: From our mission to every detailed project, everything we do is designed to create a positive impact for our customers. We Move (Very!) Quickly: The speed at which we work, iterate, and deliver value is our most competitive advantage. We Are Trustworthy: Candor, directness, and honest communication helps us learn, grow and improve so we can win together. We Are Curious: We extend beyond our comfort zone and ask questions that guide us towards new, creative, and bold paths. We Act Like A Mensch: We act with honor, integrity and empathy, and have deep respect for our customers and each other. Base Compensation Range: $145,000 - 175,000 Our compensation ranges are set using benchmarks from growth-stage companies and factor in function, level, and location—so everything stays balanced and competitive. The range listed on each job posting reflects the minimum and maximum target salary across all U.S. locations. Triple Whale is an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all employees. Join Us in Making Waves If you’re looking for more than just a job and want to be part of a movement reshaping the future of Ecommerce, Triple Whale is the place for you. We’re on the lookout for driven, curious, and creative individuals ready to thrive in a fast-paced environment. Referred? Got here thanks to a friend? Splash some gratitude their way! They'll need to submit your application through our referral system to make it official. #LI-Remote