Senior Analytics Engineer
Lightspeed Commerce, Inc.9 days ago
Montréal, CanadaSenior
Responsibilities
- Design and build canonical dimensional data models for financial reporting, GTM analytics, product insights, and operational reporting.
- Translate requirements from Finance, Revenue Operations, Marketing, and Product into scoped technical solutions with effort estimates.
- Collaborate with upstream data owners, downstream Looker/LookML developers, and domain teams across the Hub & Spoke architecture.
- Maintain documentation including column descriptions, model contracts, and architectural notes.
- Diagnose root causes and implement systemic fixes rather than one-off patches.
- Own pipeline health through proactive monitoring, incident response, and risk identification.
- Manage sprint commitments and contribute to task breakdown, estimation, and prioritization.
- Mentor junior engineers through coaching, code reviews, and technical sessions.
Requirements
- Expert-level SQL skills, including query performance, maintainable code, and advanced analytical techniques such as window functions.
- Experience designing enterprise-grade dimensional models on cloud data warehouses such as BigQuery or Snowflake, including partitioning, incremental patterns, and performance optimization.
- Hands-on experience modeling SaaS, CRM, or ERP systems such as Salesforce or NetSuite into dimensional schemas.
- Production expertise with Dataform or dbt, including materializations, incremental strategies, snapshots, and macros.
- Ability to communicate effectively with technical and non-technical stakeholders and drive alignment.
- Understanding of security, GDPR, SOX, and data access controls.
- Fluency in English as a working language.
- CI/CD experience with automated testing, linting, and deployment workflows is a bonus.
- Python or JavaScript experience for data engineering tooling is a bonus.
- LookML or equivalent semantic layer experience is a bonus.
- Familiarity with data contracts, AI/LLM-assisted development workflows, and revenue or finance concepts is a bonus.
Benefits
- Flexible work environment with remote work policies and the ability to work from most locations worldwide for up to 60 days per year.
- Flexible and unlimited paid time off policies.
- Equity options and a Lightspeed equity scheme.
- Pension and employer RRSP contributions of up to 4% of base salary, capped at $5,000.
- Health, dental, vision, and life insurance with immediate access for eligible dependents.
- Annual health and wellness benefit of $500 plus mental health, counselling, and coaching services.
- Training and continuous learning opportunities, global mobility, employee networks, and volunteer time.
- Enhanced parental leave and paid leave assistance for new parents.
- Computer purchase program and interest-free technology purchase loans for eligible Apple products.
- Office snacks, coffee, tea, scheduled meals, and social activities.
Tech Stack
Categories
Data Engineering
About Lightspeed Commerce, Inc.
Lightspeed Commerce builds a cloud-based point-of-sale and commerce platform for retail and hospitality, combining POS, omnichannel e-commerce, inventory, analytics, and integrated payments. It monetizes through software subscriptions and payment processing fees for SMBs and multi-location operators. Founded in 2005 and headquartered in Montreal, the company is publicly traded on the NYSE and TSX and serves merchants in over 100 countries.