Senior Analytics Engineer

Lightspeed is growing quickly and we’re looking for a great colleague who is also a passionate Senior Analytics Engineer to join our Central Data Team. The primary role of this position is to build data pipelines and data models that will provide insight to our corporate stakeholders.

If you have worked on data pipelines, can use SQL language to order your food at the restaurant and you are proficient in data modelling, you’re a natural-born problem-solver and always willing to develop products that solve real-world problems for customers around the globe. You are collaborative and quality-focused. You know when to take a shortcut, but more importantly, you know when you should not take one. You provide feedback, not just to other contributors but also to management, and business teams. You are able to take any task that a department throws at you and proactively challenge it, this might be the role for you.

What you'll do:

Cleanse and transform raw data into business logic to help stakeholders build reports, and ensure the right data gets to the right people at the right time
Collaborate with data analysts and data architects, to design and feed proper data models for downstream usage.
Act as a champion for data quality and usability across the organization
Ensure availability, quality, searchability of the data and documentation
Write, clean, and maintain SQL/Python queries/scripts that are easy to understand, simple to troubleshoot and are highly performing with proper test implementation
Automate the testing of our data models and monitor their quality
Provide technical leadership on data solutions that are forward looking
Work with the team to continuously improve our data pipeline
Adopt software engineering best practices, such as version control and design patterns and teach others to adopt these best practices;
Help to define and improve our internal standards for style, maintainability, and best practices for a high-scale data infrastructure
Share your knowledge and mentor more junior engineers

What you’ll be bringing to the team:

Proficient skills with SQL;
Good knowledge of Python in a data analysis context;
Ability to break down complex projects into smaller stories to help other team members & themselves deliver
Experience with MPP data warehouse (we use BigQuery)
Experience in performing data profiling, data mapping, and data quality validation.
Experience with data orchestrator (we use cloud composer)
A good understanding of industry-standard design patterns for data warehouse data models
Experience with cloud environments (in particular GCP) as well as containerization solutions as a user
Experience with source control using Git or equivalent, CI/CD pipelining, and writing automated unit and functional tests
A security mindset - should be able to understand compliances (GDPR, SOX, ...)
Excellent communication skills

‌