Lead Data Analyst

Lead Data Analyst

Our client, a commercial banking company, is looking for a Lead Data Analyst for their Atlanta, GA/Charlotte, NC/Raleigh NC location.

Responsibilities:

• Understanding of enterprise data warehouse concepts and prior experience applying that understanding to query data in a very large database (VLDB) environment
• Gather, analyze, document and maintain all data requirements related to the business applications, interfaces and reporting environments.
• Apply standards and best practices to ensure the bank's data is accurate, complete, current, understandable and accessible.
• Work closely with internal clients, audit delivery teams, business analysts and development project teams to resolve information flow and content issues.
• Gathers, reviews, analyzes, profiles, validates and maps system data into the data warehouse to meet reporting and analytical business needs.
• Performs data analysis and troubleshooting on data-related issues reported by production support and other teams.
• Develops solutions and recommendations for improving data integrity issues. Analyzes data issues and works with development teams for problem resolutions. Identifies problematic areas and conducts research to determine the best course of action to correct the data, identify, analyze and interpret trends and patterns in complex datasets.
• Determines and analyzes line of business requirements, use system data, and provide input needed by various departments and senior management to produce business reports.
• Works with extract, transform and load (ETL) developers to test and validate data attributes and with other business analysts to ensure data is integrated consistently, regardless of the source system.
• Works with business analysts and project teams to provide accurate documentation of data related project and support deliverables. And with source system business analysts to understand system nuances and resolve data issues. Takes ownership of issues through resolution including close coordination between business analysts.

Requirements:

• At least 6 years of experience in a role of data analysis, statistical analysis, data transformation, data reconciliation and/or sophisticated data presentation.
• Hands-on knowledge of SQL queries. Proficient in analyzing and understanding existing SQL queries to make necessary modifications and capable of developing new queries as needed.
• Hands-on experience with SAS. Proficient in analyzing and understanding existing SAS programs to make necessary modifications and capable of developing new programs as needed.
• Ability to act as liaison between audit team and business team
• Familiarity in using a query analysis tool.
• Experience with Python.
• Banking or financial services experience.
• Audit experience.

Why Should You Apply?

• Health benefits
• Referral program
• Excellent growth and advancement opportunities

ICONMA is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to any status protected by applicable law.