Data Integration Business Systems Analyst

The Technical Business Systems Analyst design and perform complex analysis contributing to the selection and implementation of business systems optimized to meet business requirements. In this role you will administer systems configurations and parameters controlling system functionality. Additionally, you will be tasked with minimizing implementation risks through the development and adherence to change procedures. Functions Responsible for evaluating the internal technical needs of an organization and recommending solutions. Develop and maintain data mapping documents and data flow diagrams. Responsible for serving as liaisons between business stakeholders and internal or vendor development resources to create enhancements or fixes based on business needs. Develop the system and functional requirements. Responsible for assessing available technologies to create development specifications as well as detailed test cases. Analyze release notes to assist business owners and stakeholders in deciding on how new functionality might be used. Assist with testing and analyze results. Partner with end users to identify, evaluate, and communicate system incidents to appropriate technical resources for resolution. Demonstrate compliance with all bank regulations that apply to your position and keep up to date on regulation changes. Maintain working knowledge of our policies and procedures regarding the Bank Secrecy Act, Regulation CC, Regulation E, Bank Security and other regulations that apply to your position. Qualifications Bachelor’s Degree in IT, MIS, Finance, Business or related field preferred. 6-8 years of technical bank operations experience. Knowledge of project management with bank operations, HR systems (as applicable), bank products, and mortgage, installment, and commercial loans. Extensive familiarity with financial institution computer and operating system features and third-party products. Advanced knowledge of user acceptance testing methodologies, principles, and practices of process development and implementation along with comprehensive banking/business unit system, software, and applications. Advanced PC program skills with extensive experience with Excel, data warehouse products, and other similar systems. Ability to handle complex problems to achieve department goals. Extensive verbal and written communication skills for a variety of audiences (both technical and non-technical). Ability to analyze problems of a technical nature with high accuracy and attention to detail. Ability to accurately document problems and resolutions. Possess a high level of analytical ability to understand sophisticated programs/systems for resolving business problems. Ability to respond promptly to customer needs. Ability to handle difficult or emotional customer situations. Ability to set goals and objectives, prioritize and plan work activities using time effectively, meet deadlines and commitments, and work independently with little or no directional guidelines from manager. Experience with relational database technologies and data warehousing concepts. Experience with ETL (Extract Transform & Load) tool/processes. Experience reading and writing SQL queries and stored procedures. Familiarity with cloud-based data services or technologies. Experience with Azure DevOps (ADO) Experience with Agile Development Physical Requirements and Working Conditions Work involves: Sitting Occasional walking Lifting up to 10 pounds. No relocation is offered. This is a remote work opportunity that is available to people who reside in Oregon, Washington, Idaho, California, or Nevada while employed with us. About Us We do things a little differently here at Umpqua. Our retail stores serve as community hubs, our associates are given up to 40 hours of volunteer time each year, and we’re never satisfied with the status quo. Greatness has no finish line, so we continue every day to keep people at the center of everything we do. We focus on building relationships, understanding our customers’ needs and connecting to people in new and innovative ways always staying true to our mission of providing personalized banking for all people, whenever and however they prefer to bank. Umpqua Bank is committed to employing a diverse workforce. Qualified applicants will receive consideration without regard to race, color, religion, sex, national origin, age, sexual orientation, gender identity, gender expression, protected veteran status, or disability. We maintain a drug-free workplace and may perform pre-employment substance abuse testing.