DataJobs.io
← Back to all jobs

Job Description

First Citizens Bank is seeking a Data Analyst for Enterprise Data Management with a focus on MDM ingestion. In this role, you will collaborate across business, technology, data governance, and source system teams to onboard, analyze, and integrate enterprise data into the organization’s MDM platform to support trusted master data outcomes.

Responsibilities

  • Support onboarding activities for new source systems into enterprise Master Data Management (MDM) 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 and onboarding issues, and assist with remediation planning.
  • Conduct data profiling and analysis to evaluate 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 process improvement implementations.
  • Participate in validation, reconciliation, and testing activities during project delivery and production support.
  • 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 and requirements gathering workshops and 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.
  • 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, and metadata and documentation activities.
  • 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.

Requirements

  • 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.
  • 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.

Technologies

  • SQL
  • MDM
  • Informatica MDM
  • Reltio
  • Semarchy
  • IBM MDM
  • Oracle MDM
  • SAP MDG
  • Informatica IDMC
  • PowerCenter
  • SSIS
  • Denodo
  • ETL
  • Collibra
  • R360
  • Jira
  • SCRUM
  • Agile

Benefits

Competitive, thoughtfully designed and quality benefits program.

Key Competencies

  • 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
  • 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

Location and Experience

  • Phoenix, AZ (onsite)
  • Minimum experience: 3 years

Similar Jobs