Enterprise Data Consultant - Senior Collibra Lineage Developer

First Citizens Bank; Town of Texas, Houston (WI, TX); Remote; USD 120,000 - 180,000; Full time

Job summary

A leading financial institution is seeking an Enterprise Data Consultant (Senior Collibra Lineage Developer) to design and implement data lineage solutions. This remote role involves collaborating with teams to optimize data flows and enhance traceability across systems. Candidates should have strong programming skills in Java and Python, experience with data management, and a solid understanding of data governance. The position offers competitive pay and benefits.

Qualifications

• 4 years in Data Management or 8 years with a GED.
• Min 5 years developing in Java and Spring Framework.

Responsibilities

• Implement automated lineage scanners and create interactive lineage diagrams.
• Analyze data sources and define lineage scanner scope.
• Troubleshoot complex lineage processing pipelines.

Skills

Java

Spring Framework

Python

SQL

Agile Development

Data Management

Financial Analysis

Education

Bachelor's Degree

High School Diploma or GED

Tools

Elasticsearch

DataStage

Informatica

SSIS

DBT

Tableau

Power BI

MySQL

PostgreSQL

Oracle

Job description

Overview

This is a remote role that may be hired in several markets across the United States.

The Enterprise Data Consultant (Senior Collibra Lineage Developer) is responsible for designing and implementing data lineage solutions to ensure the traceability of data throughout its lifecycle. This role involves collaborating with data architects, data analysts, and other stakeholders to develop an understanding of data flows, transformations, and dependencies across various data systems.

Responsibilities

• You will be a member of a team whose purpose is to implement automated Lineage scanners and present the result via interactive Lineage diagrams.
• Your role will specifically aim to obtain lineage from BI & ETL tools.
• Your work will have a massive impact as we replace manual Lineage by an automated reverse engineering process.
• Analyzing data sources and working with Product team to define lineage scanner scope.
• Implementing algorithms and complex logic to extract lineage from sources like API outputs, XML files and others.
• Optimizing performance and participating in architectural design
• Troubleshooting complex lineage processing pipelines
• Cooperation with internal and external stakeholders and teams to create a well-integrated and customer-friendly product.
• Responsibilities include coding in Python, optimizing performance, and troubleshooting lineage processing workflows.

Qualifications

Bachelor's Degree and 4 years of experience in Data Management, Financial Analysis, or similar.

OR

High School Diploma or GED and 8 years of experience in Data Management, Financial Analysis, or similar.

Additional Qualifications:

• Min 5 years of experience developing in Java and Spring Framework.
• Strong experience with relational databases
• Experience in microservices architecture and hands-on with continuous integration and continuous deployment (CI/CD) pipelines.
• Strong familiarity with agile development methodologies and a proven command of code versioning tools, including Git.
• Familiarity with search technologies, particularly Elasticsearch is a bonus.
• Experience in Python and great motivation to have it as your primary programming language.
• Proficiency in data modeling tools and ETL platforms (E.g., DataStage, Informatica, SSIS, DBT etc.)

• Knowledge of the leading PaaS providers, Data Lakes, Databases, and Integration platforms (SQL, Databricks, GCP, Snowflake etc.)

• Experience with data visualization tools (e.g., Tableau, Power BI) to illustrate data lineage.
• Strong knowledge of SQL and database management systems (e.g., MySQL, PostgreSQL, Oracle).
• An agile mindset and like to work in scrum/kanban environments.
• Excellent analytical and problem-solving skills to identify data discrepancies.
• Strong communication skills to collaborate with cross-functional teams and stakeholders.
• Ability to work independently and manage multiple projects simultaneously.
• Leadership qualities to mentor junior team members and drive data lineage initiatives.
• Understanding of data governance and compliance regulations (e.g., GDPR, HIPAA).

This job posting is expected to remain active for 45 days from the initial posting date listed above. If it is necessary to extend this deadline, the posting will remain active as appropriate. Job postings may come down early due to business need or a high volume of applicants.

The base pay for this position is generally between $120,000 and $180,000. Actual starting base pay will be determined based on skills, experience, location, and other non-discriminatory factors permitted by law. For some roles, total compensation may also include variable incentives, bonuses, benefits, and/or other awards as outlined in the offer of employment.

Benefits are an integral part of total rewards and First Citizens Bank is committed to providing a competitive, thoughtfully designed and quality benefits program to meet the needs of our associates. More information can be found at https://jobs.firstcitizens.com/benefits.