Junior Analytics Engineer (Financial Services)

Lightspeed Commerce, Inc.•Montreal, QC

3d•Hybrid

About The Position

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 modelling, 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.

Requirements

Experience with SQL and Python (or equivalent language)
Familiarity with cloud data warehouses such as BigQuery, Snowflake, Redshift or similar platforms
Experience with dbt or dataform
Experience in performing data profiling, data mapping and data quality validation
Experience with data orchestrator
Understanding of industry standards for data warehousing and data modelling
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 the 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

Nice To Haves

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

Responsibilities

Cleanse and transform raw data into business logic to help stakeholders build reports and data models
Analyze raw data and suggest data sources that best meet expressed business needs
Ensure the right data gets to the right people at the right time
Collaborate with the Central Data Team to build data pipelines in accordance with shared best practices and design, and feed data models for usage
Contribute to data quality initiatives and help maintain reliable datasets for stakeholders.
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 using version control and CI/CD
Automate testing of data models and add appropriate validations to ensure quality
Help define and improve our internal standards for data models and infrastructure
Ability to communicate technical concepts clearly to both technical and non-technical audiences.
Ability to maintain or develop a simple report or dashboard in Looker

Benefits

A flexible work environment that empowers you to do your best work
A culture that celebrates performance
The chance to make an impact in a team that’s big enough for career growth, but lean enough to make your voice heard
Career-defining opportunities
Flexible paid time off and remote work policies
Equity options, because this is your company too
Contributions to your pension plan
Training opportunities to grow your skills and career
Health and wellness credit
Time off to volunteer and give back to your community
Interest groups, employee-led networks, social committees to sponsored sports teams
Computer purchase program to get your personal MacBook
Enhanced parental leave to support growing families
Lightspeed equity scheme (we are all owners)
Unlimited paid time off policy
People Experience - Our PX benefit allows you to work from pretty much anywhere in the world for 60 days a year
Health insurance: Immediate access to health, dental, vision, and life insurance for you and your eligible dependents.
Employer RRSP contribution of up to 4% of base salary to a maximum of $5,000
Health and wellness benefit of $500 per year
Employee Technology Purchase Program: Ability to an interest-free loan to purchase certain Apple products
Paid leave and assistance for new parents
Mental health online platform and counselling & coaching services
Volunteer day
Variety of snacks, coffee, and teas are always accessible and available in the office kitchen - Tuesday: Pancakes, Wednesday: Lunch is served, and Thursday is Happy Hour with a variety of drinks and snacks.