Analytics Engineer

Lightspeed; Montreal; On-site; CAD 70,000 - 90,000; Full time

Job summary

A fast-growing tech company in Montreal is seeking an Analytics Engineer to build data pipelines and models. You will work collaboratively with data teams, focusing on data quality and usability. Strong SQL skills are essential, while knowledge of Python and experience with cloud environments are a plus. This role offers great benefits, autonomy, and opportunities for professional growth.

Benefits

Equity for all employees

Flexible paid time off

Health insurance

Wellness benefit of $500 per year

Training opportunities for skill growth

Qualifications

• Experience with MPP data warehouse.
• Experience in data profiling and mapping.
• Ability to adopt software engineering best practices.

Responsibilities

• Design and feed data models for stakeholders.
• Maintain SQL/Python queries and scripts.
• Act as a champion for data quality across the organization.

Skills

SQL skills

Good communication skills

Knowledge of Python

Understanding of data quality validation

Education

No specific degree mentioned

Tools

BigQuery

Cloud environments (GCP)

Git

Job description

Overview

Lightspeed is growing quickly and we’re looking for a great colleague who is also a passionate Analytics Engineer to join our Central Data Team. The primary role of this position is to build data pipelines and data models that will provide insight to our corporate stakeholders.

If you have worked on data pipelines, can use SQL language to order your food at the restaurant and you are proficient in data modelling, you’re a natural-born problem-solver and always willing to develop products that solve real-world problems for customers around the globe. You are collaborative and quality-focused. You know when to take a shortcut, but more importantly, you know when you should not take one. You provide feedback, not just to other contributors but also to management, and business teams. You are able to take any task that a department throws at you and proactively challenge it, this might be the role for you.

What you’ll do

• Cleanse and transform raw data into business logic to help stakeholders build reports, and ensure the right data gets to the right people at the right time
• Collaborate with data analysts and data architects to design and feed proper data models for downstream usage
• Act as a champion for data quality and usability across the organization
• Ensure availability, quality, and searchability of the data and documentation
• Write, clean, and maintain SQL/Python queries/scripts that are easy to understand, simple to troubleshoot and are highly performing with proper test implementation
• Automate the testing of our data models and monitor their quality
• Provide technical leadership on data solutions that are forward looking
• Work with the team to continuously improve our data pipeline
• Adopt software engineering best practices, such as version control and design patterns and teach others to adopt these best practices
• Help to define and improve our internal standards for style, maintainability, and best practices for a high-scale data infrastructure
• Share your knowledge and mentor more junior engineers

What you’ll be bringing to the team

• Great SQL skills
• Knowledge of Python would be a plus
• Experience with MPP data warehouse (we use BigQuery)
• Experience in performing data profiling, data mapping, and data quality validation
• A good understanding of industry-standard design patterns for data warehouse data models
• Experience with cloud environments (in particular GCP) as well as containerization solutions as a user
• Experience with source control using Git or equivalent, CI/CD pipelining, and writing automated unit and functional tests
• A security mindset - should be able to understand compliances (GDPR, SOX, ...)
• Good communication skills

What’s in it for you

Come live the Lightspeed experience...

• Join a growing team and help us move to the next level
• Amazing benefits & perks, including equity for all Lightspeeders
• Constant development of both your skill-set and business acumen with limitless growth opportunities
• Lots of autonomy, flexible work culture
• Innovation time to explore and learn at work
• Shaping the company by joining cultural & technical committees
• Tons of growth opportunities into technical or people management roles
• Opportunity to join a fast-paced, high-growth company
• Opportunity to learn, expand your skill set, forge wonderful relationships and make your mark within the diverse and inclusive Lightspeed family, a true Canadian tech success story

… and enjoy a range of benefits that will keep you happy, healthy and (not) hungry.

• Lightspeed equity scheme (we are all owners)
• Flexible paid time off and remote work policies
• Health insurance
• Contributions to your pension plan - RRSP
• Health and wellness benefit of $500 per year
• Paid leave and assistance for new parents
• Mental health online platform and counseling & coaching services
• Training opportunities to grow your skills and career
• Volunteer day
• Fully stacked kitchen (hot and cold beverages, meals served)
• Happy hours to build your relationships with colleagues after work

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 tocreating an inclusive and barrier-free workplace. Lightspeed welcomes andencourages applications from people with disabilities. Accommodations areavailable on request for candidates taking part in all aspects of theselection 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.