Lead SQL Engineer

This is a fully remote position, open to applicants in United States.

📋 Description

• Lead, mentor, and develop a geographically distributed team of SQL engineers located in the US and Eastern Europe.

• Manage the complete service model for custom analytics requests, encompassing intake, scoping, Jira execution, quality assurance, customer review, feedback loops, and service level agreements.

• Act as a customer-facing technical leader, participating in calls to define complex requests, present dashboards, clarify data logic, and convert business inquiries into precise SQL deliverables.

• Establish the benchmark for delivery quality, ensuring that dashboards and queries are accurate, thoroughly documented, and quality-assured against key Triple Whale data sources prior to delivery to customers.

• Enhance the systems and processes that support the team, including ticket routing, request categorization, capacity planning, documentation, and reporting.

• Develop a more comprehensive taxonomy of customer requests categorized by product surface, segment, complexity, and use case to facilitate planning and highlight product insights.

• Collaborate with Customer Success, Solutions Architecture, Implementation, Sales, Product, and Engineering to support renewals, expansions, escalations, and strategic customer initiatives.

• Assist in identifying which requests should be addressed through self-service product features, documentation, enablement, or Product/Engineering investment instead of custom SQL solutions.

• Continue the team’s collaboration with Product and Engineering on internal platform initiatives, including template libraries, Moby-related SQL work, migrations, and AI-driven analytics workflows.

• Balance customer-facing delivery with internal technical objectives, ensuring the team's efforts are directed towards the highest-impact tasks.

• Serve as the technical representative in discussions concerning Advanced Intelligence credits, customer value, and the significance of custom analytics in retention and expansion.

⛳️ Requirements

• Over 6 years of experience in writing and deploying production SQL at scale, preferably within e-commerce, marketing, attribution, or customer analytics domains.

• Extensive experience with BigQuery and/or ClickHouse, including performance optimization, handling edge cases, and ensuring data quality.

• At least 2 years of experience managing data engineers, analysts, BI engineers, or a customer-facing technical delivery team.

• Proven track record in managing or enhancing a request-driven service model, including intake, ticketing, quality assurance, service level agreements, delivery standards, and feedback mechanisms.

• Strong customer-facing skills, capable of leading discussions with senior marketing, growth, or data stakeholders and transforming ambiguous business questions into clear technical specifications.

• Practical knowledge of the modern e-commerce data stack, including Shopify, Meta, Google, TikTok, Klaviyo, attribution modeling, and the necessary data integrations.

• Strong systems thinking aptitude, with the capability to design scalable workflows, improve visibility, and create structure in a high-volume environment.

• Proficiency in using Jira, Slack, HubSpot, and other workflow tools to establish clear, measurable, and repeatable processes.

• Exceptional written communication skills, with the ability to generate clear Jira updates, customer notes, documentation, team standards, and technical explanations.

• A strong sense of ownership, capable of balancing technical depth, customer empathy, team leadership, and operational execution.

🏝️ Benefits

• Health insurance

• 401(k) matching

• Flexible work hours

• Paid time off