Senior Data Engineer - ETL & Integrations

Lasso Informatics

Montreal (administrative region)

On-site

CAD 110,000 - 150,000

Full time

14 days+

Get more replies from employers

Send a job-specific resume in minutes.

Benefits offered by this job

In-office presence Tue–Thu

Competitive salary & benefits

Leadership opportunities

Professional development

Job summary

Lasso Informatics is seeking a Senior Data Engineer – ETL & Integrations to design, build and operate production-grade data pipelines across ingestion, transformation and loading. You will model workflows with BPMN and implement integration services in Java and Python.

The role focuses on data quality, reliability, and performance in a fast-paced SaaS research platform, with collaboration across engineering, product, and external partners. Strong scripting and backend skills are essential.

Qualifications

5+ years in data engineering, ETL, or systems integration.
Production ETL pipelines experience.
Python and/or Java in backend/data processing.
Strong PostgreSQL/SQL, including tuning.
Data transformation/loading techniques (ETL/ELT, CDC).
REST APIs and API gateways integration experience.
BPMN-based workflow engines familiarity.
Experience operating distributed production systems.
Strong debugging and operational mindset.
Familiarity with layered architectures and event-driven patterns.

Responsibilities

Design, build, and operate end-to-end ETL pipelines and data integrations.
Develop BPMN-based workflows to model complex processes.
Build integration/transform logic in Python and Java.
Integrate systems via REST APIs and gateways; asynchronous messaging.
Apply batch and near-real-time loading strategies.
Design/optimize PostgreSQL schemas, queries, and indexes.
Handle structured and semi-structured data formats (JSON, CSV, XML, Parquet, Avro).
Ensure data quality, deduplication, and idempotency.
Monitor and optimize production ETL pipelines and services.
Collaborate on data models and integration contracts; document processes.

Skills

Senior-level

ETL pipelines

Python

Java

PostgreSQL/SQL

Data integration

REST APIs

BPMN/workflow engines

Distributed systems

Troubleshooting

Tools

Docker

Kubernetes

Camunda

Zeebe

Flowable

Job description

Senior Data Engineer – ETL & Integrations

About Lasso Informatics

Lasso Informatics is a SaaS start-up with a live research data management and analysis platform that brings together multi-modal (imaging, genetics, behavioral, and biosample) data for large-scale studies. Thousands of researchers across the globe rely on our platform today, and we are rapidly iterating and improving to push the boundaries of what is possible in research data management.

We live to innovate, and empower scientists to focus on the science, not the technology, leading to a faster time to science and cure.

Our team is incredibly diverse both by background and expertise, and that is not by accident. We believe that the most creative and powerful solutions come from different ways of thinking about the world. You will be working in an inspiring ecosystem alongside world-renowned professionals in medicine, physics, engineering, imaging, epidemiology, software development, and genetics. We thrive on empowering our colleagues to be thought leaders and innovate fresh new solutions for an exciting and rapidly changing field.

About The Role

This is a senior-level data engineering and systems integration role focused on building and operating production-grade ETL pipelines and integrations. You will work across data ingestion, transformation, and loading while leveraging a BPMN-based workflow engine to model and manage process flows where appropriate. The role sits at the intersection of data engineering, backend development, and workflow-driven systems, with a clear distinction between ETL responsibilities and workflow orchestration capabilities.

Key Responsibilities

Design, build, and operate end-to-end ETL pipelines and data integrations
Develop BPMN-based workflows to model and manage complex process flows
Build integration services and transformation logic in Java and Python
Integrate internal and external systems using REST APIs, API gateways, and asynchronous messaging
Apply appropriate data transformation and loading strategies (batch and near-real-time)
Design and optimize PostgreSQL schemas, queries, indexes, and bulk loading mechanisms
Work with structured and semi-structured data formats (JSON, CSV, XML, Parquet, Avro)
Ensure data quality, consistency, and reliability through validation, deduplication, and idempotency
Monitor, troubleshoot, and optimize production ETL pipelines and integration services
Collaborate with engineering, product, and external partners on integration contracts and data models
Document ETL pipelines, workflows, schemas, and operational procedures

Required Skills & Experience

5+ years of experience in data engineering, ETL, or systems integration roles
Strong experience building and operating production ETL pipelines
Proficiency in Python and/or Java in backend or data-processing environments
Strong PostgreSQL and SQL experience, including performance tuning
Hands-on experience with data transformation and loading techniques (ETL vs ELT, incremental loads, CDC concepts)
Experience integrating systems via REST APIs and API gateways
Experience working with BPMN-based workflow engines or workflow modeling tools
Experience operating distributed systems in production environments
Strong troubleshooting, debugging, and operational mindset
Familiarity with common architectural patterns (layered architectures, event-driven systems, integration patterns)

Nice-to-Haves

Experience with specific BPMN workflow engines such as Camunda, Zeebe, or Flowable
Experience with event-driven architectures or message queues
Cloud platforms experience (AWS, GCP, or Azure)
Docker and Kubernetes experience
CI/CD pipelines for data or backend systems
Experience working in regulated or compliance-driven environments

What Lasso Offers