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.