Enterprise Data Consultant

First Citizens Bank • Raleigh, NC

4d • $140,000 - $150,000 • Remote

About The Position

This is a remote role that may be hired in several markets across the United States.
This position is within the Data Management group that is responsible for enterprise governed data delivery. This individual will play a subject matter expert role for data delivery across multiple data domains per the business units data needs.

Requirements

• Bachelor's Degree and 6 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
• 5+ years of experience in banking and financial services
• Expert proficiency in working with SQL
• Deep understanding of Data warehousing and transformation methods, ETL processes and tools such as Informatica
• Knowledge various Databases such as Oracle, SQL Server, Netezza, Snowflake
• Proven experience in Data Analysis, Data Quality, Data Governance, Metadata management, Data Lineage documentation Data Profiling, Data mapping and Data validation
• Relevant experience in BI reporting tools such as Tableau and Business objects
• Excellent written and verbal communication
• Self-starter with high attention to details, excellent interpersonal skills, and ability to take charge and deliver results.
• Knowledge of Regulatory reporting such as LFI, Call reports etc

Nice To Haves

• Preferred Education: Bachelor’s degree in Engineering, Information Technology Management or related field
• Preferred Experience: 8+ years of experience in Data Management, Data Analytics, and Data Governance
• Preferred skill(s): Understanding of Data warehousing and transformation methods, lineage documentation, ETL processes, Knowledge of data spreadsheets and databases, Data Analysis, Data Quality, Data Governance, Metadata management, Data Profiling, Data mapping, Data validation, Business Analytics, BI reporting

Responsibilities

• Collaborate with large cross-functional teams, SMEs, vendors, etc. to deliver governed data.
• Act as a data SME and partner with diverse group of business functions to define requirements, analysis, mapping, validation and resolve any data issues.
• Perform detailed data analysis to translate business requirements into source to target data mappings for CDEs (Critical Data elements)
• Create and maintain all relevant documentation for Enterprise data warehouse which includes source-to-target mappings, data dictionaries, and other related materials.
• Communicate and guide technology teams through data mapping documents in implementing the solutions.
• Proactively identify areas of improvement in current data infrastructure and work with key stakeholders to fix them.
• Validate functional workflow, business rules, and formulae through data profiling using SQL (Structured Query Language) queries.
• Work closely with business stakeholders to share insights and data issues.
• Perform ad-hoc analytics using advanced SQL to extract business value and answer questions from stakeholders.
• Drive and enforce data governance framework to ensure high quality strategic data solutions.
• Develop and execute procedures and processes to certify data quality for business purposes.
• Ensure data consistency, accuracy, timeliness, validity, and completeness.
• Provide updates and raise issues to management in timely manner.
• Represent data management group in various forums such as Internal / external audits, status updates, and respond to queries in an effective and timely manner

Benefits

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

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Number of Employees: 5,001-10,000 employees