Data Analyst, Enterprise Data Management (MDM Ingestion)

First Citizens Bank

Raleigh (NC)

Hybrid

USD 110,000 - 140,000

Full time

4 days ago
Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

First Citizens Bank is seeking a hybrid Data Management professional to onboard and integrate data into our enterprise MDM platform. You will collaborate with business, data governance and technology teams to profile, map, standardize, and govern data across customer, organization and reference domains.

Responsibilities include data discovery, profiling, mapping, quality assessments, and defining governance rules. Strong SQL and experience with MDM tools and Jira/Agile are highly valued.

Qualifications

  • Bachelor's degree and 4 years' experience OR High School Diploma or GED with 8 years' experience in Data Management or related fields.

Responsibilities

  • Partner with business, technology and governance teams to onboard and integrate data into the MDM platform.
  • Perform data profiling, data quality assessments, and validation during projects.
  • Document mappings, rules, and data standards to support trusted master data.

Skills

MDM
SQL
Data Governance
Data Quality
Data Integration
JIRA
SCRUM

Education

Bachelor's Degree in a related field
Eight years of progressive data management experience (or equivalent)

Tools

Informatica MDM
PowerCenter
SSIS
Denodo
Collibra
Reltio/IBM/Oracle MDM

Job description

Overview

This is a hybrid role, with the expectation that time working will regularly take place inside and outside of a company office: NC, AZ

This role is responsible for partnering with business, technology, data governance, and source system teams to support the onboarding, analysis, and integration of enterprise data into the MDM platform

The individual will contribute to ensuring source data is accurately profiled, mapped, standardized, governed, and integrated to support trusted master data across customer, organization, and reference data domains.

The ideal candidate possesses strong analytical skills, foundational data management expertise, and the ability to collaborate effectively across business and technology teams to deliver high-quality data onboarding and integration delivery.

Responsibilities & Qualifications
Support Data Ingestion and Source Onboarding
  • Support onboarding activities for new source systems into enterprise Master Data Management platforms.
  • Analyze source system data structures and business processes to understand integration requirements.
  • Participate in data discovery, profiling, and source assessment activities.
  • Develop and maintain source-to-target mapping documentation and transformation requirements.
  • Support definition and validation of data standardization, matching, survivorship, hierarchy, and integration rules.
  • Identify data quality concerns, onboarding issues, and assist with remediation planning.
Perform Data Analysis and Data Quality Assessments
  • Conduct data profiling and analysis to assess completeness, accuracy, consistency, and conformity of incoming data.
  • Investigate data quality issues and support root cause analysis activities.
  • Assist in defining and monitoring data quality rules, controls, metrics, and KPIs.
  • Analyze ingestion exceptions and support implementation of process improvements.
  • Participate in validation, reconciliation, and testing activities during project delivery and production support.
Partner with Business and Technology Stakeholders
  • Collaborate with business users, Product Owners, Architects, Tech Leads, and Engineering teams to understand data requirements.
  • Document business requirements, functional specifications, and data mapping requirements.
  • Participate in design, requirements gathering workshops, stakeholder discussions.
  • Ensure recommendations align with enterprise data standards and governance policies for MDM Sources.
  • Present findings, analysis results, and recommendations to project teams and stakeholders.
Support Data Governance and Reference Data Management
  • Ensure compliance with enterprise data standards and MDM-related reference data requirements.
  • Work with Data Governance teams and source system owners to support data stewardship and ownership processes.
  • Contribute to maintenance of data definitions, business definitions, onboarding standards , metadata and documentation activities.
Support MDM Operations and Continuous Improvement
  • Identify opportunities to improve source onboarding processes, controls, and data quality outcomes.
  • Support operational activities, release validation, and production issue analysis.
  • Contribute to process improvement initiatives across data onboarding and integration functions.
  • Support knowledge sharing
Qualifications

Minimum Required Education and Experience: Bachelor's Degree and 4 years' experience OR High School Diploma or GED/Equivalent and 8 years' experience in Data Management, Financial Analysis, or similar

