Kaiser Permanente Senior EDW| ETL Engineer in SEATTLE, Washington
Title: Senior EDW| ETL Engineer Location: WA - Seattle-Renton-GH Campus - Southwest Job Number: 172506
Explore exciting technology opportunities with our Enterprise Data Warehouse (EDW) Team! New Senior EDW & ETL Engineer Role Available with Kaiser Permanente Washington.
The work you’ll contribute in a role with Kaiser Permanente supports the health and wellness of the millions of individuals and families who turn to us for the highest quality health care. This is because each and every team member across our organization cares and is committed to providing the best care experience possible. With a purpose and mission as personal as ours, we can offer you the opportunity to build a rewarding career in an environment that supports your success.
Within our EDW organization, we’re passionate about the work we do. This Senior EDW & ETL Engineer is a critical and valuable part of our team. The Sr. Data Warehouse Engineer is a member of the Informatics EDW group which builds and supports the Enterprise Data Warehouse to deliver strategic business value to the organization. This Sr. DW Engineer will apply expert data warehousing, ETL and systems experience in maintaining and improving our Production data warehouse environment, including, but not limited to, the following activities: maintaining and optimizing production processes, implementing enhancements, upgrading tools, researching and recommending new tool opportunities, and supporting delivery teams in building robust system processes, deploying stable code and optimizing our environment.
Ideal candidates will have the following:
Expert experience with Informatica or other ETL tools
Strong experience with Unix
Strong Data Warehousing experience
Prior Tool administration experience
Prior SAS administration experience
Preferred demonstrated experience with Teradata
Experience with WhereScape is a plus Qualifications: Education Minimum Education Requirements: Bachelor's degree or equivalent combination of education and experience. Preferred Education: Bachelor's degree or advanced degree in computer sciences, mathematics, business administration, MIS, healthcare or public administration.
Knowledge/Skills Minimum Knowledge/Skills Requirements: Intermediate level experience with the following:
Requirements gathering Experience with ETL and ELT Experience with Quality Assurance and Testing in a relational database environment Experience in the implementation of end user analytical toolsets Experience working in an agile development methodology Hands-on programming and database design skills (primarily SQL and stored procedures) Experience designing Data Management processes and standards for Metadata Management, Data Architecture, Data Quality, and Data Security. Advanced level experience with the following:
Excellent analytical skills Excellent communication skills at various levels of the business. Ability to select and apply highly technical and specialized toolsets and quickly to adapt to changes and advances in technology for Data Warehousing (RDBMS, ETL, etc.), OLAP and BI systems. Strong data warehouse modeling expertise (i.e. integrated model, and star/snowflake schema data model). Subject Matter Expert (SME) in Business Intelligence/Data Warehouse (BIDW) data modelling best practices. Demonstrated experience developing measurement, business intelligence, and data warehousing solutions. Preferred Knowledge/Skills: Intermediate experience utilizing Agile methodologies for DW/BI solutions.
Experience Minimum Experience Requirements:
10 or more years of Information systems experience in a data warehouse/business intelligence, measurement or application development environment. 8 years of demonstrated experience in two or more of the following: Data analysis; requirements gathering; data modeling; ETL; ELT, quality assurance; testing of DW systems; BI reporting. Preferred Experience: 5 years of demonstrated success in multidisciplinary roles in complex data warehouse, business intelligence or measurement projects. 5 years of demonstrated knowledge of Agile DW/BI development practices.
License/Certifications Minimum License/Certifications Requirements: None Required Preferred License/Certifications: None Required
External hires must pass a background check/drug screen. Qualified applicants with arrest and/or conviction records will be considered for employment in a manner consistent with Federal, state and local laws, including but not limited to the San Francisco Fair Chance Ordinance. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, sexual orientation, gender identity, protected veteran, or disability status. Job: Information Services Bargaining Unit: WWA Admin Exempt (non-union) FTE: 1 Schedule: Full-time Shift: Day Job Days of shift: Monday - Friday Hours of shift: 8am - 5pm Travel: No Job level: Individual Contributor Job type: Standard Employee status: Regular J2W code: 1T
External hires must pass a background check/drug screen. Qualified applicants with arrest and/or conviction records will be considered for employment in a manner consistent with Federal, state and local laws, including but not limited to the San Francisco Fair Chance Ordinance. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, sexual orientation, gender identity, protected veteran, or disability status.