As a Data Management Specialist you will assist the Bank in using information systems for decision making to achieve strategic competitive advantage. The position is responsible for iVue data warehouse administration, building relational database tables for third party data sets, and the design and timely distribution of key Bank reports. The role will utilize and support the reporting functions of other applications in use at the Bank.
The Data Management Specialist will participate in and adhere to data governance, promote best practices and mentor other Bank employees. The Data Management Specialist will recommend metrics and analysis, and leverage existing and new technology to create efficiencies and improve reliability.
GENERAL DESCRIPTION OF DUTIES:
?? Support and utilize the reporting functions of existing Bank applications including but not limited to iVue, Touch?? Analyzer, Bank Intelligence, Prologue, and Nautilus to create efficiencies, deliver insight, and actionable information.
Manage the iVue data warehouse as the Security, Powershare and Scheduling administrator.
?? Work with Bank departments to create new relational database tables, design and automate import processes from third party systems.
?? Create and maintain product and organizational hierarchies based on the recommendation of product development and data governance committees.
?? Perform daily tasks necessary to keep systems operating efficiently including balancing applications and hierarchies daily.
?? Create balanced views for baseline reporting.
?? Ensure timely delivery of reports utilizing the Scheduler in conjunction with the IS department. Check reports for coding, assign triggers and set priority.
?? Review and distribute upgrade bulletins with detailed action plans.
?? Responsible for user and table access.
Generate key metric reports such as Scorecards, Board Reports and select committee reports which analyze strategies and performance.
Work with Bank departments to identify reporting needs, develop requirements, and create reports or templates, recommend metrics and analysis, and develop ad-hoc reports as necessary.
Assist in identifying opportunities to leverage current and new technologies and recommends process improvements. Create efficiencies through scripting and data export and import processes across applications.
Support the creation and delivery of extracts to third party vendors and regulatory agencies.
Provide mentoring and training to report power users in the use of reporting tools, validation techniques, formulas, analysis, and report design. Promote best practices and instill report standards.
Participate in Data Governance meetings and adhere to governance guidelines.
Act as a resource to users regarding technical, operational and procedural problems including analysis of problems as they relate to reporting software in use at the Bank.
Aides in systems audits and works with the Enterprise Risk Management team to remain knowledgeable regarding current and future regulations.
Complete all required compliance training as assigned in a timely manner.
Perform other duties as assigned.
Design and maintenance of custom tables in the data warehouse, day to day application and support activities for the data warehouse, and reporting activities as assigned.
POSITIONS SUPERVISED: None
BASIC KNOWLEDGE & TRAINING REQUIRED FOR MAXIMUM PROFICIENCY:
Work requires a strong understanding of relational databases and queries, as well as general banking or business knowledge, strong analytical skills, attention to detail, critical thinking, and organizational skills. A practical understanding of the concepts of data management, MSSQL and end user reporting tools, and a proficiency with Microsoft Excel and Access programs. The ability to function efficiently and effectively under deadlines.
PHYSICAL DEMANDS/CONDITIONS REQUIREMENTS:
Travel required to various Bank sites including branch locations, offsite business continuity facilities and/or training facilities utilized by the Bank.
One to three years of similar or related experience in database design, reporting, and analysis. Experience in the banking and/or financial services sector preferred. Must demonstrate a willingness to learn in an evolving department and show a strong ability to work collaboratively throughout the Bank while managing multiple tasks. Candidate should be one who embraces new technology and be capable of effectively communicating training to internal customers.
A four year college degree in either Computer Science or Business with a focus in data management, or completion of a specialized course of study at a business or trade school.