Preferred Skills
  • 7+ years of experience in Data Management, Data Governance, Data Quality, Data Integration, Business Analysis, or Master Data Management.
  • 3+ years of experience supporting enterprise MDM initiatives.
  • Experience working with source system onboarding and data integration projects.
  • Experience gathering, documenting, and validating business and functional requirements.
  • Strong SQL skills for data analysis, profiling, reconciliation, and validation.
  • Experience with source-to-target mapping and business rule documentation.
  • Strong analytical and problem-solving skills.
  • Ability to work effectively with cross-functional stakeholders.
  • Experience working in Agile delivery environments and using Jira.
  • Banking or financial services industry experience.
  • Experience with Informatica MDM or other MDM platforms such as Reltio, Semarchy, IBM MDM, Oracle MDM, or SAP MDG.
  • Experience with Customer, Party, Organization, Product, or Reference Data domains.
  • Familiarity with integration technologies such as Informatica IDMC, PowerCenter, SSIS, Denodo, or equivalent ETL platforms.
  • Knowledge of Data Governance, Metadata Management, Data Lineage, and tools such as Collibra or R360.
  • Familiarity with KYC, Customer Lifecycle Management, and Enterprise Customer Data initiatives.
  • Experience supporting Data Quality monitoring and remediation initiatives.
Key Competencies
Data Management
  • Master Data Management (MDM) , SQL
  • Data Quality: Data Profiling, Data Analysis, Data Quality Monitoring
  • Data Governance: Metadata Management, Reference Data Management
  • Source-to-Target Mapping, Data Integration, Data Validation and Reconciliation
  • JIRA, SCRUM
Other Competencies
  • Requirements Gathering and Documentation
  • Root Cause Analysis, Process Improvement
  • Stakeholder Collaboration
  • Communication and Presentation Skills
  • Critical Thinking and Problem Solving
  • Working Effectively in Cross-Functional Teams
Additional Information

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.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Data Analyst, Enterprise Data Management (MDM Ingestion)
Data Analyst, Enterprise Data Management (MDM Ingestion)

First Citizens Bank • Phoenix (AZ), Raleigh (NC)

Hybrid
USD 90,000 - 140,000
Data Analyst, Enterprise Data Management (MDM Ingestion)
Data Analyst, Enterprise Data Management (MDM Ingestion)

First Citizens Bank • Phoenix (AZ)

On-site
USD 110,000 - 140,000
MDM Ingestion & Data Quality Analyst
MDM Ingestion & Data Quality Analyst

First Citizens Bank • Phoenix (AZ)

On-site
USD 110,000 - 140,000
Senior Enterprise Data Analyst- (Charlotte, NC, Raleigh, NC or Phoenix, AZ)
Senior Enterprise Data Analyst- (Charlotte, NC, Raleigh, NC or Phoenix, AZ)

First Citizens Bank • Raleigh (NC)

Remote
USD 110,000 - 150,000
MDM Data Ingestion Analyst — Enterprise Data
MDM Data Ingestion Analyst — Enterprise Data

First Citizens Bank • Phoenix (AZ), Raleigh (NC)

Hybrid
USD 90,000 - 140,000
Informatica PowerCentre and MDM Developer
Informatica PowerCentre and MDM Developer

Compunnel Inc. • Austin (TX)

On-site
USD 110,000 - 170,000
Senior Informatica MDM & PowerCenter Lead
Senior Informatica MDM & PowerCenter Lead

Compunnel Inc. • Austin (TX)

Hybrid
USD 110,000 - 170,000
Senior MDM Techno-Functional Consultant – Commercial Banking
Senior MDM Techno-Functional Consultant – Commercial Banking

Compunnel Inc. • Johnston (RI)

On-site
USD 90,000 - 120,000
Senior Enterprise Data Analyst- (Charlotte, NC, Raleigh, NC or Phoenix, AZ)
Senior Enterprise Data Analyst- (Charlotte, NC, Raleigh, NC or Phoenix, AZ)

First Citizens Bank • Raleigh (NC)

On-site
USD 110,000 - 150,000
Benefits package
Sr. Advisor, Data Engineer MDM
Sr. Advisor, Data Engineer MDM

OP RaaS • Tennessee

Hybrid
USD 140,000 - 190,000