Technical Business Analyst

deploy; Birmingham (AL); On-site; USD 70,000 - 90,000; Full time

Job summary

deploy is looking for a Technical Business Analyst III in Birmingham, Alabama. This role requires collaboration with IT teams and stakeholders to design and implement core systems effectively.

The ideal candidate should have advanced skills in computer science, SQL scripting, and Excel, with proven experience in data analysis and reporting tools. This position involves a variety of responsibilities including system upgrades, troubleshooting, and supporting merger and acquisition processes.

Qualifications

• Proven experience as a technical business analyst or in a similar role.
• Strong analytical and problem-solving skills.
• Ability to translate and document business needs into technical specifications.

Responsibilities

• Analyze, develop, and implement new products and processes in the core systems.
• SQL scripting to assist with system testing, create operational extracts/reports.
• Support the business unit team members through the Internal MSR Support ring group.

Skills

Advanced General Computer Skills

Beginner SQL Scripting Experience

Advanced Excel skills (including programming with Excel)

Tools

Data analysis and reporting tools (SQL, Excel)

Programming languages (JavaScript, DB2)

Job description

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.

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, 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