Lightspeed is growing at a fast pace and we’re looking for a passionate data engineer to join our Data Engineering practice within our Data Foundations team. The primary function for this position will be to establish and maintain insights for our corporate partners.
You are inspired by generating value by leveraging data within the organization. As a leading member of this team, you will be responsible for developing analytics and insights that will change how Lightspeed and our customers do business.
The Role:
As a Senior Data Engineer, you will be instrumental in shaping Lightspeed’s data infrastructure, building scalable data pipelines, robust data models, and efficient transformations that empower analytics across the organization. You will work closely with analytics engineers, data scientists, and software developers to design, develop, and optimize well-structured, maintainable, and performant datasets that fuel decision-making.
What you'll do:
- Design and implement clean, scalable, and performant data models using Dataform and DBT.
- Own the curation and transformation layer, ensuring best practices for SQL-based transformations and maintaining data integrity.
- Optimize SQL queries and models for efficient warehouse performance.
- Develop, orchestrate, and monitor data pipelines using Apache Airflow.
- Automate ETL/ELT processes for efficient, repeatable, and scalable data ingestion and transformation.
- Collaborate with stakeholders to map business requirements into reliable data models.
- Implement data validation, anomaly detection, and automated testing for data reliability.
- Maintain documentation and ensure datasets adhere to governance, compliance, and security standards.
- Work with analysts and data scientists to make sure models serve business needs.
- Build and maintain high-performance, cloud-native data solutions using GCP.
- Leverage best practices in CI/CD, infrastructure-as-code, and data security.
What you’ll be bringing to the team:
- Proficient with SQL for data modeling, transformation, and performance tuning
- Experience with SQL-based transformation tools for modular and version-controlled data modeling (we use Dataform and DBT).
- Expertise with orchestration tools for building and scheduling data workflows (we use Airflow).
- Hands-on experience with cloud data platforms (we use GCP).
- Solid understanding of ETL/ELT principles and batch vs. streaming architectures.
- Proficiency in Python for automation and data pipeline development.
- Familiarity with software engineering best practices, including version control, CI/CD, and testing for data workflows.
- Strong understanding of data governance, security, and compliance (GDPR, SOX, etc.).
- Excellent problem-solving and communication skills to collaborate with engineers, analysts, and business teams.
Bonus Skills (Nice to Have):
- Experience with MongoDB is highly desirable.
- Experience with BI tools for data visualization (we use Looker).
- Familiarity with Terraform or other infrastructure-as-code tools.
- Exposure to real-time data processing frameworks (Kafka, Pub/Sub, etc.)
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
- Volunteer day.
- Fully stacked kitchen (hot and cold beverages, meals served)
- Happy hours to build your relationships with colleagues after work
To all recruitment agencies: Lightspeed does not accept unsolicited agency resumes. If we have not directly engaged your company in writing to supply candidates for a specific vacancy, Lightspeed will not be responsible for any fees related to unsolicited resumes.
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.
Where to from here?
Obviously, this has to be mutually beneficial: we want you to step into a role you love, and we want to offer you a place you’re proud to come to every day. For a glimpse into our world check out our career page here.
Lightspeed is building communities through commerce, and we need people from all backgrounds and lived experiences to do that. We were founded in 2005, in Montreal’s gay village and our original members were all part of the LGBTQ+ community. The ethos of our business has been about inclusion from the very beginning, and we strive to provide a workplace where everyone belongs.
Who we are:
Powering the businesses that are the backbone of the global economy, Lightspeed's one-stop commerce platform helps merchants innovate to simplify, scale, and provide exceptional customer experiences. Our cloud commerce solution transforms and unifies online and physical operations, multichannel sales, expansion to new locations, global payments, financial solutions, and connection to supplier networks.
Founded in Montréal, Canada in 2005, Lightspeed is dual-listed on the New York Stock Exchange (NYSE: LSPD) and Toronto Stock Exchange (TSX: LSPD). With teams across North America, Europe, and Asia Pacific, the company serves retail, hospitality, and golf businesses in over 100 countries.
Lightspeed handles your information in accordance with our Applicant Privacy Statement.
