Enterprise Data Analyst II

First Citizens Bank; Charlotte (NC); On-site; USD 110,000 - 140,000; Full time

Job summary

First Citizens Bank is seeking a senior data governance professional to oversee enterprise data governance and architecture. The role focuses on improving data quality, supporting analytics, and driving governance initiatives across the bank.

Responsibilities include enforcing data policies, maintaining data documentation, and delivering dashboards to modernize analytics. Collaboration with IT, stakeholders, and analytics teams is essential, with a strong emphasis on scalable data management.

Qualifications

• Understanding of data warehousing and transformation methods, lineage documentation, and ETL processes.
• Knowledge of data spreadsheets and databases.
• Understanding of Base SAS programming, SAS Enterprise Guide, Cognos, or related programs.
• IBM InfoSphere Information Management suite or similar.

Responsibilities

• Data Enhancement - Identifies and implements enhancements for the quality, management, and storage of enterprise data. Builds dashboards to modernize analytics where appropriate.
• Business Support - Enforces data policies and procedures across the enterprise and validates reporting data.
• Business Tactics - Facilitates initiatives that develop the Bank’s data management capabilities and aligns with strategic objectives.
• Documentation - Creates and maintains technical documentation for the Enterprise Data Warehouse, including source-to-target mappings and data dictionaries.

Skills

Data governance

Data quality

SQL

Data warehousing

ETL

SAS

Cognos

IBM InfoSphere

Education

Bachelor's Degree + 4 years in Data Management/Finance

High School Diploma or GED + 8 years in Data Management/Finance

Tools

SAS Enterprise Guide

Cognos

IBM InfoSphere Information Management

Tableau

Power BI

Job description

Overview

This role is part of the Enterprise Data organization and is primarily focused on the overarching governance and architecture of all data across the enterprise.

This position supports initiatives within the Bank that improve enterprise data quality, governance, and analytics. Drives positive change across the Bank through technical innovation and continuous improvement initiatives. Creates and maintains technical documentation related to enterprise data. Provides expert consultation to team members, the Information Technology department, and other stakeholders on tactics that achieve data management goals.

Responsibilities & Qualifications

Duties & Responsibilities:

• Data Enhancement - Identifies and implements enhancements for the quality, management, and storage of enterprise data. Executes initiatives that improve profiling, exception reporting, and issue resolution as well as general fixes for the Enterprise Data Warehouse. Builds dashboards to modernize analytics where appropriate.
• Business Support - Enforces data policies and procedures across the enterprise. Encourages discussion and feedback from associates in order to identify areas of improvement within data management capabilities. Completes month-end validations on reporting data to ensure the quality and completeness of data prior to business use.
• Business Tactics - Facilitates initiatives that develop the Bank’s data management capabilities. Assists management in creating and implementing business plans to achieve planned objectives. Maintains a strong knowledge of current and emerging technologies or trends impacting the financial service industry.
• Documentation - Creates and maintains technical documentation for the Enterprise Data Warehouse, which includes source-to-target mappings, data dictionaries, and other related materials.

Position Specific Skills

• Understanding of data warehousing and transformation methods, lineage documentation, and ETL processes
• Knowledge of data spreadsheets and databases
• Understanding of Base SAS programming, SAS Enterprise Guide, Cognos, or related programs
• IBM InfoSphere Information Management suite or similar

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

Preferred Skills

• Understanding of data warehousing and transformation as well as extract, transform, and load processes, Knowledge of technologies and trends impacting the financial service and insurance industry.
• Experience in Banking, Regulatory, Data Warehouse/Data Lakes, AWS/ Snowflake
• Proven track record of leading agile data product delivery across cross-functional teams using agile frameworks such as Scrum, SAFe, or Kanban
• Understanding of data warehousing and transformation methods, lineage documentation, and ETL processes, Knowledge of data spreadsheets and databases.
• Advanced proficiency in writing complex SQL queries to perform data analysis on the complex data sets.
• Ability to convert complex technical findings into clear, actionable narratives for both technical and non-technical stakeholders.
• Ability to create dashboards using the tools Tableau and Power BI for reporting analysis.

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.