Technical Business Analyst

Summary:

The Technical Business Analyst III is responsible for designing, implementing, and maintaining 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, managing advanced system projects, supporting merger and acquisition activities, and programming new scripts for core systems.

Requirements:

• Advanced general computer skills
• Beginner SQL scripting experience
• Advanced Excel skills, including programming with Excel

Preferred Qualifications:

Responsibilities:

• Analyze, develop, and implement new products and processes in core systems
• Administer core system privileges and roles
• Configure and review XML, HTML, or BAT files for system setup and error resolution
• Develop Excel templates with macros, programming, and user forms for balancing and workflows
• Write SQL scripts for system testing, reports, and communication with developers
• Plan and request automation scripts and batch files
• Conduct release testing for new processes, updates, and corrections
• Support merger and acquisition activities, including data mapping and validation
• Assist business units via the MSR Support group for system questions
• Perform system maintenance tasks as needed, such as account conversions, dividend rate changes, password resets, and security updates
• Perform other duties as assigned