L

Lightspeed Commerce

Global SMB POS and payment platform

Senior Analytics Engineer

Data EngineeringConfirmed live in the last 24 hours
Full-timeMontreal, QC, CanadaNo salary listedHybrid

About the Job

Requirements

  • Advanced proficiency in SQL, including query performance, clean and maintainable code, and advanced analytical techniques such as window functions.
  • Proven experience designing enterprise dimensional data models on modern cloud data warehouses such as BigQuery or Snowflake, including partitioning, incremental models, and performance optimization.
  • Hands-on experience modeling SaaS, CRM, or ERP source systems such as Salesforce or NetSuite, with a clear understanding of translating their object models into dimensional schemas.
  • Proven production expertise in Dataform or dbt, including materializations, incremental strategies, snapshots, and macros.
  • Effectively communicate with technical and non-technical stakeholders to clarify needs, highlight trade-offs, and foster alignment.
  • Apply a security- and compliance-focused mindset; GDPR, SOX, and data access controls are integral to the role.
  • English proficiency as the working language is required.
  • Autonomously manage personal sprint commitments and contribute to team-level planning, including task allocation, effort estimation, and prioritization.

Responsibilities

  • Design and develop data models underlying the business, including financial reporting (GTV, MRR, and revenue recognition), go-to-market analytics, and product and operations insights.
  • Design for scalability and maintainability while remaining pragmatic, delivering incremental value, gathering feedback, and iterating.
  • Translate ambiguous business requirements from Finance, Revenue Operations, Marketing, and Product into clearly defined technical solutions with effort estimates.
  • Collaborate within the Hub & Spoke architecture with upstream data-owner teams, downstream Looker/LookML developers, and other business pods, including Retail, Hospitality, and Operations, to design end-to-end functional models.
  • Produce documentation as a deliverable, including column descriptions, model contracts, and architectural notes that support human reviewers and AI- and large-language-model-assisted workflows.
  • Diagnose root causes and implement systemic fixes rather than one-off patches.
  • Maintain end-to-end pipeline health by proactively monitoring, leading incident response, and surfacing risks before they become delivery issues.
  • Coach junior engineers through coaching, code reviews, and technical sessions, and define standards of excellence.

Desired Qualifications

  • Experience with CI/CD, such as GitHub Actions, including automated testing, linting, and deployment workflows.
  • Python or JavaScript for data engineering tools.
  • Experience with LookML or an equivalent semantic layer.
  • Proficiency with data contracts for pipeline validation.
  • Experience using AI/LLM-assisted tools to accelerate development workflows, including code generation, documentation, debugging, or review.
  • Knowledge of revenue and finance domains, including ARR, MRR, NetSuite, and revenue agreements.

About the Company

Lightspeed Commerce

Global SMB POS and payment platform

Lightspeed Commerce provides software for small and medium-sized retailers and restaurants, offering POS, payments, inventory, and customer engagement tools delivered as cloud-based software on a subscription. It combines hardware with cloud software so sales can be processed, stock tracked, and data analyzed across online and physical channels, with data syncing across locations. The company differentiates itself by focusing on SMBs with a broad, integrated suite tailored for retail and hospitality and by its global reach and scalable subscription model. Its goal is to help small businesses streamline operations, improve customer experiences, and drive growth to transform global commerce.

Company size
1,001-5,000
Company stage
IPO
Headquarters
Montreal, Canada
Founded
2005

Recently Posted Jobs

Explore more opportunities at Lightspeed Commerce

See more jobs