TEDRA Data Lineage Developer
Apply NowCompany: Compunnel Software Group
Location: Montreal, QC H1A 0A1
Description:
Job Summary
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
Required Qualifications
Preferred Qualifications
Certifications
Education: Bachelors Degree
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.
Education: Bachelors Degree