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, 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.
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.
Takes ownership of issues through resolution including close coordination between business analysts.
Requirements
Bachelor's degree in information technology, information systems, computer science or business-related field
Four years of experience in a role of data analysis, statistical analysis, data transformation, data reconciliation and/or sophisticated data presentation or equivalent education and related training or experience
Familiar with ETL Development using standard tools
Working knowledge of Enterprise Data Warehouse concepts and experience applying that understanding to query data in a Very Large Database (VLDB) environment