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
What you will bring to the team
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
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
As a global company with employees and clients outside of Quebec, fluency in English as a working language is required for this position.
Some additional things that would be a bonus
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)
What’s in it for you
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.
Fuel your growth. Find your people.
At Lightspeed, your growth is our priority. We invest in you with continuous learning opportunities, global mobility and benefits designed to support you—all within a driven, diverse and inclusive team that’s passionate about empowering our communities.
Please note that we ask applicants to disclose any criminal convictions, and we conduct criminal record checks as part of our hiring process for this role.
To all recruitment agencies: Lightspeed does not accept unsolicited agency resumes. If we have not directly engaged your company in writing to supply candidates for a specific vacancy, Lightspeed will not be responsible for any fees related to unsolicited resumes.
Lightspeed is a proud equal opportunity employer and we are committed to creating an inclusive and barrier-free workplace. Lightspeed welcomes and encourages applications from people with disabilities. Accommodations are available on request for candidates taking part in all aspects of the selection process.
Where to from here?
Obviously, this has to be mutually beneficial: we want you to step into a role you love, and we want to offer you a place you’re proud to come to every day. For a glimpse into our world check out our career page here.
Lightspeed is building communities through commerce, and we need people from all backgrounds and lived experiences to do that. We were founded in 2005, in Montreal’s gay village and our original members were all part of the LGBTQ+ community. The ethos of our business has been about inclusion from the very beginning, and we strive to provide a workplace where everyone belongs.
Who we are
Powering the businesses that are the backbone of the global economy, Lightspeed's one-stop commerce platform helps merchants innovate to simplify, scale, and provide exceptional customer experiences. Our cloud commerce solution transforms and unifies online and physical operations, multichannel sales, expansion to new locations, global payments, financial solutions, and connection to supplier networks.
Founded in Montréal, Canada in 2005, Lightspeed is dual-listed on the New York Stock Exchange (NYSE: LSPD) and Toronto Stock Exchange (TSX: LSPD). With teams across North America, Europe, and Asia Pacific, the company serves retail, hospitality, and golf businesses in over 100 countries.
Lightspeed handles your information in accordance with our Applicant Privacy Statement.
