Quality Assurance Data Engineer Innovation and Technology Hillsboro, Oregon NA, Nevada NA, Idaho NA, Washington NA, Oregon **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:** 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, 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:** + Bachelor's Degree in MIS, computer science, or related fieldrequired. + 7-10yearsof related experience. + 3+ yearsin Quality Assurance testing and automating test cases. + 2+ yearsof 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, andproblem-solvingskills, 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 basewagesand comprehensive benefits. Thepayrange for this role is $74,418.40 to $138,205.60, 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, 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 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 fromagencies 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.