TEDRA Data Lineage Developer

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

Job summary

An established industry player is on the lookout for a skilled Data Lineage Developer to enhance data transparency and quality. This pivotal role involves analyzing complex data flows, implementing metadata cataloging solutions, and ensuring compliance with data governance standards. The ideal candidate will thrive in a collaborative environment, utilizing their expertise in data engineering and programming to support decision-making processes. Join a dynamic team where your contributions will shape the future of data management and governance, making a real impact on the organization’s success.

Qualifications

• 4+ years of hands-on development experience in data lineage.
• Strong understanding of data architecture and governance.
• Proficient in SQL and programming for automation.

Responsibilities

• Analyze business processes to document data flows across systems.
• Define and map end-to-end data lineage and transformations.
• Collaborate with governance teams to integrate metadata.

Skills

Data Engineering

Data Governance

Metadata Cataloging

SQL

Python

Java

ETL Processes

Problem-Solving

Communication Skills

Education

Bachelor's Degree in Computer Science or related field

Tools

Collibra

MongoDB

Snowflake

SQL Server

DB2

Sybase

Job description

We are seeking a skilled Data Lineage Developer to join our TEDRA team, responsible for the collection, cataloging, and traceability of metadata and data lineage across diverse data platforms. This role will be pivotal in ensuring data transparency, improving data quality, supporting regulatory compliance, and enabling trusted decision-making. The ideal candidate will bring a strong background in data architecture, governance, and metadata tools, and work collaboratively with global business and technology stakeholders.

Key Responsibilities

• Analyze complex business processes to understand and document current data flows across multiple systems and stakeholders.
• Define and map end-to-end data lineage, identifying data sources, transformations, dependencies, and destinations.
• Implement metadata cataloging solutions for systems including MongoDB, Snowflake, and relational databases (e.g., SQL Server, DB2).
• Collaborate with firmwide data governance teams to integrate lineage metadata with Collibra for compliance and audit readiness.
• Design processes to monitor data quality and ensure data lineage accurately reflects all transformations and business logic.
• Build and maintain automation scripts and tools to support scheduled lineage capture and catalog maintenance.
• Create and maintain clear documentation to communicate lineage structures and metadata to both technical and non-technical audiences.
• Troubleshoot and resolve issues related to data inconsistencies, transformation errors, or discrepancies in lineage records.
• Author and maintain technical specifications, process documentation, and metadata standards.

Required Qualifications

• Minimum of 4 years of hands-on development experience.
• Solid understanding of data engineering, data governance, and metadata cataloging with a focus on data lineage.
• Expertise in data modeling, SQL, and developing stored procedures/triggers.
• Strong programming experience in Python, Java, or similar languages for automation and integration.
• Familiarity with ETL processes, data pipelines, and transformation logic.
• Hands-on experience with relational databases like Sybase, DB2, and SQL Server.
• Proficient in object-oriented programming, data structures, and algorithms.
• Strong problem-solving and analytical skills to address complex data flow challenges.
• Excellent communication skills, able to translate technical findings for business stakeholders.
• Proven ability to work in dynamic, fast-paced, and collaborative environments.

Preferred Qualifications

• Experience working with Collibra or similar metadata management platforms.
• Familiarity with metadata extraction techniques from MongoDB, Snowflake, and other non-relational systems.
• Understanding of data privacy regulations such as GDPR or CCPA and their implications for data governance.
• Experience working in Agile/Scrum team environments.

Certifications

• No certifications required, but relevant data governance or cloud certifications are a plus.