Analytics Engineer

Summary

Join Lightspeed's Central Data Team as an Analytics Engineer to build data pipelines and models providing insights to corporate stakeholders. You will cleanse and transform raw data, collaborate with data analysts and architects on data models, champion data quality, and ensure data searchability. Responsibilities include writing and maintaining SQL/Python queries, automating data model testing, providing technical leadership, and improving data pipelines. You will also adopt and teach software engineering best practices and help define internal standards. The ideal candidate possesses strong SQL skills, experience with BigQuery, data profiling, and cloud environments. A security mindset and excellent communication skills are essential.

Requirements

• Great SQL skills
• Experience with MPP data warehouse (we use BigQuery)
• Experience in performing data profiling, data mapping, and data quality validation
• 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, ...)
• Good communication skills

Responsibilities

• 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, and 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

Preferred Qualifications

Knowledge of Python would be a plus

Benefits

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