Senior Analytics Engineer (Financial Services)

Lightspeed Commerce; Montreal; On-site; CAD 80,000 - 110,000; Full time

Job summary

A leading technology company is looking for a Senior Analytics Engineer to join their Financial Services Data team in Montreal. This role involves cleansing and transforming data, building data pipelines, and ensuring data quality. The ideal candidate is proficient in SQL and Python, with experience in MPP data warehouses like BigQuery. This position offers great growth opportunities and a range of employee benefits, including equity and health insurance.

Benefits

Flexible paid time off

Health insurance

Equity scheme

Wellness benefit

Training opportunities

Qualifications

• Fluency in English is required.
• Experience with MPP data warehouse is preferred.
• Experience in Payments or Financial Services is a plus.

Responsibilities

• Cleanse and transform raw data into business logic.
• Collaborate with teams to build data pipelines.
• Act as a champion for data quality.

Skills

SQL

Python

Data quality validation

Communication skills

Problem solving

Tools

BigQuery

GCP

Job description

Overview

Lightspeed Financial Services is growing quickly and we are looking for a talented and passionate Senior Analytics Engineer to join our Financial Services Data team. This is a great opportunity to be part of an early team and help define the data landscape for very fast growing, global, Financial Services products. This role 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 proper 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
• Help define the data vision and roadmap for a new and fast growing product
• Mentor and help grow the team

What you will bring to the team

• Proficient with SQL and Python (or equivalent language)
• Experience with MPP data warehouse (we use BigQuery)
• Proficiency in performing data profiling, data mapping and data quality validation
• Experience with data orchestrator
• Solid understanding of industry standards for data warehousing and data modeling/DBT/Dataform
• Proficiency with data environments (we use GCP) as well as containerization solutions
• Proficiency 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

Bonus experience

• 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 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
• Fully stacked kitchen (hot and cold beverages, meals served)
• Happy hours to build your relationships with colleagues after work

Equal opportunity / Inclusion

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.

How to apply

Where to from here? We want you to step into a role you love and offer you a place you’re proud to come to every day. For a glimpse into our world check out our career page. We are building communities through commerce and welcome candidates from all backgrounds and lived experiences.

About Lightspeed

Lightspeed is powering the businesses that are the backbone of the global economy. Our cloud commerce platform helps merchants innovate to simplify, scale, and provide exceptional customer experiences. Founded in Montréal, Canada in 2005, Lightspeed is dual-listed on the NYSE and TSX, with teams across North America, Europe, and Asia Pacific, serving customers in over 100 countries.