Resume Score

Check how well your resume matches this job before you apply.

Sign in to check score

About the role

  • Analytics Engineer transforming data for Lightspeed’s commerce and financial services platform. Building pipelines, models, quality checks, and Looker reporting for cross-functional teams.

Responsibilities

  • Oversee analytic and reporting needs across the Financial Services division
  • Cleanse and transform raw data into business logic for reports and data models
  • Analyze raw data and recommend data sources for business needs
  • Ensure the right data reaches the right people at the right time
  • Collaborate with the Central Data Team to build data pipelines according to shared best practices
  • Feed data models for usage
  • Champion data quality and usability across Financial Services
  • Ensure data and documentation are available, high-quality, and searchable
  • Write, clean, and maintain high-performing queries and scripts using version control and CI/CD
  • Automate data-model testing and add validations
  • Help define and improve standards for data models and infrastructure
  • Explain intermediate to complex information to team members
  • Maintain or develop simple reports or dashboards in Looker
  • Collaborate with Application Engineering, Product, Operations, Risk, Finance, and other functions

Requirements

  • Located in Canada
  • Able to work within EST/EDT hours
  • Experience with data pipelines
  • Experience with SQL and Python coding or equivalent language
  • Experience with MPP data warehouses, especially BigQuery
  • Experience with dbt or Dataform
  • Experience performing data profiling, data mapping, and data quality validation
  • Experience with a data orchestrator
  • Understanding of industry standards for data warehousing and data modelling
  • Knowledge of data environments, especially GCP, and containerization solutions
  • Experience with source control, CI/CD, and automated testing
  • Security mindset and ability to work with compliance protocols including SOX and GDPR
  • Excellent communication skills with technical and non-technical stakeholders
  • Excellent problem-solving skills
  • Ability to work independently and in teams
  • Self-motivated and able to take initiative
  • Fluency in English as a working language
  • Criminal record check as part of the hiring process
  • Payments or Financial Services experience is a bonus
  • SaaS solutions experience is a bonus
  • Solid knowledge of cloud services, particularly AWS and GCP, is a bonus

Benefits

  • A flexible work environment
  • Flexible paid time off and remote work policies
  • Equity options
  • Contributions to pension plan
  • Training opportunities
  • Health and wellness credit
  • Time off to volunteer
  • Interest groups, employee-led networks, social committees, and sponsored sports teams
  • Computer purchase program for a personal MacBook
  • Enhanced parental leave
  • Lightspeed equity scheme
  • Unlimited paid time off policy
  • People Experience benefit allowing work from pretty much anywhere in the world for 60 days a year
  • Health, dental, vision, and life insurance for eligible dependents
  • Employer RRSP contribution of up to 4% of base salary, maximum $5,000
  • Health and wellness benefit of $500 per year
  • Interest-free loan to purchase certain Apple products
  • Paid leave and assistance for new parents
  • Mental health online platform and counselling and coaching services
  • Volunteer day
  • Office snacks, coffee, and tea
  • Tuesday–Thursday lunch served in the office
  • Thursday Happy Hour
  • Continuous learning opportunities
  • Global mobility
  • Inclusive and barrier-free workplace accommodations

Job type

Full Time

Experience level

Mid levelSenior

Salary

Not specified

Degree requirement

No Education Requirement

Tech skills

AWSBigQueryCloudGoogle Cloud PlatformPythonSQL

Location requirements

HybridMontrealCanada

Report this job

Found something wrong with the page? Please let us know by submitting a report below.