Lead SQL Engineer

Triple Whale

$145K — $175K *
US-AnywhereRemote in United States
Enterprise Technology
5 - 7 years of experience
Job Overview by Ladders

Qualifications

  • 6+ years of experience in production SQL, particularly in e-commerce and customer analytics.
  • Strong expertise in BigQuery and/or ClickHouse with a focus on performance and data quality.
  • 2+ years in a leadership role managing data engineers or customer-facing technical teams.
  • Proven experience in running a request-driven service model, including ticketing and quality assurance.
  • Excellent communication skills to engage with senior stakeholders and clarify technical scopes.
  • Familiarity with the e-commerce data stack, including key platforms like Shopify and Google.
  • Ability to design scalable workflows and improve operational visibility.

Responsibilities

  • Lead and develop a distributed team of SQL engineers across multiple regions.
  • Own the custom analytics service model from request intake to delivery and review.
  • Act as a customer-facing technical leader, translating business needs into SQL deliverables.
  • Establish high-quality standards for dashboards and queries prior to customer delivery.
  • Enhance internal systems for ticket routing, documentation, and reporting.
  • Collaborate with various teams to support customer retention and strategic work.
  • Identify opportunities to shift customer requests to self-service solutions or product enhancements.

Benefits

  • Opportunity to lead the first US-based SQL engineering team.
  • Direct impact on customer retention through custom analytics delivery.
  • Collaboration with a diverse set of internal teams on strategic initiatives.
  • Flexibility of a remote work environment.
  • Engagement in innovative projects that reshape the e-commerce landscape.
Full Job Description
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.

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.

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

Similar Jobs

More Jobs at Triple Whale

More Enterprise Technology Jobs

Find similar Lead SQL Engineer jobs: