Support the Enterprise by performing data management, programming, analytic and consultative activities including database, documentation and data trending assessment. Design, develop, and update data integration, profiling, and cleansing routines. Ensure all relevant metadata is captured and/or updated. Provide related modeling, mapping, and process assistance.
Design , develop, test, and update data integration (ETL, replication, change data capture), data profiling, and data profiling processes. Update and maintain metadata repositories and dictionaries. Responsible for creating, validating, and/or updating source-to-target maps. Help perform source analysis and supports departmental process improvement initiatives. Assist with logical and physical model design, source-to-target mapping, use cases, and other development processes and artifacts. Identify data subject areas, entities, attributes, relationships, information types, and domains. With project team, design and communicate logical and/or physical models and designs. Responsible for supporting identification of physical implementation requirements, including normalization techniques and referential integrity or dimensional techniques. 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.
5-8 years of related experience. 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. Intermediate knowledge of logical and physical data modeling and data modeling tools. 5+ years Oracle ETL experience required. Experienced in complex SQL statements, Microsoft Access, SQL databases, VB programming language, Excel, Data Warehousing, ETL and possibly Crystal Reports. Proficient in Microsoft Office products (Word, PowerPoint, and Project). Knowledge of Business Objects and/or Crystal Reports preferred. Intermediate knowledge of ETL, replication, change data capture and other data integration techniques and technologies (Microsoft SQL Server 2008 Suite of tools (SQL Server Management Studio, SSIS, SSRS, SQL Server Business Intelligence Studio, etc). Ability to work effectively in a team environment. Excellent verbal and written communication skills required. Bachelor’s Degree in MIS, Computer Science or related field required.
PHYSICAL REQUIREMENTS & WORKING CONDITIONS
Work involves sitting, occasional walking, and lifting up to 10 pounds.
Requires close visual acuity.
Normal office environment.
No relocation offered.
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.
To apply for this job please visit tinyurl.com.