Technical Business Analyst

Summary

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.

• Advanced General Computer Skills
• Beginner SQL Scripting Experience
• Advanced Excel skills (including programming with Excel)

• 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

• 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, including macros, programming, and user forms
• SQL scripting to assist with system testing, create operational extracts/reports, and communicate needed scripts/reports with the development team; edit existing SQL reports for system updates and changes
• Plan and request 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: create data mapping documentation for programming the merger, resolve 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 operational support tickets, including converting accounts, changing dividend rates, deleting passwords and identification changes, and performing all other system maintenance that cannot be completed by other team members (for security and complexity purposes)
• All other job duties as assigned