Business System Programming Analyst

Role Overview

• Collects functional requirements from the business line
• Assists application development team in creating functional designs
• Aids in testing of applications
• Analyzes and evaluates user needs
• Assists in developing and maintaining a complete and accurate understanding of how an impacted business unit conducts its business
• Assists in developing and maintaining detailed knowledge of the business' current technology and infrastructure from a functional perspective
• Assists in analyzing and documenting business processes of medium complexity
• Works with business representatives to identify, analyze, document, and refine detailed business needs of medium complexity and scope
• Designs functional solutions that appropriately meet the business needs
• Reviews test plans for multiple projects and ensures that test cases and results meet requirements
• Plays a key role in identifying and pursuing process improvement opportunities within U.S. Bank Global Fund Services
• Proactively analyzes operational challenges raised by business users and collaborates with both internal and external clients, business partners, and developers to design and implement automated solutions that benefit the department
• Documents client requirements and translates them into clear business or technical specifications
• Develops and deploys high-quality, practical business solutions using available tools
• Systematically identifies and assesses business opportunities across various functions through data trend analysis and stakeholder input
• Conducts comprehensive system testing to ensure report accuracy and functional integrity prior to deployment
• Facilitates training sessions and demonstrates new system functionalities to relevant teams

Requirements

• Bachelor's degree in Computer Science, Data Science, Accounting, Finance or a business-related field, or equivalent work experience
• Two to three years of related experience, preferably building automated solutions for finance teams
• Intermediate proficiency in SQL, including the ability to read and modify procedures, as well as create tables and triggers
• Intermediate experience with Python or other scripting/programming languages for automation and solution development
• Skilled in leveraging Power Platform tools, such as Power Apps, to build and enhance business applications
• Experienced in utilizing database management systems and data visualization tools (e.g., Tableau, Power BI, Qlik, Cognos) to analyze and present complex information
• Proven track record of designing and developing innovative solutions based on business requirements
• Strong working knowledge of Microsoft Office products to support business operations and communication
• Experienced in testing end-user software, including applying patches and managing upgrades to ensure system reliability
• Proficient in documenting and articulating business processes and workflows, with the ability to translate them into clear technical specifications
• Exceptional verbal and written communication skills, enabling effective collaboration with diverse stakeholders
• Demonstrated leadership, organizational, and team-oriented abilities in dynamic business environments

Tech Stack

• Cognos
• Python
• SQL
• Tableau

Benefits

• Healthcare (medical, dental, vision)
• Basic term and optional term life insurance
• Short-term and long-term disability
• Pregnancy disability and parental leave
• 401(k) and employer-funded retirement plan
• Paid vacation (from two to five weeks depending on salary grade and tenure)
• Up to 11 paid holiday opportunities
• Adoption assistance
• Sick and Safe Leave accruals of one hour for every 30 worked, up to 80 hours per calendar year unless otherwise provided by law