Senior Analytics Engineer

Lightspeed Commerce

. Design and develop data models supporting financial reporting, GTM analytics, and product and operations insights.

Posted 11/2/2026full-timeMontreal • CanadaSeniorWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates advanced SQL proficiency and proven experience in designing enterprise dimensional models on BigQuery or Snowflake. Capable of translating business requirements into technical solutions while ensuring compliance with security standards and effective communication across teams.

Highest-signal resume keywords

Advanced SQL ProficiencyEnterprise Dimensional ModelingDataform or dbt ExpertiseCI/CD ExperienceFluency in English

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

SQLBigQuerySnowflakeDataformDbtPythonJavaScriptLookMLData ContractsPerformance Optimization

Soft Skills

Effective CommunicationCoachingCollaborationProblem-SolvingTask Prioritization

Tools & Technologies

SalesforceNetSuiteGitHub ActionsAutomated TestingLinting

Industry Keywords

GDPRSOXARRMRRRevenue Agreements

Tech Stack

Tools & technologies

BigQueryERPJavaScriptPythonSnowflakeSQL

About the role

Key responsibilities & impact

Design and develop data models supporting financial reporting, GTM analytics, and product and operations insights.
Design scalable, maintainable solutions, deliver value incrementally, gather feedback, and iterate.
Translate ambiguous business requirements from Finance, Revenue Operations, Marketing, and Product teams into clearly defined technical solutions with effort estimates.
Collaborate within the “Hub & Spoke” architecture with upstream data owners, downstream Looker/LookML developers, and other business pods.
Produce documentation, including column descriptions, model contracts, and architectural notes.
Diagnose issues at their root cause and implement systemic fixes.
Ensure end-to-end pipeline health, proactively monitor systems, lead incident response, and communicate risks.
Manage sprint commitments and contribute to team planning, task allocation, estimation, and prioritization.
Support junior engineers through coaching, code reviews, and technical sessions.
Define the team’s standards of excellence.
Design reference data models used by executives, the CFO, GTM teams, and Product.

Requirements

What you’ll need

Advanced SQL proficiency, including query performance, clean and maintainable code, and advanced analytical functions.
Proven experience designing enterprise dimensional models on BigQuery or Snowflake, including partitioning, incremental models, and performance optimization.
Hands-on experience modeling SaaS, CRM, and ERP source systems such as Salesforce or NetSuite.
Proven production expertise with Dataform or dbt, including materializations, incremental strategies, snapshots, and macros.
Effective communication with both technical and non-technical stakeholders.
A security- and compliance-oriented mindset, including GDPR, SOX, and data access controls.
Fluency in English as a working language required.
Experience with CI/CD, including GitHub Actions, automated testing, linting, and deployment workflows is an asset.
Python or JavaScript for data engineering tools is an asset.
Experience with LookML or an equivalent semantic layer is an asset.
Familiarity with data contracts for pipeline validation is an asset.
Experience with AI/LLM-powered tools is an asset.
Knowledge of revenue and finance, including ARR, MRR, NetSuite, and revenue agreements is an asset.
Disclosure of any criminal convictions and a criminal background check are part of the hiring process.

Benefits

Comp & perks

Flexible paid time off and remote work policy.
Lightspeed equity program.
Contributions to your retirement plan.
Learning and development opportunities.
$500 annual health and wellness allowance.
Dedicated volunteer time / volunteer day.
Employee networks, interest groups, social committees, and sponsored sports teams.
Computer purchase program for your personal MacBook.
Enhanced parental leave.
Unlimited paid time off policy.
People Experience program allowing you to work from almost anywhere in the world for 60 days per year.
Health, dental, vision, and life insurance from your first day of employment.
Employer RRSP contributions of up to 4% of base salary, to a maximum of $5,000.
Technology purchase program with an interest-free loan for select Apple products.
Leave and support for new parents.
Mental health platform, coaching, and counseling services.
Well-stocked office kitchen with snacks, coffee, and tea, along with weekly activities.
Flexible work environment.
Ongoing learning opportunities and international mobility.