Analytics Engineer: FS Data & Insights (Remote)

Lightspeed Commerce; Canada; Hybrid; CAD 100,000 - 115,000; Full time

Benefits offered by this job

Equity options

Unlimited paid time off

RRSP match up to 4% of base salary (to

Wellness & health benefits

Job summary

Lightspeed Commerce is seeking an Analytics Engineer for its Financial Services Data team, located in Canada with EST/EDT hours. The role supports analytics, reporting, data pipelines, and data models across Finance, Risk, and Product.

You will cleanse data, build sources for reports, and collaborate with multiple functions to ensure data quality and accessibility. Remote, hybrid, or office-based work environments are available, with English fluency required.

Qualifications

• Experience with SQL and Python coding is required.
• Strong background in data warehousing and data modeling.
• Familiarity with BigQuery, dbt or dataform, and data quality validation.
• Ability to communicate complex data insights to stakeholders.

Responsibilities

• Cleanses and transforms raw data into business logic for reports and models.
• Analyzes data and suggests data sources for business needs.
• Ensures timely delivery of data to the right people.
• Collaborates with Central Data Team to build pipelines and feed data models.
• Champions data quality and usability across the organization.
• Maintains data availability, quality, and documentation.
• Writes efficient queries and scripts with version control and CI/CD.
• Automates testing of data models and adds validations.
• Helps define internal standards for data models and infrastructure.
• Explains complex information to team members and supports dashboards in Looker.

Skills

SQL

Python

BigQuery

dbt

Data profiling

Data quality

CI/CD

Source control

GCP

Data modeling

Communication

Tools

Looker

Job description

Lightspeed Commerce is seeking an Analytics Engineer for its Financial Services Data team, located in Canada with EST/EDT hours. The role supports analytics, reporting, data pipelines, and data models across Finance, Risk, and Product.

You will cleanse data, build sources for reports, and collaborate with multiple functions to ensure data quality and accessibility. Remote, hybrid, or office-based work environments are available, with English fluency required.