Senior Analytics Engineer at Pilot

<div> <h2>The Role</h2> </div> <div> <div> <div> <div><span class=" author-d-1gg9uz65z1iz85zgdz68zmqkz84zo2qotuz85z94z87z5z85zmz85z2z86z1z69z8z90zrz87zf0s5xturpwbz84zz68z5">Pilot is hiring a Senior Analytics Engineer to own our data foundation: the warehouse, the semantic layer, and the ingestion that every team at Pilot runs on.</span></div> <div>&nbsp;</div> <div><span class=" author-d-1gg9uz65z1iz85zgdz68zmqkz84zo2qotuz85z94z87z5z85zmz85z2z86z1z69z8z90zrz87zf0s5xturpwbz84zz68z5">Pilot launched in 2017 to bring the back office into the modern era. Today, with 3,000+ customers and a fast-growing roster of AI-native services, the company runs on data, and the foundation underneath it is being rebuilt to keep up.</span></div> <div>&nbsp;</div> <div><span class=" author-d-1gg9uz65z1iz85zgdz68zmqkz84zo2qotuz85z94z87z5z85zmz85z2z86z1z69z8z90zrz87zf0s5xturpwbz84zz68z5">As the Senior Analytics Engineer on this team, you'll own that foundation end-to-end. You'll architect the warehouse and the semantic layer, bring new data sources online as the business expands, and operate it like a well-oiled production system. The work you ship is the foundation every team at Pilot reports, decides, and forecasts against. You own how Pilot's data is shaped, modeled, and surfaced for AI tools, so every team can integrate AI into their workflows safely and reliably.</span></div> <div>&nbsp;</div> <div><span class=" author-d-1gg9uz65z1iz85zgdz68zmqkz84zo2qotuz85z94z87z5z85zmz85z2z86z1z69z8z90zrz87zf0s5xturpwbz84zz68z5">This is a strong fit for someone who strives to enable and empower others, brings a critical eye to processes and looks for opportunities to automate and streamline them, has clear opinions about what good data foundations look like, and treats AI-coding tools as a default part of how they build.</span></div> <div>&nbsp;</div> <div><span class=" author-d-1gg9uz65z1iz85zgdz68zmqkz84zo2qotuz85z94z87z5z85zmz85z2z86z1z69z8z90zrz87zf0s5xturpwbz84zz68z5">Pilot's data stack is Snowflake, dbt, and Looker, with Fivetran and Airflow for ingestion and&nbsp;</span><span class=" author-d-iz88z86z86za0dz67zz78zz78zz74zz68zjz80zz71z9iz90z9z84zl7jz81zz65zz89zvz70zz67zz86z0gz87zibz65zjz82zkz84ze7d5qz69z2z84zz85z">Fivetran Activations</span> <span class=" author-d-iz88z86z86za0dz67zz78zz78zz74zz68zjz80zz71z9iz90z9z84zl7jz81zz65zz89zvz70zz67zz86z0gz87zibz65zjz82zkz84ze7d5qz69z2z84zz85z h-lparen">(formerly</span><span class=" author-d-iz88z86z86za0dz67zz78zz78zz74zz68zjz80zz71z9iz90z9z84zl7jz81zz65zz89zvz70zz67zz86z0gz87zibz65zjz82zkz84ze7d5qz69z2z84zz85z"> Census) </span><span class=" author-d-1gg9uz65z1iz85zgdz68zmqkz84zo2qotuz85z94z87z5z85zmz85z2z86z1z69z8z90zrz87zf0s5xturpwbz84zz68z5">for reverse-ETL. </span><span class="thread-656305459155464637788782 author-d-1gg9uz65z1iz85zgdz68zmqkz84zo2qotuz85z94z87z5z85zmz85z2z86z1z69z8z90zrz87zf0s5xturpwbz84zz68z5">We use Claude Code or Cursor with governed MCP servers</span> <span class="thread-656305459155464637788782 author-d-1gg9uz65z1iz85zgdz68zmqkz84zo2qotuz85z94z87z5z85zmz85z2z86z1z69z8z90zrz87zf0s5xturpwbz84zz68z5 h-lparen">(Looker,</span><span class="thread-656305459155464637788782 author-d-1gg9uz65z1iz85zgdz68zmqkz84zo2qotuz85z94z87z5z85zmz85z2z86z1z69z8z90zrz87zf0s5xturpwbz84zz68z5"> dbt, Snowflake) as part of our day-to-day workflow.</span></div> <div>&nbsp;</div> <div><span class="thread-656305459155464637788782 author-d-1gg9uz65z1iz85zgdz68zmqkz84zo2qotuz85z94z87z5z85zmz85z2z86z1z69z8z90zrz87zf0s5xturpwbz84zz68z5"><strong>Location: San Francisco, CA (3 days/week in office - Mondays, Tuesdays, and Thursdays).</strong></span></div> </div> <h2><strong><span class=" author-d-1gg9uz65z1iz85zgdz68zmqkz84zo2qowz81zz86z59z85zz79zz83z3z85zz74zz80zz81zqz72z21z122zlpz89zz122zz79zz69ziz74zwkz88zamz122z">Key Responsibilities</span></strong></h2> <ul class="listtype-bullet listindent1 list-bullet1" data-testid="bullet-list" data-test-indentation="1"> <li><span class=" author-d-1gg9uz65z1iz85zgdz68zmqkz84zo2qotuz85z94z87z5z85zmz85z2z86z1z69z8z90zrz87zf0s5xturpwbz84zz68z5">Architect Pilot's data foundation: the warehouse layout, the semantic layer, and the access patterns that let humans and AI agents use Pilot's data safely and well</span></li> <li><span class=" author-d-1gg9uz65z1iz85zgdz68zmqkz84zo2qotuz85z94z87z5z85zmz85z2z86z1z69z8z90zrz87zf0s5xturpwbz84zz68z5">Methodically plan what each domain's data needs to look like, then ship it as durable, well-documented, well-tested models in dbt</span></li> <li><span class=" author-d-1gg9uz65z1iz85zgdz68zmqkz84zo2qotuz85z94z87z5z85zmz85z2z86z1z69z8z90zrz87zf0s5xturpwbz84zz68z5">Lead the ingestion of new data sources as the business expands: scope what's needed, choose the right pattern</span> <span class=" author-d-1gg9uz65z1iz85zgdz68zmqkz84zo2qotuz85z94z87z5z85zmz85z2z86z1z69z8z90zrz87zf0s5xturpwbz84zz68z5 h-lparen">(Fivetran,</span><span class=" author-d-1gg9uz65z1iz85zgdz68zmqkz84zo2qotuz85z94z87z5z85zmz85z2z86z1z69z8z90zrz87zf0s5xturpwbz84zz68z5"> custom Airflow DAG, or partner share), and ship it production-grade with tests and docs</span></li> <li><span class=" author-d-1gg9uz65z1iz85zgdz68zmqkz84zo2qotuz85z94z87z5z85zmz85z2z86z1z69z8z90zrz87zf0s5xturpwbz84zz68z5">Keep the foundation reliable and clean: operate it as a production system and continuously retire what's stale</span></li> <li><span class=" author-d-1gg9uz65z1iz85zgdz68zmqkz84zo2qotuz85z94z87z5z85zmz85z2z86z1z69z8z90zrz87zf0s5xturpwbz84zz68z5">Build AI tools and workflows that uplevel the data team's own work</span> <span class=" author-d-1gg9uz65z1iz85zgdz68zmqkz84zo2qotuz85z94z87z5z85zmz85z2z86z1z69z8z90zrz87zf0s5xturpwbz84zz68z5 h-lparen">(Claude</span><span class=" author-d-1gg9uz65z1iz85zgdz68zmqkz84zo2qotuz85z94z87z5z85zmz85z2z86z1z69z8z90zrz87zf0s5xturpwbz84zz68z5"> Code skills, MCP-driven agents)</span></li> <li><span class=" author-d-1gg9uz65z1iz85zgdz68zmqkz84zo2qotuz85z94z87z5z85zmz85z2z86z1z69z8z90zrz87zf0s5xturpwbz84zz68z5">Enable other teams to safely AI-enable their own workflows on Pilot data. For example, scope governed access surfaces, build the patterns that route them to the semantic layer first, and partner on intake review for new Claude Project integrations</span></li> <li><span class=" author-d-1gg9uz65z1iz85zgdz68zmqkz84zo2qotuz85z94z87z5z85zmz85z2z86z1z69z8z90zrz87zf0s5xturpwbz84zz68z5">Set the technical standards: testing, documentation, naming, materialization, deprecation, code review</span></li> <li><span class=" author-d-1gg9uz65z1iz85zgdz68zmqkz84zo2qotuz85z94z87z5z85zmz85z2z86z1z69z8z90zrz87zf0s5xturpwbz84zz68z5">Own Pilot's canonical metrics across the company</span> <span class=" author-d-1gg9uz65z1iz85zgdz68zmqkz84zo2qotuz85z94z87z5z85zmz85z2z86z1z69z8z90zrz87zf0s5xturpwbz84zz68z5 h-lparen">(including</span><span class=" author-d-1gg9uz65z1iz85zgdz68zmqkz84zo2qotuz85z94z87z5z85zmz85z2z86z1z69z8z90zrz87zf0s5xturpwbz84zz68z5"> Finance, Sales, Operations, and Marketing)</span></li> </ul> </div> <h2 data-usually-unique-id="138472287537425016436163"><span class=" author-d-1gg9uz65z1iz85zgdz68zmqkz84zo2qoxwyz67zz90z2z83zz76z8cpz84zfz70z92z88zz78zz71zz83znz66zz66zz88zw7dz88zz86zz75zz66zz71z">About you</span></h2> </div> <div><span class="ace-all-bold-hthree"><span class=" author-d-1gg9uz65z1iz85zgdz68zmqkz84zo2qotuz85z94z87z5z85zmz85z2z86z1z69z8z90zrz87zf0s5xturpwbz84zz68z5"><strong>Requirements:</strong></span></span></div> <div><span class=" author-d-1gg9uz65z1iz85zgdz68zmqkz84zo2qotuz85z94z87z5z85zmz85z2z86z1z69z8z90zrz87zf0s5xturpwbz84zz68z5">Even if you don't have experience with the specific technologies in our stack, we'd love to talk to you!</span></div> <ul class="listtype-bullet listindent1 list-bullet1" data-testid="bullet-list" data-test-indentation="1"> <li><span class=" author-d-1gg9uz65z1iz85zgdz68zmqkz84zo2qotuz85z94z87z5z85zmz85z2z86z1z69z8z90zrz87zf0s5xturpwbz84zz68z5">5+ years experience as an Analytics Engineer or Data Engineer with end-to-end ownership of a production warehouse and modeling layer</span></li> <li><span class=" author-d-1gg9uz65z1iz85zgdz68zmqkz84zo2qotuz85z94z87z5z85zmz85z2z86z1z69z8z90zrz87zf0s5xturpwbz84zz68z5">A track record of architecting data platforms that other teams build on</span></li> <li><span class=" author-d-1gg9uz65z1iz85zgdz68zmqkz84zo2qotuz85z94z87z5z85zmz85z2z86z1z69z8z90zrz87zf0s5xturpwbz84zz68z5">Strong SQL and production dbt experience at meaningful scale, including layered architecture, tests, documentation, and CI</span></li> <li><span class=" author-d-1gg9uz65z1iz85zgdz68zmqkz84zo2qotuz85z94z87z5z85zmz85z2z86z1z69z8z90zrz87zf0s5xturpwbz84zz68z5">Snowflake or comparable cloud data warehouse experience</span></li> <li><span class=" author-d-1gg9uz65z1iz85zgdz68zmqkz84zo2qotuz85z94z87z5z85zmz85z2z86z1z69z8z90zrz87zf0s5xturpwbz84zz68z5">Experience with a semantic layer</span> <span class=" author-d-1gg9uz65z1iz85zgdz68zmqkz84zo2qotuz85z94z87z5z85zmz85z2z86z1z69z8z90zrz87zf0s5xturpwbz84zz68z5 h-lparen">(LookML,</span><span class=" author-d-1gg9uz65z1iz85zgdz68zmqkz84zo2qotuz85z94z87z5z85zmz85z2z86z1z69z8z90zrz87zf0s5xturpwbz84zz68z5"> dbt Semantic Layer, Cube, MetricFlow, or comparable)</span></li> <li><span class=" author-d-1gg9uz65z1iz85zgdz68zmqkz84zo2qotuz85z94z87z5z85zmz85z2z86z1z69z8z90zrz87zf0s5xturpwbz84zz68z5">Experience streamlining data processes with AI dev tools, and building AI workflows or agents that teammates use day-to-day</span></li> <li><span class=" author-d-1gg9uz65z1iz85zgdz68zmqkz84zo2qotuz85z94z87z5z85zmz85z2z86z1z69z8z90zrz87zf0s5xturpwbz84zz68z5">Working Python proficiency for ingestion code</span> <span class=" author-d-1gg9uz65z1iz85zgdz68zmqkz84zo2qotuz85z94z87z5z85zmz85z2z86z1z69z8z90zrz87zf0s5xturpwbz84zz68z5 h-lparen">(extending</span><span class=" author-d-1gg9uz65z1iz85zgdz68zmqkz84zo2qotuz85z94z87z5z85zmz85z2z86z1z69z8z90zrz87zf0s5xturpwbz84zz68z5"> or writing Airflow DAGs, building custom connectors), plus hands-on experience with managed ingestion</span> <span class=" author-d-1gg9uz65z1iz85zgdz68zmqkz84zo2qotuz85z94z87z5z85zmz85z2z86z1z69z8z90zrz87zf0s5xturpwbz84zz68z5 h-lparen">(Fivetran</span><span class=" author-d-1gg9uz65z1iz85zgdz68zmqkz84zo2qotuz85z94z87z5z85zmz85z2z86z1z69z8z90zrz87zf0s5xturpwbz84zz68z5"> or comparable) and reverse-ETL</span> <span class=" author-d-1gg9uz65z1iz85zgdz68zmqkz84zo2qotuz85z94z87z5z85zmz85z2z86z1z69z8z90zrz87zf0s5xturpwbz84zz68z5 h-lparen">(Census</span><span class=" author-d-1gg9uz65z1iz85zgdz68zmqkz84zo2qotuz85z94z87z5z85zmz85z2z86z1z69z8z90zrz87zf0s5xturpwbz84zz68z5"> or comparable)</span></li> </ul> <div><span class="ace-all-bold-hthree"><span class=" author-d-1gg9uz65z1iz85zgdz68zmqkz84zo2qotuz85z94z87z5z85zmz85z2z86z1z69z8z90zrz87zf0s5xturpwbz84zz68z5"><strong>Working Style</strong></span></span></div> <ul class="listtype-bullet listindent1 list-bullet1" data-testid="bullet-list" data-test-indentation="1"> <li><span class=" author-d-1gg9uz65z1iz85zgdz68zmqkz84zo2qotuz85z94z87z5z85zmz85z2z86z1z69z8z90zrz87zf0s5xturpwbz84zz68z5">Cares about driving a company-wide data-driven culture through easy data access and self-service</span></li> <li><span class=" author-d-1gg9uz65z1iz85zgdz68zmqkz84zo2qotuz85z94z87z5z85zmz85z2z86z1z69z8z90zrz87zf0s5xturpwbz84zz68z5">Drives to find new tools and ways of working, and spreads them to uplevel the team</span></li> <li><span class=" author-d-1gg9uz65z1iz85zgdz68zmqkz84zo2qotuz85z94z87z5z85zmz85z2z86z1z69z8z90zrz87zf0s5xturpwbz84zz68z5">Takes pride in end-to-end ownership. Cares about how the platform looks and works, with a point of view about where it should go</span></li> </ul> <div><span class="ace-all-bold-hthree"><span class=" author-d-1gg9uz65z1iz85zgdz68zmqkz84zo2qotuz85z94z87z5z85zmz85z2z86z1z69z8z90zrz87zf0s5xturpwbz84zz68z5"><strong>Nice to Have</strong></span></span></div> <ul class="listtype-bullet listindent1 list-bullet1" data-testid="bullet-list" data-test-indentation="1"> <li><span class=" author-d-1gg9uz65z1iz85zgdz68zmqkz84zo2qotuz85z94z87z5z85zmz85z2z86z1z69z8z90zrz87zf0s5xturpwbz84zz68z5">Experience setting up safe, audited AI access to a data warehouse</span> <span class=" author-d-1gg9uz65z1iz85zgdz68zmqkz84zo2qotuz85z94z87z5z85zmz85z2z86z1z69z8z90zrz87zf0s5xturpwbz84zz68z5 h-lparen">(allow-listed</span><span class=" author-d-1gg9uz65z1iz85zgdz68zmqkz84zo2qotuz85z94z87z5z85zmz85z2z86z1z69z8z90zrz87zf0s5xturpwbz84zz68z5"> schemas, audit logs, kill switches)</span></li> <li><span class=" author-d-1gg9uz65z1iz85zgdz68zmqkz84zo2qotuz85z94z87z5z85zmz85z2z86z1z69z8z90zrz87zf0s5xturpwbz84zz68z5">Experience designing data platforms that non-data teams build self-serve workflows on top of</span></li> <li><span class=" author-d-1gg9uz65z1iz85zgdz68zmqkz84zo2qotuz85z94z87z5z85zmz85z2z86z1z69z8z90zrz87zf0s5xturpwbz84zz68z5">Airflow production experience</span></li> <li><span class=" author-d-1gg9uz65z1iz85zgdz68zmqkz84zo2qotuz85z94z87z5z85zmz85z2z86z1z69z8z90zrz87zf0s5xturpwbz84zz68z5">dbt Cloud experience</span></li> <li><span class=" author-d-1gg9uz65z1iz85zgdz68zmqkz84zo2qotuz85z94z87z5z85zmz85z2z86z1z69z8z90zrz87zf0s5xturpwbz84zz68z5">Looker administration experience</span> <span class=" author-d-1gg9uz65z1iz85zgdz68zmqkz84zo2qotuz85z94z87z5z85zmz85z2z86z1z69z8z90zrz87zf0s5xturpwbz84zz68z5 h-lparen">(permissions,</span><span class=" author-d-1gg9uz65z1iz85zgdz68zmqkz84zo2qotuz85z94z87z5z85zmz85z2z86z1z69z8z90zrz87zf0s5xturpwbz84zz68z5"> content curation, Spectacles, LAMS)</span></li> <li><span class=" author-d-1gg9uz65z1iz85zgdz68zmqkz84zo2qotuz85z94z87z5z85zmz85z2z86z1z69z8z90zrz87zf0s5xturpwbz84zz68z5">Data observability experience</span> <span class=" author-d-1gg9uz65z1iz85zgdz68zmqkz84zo2qotuz85z94z87z5z85zmz85z2z86z1z69z8z90zrz87zf0s5xturpwbz84zz68z5 h-lparen">(Elementary,</span><span class=" author-d-1gg9uz65z1iz85zgdz68zmqkz84zo2qotuz85z94z87z5z85zmz85z2z86z1z69z8z90zrz87zf0s5xturpwbz84zz68z5"> Monte Carlo, or comparable)</span></li> <li><span class=" author-d-1gg9uz65z1iz85zgdz68zmqkz84zo2qotuz85z94z87z5z85zmz85z2z86z1z69z8z90zrz87zf0s5xturpwbz84zz68z5">Fintech, accounting software, or B2B SaaS data background</span></li> </ul> <div> <h2>About Pilot</h2> <p>Pilot launched in 2017 to bring the back office into the modern era. Pilot provides small businesses with dedicated finance experts - which Pilot hires as full-time, U.S.-based employees - who learn the ins-and-outs of their business. Pilot integrates directly with the billing, banking, expense, and payroll systems customers already use. With a special blend of custom software and expert bookkeepers, Pilot delivers accurate, consistent bookkeeping and financial management and tax services that give entrepreneurs the freedom to focus on their business.</p> <p>Pilot has over 3,000 customers and has raised over $170 million in financing from Sequoia, Index Ventures, Stripe, Bezos Expeditions, and Whale Rock.&nbsp; Our investors also include a long list of world-class entrepreneurs, including Patrick and John Collison, Drew Houston, and Diane Greene.&nbsp; Our most recent funding round doubled our valuation to $1.2 billion – <a href="https://pilot.com/blog/pilot-unicorn-bezos-expeditions-whale-rock/">Meet Fintech’s Newest Unicorn</a>.</p> <h2>Why Pilot?</h2> <ul> <li>We invest in our employees’ development and happiness because our employees are the keys to our success and ensuring happy customers</li> <li>The opportunity to join a seasoned founding team that has led companies through two prior successful startups and acquisitions (by Oracle and Dropbox).</li> <li>Flexible vacation/time-off policy</li> <li>All federal holidays are observed</li> <li>Competitive benefits package including additional wellness benefits</li> <li>Parental leave for birthing or non-birthing parents – 100% pay for 12 weeks</li> <li>401(k) plan</li> </ul> <p>The base pay range target for the role seniority described in this job description is <em>$166,000 - $224,000</em> in San Francisco, CA. Final offer amounts depend on multiple factors such as candidate experience and expertise, geographic location, total compensation, and market data. In addition to cash pay, full-time regular positions are eligible for equity, 401(k), health benefits, and other benefits; some of these benefits may be available for part-time or temporary positions.</p> <p>Pilot commits to provide a work environment free of discrimination and harassment, as well as equal employment opportunity regardless of race, color, ancestry, religion, sex, national origin, sexual orientation, age, citizenship, marital status, disability, gender identity or Veteran status. We also consider qualified applicants regardless of criminal histories, consistent with legal requirements. You may view all of Pilot’s <a href="https://pilot.com/recruiting-notices">recruiting notices here</a>, including our EEO policy, information about requesting a reasonable accommodation in the job application process, recruitment agency policy, recruitment scam notice, and important E-Verify information. You may view our job candidate privacy policy <a href="https://pilot.com/terms/privacy-job-candidate">here</a>.</p> </div>