Data Lineage Developer

Compunnel, Inc.; Montreal; On-site; CAD 70,000 - 110,000; Full time

Job summary

Join a forward-thinking company as a Data Lineage Developer, where you will play a pivotal role in enhancing data governance and engineering initiatives. In this dynamic position, you will analyze business processes, design and implement data lineage frameworks, and ensure proper documentation of metadata from diverse systems. Collaborating with cross-functional teams, you'll automate data lineage capture and integrate with leading governance platforms. This is an exciting opportunity to leverage your skills in SQL, Python, and data engineering to make a significant impact in a fast-paced environment.

Qualifications

• 3+ years of experience in data engineering or governance.
• Strong SQL skills and experience with data modeling and ETL pipelines.

Responsibilities

• Analyze business processes and implement data lineage frameworks.
• Collaborate with data governance teams to ensure accurate metadata integration.

Skills

SQL

Python

Java

Data Engineering

Data Governance

Metadata Cataloging

Problem-Solving

Communication Skills

Education

Bachelor's Degree in Computer Science or related field

Tools

Collibra

MongoDB

Snowflake

SQL Server

DB2

Job description

We are seeking a skilled Data Lineage Developer to join our data governance and engineering team. This role will focus on analyzing business processes, designing and implementing data lineage frameworks, and cataloging metadata from diverse systems. You will collaborate closely with cross-functional stakeholders and ensure that data flow and metadata are properly documented, automated, and integrated with enterprise governance platforms like Collibra.

Job Responsibilities:

• Analyze current business processes and navigate multiple systems and data products
• Build and implement data lineage frameworks to track data flow across systems, databases, and pipelines
• Define and map end-to-end data flows, transformations, destinations, and dependencies
• Implement solutions to catalog metadata from MongoDB, Snowflake, and relational databases (SQL Server, DB2, etc.)
• Collaborate with firmwide data governance teams to integrate lineage metadata with Collibra
• Monitor data quality and ensure accurate reflection of data transformations and business rules
• Automate the capture and maintenance of data lineage and metadata catalog updates
• Document data lineage in a clear, user-friendly manner for business and technical audiences
• Troubleshoot and resolve issues in data flow, transformations, or lineage discrepancies
• Document technical requirements, architecture specifications, and solutions

Required Skills:

• Minimum 3 years of development experience
• Hands-on experience in data engineering, data governance, or metadata cataloging
• Strong SQL skills including stored procedures and triggers
• Sound knowledge of object-oriented programming, data structures, and algorithms
• Experience with data modeling, ETL pipelines, and data transformation workflows
• Proficiency in scripting/programming languages like Python, Java
• Solid understanding of relational databases: Sybase, DB2, SQL Server
• Excellent problem-solving skills and analytical mindset
• Strong verbal and written communication skills
• Ability to work effectively in cross-functional, fast-paced teams

Preferred Skills:

• Experience working with Collibra
• Familiarity with metadata extraction from MongoDB, Snowflake, and relational databases
• Understanding of data privacy regulations such as GDPR, CCPA
• Experience in Agile environments
• Background in reference data management

Certifications:

[Specify if any certifications are required or preferred, e.g., Collibra Ranger, Data Management certifications, etc.]