Data Engineer II – Remote, Equity & Growth

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

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.