Enterprise Data Warehouse Business System Analyst - Umpqua Bank
Hillsboro, OR
About the Job
Enterprise Data Warehouse Business System Analyst
Innovation and Technology
Hillsboro,
Oregon
Lakewood,
Washington
NA,
Nevada
NA,
Idaho
NA,
Utah
NA,
Arizona
NA,
Colorado
NA,
Washington
NA,
CA
NA,
Oregon
Spokane,
Washington
Description
About Us:
Umpqua Bank is headquartered in the Pacific Northwest with 5,000+ employees and offers banking services to customers throughout the nation. It’s an especially exciting time to join our team as, following the recent merger with Columbia Bank, we have grown to become a leading western-based regional bank with more than $50B in assets under management and an unwavering commitment to our associates, our customers, and our communities.
We create a great place to work by offering a special brand of relationship banking and by providing a culture where associates thrive. Associates who embody our core values fit in well here and we are eager to meet candidates who demonstrate behaviors that align with Trust, Ownership, Growth, Empathy, Teamwork, Heart, Enjoyment, and Relationships.
About the Role:
We are seeking a skilled Business Systems Analyst to join our team and work on our enterprise data warehouse. The ideal candidate will be responsible for analyzing business requirements and designing solutions to support the enterprise data warehouse. The candidate will be responsible for working with stakeholders from various departments to identify requirements, develop use cases, and create functional specifications. The candidate should have a thorough understanding of data warehousing principles, data modeling, and data integration.
+ Collaborate with stakeholders to identify and document business requirements for the enterprise datawarehouse.
+ Develop use cases and functional specifications for the datawarehouse.
+ Work with IT teams to integrate data from various sources into the datawarehouse.
+ Develop and maintain documentation for the enterprise datawarehouse.
+ Ensure data quality and integrity for the enterprise datawarehouse.
+ Provide support to end-users of the enterprise datawarehouse.
+ Monitor and maintain the performance of the enterprise datawarehouse.
+ Demonstrates compliance with all bank regulations for assigned job function and applies to designated job responsibilities – knowledge may be gained through coursework and on-the-job training. Keeps up to date on regulation changes.
+ Follows all Bank policies and procedures, compliance regulations, and completes all required annual or job-specific training.
+ Maintain a working knowledge of Bank's written policies and procedures regarding Bank Secrecy Act, Regulation CC, Regulation E, BankSecurity,and other regulations as applicable to this job description.
+ May be asked to coach, mentor, or train others and teach coursework as subject matter expert.
+ Actively learns, demonstrates, and fosters the Umpqua corporate culture in all actions and words.
+ Takes personal initiative and is a positive example for others to emulate.
+ Embraces our vision to become "Business Bank of Choice.”
+ May perform other duties as assigned.
About You:
+ H.S Diploma/GED
+ Bachelor’s Degree in IT, MIS, Finance,Business,or related field.
+ 7-10 years of technical bank operations experience required.
+ 3+ years agile development experience preferred.
+ 6+ years’ experience with databases such as SQL Server, Oracle, or Snowflake preferred.
+ 2+ years’ experience working with dimensional or relational database models preferred.
+ Knowledge of project management with Microsoft DevOps, bank operations, Microsoft Azure, bank products, and mortgage, installment, and commercial loans. Extensive familiarity with financial institution computer and operating system features andthird-partyproducts.
+ 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.
Workstyle: Fully onsite.
Our Benefits:
We offer a competitive total rewards package including basewagesand comprehensive benefits. Thepayrange for this role is $66,976.56 to $106,312.00,and the pay rate for theselected candidate isdependent upon a variety of non-discriminatory factors including, but not limited to, job-related knowledge, skills, and experience, education, and geographic location. The rolemay beeligible for performance-based incentive compensation and those details will be provided during the recruitment process.
We offer eligible associates comprehensive healthcare coverage (medical, dental, and vision plans), a 401(k)-retirement savings plan with employer match for qualifying associate contributions, an employee assistance program, life insurance, disabilityinsurance, tuition assistance, mental health resources, identity theft protection, legal support, auto and home insurance, pet insurance, access to an online discount marketplace, and paid vacation, sick days, volunteer days, and holidays. Benefit eligibility begins the first day of the month following the date of hire for associates who are regularly scheduled to work at least thirty hours weekly.
Our Commitment to Diversity :
Umpqua Bank isan equal opportunityand affirmative actionemployercommitted to employing, engaging, and developinga diverse workforce.Allqualifiedapplicants will receive considerationfor employmentwithout regard to race, color,national origin,religion, sex, age, sexual orientation, gender identity, gender expression, protected veteran status, disability, or any other applicable protected status or characteristics.If you require an accommodation to complete the application or interview(s),please let us know by email: [email protected] .
To Staffing and Recruiting Agencies:
Our posted job opportunities are onlyintendedfor individuals seekingemploymentat Umpqua Bank.Umpqua Bank does not accept unsolicited resumes or applications from agencies and Umpqua Bank will not be responsible for any fees related to unsolicited resume submissions.Staffing and recruiting agencies are not authorized to submit profiles, applications,or resumestothis site or toany Umpqua Bank employeeand any such submissionswill be consideredunsolicitedunlessrequesteddirectlyby a member of the Talent Acquisition team.
Innovation and Technology
Hillsboro,
Oregon
Lakewood,
Washington
NA,
Nevada
NA,
Idaho
NA,
Utah
NA,
Arizona
NA,
Colorado
NA,
Washington
NA,
CA
NA,
Oregon
Spokane,
Washington
Description
About Us:
Umpqua Bank is headquartered in the Pacific Northwest with 5,000+ employees and offers banking services to customers throughout the nation. It’s an especially exciting time to join our team as, following the recent merger with Columbia Bank, we have grown to become a leading western-based regional bank with more than $50B in assets under management and an unwavering commitment to our associates, our customers, and our communities.
We create a great place to work by offering a special brand of relationship banking and by providing a culture where associates thrive. Associates who embody our core values fit in well here and we are eager to meet candidates who demonstrate behaviors that align with Trust, Ownership, Growth, Empathy, Teamwork, Heart, Enjoyment, and Relationships.
About the Role:
We are seeking a skilled Business Systems Analyst to join our team and work on our enterprise data warehouse. The ideal candidate will be responsible for analyzing business requirements and designing solutions to support the enterprise data warehouse. The candidate will be responsible for working with stakeholders from various departments to identify requirements, develop use cases, and create functional specifications. The candidate should have a thorough understanding of data warehousing principles, data modeling, and data integration.
+ Collaborate with stakeholders to identify and document business requirements for the enterprise datawarehouse.
+ Develop use cases and functional specifications for the datawarehouse.
+ Work with IT teams to integrate data from various sources into the datawarehouse.
+ Develop and maintain documentation for the enterprise datawarehouse.
+ Ensure data quality and integrity for the enterprise datawarehouse.
+ Provide support to end-users of the enterprise datawarehouse.
+ Monitor and maintain the performance of the enterprise datawarehouse.
+ Demonstrates compliance with all bank regulations for assigned job function and applies to designated job responsibilities – knowledge may be gained through coursework and on-the-job training. Keeps up to date on regulation changes.
+ Follows all Bank policies and procedures, compliance regulations, and completes all required annual or job-specific training.
+ Maintain a working knowledge of Bank's written policies and procedures regarding Bank Secrecy Act, Regulation CC, Regulation E, BankSecurity,and other regulations as applicable to this job description.
+ May be asked to coach, mentor, or train others and teach coursework as subject matter expert.
+ Actively learns, demonstrates, and fosters the Umpqua corporate culture in all actions and words.
+ Takes personal initiative and is a positive example for others to emulate.
+ Embraces our vision to become "Business Bank of Choice.”
+ May perform other duties as assigned.
About You:
+ H.S Diploma/GED
+ Bachelor’s Degree in IT, MIS, Finance,Business,or related field.
+ 7-10 years of technical bank operations experience required.
+ 3+ years agile development experience preferred.
+ 6+ years’ experience with databases such as SQL Server, Oracle, or Snowflake preferred.
+ 2+ years’ experience working with dimensional or relational database models preferred.
+ Knowledge of project management with Microsoft DevOps, bank operations, Microsoft Azure, bank products, and mortgage, installment, and commercial loans. Extensive familiarity with financial institution computer and operating system features andthird-partyproducts.
+ 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.
Workstyle: Fully onsite.
Our Benefits:
We offer a competitive total rewards package including basewagesand comprehensive benefits. Thepayrange for this role is $66,976.56 to $106,312.00,and the pay rate for theselected candidate isdependent upon a variety of non-discriminatory factors including, but not limited to, job-related knowledge, skills, and experience, education, and geographic location. The rolemay beeligible for performance-based incentive compensation and those details will be provided during the recruitment process.
We offer eligible associates comprehensive healthcare coverage (medical, dental, and vision plans), a 401(k)-retirement savings plan with employer match for qualifying associate contributions, an employee assistance program, life insurance, disabilityinsurance, tuition assistance, mental health resources, identity theft protection, legal support, auto and home insurance, pet insurance, access to an online discount marketplace, and paid vacation, sick days, volunteer days, and holidays. Benefit eligibility begins the first day of the month following the date of hire for associates who are regularly scheduled to work at least thirty hours weekly.
Our Commitment to Diversity :
Umpqua Bank isan equal opportunityand affirmative actionemployercommitted to employing, engaging, and developinga diverse workforce.Allqualifiedapplicants will receive considerationfor employmentwithout regard to race, color,national origin,religion, sex, age, sexual orientation, gender identity, gender expression, protected veteran status, disability, or any other applicable protected status or characteristics.If you require an accommodation to complete the application or interview(s),please let us know by email: [email protected] .
To Staffing and Recruiting Agencies:
Our posted job opportunities are onlyintendedfor individuals seekingemploymentat Umpqua Bank.Umpqua Bank does not accept unsolicited resumes or applications from agencies and Umpqua Bank will not be responsible for any fees related to unsolicited resume submissions.Staffing and recruiting agencies are not authorized to submit profiles, applications,or resumestothis site or toany Umpqua Bank employeeand any such submissionswill be consideredunsolicitedunlessrequesteddirectlyby a member of the Talent Acquisition team.
Source : Umpqua Bank
