Enterprise Data Analyst II

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

Job summary

First Citizens Bank seeks a data governance professional to lead enterprise data quality, governance, and analytics initiatives. You will drive improvements across the data warehouse, build dashboards, and provide expert consultation to IT and stakeholders while maintaining robust documentation.

Responsibilities include enhancing data storage, enforcing data policies, and developing plans to advance data management capabilities in a dynamic banking environment.

Qualifications

• Bachelor's Degree + 4 years in Data Management or related field OR High School + 8 years experience in Data Management or related field.
• Experience with data governance, quality, and analytics initiatives across enterprise.
• Ability to create and maintain technical documentation and dashboards.

Responsibilities

• Data Enhancement: improve quality, management, and storage of enterprise data and build analytics dashboards.
• Business Support: enforce data policies and ensure data quality for reporting.
• Business Tactics: develop plans to enhance data management capabilities and stay ahead of trends in finance.
• Documentation: maintain source-to-target mappings, data dictionaries, and related docs for the Enterprise Data Warehouse.

Skills

Data governance

Data quality

Stakeholder communication

Agile data product delivery

Education

Bachelor's Degree in Data Management / IT / Finance

High School Diploma + 8 years experience

Tools

SAS

SAS Enterprise Guide

Cognos

IBM InfoSphere

SQL

Tableau

Power BI

AWS

Snowflake

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.

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.