Enterprise Data Analyst II

First Citizens; Raleigh (NC); Remote; USD 90,000 - 130,000; Full time

Job summary

First Citizens in the United States seeks a senior data professional to lead initiatives in data quality, governance, and analytics across the Bank. This remote role hires only in Charlotte, Raleigh, or Phoenix; collaborates with IT and business units to advance data initiatives and reporting. Strong SQL/ETL and data warehousing knowledge are required.

Documentation of data processes is essential. The role emphasizes cross-functional partnership, advanced data techniques, and proactive

Qualifications

• Bachelor's Degree and 4 years of experience in Data Management, Financial Analysis, or similar.
• Alternatively, High School Diploma/GED with 8 years of experience in Data Management or similar.
• Understanding of data warehousing, transformation, lineage, and ETL processes.
• Knowledge of data spreadsheets and databases.
• Experience with data modelling, governance, and analytics preferred.

Responsibilities

• Identifies enhancements for the quality, management, and storage of enterprise data.
• Builds dashboards to modernize analytics and support reporting.
• Ensures data policies and procedures are followed across the enterprise.
• Maintains technical documentation for the Enterprise Data Warehouse.
• Works with IT and stakeholders to align data initiatives with business goals.

Skills

Data warehousing

ETL processes

Data lineage

Data analysis

Data governance

Agile environment

Presentation skills

Education

Bachelor's degree in Data Management or related field

High School Diploma or GED with 8 years experience in Data Management or similar

Tools

Base SAS programming

SAS Enterprise Guide

Cognos

IBM InfoSphere Information Management

Job description

Overview

This is a remote role that may only be hired in the following locations: (Charlotte, NC, Raleigh, NC or Phoenix, AZ)

This position leads Bank initiatives that improve enterprise data quality, governance, reporting, and analytics at an advanced level of ability and technical expertise. Drives positive change across the Bank through technical innovation and continuous improvement initiatives, as well as through cross-functional partnership with other business units. Provides expert consultation to team members, the Information Technology department, and other stakeholders on strategies that achieve data management goals. May provide leadership to less experienced consultants in the work group.

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:

• Experience as Strong Data analyst in Agile environment
• Deep expertise and 15+ years of experience in Data Analysis, Data warehouse and Analytics
• Hardcore data analyst with broad experience desired in data warehousing, documenting business processes, data governance & data integration
• Data wizard with hands on data analysis, profiling, and advanced PL/SQL skills
• Excellent presentation, listening, and writing skills with ability to lead workstreams independently
• Experience with data modelling, data analysis, data visualization, API’s and real time services preferred
• Full understanding and hands on experience of waterfall and agile development practices
• Excellent written and verbal communication skills with both internal and external stakeholders
• Domain experience in Customer Data, Marketing Data and systems is highly preferred

Additional Information

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 Education: Advanced degreeLicense or Certification Type: null nullSkill(s): 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

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.