Systems Business & Data Analyst

TECHNICAL SKILLS Must Have 1) Proficient use of Project Managment methodologies and tools 2) Experience creating and executing test scripts 3) Experience documenting and gathering requirements 4) Strong problem solving skills 5) Strong analytical skills 6) Excellent communication skills • Business Analyst • DataStage, SQL, understanding of dimensionally-designed databases, and experience interacting with a relational database (DB2, Oracle, etc.). • Mainframe experience would be a bonus, but not required. Ability to analyze complex data flows and understand existing jobs. Nice To Have • Databases:- Oracle, IBM DB2, SQL Server • UNIX ESSENTIAL DUTIES AND RESPONSIBILITIES: • Supports and recommends priorities for application backlog, where backlog includes both business and technical needs. Participate in team prioritization decisions. • Defines and coordinates work requirements by identifying milestones, phases, and elements. • 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. • Support, as needed, weekend cycle processing. • Manage and resolve incident tickets and service requests to SLA’s, Level 2 Help Desk. • Write SQL scripts to analyze data directly from the DB, in order to resolve incidents and service requests. • Understand inbound/outbound data, and maintain relationships with respective IT teams. • Read and interpret inbound/outbound ETL for analysis and incident resolution • Maintains system protocols by writing and updating both business and IT procedures • Write and maintain user documentation. Train users. • 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. • Attend team operational ceremonies like daily team meetings and monthly backlog planning, including regular connections with LOB partners. MINIMUM KNOWLEDGE, SKILLS AND ABILITIES REQUIRED: • Bachelor's degree in Management Information Systems, Finance or comparable. At least 1-2 years of experience preferably in Banking/Finance industry a plus. • Experience with Finance processes, especially FTP, a plus • Experience writing SQL scripts, to pull data for analysis. Able to navigate Oracle DB’s. • Experience documenting user requirements, and partnering with technical teams to translate business requirements to technical requirements • Experience with Excel, used for data analysis & Data uploads • Experience with ticketing systems, ServiceNow experience is a plus • Understand workload schedulers. TWS (Tivoli Workload Scheduler) experience is a plus • Understand on-call tracking applications, EverBridge experience is a plus • Understand system monitoring tools, SiteScope experience is a plus • Understand File Transfer Services. IBM Sterling experience is a plus • Understand ETL, IBM Datastage experience a plus • Experience supporting user needs of applications, a plus • Understand ITIL basics • Understand Software Development Methodologies • Demonstrated problem solving skills • Demonstrated collaboration skills • Demonstrated ability to learn fast • Excellent verbal and written communication skills

TECHNICAL SKILLS Must Have 1) Proficient use of Project Managment methodologies and tools 2) Experience creating and executing test scripts 3) Experience documenting and gathering requirements 4) Strong problem solving skills 5) Strong analytical skills 6) Excellent communication skills • Business Analyst • DataStage, SQL, understanding of dimensionally-designed databases, and experience interacting with a relational database (DB2, Oracle, etc.). • Mainframe experience would be a bonus, but not required. Ability to analyze complex data flows and understand existing jobs. Nice To Have • Databases:- Oracle, IBM DB2, SQL Server • UNIX ESSENTIAL DUTIES AND RESPONSIBILITIES: • Supports and recommends priorities for application backlog, where backlog includes both business and technical needs. Participate in team prioritization decisions. • Defines and coordinates work requirements by identifying milestones, phases, and elements. • 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. • Support, as needed, weekend cycle processing. • Manage and resolve incident tickets and service requests to SLA’s, Level 2 Help Desk. • Write SQL scripts to analyze data directly from the DB, in order to resolve incidents and service requests. • Understand inbound/outbound data, and maintain relationships with respective IT teams. • Read and interpret inbound/outbound ETL for analysis and incident resolution • Maintains system protocols by writing and updating both business and IT procedures • Write and maintain user documentation. Train users. • 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. • Attend team operational ceremonies like daily team meetings and monthly backlog planning, including regular connections with LOB partners. MINIMUM KNOWLEDGE, SKILLS AND ABILITIES REQUIRED: • Bachelor's degree in Management Information Systems, Finance or comparable. At least 1-2 years of experience preferably in Banking/Finance industry a plus. • Experience with Finance processes, especially FTP, a plus • Experience writing SQL scripts, to pull data for analysis. Able to navigate Oracle DB’s. • Experience documenting user requirements, and partnering with technical teams to translate business requirements to technical requirements • Experience with Excel, used for data analysis & Data uploads • Experience with ticketing systems, ServiceNow experience is a plus • Understand workload schedulers. TWS (Tivoli Workload Scheduler) experience is a plus • Understand on-call tracking applications, EverBridge experience is a plus • Understand system monitoring tools, SiteScope experience is a plus • Understand File Transfer Services. IBM Sterling experience is a plus • Understand ETL, IBM Datastage experience a plus • Experience supporting user needs of applications, a plus • Understand ITIL basics • Understand Software Development Methodologies • Demonstrated problem solving skills • Demonstrated collaboration skills • Demonstrated ability to learn fast • Excellent verbal and written communication skills