Enterprise Data Consultant

First Citizens Bank; Los Angeles (CA); Remote; USD 140,000 - 150,000; Full time

Job summary

A leading financial institution is seeking a Data Management expert to oversee enterprise data delivery. This remote role involves collaborating with cross-functional teams, ensuring data quality, and providing insights through advanced analytics. The ideal candidate will possess extensive experience in data governance, SQL proficiency, and a strong background in financial services. Join us to drive strategic data solutions and enhance our data infrastructure.

Benefits

Competitive benefits program

Qualifications

• 6 years in Data Management or 8 years with GED.
• 5+ years in banking and financial services.
• Expert proficiency in SQL.

Responsibilities

• Collaborate with teams to deliver governed data.
• Perform detailed data analysis and mapping.
• Drive data governance framework for quality solutions.

Skills

SQL

Data Governance

Data Analysis

Communication

Education

Bachelor's Degree

High School Diploma or GED

Tools

Informatica

Tableau

SQL Server

Oracle

Snowflake

Job description

Overview

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.

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

Qualifications

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

The base pay for this position is generally between $140,000 and $150,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.