The Technical Business Analyst III is responsible for designing, implementing, and maintaining the core systems. This role involves working closely with IT teams, developers, and stakeholders to ensure all systems and processes function efficiently. Tasks include creating new products and workflows, planning and implementing system upgrades, troubleshooting issues, advanced system projects, merger and acquisition tasks and events, and programming new scripts for the core systems.
Requirements:
Advanced General Computer Skills
Beginner SQL Scripting Experience
Advanced Excel skills (including programming with Excel)
Preferred Qualifications:
Advanced proficiency in data analysis and reporting tools (SQL, Excel)
Experience and understanding of programming languages (JavaScript, DB2).
Strong analytical and problem-solving skills.
Attention to detail and accuracy in data analysis.
Ability to translate and document business needs into technical specifications and provide solutions.
Excellent Written and verbal communication skills.
Ability to explain technical concepts to non-technical team members.
Proven experience as a technical business analyst or in a similar role.
Duties & Responsibilities:
Analyze, develop, and implement new products and processes in the core systems.
Core system privilege and role administrator.
Configure and review XML, HTML, (or BAT) files for system setup and error resolution.
Develop and create Excel balancing/workflow templates for various teams. This involves creating macros, programming, and user forms.
SQL scripting to assist with system testing, creating operational extracts/reports, and communicating needed scripts/reports with the development team. Editing currently created SQL reports for system updates and changes.
Planning and requesting system automation for scripts and batch files.
Core system release testing for new processes, updates, and corrections. Including all current batch processes, newly setup batch scripts, and privilege changes from the system release.
Merger and acquisition support team member. Create the data mapping documentation for programming the merger. Resolve all reported data validation issues from the merger events and adjust the data mapping.
Support the business unit team members through the Internal MSR Support ring group for deposit application and core system setup questions.
Complete any system maintenance reported through opportunities or operation support tickets. Including converting accounts, changing dividend rates, deleting passwords and identification changes, and performing all other system maintenance that can not be completed by other team members (for security and complexity purposes).