Kit 3 дня назад

Senior Analytics Engineer

от 172 000 $в год
  • Worldwide
  • Удалённо
  • Опыт от 7 лет
  • Полная занятость
AISQLCRMSaaSBIDBTLooker StudioAnalytics Engineering

Описание

Responsibilities

  • Own sales and creator commerce data from end to end.
  • Transform CRM and commerce data into trusted metrics and self-serve reporting.
  • Support product reporting.
  • Ensure semantic-layer documentation is usable by people and AI tools.
  • Build dbt models and Omni dashboards for Sales and RevOps.
  • Map how HubSpot objects flow into dbt models and document gaps.
  • Take over day-to-day ownership of sales models and Omni dashboards.
  • Audit current sales reporting and list where definitions differ or numbers don't reconcile.
  • Get familiar with how commerce data lands in the warehouse.
  • Agree with RevOps and Sales on the most important questions they need answered.
  • Review teammates' pull requests and contribute to shared SQL, dbt, and documentation standards.
  • Ship and maintain well-tested, documented dbt models for core sales metrics.
  • Expose those metrics through the Omni semantic layer within team's governance standards.
  • Rebuild or refresh core sales dashboards.
  • Resolve competing sales metric definitions by writing down options and tradeoffs, aligning with Sales and RevOps, and documenting the outcome.
  • Model creator-level commerce data, such as products sold, revenue earned through Kit, and conversion, in partnership with data engineering.
  • Write semantic layer descriptions, metric definitions, and documentation that let Omni's AI and MCP-connected AI tools answer routine sales questions correctly.
  • Test semantic layer descriptions against real questions from Sales, RevOps and Product.
  • Get Sales to the point where routine questions are answered through self-serve.
  • Be the recognized owner of Kit's sales data.
  • Give revenue analysis work the sales and commerce models it depends on.
  • Ensure domains are well documented and well tested, legible to new teammates, stakeholders, and AI agents.
  • Help raise team's modeling quality through code review, pairing, and sharing knowledge.

Requirements

  • Deep dbt experience (modular, tested, documented dbt projects, incremental models, snapshots, macros, CI, scheduled jobs in dbt Cloud).
  • Advanced SQL (reason carefully about grain, joins, window functions, write readable and performant queries).
  • Data modeling for sales and GTM (model deals, pipeline stages and their history, ownership changes, funnel conversion into clean, reusable structures).
  • Opinionated on Kimball standards and when a concept should be a fact or dimension.
  • CRM data fluency (recognize common CRM patterns, stage changes, backdated edits, custom properties).
  • HubSpot experience preferred, but other CRM experience (e.g. Salesforce) applies.
  • AI-assisted development (use AI code editors and agents like Cursor, Claude Code, Codex daily, validate their output with tests, query results, and review).
  • Clear written communication (explain metric definitions, tradeoffs, data caveats in plain language).
  • BI and semantic layer experience (build dashboards and semantic models in Omni, Looker, or similar BI tool).
  • Design metric definitions that people and AI tools can both query correctly.
  • Git-based workflows (keep pull requests small and well described, give thoughtful code review).
  • Around 7 or more years in analytics engineering or data engineering shipping production data models.
  • Several years of hands-on work building and maintaining production dbt projects.
  • Working directly with sales teams and RevOps, and owning reporting they relied on.
  • Owning a data domain over time and evolving its models as business needs changed.
  • Working at a SaaS company, ideally with self-serve and sales-led motion.
  • Working on a small or remote team with independent decision making.
  • Ownership and follow-through.
  • Judgment (match rigor to decision, know when a quick answer is enough, say so clearly).
  • Flexibility (glad to step outside primary area when needed, balance work against core commitments openly).
  • Teach everything you know (document as you go, pair generously, help stakeholders understand data).
  • Work in public (share progress, open questions, decisions in writing, including what didn't work).
  • Creator success is our success (remember who's on the other end, work carefully).
  • Do it with excellence (test work, review carefully, don't ship undefendable numbers).
  • Candor with care (comfortable pushing back when request won't answer real question, build trust).

Nice to have

  • Redshift performance tuning (sort and distribution keys).
  • Python for scripting or API pulls.
  • Reverse ETL.
  • Experience with product event, billing, payments, or ecommerce data.

We offer

  • Full-time remote role.
  • Work mostly on East Coast time (potential for early mornings or late evenings depending on location).
  • Compensation: US$172k / year.

Hiring process

  • Work through onboarding curriculum in Notion and meet team, partners.
  • Get set up in core tools: dbt Cloud, GitHub, Amazon Redshift, Omni, HubSpot, Linear, Hightouch, Slack.
  • Set up AI-assisted development environment and learn shared AI workflows.
  • Open and merge first small pull request.
  • Share written reflection with team on learnings and focus areas.