Lead Consultant - Data Lineage Developer

Genpact; Montreal; On-site; CAD 70,000 - 110,000; Full time

Job summary

An innovative firm is looking for a Lead Consultant specializing in Data Lineage Development. This role involves analyzing business processes, building data lineage frameworks, and ensuring data quality across various systems. You'll collaborate with stakeholders to define data flows and implement solutions for metadata cataloging. If you have a passion for data engineering and governance, and thrive in a dynamic environment, this position offers the opportunity to make a significant impact in a forward-thinking organization.

Qualifications

• Experience in data engineering and governance with a focus on data lineage.
• Strong expertise in SQL, data modeling, and ETL pipelines.

Responsibilities

• Build and implement data lineage frameworks across multiple systems.
• Collaborate with stakeholders to define and map data flow.

Skills

Data Engineering

Data Governance

Data Lineage

SQL

Python

Java

Data Modeling

ETL Pipelines

Analytical Skills

Education

Bachelor of Engineering

Master of Computer Applications

Tools

Collibra

MongoDB

Snowflake

SQL Server

DB2

Job description

Job Description - Lead Consultant - Data Lineage Developer (ITO090873)

Lead Consultant - Data Lineage Developer - ITO090873

Genpact (NYSE: G) is a global professional services and solutions firm delivering outcomes that shape the future. Our 125,000+ people across 30+ countries are driven by our innate curiosity, entrepreneurial agility, and desire to create lasting value for clients. Powered by our purpose – the relentless pursuit of a world that works better for people – we serve and transform leading enterprises, including the Fortune Global 500, with our deep business and industry knowledge, digital operations services, and expertise in data, technology, and AI.

Inviting applications for the role of Principal Consultant, Data Lineage Developer
In this role, you will be responsible for coding, testing, and delivering high quality deliverables, and should be willing to learn new technologies.

Responsibilities
• Analysis of business processes to understand current setup, navigating through multiple systems, products and coordinate with multiple stakeholders.
• Build and implement data lineage frameworks that track the flow of data across multiple systems, databases, and pipelines.
• Work with stakeholders to define and map the end-to-end flow of data, identifying sources, transformations, destinations, and dependencies.
• Implement solutions to catalog metadata from diverse data sources, including MongoDB, Snowflake, and relational databases (e.g., SQL Server, DB2).
• Collaborate with firmwide data governance teams to ensure that lineage metadata is integrated with Collibra for auditing and compliance purposes.
• Develop processes to monitor data quality and ensure that data lineage tracks and reflects accurate data transformations and business rules.
• Design and implement automation tools and scripts to capture and maintain data lineage information and catalog updates on a scheduled basis.
• Create clear, understandable, and accurate documentation of data lineage for business users and technical teams.
• Identify and resolve issues related to data inconsistencies, lineage discrepancies, or errors in data transformation processes.
• Document technical requirements, specifications, and solutions.

Qualifications we seek in you!
Minimum Qualifications
• BE/B Tech/MCA
• Excellent written and verbal communication skills

Preferred Qualifications/ Skills
• Experience/exposure in data engineering, data governance, or related fields, with a focus on data lineage and metadata cataloging.
• Strong expertise in data modeling, SQL, Stored Procedures/triggers, etc.
• Should possess good knowledge of OO, data structures and algorithms.
• Experience with data modeling, ETL pipelines, and data transformation.
• Experience with SQL and relational databases (e.g., Sybase, DB2, SQL Server).
• Proficiency in Python, Java, or other scripting languages for data integration and automation tasks.
• Strong analytical and troubleshooting skills with the ability to solve complex data flow problems.
• Excellent written and verbal communication skills, with the ability to explain technical concepts to non-technical stakeholders.
• Ability to work in a fast-paced, collaborative environment with cross-functional teams.
• Experience with Collibra
• Knowledge of metadata management practices, including the ability to extract and catalog metadata from complex data sources such as MongoDB, Snowflake, and relational databases.
• Understanding of data privacy regulations (e.g., GDPR, CCPA) and their impact on data lineage and governance.
• Experience of working in Agile teams.
• Reference Data experience.

Genpact is an Equal Opportunity Employer and considers applicants for all positions without regard to race, color, religion or belief, sex, age, national origin, citizenship status, marital status, military/veteran status, genetic information, sexual orientation, gender identity, physical or mental disability or any other characteristic protected by applicable laws. Genpact is committed to creating a dynamic work environment that values respect and integrity, customer focus, and innovation. For more information, visit www.genpact.com.Follow us on Twitter, Facebook, LinkedIn, and YouTube.

Furthermore, please do note that Genpact does not charge fees to process job applications and applicants are not required to pay to participate in our hiring process in any other way. Examples of such scams include purchasing a 'starter kit,' paying to apply, or purchasing equipment or training.