Enterprise Data Analyst II

First Citizens
Raleigh, United States of America
3 days ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Intermediate

Job location

Raleigh, United States of America

Tech stack

Amazon Web Services (AWS)
Data analysis
Spreadsheets
Profiling
Databases
Data Dictionary
Data Files
ETL
Data Warehousing
Scrum
Power BI
Tableau
Enterprise Data Management
Freeform SQL
Snowflake
Data Lake
Information Technology
Data Management

Job description

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

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

Requirements

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.

Apply for this position