Expert-level SQL skills with a focus on performance and maintainability
Experience designing enterprise-grade dimensional models on cloud data warehouses like BigQuery or Snowflake
Hands-on experience with SaaS/CRM/ERP systems such as Salesforce or NetSuite
Proven expertise in Dataform or dbt for production data modeling
Strong communication skills for technical and non-technical stakeholders
Understanding of security and compliance standards like GDPR and SOX
Responsibilities
Design and build data models for financial reporting and analytics
Ensure models are scalable and maintainable while delivering incremental value
Translate ambiguous business requirements into technical solutions
Collaborate with various teams to create end-to-end data models
Document data models and architectural decisions thoroughly
Identify root problems and implement systemic solutions
Monitor pipeline health and lead incident responses
Manage personal sprint commitments and mentor junior engineers
Benefits
Real ownership of data models that influence leadership decisions
Access to a modern tech stack with a focus on developer experience
Collaboration with high-quality peers and opportunities for skill enhancement
Direct impact on business conversations with leadership
Flexible work environment that promotes productivity
Career growth opportunities in a growing Data Office
Flexible paid time off and remote work policies
Equity options and pension plan contributions
Health and wellness credits and training opportunities
Community volunteer time and employee-led networks
Full Job Description
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.
If you are someone who enjoys 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, then this role is for you. You can sit down with Finance to talk revenue recognition or with Product to map activation funnels, and walk away with a clear data model in your head. You hold a high bar on quality, push back constructively when it matters, and don't wait to be handed a well-defined problem. You scope the work, drive it to completion, and bring others along.
What you'll be responsible for:
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
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
You 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
Real ownership: you'll own canonical data models that leadership relies on, with the autonomy to design them properly and the influence to evolve team standards
A modern, well-maintained stack (Dataform, BigQuery, Looker, GitHub Actions, OpenCode) with active investment in developer experience and tooling
High-quality peers who care about craft, code reviews that make you better, and time to do things the right way
Direct line of sight to business impact: your work powers conversations with the CFO, GTM leadership, and Product teams
A growing Data Office at a publicly traded company headquartered in Montreal
Be a changemaker, You'll enjoy:
A flexible work environment that empowers you to do your best work
A culture that celebrates performance
The chance to make an impact in a team that's big enough for career growth, but lean enough to make your voice heard
Career-defining opportunities
Plus benefits designed to keep you happy, healthy and fulfilled.
Flexible paid time off and remote work policies
Equity options, because this is your company too
Contributions to your pension plan. Your future matters
Training opportunities to grow your skills and career
Health and wellness credit so you feel your best
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 (we are all owners)
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
We got you covered! 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.
About LightSpeed Retail
LightSpeed Retail is a cloud-based point-of-sale and e-commerce software provider for retailers and restaurateurs. The company was founded in 2005 by Dax Dasilva and is headquartered in Montreal, Canada. LightSpeed Retail's platform allows businesses to manage their inventory, process transactions, and analyze sales data. The company's mission is to help businesses grow by providing them with the tools they need to succeed. LightSpeed Retail has raised over $290 million in funding from investors such as Caisse de dépôt et placement du Québec, iNovia Capital, and Accel Partners.
