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
Senior Analytics Engineer building cloud data pipelines, analytical models, and BI dashboards for Valtech, an experience innovation company. Translating client business questions into reliable, governed data solutions.
Intermediate ETL Developer migrating customer data into Pandell - ESG’s energy software. Writing conversion scripts, adapting ETL frameworks, and leading technical implementation projects.
Senior Analytics Engineer building trusted financial data products for Kraken, a global crypto platform. Automating reconciliations, pipelines, dashboards and finance close processes.
Marketing Data Analytics Engineer building Salesforce, Marketo, and warehouse pipelines for PointClickCare’s healthcare analytics platform. Automating campaign reporting and supporting marketing - sourced pipeline insights.
Senior Analytics Engineer designing Lime’s finance - grade data warehouse and semantic layer. Ensuring governed, audit - ready reporting for the global shared micromobility business.
Analytics Engineer building Snowflake and dbt data platforms for Tucows’ Internet businesses. Applying AI, SQL, Looker, and Python to drive data - informed decisions.
Senior Analytics Engineer designing financial, GTM, and product data models for Lightspeed’s cloud commerce platform. Owning pipelines, documentation, and analytics foundations used across the business.
Senior Analytics Engineer building scalable data pipelines and AI - native analytics foundations at Mercury, a fintech company. Supporting agentic tooling, self - service analytics, governance, and data products.