EDW Data Analyst

Infinitek Limited

Charlotte, United States

11 days ago

Apply on www.dice.com

Prepare application

Role details

Contract type

Permanent contract

Employment type

Full-time (> 32 hours)

Experience level

Experienced

Experience required

4 years minimum

Working hours

Regular working hours

Job source

www.dice.com

Tech stack

Amazon Web Services Spreadsheets Profiling Databases Data Dictionary Extract Transform Load (ETL) Data Warehousing Database Queries SQL Databases Snowflake Data Lakes Data Management

Job description

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
Experience in Banking, Regulatory, Data Warehouse/Data Lakes, AWS/ Snowflake
Understanding of data warehousing and transformation methods, lineage documentation, and ETL processes.
Knowledge of data spreadsheets and databases
Hands-on SQL experience for writing complex queries