Data Engineer II

Lightspeed; Montreal; Hybrid; CAD 80,000 - 110,000; Full time

Job summary

A growing technology company in Montreal is looking for a Data Engineer to shape its data infrastructure. The role involves building scalable data pipelines, optimizing data models, and collaborating with cross-functional teams to improve analytics. Ideal candidates will have a strong background in SQL and experience with cloud platforms such as GCP. The position offers an inclusive work environment and various growth opportunities.

Benefits

Equity for all employees

Flexible paid time off

Health insurance

Pension plan contributions

Annual health/wellness benefit

Paid parental leave

Mental health support services

Training and development opportunities

Volunteer days

Fully stocked kitchen

Social events to enhance relationships

Qualifications

• Proven experience with SQL for data modeling and transformation.
• Hands-on practice with transformation tools like Dataform and DBT.
• Ability to develop and orchestrate data pipelines using Apache Airflow.

Responsibilities

• Design and implement scalable data models for analytics.
• Automate ETL/ELT processes for efficient data ingestion.
• Collaborate with teams to ensure models meet business needs.

Skills

SQL proficiency

Data modeling

Data transformation

Experience with Airflow

Python skills

Data governance understanding

Problem-solving skills

Tools

Dataform

DBT

Google Cloud Platform (GCP)

Job description

The Role:

As a 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 working with AI/ML models or frameworks (e.g., scikit-learn, TensorFlow, PyTorch) for data-driven applications.
• Familiarity with vector search and embedding-based retrieval for semantic search or recommendation use cases.
• 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-stopcommerce platform helps merchants innovate to simplify, scale, and provide exceptional customer experiences. Our cloudcommerce 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.