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:

The Quality Assurance Data Engineer will develop, implement, and manage the quality assurance program for the Data Engineer team that is responsible for data management, programming, analytic and consultative activities including database, documentation, and data trending assessment.  Partner with Data Engineer team to ensure data integrity and best practices are implemented and utilized. May design, develop, and update data integration, profiling, and cleansing routines.

• Develop and implement data quality assurance processes and procedures.
• Create and execute test plans and test cases to ensure data accuracy and completeness.
• Collaborate with data engineering teams to ensure high-quality data ETL pipelines
• Ensure adherence to dimensional data modeling best practices.
• Automate test cases and integrate them into the continuous integration/continuous delivery (CI/CD) pipeline.
• Collaborate with development teams to ensure adherence to Agile development practices.
• Utilize ADO (Azure Devops) to manage project tasks and track progress
• Develop and maintain Informatica ETL processes.
• May design, develop, test, and update data integration (ETL, replication, and change data capture).
• Assist with defining, maintaining, and enforcing data architecture, definitions, and standards.  Participate in data policy, standards, and procedure development processes.
• Perform code reviews, data model reviews, and testing.  Establish standards and best practices. Work with IT partners to perform periodic system and database operational tests, audits, and tuning.
• Responsible for promoting understanding of data quality concepts and methods.  Identify, document, and recommend solutions for poor quality data.
• 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, Bank Security, 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:

• Bachelor's Degree in MIS, computer science, or related field required.
• 7-10 years of related experience.
• 3+ years in Quality Assurance testing and automating test cases.
• 2+ years of experience with modern data warehouse engineering, Microsoft Azure data products, Snowflake, and data ETL pipelines and dimensional data models.
• Intermediate knowledge of database concepts, methodologies, and architectural approaches.
• Extensive knowledge of database systems and administration, including security, development and testing support, modeling and logical design, database design, and qualify control.
• Demonstrate strong quantitative, analytical, and problem-solving skills, with ability to adapt to new methods, techniques, and procedures.
• Familiarity with Agile development practices and ADO (Azure Devops).
• Experience with Informatica ETL development.
• Strong knowledge in modern data warehouse engineering, Microsoft Azure data products, and Snowflake.
• Proven experienced in data ETL pipelines, dimensional data models, quality assurance testing, and automating test cases.
• Ability to work effectively in a team environment. 
• Excellent verbal and written communication skills required.

Workstyle: Fully onsite.

Our Benefits:

We offer a competitive total rewards package including base wages and comprehensive benefits. The pay range for this role is $74,418.40 to $138,205.60, and the pay rate for the selected candidate is dependent upon a variety of non-discriminatory factors including, but not limited to, job-related knowledge, skills, and experience, education, and geographic location. The role may be eligible 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, disability insurance, 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 is an equal opportunity and affirmative action employer committed to employing, engaging, and developing a diverse workforce. All qualified applicants will receive consideration for employment without 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 only intended for individuals seeking employment at 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 resumes to this site or to any Umpqua Bank employee and any such submissions will be considered unsolicited unless requested directly by a member of the Talent Acquisition team.