Senior Analytics Engineer

Lightspeed Commerce

2d•$115,000 - $135,000•Hybrid

About The Position

Lightspeed's Data Office is hiring a Senior Analytics Engineer to design and own the data models that drive decisions across financial performance, GTM activities, and product insights. You'll partner with stakeholders across Finance, Revenue Ops, Marketing, and Product to deliver the analytics foundation the business runs on. This role is for individuals who enjoy building data pipelines that power real business decisions and want to design canonical models that unify fragmented source systems across multiple CRMs, ERPs, and product platforms. You can engage with Finance on revenue recognition or with Product on activation funnels, and translate those discussions into clear data models. You uphold a high standard for quality, provide constructive feedback when necessary, and proactively identify and solve problems. You will be responsible for scoping work, driving it to completion, and collaborating with others.

Requirements

Expert-level SQL: query performance, clean, maintainable code, and advanced analytical techniques (e.g. window functions)
Proven experience designing enterprise-grade dimensional models on modern cloud data warehouses such as BigQuery or Snowflake, including partitioning, incremental patterns, and performance optimization
Hands-on experience modelling SaaS / CRM / ERP source systems such as Salesforce or NetSuite, with a clear understanding of how their object models translate into clean dimensional schemas
Proven Dataform or dbt expertise in production: materializations, incremental strategies, snapshots, and macros
Communicate effectively with technical and non-technical stakeholders, clarifying needs, surfacing tradeoffs, and driving alignment
A security and compliance mindset: GDPR, SOX, and data access controls are part of the job, not an afterthought

Nice To Haves

CI/CD experience (e.g. GitHub Actions): automated testing, linting, and deployment workflows
Python or JavaScript for data engineering tooling
LookML or equivalent semantic layer experience
Familiarity with data contracts for pipeline validation
Experience using AI/LLM-assisted tooling to accelerate development workflows: code generation, documentation, debugging, or review
Revenue/finance domain knowledge (ARR, MRR, NetSuite, revenue arrangements)

Responsibilities

Design and build the data models that power the business: financial reporting (GTV, MRR, revenue recognition), GTM analytics, and product and operational insights
Design for scale and maintainability while staying pragmatic, shipping incremental value, gathering feedback, and iterating as you go
Turn ambiguous business requirements from Finance, Revenue Ops, Marketing, and Product teams into well-scoped technical solutions with effort estimates
Collaborate across our Hub & Spoke architecture, partnering with upstream data owner teams, downstream Looker/LookML developers, and other domain pods (Retail, Hospo, Operations) to design models that work end-to-end
Treat documentation as a first-class deliverable: column descriptions, model contracts, and architectural notes that power both human reviewers and AI/LLM-assisted workflows
Diagnose root problems, not symptoms, and drive systemic fixes rather than one-off patches
Own pipeline health end-to-end: monitor proactively, lead incident response, and surface risks before they become delivery problems
Autonomously manage personal sprint commitments and contribute to team-level planning, including task breakdown, effort estimation, and priority sequencing
Mentor junior engineers through coaching, code reviews, and technical sessions, and set the bar for what good looks like

Benefits

Flexible paid time off
Remote work policies
Equity options
Contributions to your pension plan
Training opportunities to grow your skills and career
Health and wellness credit
Time off to volunteer and give back to your community
Interest groups, employee-led networks, social committees to sponsored sports teams
Computer purchase program to get your personal MacBook
Enhanced parental leave to support growing families
Lightspeed equity scheme
Unlimited paid time off policy
People Experience - Our PX benefit allows you to work from pretty much anywhere in the world for 60 days a year
Health insurance: Immediate access to health, dental, vision, and life insurance for you and your eligible dependents.
Employer RRSP contribution of up to 4% of base salary to a maximum of $5,000
Health and wellness benefit of $500 per year
Employee Technology Purchase Program: Ability to an interest-free loan to purchase certain Apple products
Paid leave and assistance for new parents
Mental health online platform and counselling & coaching services
Volunteer day
A variety of snacks, coffee, and teas are always accessible and available in the office kitchen - Tuesday: Pancakes, Wednesday: Lunch is served, and Thursday is Happy Hour with a variety of drinks and snacks.