Business Data Analyst - Hybrid

Business Systems & Data Analyst - Hybrid

Location: Cincinnati, OH (3 days onsite)

Duration: 12 Months +

GENERAL FUNCTION:

This role is a member of the team responsible to support the FTP (Funds Transfer Pricing) technical processes. FTP is a critical bank methodology used in product pricing, liquidity, funding management, balance sheet management and profitability management. It helps in accurately measuring a financial institutions profitability on deposits and loans by assessing the cost or credit of funds.

This role requires interacting with business partners on a regular basis to understand business asks for analysis from monthly/weekend cycles, translate new requirements to technical execution and to facilitate testing. Expect to investigate, identify root causes, explain to the LOB and identify mitigations for any incidents and problem tickets related to FTP calculations. Strong verbal and written communications are required to explain analysis. Maintain & communicate the application backlog. Drives for continuous improvement.

ESSENTIAL DUTIES AND RESPONSIBILITIES:

• Defines and coordinates work requirements by identifying milestones, phases, and elements.
• Manage and resolve incident tickets and service requests to SLA’s, Level 2 Help Desk.
• Attend team operational ceremonies like daily team meetings and monthly backlog planning, including regular connections with LOB partners.
• Maintains system protocols by writing and updating both business and IT procedures
• Support, as needed, weekend cycle processing.
• Understand inbound/outbound data, and maintain relationships with respective IT teams.
• Maintain access and communicate with software vendor via their website, as required.
• Support basic application management functions including access management, governance and environment management. Partner with the technical lead as required.
• Write SQL scripts to analyze data directly from the DB, in order to resolve incidents and service requests.
• Write and maintain user documentation. Train users.
• Manage and execute monthly manual cycle processing, validations and reruns at the beginning of each month. Resolve issues. Identify and support opportunities to automate monthly cycle processing.
• Supports and recommends priorities for application backlog, where backlog includes both business and technical needs. Participate in team prioritization decisions.
• Read and interpret inbound/outbound ETL for analysis and incident resolution

SUPERVISORY RESPONSIBILITIES: None

MINIMUM KNOWLEDGE, SKILLS AND ABILITIES REQUIRED:

• Experience writing SQL scripts, to pull data for analysis. Able to navigate Oracle DB’s.
• Understand on-call tracking applications, EverBridge experience is a plus
• Demonstrated ability to learn fast
• Demonstrated collaboration skills
• Understand workload schedulers. TWS (Tivoli Workload Scheduler) experience is a plus
• Understand File Transfer Services. IBM Sterling experience is a plus
• Understand ITIL basics
• Excellent verbal and written communication skills
• Experience with Excel, used for data analysis & data uploads
• Demonstrated problem solving skills
• Experience with ticketing systems, ServiceNow experience is a plus
• Experience with Finance processes, especially FTP, a plus
• Bachelor's degree in Management Information Systems, Finance or comparable. At least 1-2 years of experience preferably in Banking/Finance industry a plus.
• Understand Software Development Methodologies
• Experience supporting user needs of applications, a plus
• Understand ETL, IBM Datastage experience a plus
• Understand system monitoring tools, SiteScope experience is a plus
• Experience documenting user requirements, and partnering with technical teams to translate business requirements to technical requirements