Lightspeed Commerce Logo

Lightspeed Commerce

Analytics Engineer II

Posted Yesterday
Be an Early Applicant
Easy Apply
In-Office
Montréal, QC
Mid level
Easy Apply
In-Office
Montréal, QC
Mid level
The Analytics Engineer II will oversee analytics and reporting needs, clean and transform data, build data pipelines, and ensure data quality.
The summary above was generated by AI

Join Lightspeed's fast-growing Financial Services division as a talented and passionate Analytics Engineer on our FS Data team. In this key role, you'll be instrumental in overseeing all analytic and reporting needs, contributing directly to the success of every domain within Financial Services.

If you have worked on data pipelines, have great communication skills, are familiar with data modeling and have helped teams to gather both predictive and historical insights, you might be a great fit for this role! This role also involves collaborating with multiple functions across Lightspeed, including Application Engineering, Product, Operations, Risk and Finance among others.

Note: As a global company with employees and clients outside of Quebec, fluency in English as a working language is required for this position.

What you’ll be responsible for: 

  • Cleanse and transform raw data into business logic to help stakeholders build reports and data models
  • Ensure the right data gets to the right people at the right time
  • Collaborate with a Central Data Team to build data pipelines in accordance with shared best practices and design, and feed data models for usage
  • Act as a champion for data quality and usability across the Financial Services organization
  • Ensure availability, quality and searchability of data and documentation
  • Write, clean and maintainable queries and scripts that are highly performing, well structured and easy to understand and extend
  • Automate testing of data models and add appropriate validations to ensure quality
  • Help define and improve our internal standards for data models and infrastructure
  • Contribute to the  roadmap for a new and fast growing product

What you will bring to the team:

  • Experience with SQL and Python (or equivalent language)
  • Experience with MPP data warehouse (we use BigQuery)
  • Experience in performing data profiling, data mapping and data quality validation
  • Experience with data orchestrator
  • Understanding of industry standards for data warehousing and data modeling
  • Knowledge of data environments (we use GCP) as well as containerization solutions
  • Experience in source control, CI/CD and automated testing
  • A security mindset with ability to work with compliance protocols (SOX, GDPR)
  • Excellent communication skills and ability to communicate with technical and non technical stakeholders
  • Excellent problem solving skills
  • Ability to work independently and in teams
  • Self motivated and great at taking initiative

Some additional things that would be a bonus:

  • Experience in the Payments or Financial Services domain
  • Experience in working with SaaS solutions
  • Solid knowledge of cloud services (AWS and GCP in particular)

What’s in it for you:

  • Join a growing team and help us evolve 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 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.
 

Top Skills

BigQuery
Ci/Cd
GCP
Python
SQL

Lightspeed Commerce Toronto, Ontario, CAN Office

410 Adelaide St W, 501, Toronto, Ontario, Canada, M5V 1S4

Similar Jobs

Yesterday
Easy Apply
In-Office
Montréal, QC, CAN
Easy Apply
Mid level
Mid level
Software
The Analytics Engineer II will manage analytics and reporting needs, process raw data, ensure data quality, collaborate across functions, and automate data testing.
Top Skills: BigQueryCi/CdContainerizationGCPPythonSQL
Internship
Artificial Intelligence • Hardware • Information Technology • Security • Software • Cybersecurity • Big Data Analytics
As a Presales Engineering Intern, you will collaborate with the Sales Team to design innovative communication solutions for public safety agencies in Canada, focusing on various mission-critical technologies.
Top Skills: ExcelMs ProjectPowerPointVisioWord
Yesterday
Remote or Hybrid
Montréal, QC, CAN
Senior level
Senior level
Artificial Intelligence • Cloud • HR Tech • Information Technology • Productivity • Software • Automation
The Senior Technical Accelerator Consultant will deliver technical accelerators for ServiceNow products, drive customer success, mentor team members, and work on digital transformation projects.
Top Skills: EaHrsdIrmItsmPaServicenow ItamServicenow ItomSowSpm

What you need to know about the Toronto Tech Scene

Although home to some of the biggest names in tech, including Google, Microsoft and Amazon, Toronto has established itself as one of the largest startup ecosystems in the world. And with over 2,000 startups — more than 30 percent of the country's total startups — Toronto continues to attract new businesses. Be it helping entrepreneurs manage their finances, simplifying business operations by automating payroll or assisting pharmaceutical companies in launching new drugs, the city's tech scene is just getting started.

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account