.Umpqua Bank - Enterprise Data Warehouse Business System AnalystLocation: NA, CaliforniaAbout Us:Umpqua Bank is headquartered in the Pacific Northwest with 5,000+ employees and offers banking services to customers throughout the nation. 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 work 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 data warehouse.Develop use cases and functional specifications for the data warehouse.Work with IT teams to integrate data from various sources into the data warehouse.Develop and maintain documentation for the enterprise data warehouse.Ensure data quality and integrity for the enterprise data warehouse.Provide support to end-users of the enterprise data warehouse.Monitor and maintain the performance of the enterprise data warehouse.Demonstrate compliance with all bank regulations for assigned job function.Follow all Bank policies and procedures, compliance regulations, and complete all required training.Maintain a working knowledge of Bank's written policies regarding applicable regulations.May be asked to coach, mentor, or train others.Actively learn, demonstrate, and foster the Umpqua corporate culture.Take personal initiative and be a positive example for others to emulate.Embrace our vision to become the '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.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, and bank products.Advanced knowledge of user acceptance testing methodologies and principles