Skip to Main Content

Kaiser Permanente Careers

Information Technology

Sr Data Warehouse Engineer

Location: Renton, WA Additional Locations:
Job Number: 709116 Date posted: 06/09/2018
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. The Sr. DW Engineer will collaborate with product owners to plan and define requirements, and then with the implementation team to design, develop, test and maintain a high performance data warehouse environment. The DW architecture delivers BI capabilities including pre-defined, ad-hoc, dynamic reporting, OLAP analysis, and dashboards as well as data sharing interfaces with other systems.

Essential Responsibilities:

  • Design, develop, test, and support the data warehouse solution. Adapt best practices and industry standards to the Kaiser Foundation Health Plan of Washington environment, ensuring top quality deliverables and playing an integral role in cross-functional system integration.

  • As a lead member in an Agile team environment, assist and deliver EDW/BI business value as defined by a Product Owner, by providing high quality and performant EDW/BI solutions. Know the business value of your work and ensure team success in meeting sprint commitments; be flexible, show initiative and develop additional skill sets to improve team capabilities and throughput.

  • Lead and mentor other team members in DW best practices and development processes.

  • Basic Qualifications:


  • Minimum ten (10) or more years of information systems experience in a data warehouse/business intelligence, measurement or application development environment.

  • Minimum eight (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.

  • Education

  • Bachelor's degree OR a minimum four (4) years of experience in a directly related field.

  • High School Diploma OR General Education Development (GED) is required.

  • License, Certification, Registration

  • N/A


    Additional Requirements:

  • Demonstrated experience developing measurement, business intelligence, and data warehousing solutions.

  • 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.

  • Experience designing data management processes and standards for metadata management, data architecture, data quality, and data security.

  • Hands-on programming and database design skills (primarily SQL and stored procedures).

  • Requirements gathering.

  • Excellent analytical skills.

  • Excellent spoken, listening and written communication 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.


    Preferred Qualifications:

  • Five (5) years of demonstrated success in multidisciplinary roles in complex data warehouse, business intelligence or measurement projects.

  • Five (5) years of demonstrated knowledge of Agile DW/BI development practices.

  • Bachelor's degree or advanced degree in computer sciences, mathematics, business administration, MIS, health care or public administration.

  • Utilizing Agile methodologies for DW/BI solutions.

    Primary Location: Washington,Renton,Renton Administration - Rainier 2715 Naches Ave. Scheduled Weekly Hours: 40 Shift: Day Workdays: Mon-Fri Working Hours Start: 8:00AM Working Hours End: 5:00PM Job Schedule: Full-time Job Type: Standard Employee Status: Regular Employee Group/Union Affiliation: Salaried, Non-Union, Exempt Job Level: Individual Contributor Job Category: Information Technology Department: Enterprise Data Warehouse Travel: No
    Glassdoor Logo

    See What People are Saying About Working at KP

    Jan 18, 2018

    "Best place I've ever worked"

    Glassdoor Ratings

    Current Employee - Pharmacy Operations Regional Offices Manager in Downey, CA

    • Recommends
    • Positive Outlook
    • Approves of CEO

    I have been working at Kaiser Permanente full-time (More than 10 years)


    A company that consistently focuses on doing the right thing for members, patients, employees, and communities. Employees are collaborative and consensus is prized. Company's mission is progressive. Employees' quality of life is an important consideration for management. Excellent benefits.Full Review

    More Kaiser Permanente Ratings & Reviews (3,975)

    to Our

    Kaiser Permanente has been named one of the 2018 Best Places to Work. Check out what our employees like best about working at KP!

    glassdoor 2018 Best Places to Work - Employees' Choice

    Our Events

    Come introduce yourself to a member of the Kaiser Permanente team at an upcoming career or professional event. We look forward to meeting you in person.

    Recently Viewed Jobs

    You do not have any recently viewed jobs.

    Join Kaiser Permanente's Talent Network

    Please fill out the fields below and click "Join Now" to receive information about opportunities that relate to your selections.

    Interested InSearch for a category and select one from the list of suggestions. Search for a location and select one from the list of suggestions. Finally, click “Add” to create your job alert.

    • Information Technology, Renton, Washington, United StatesRemove

    Interested in internships or early career opportunities? Click here to join our University Talent Network. Are you a Veteran? Click here to join our Military Talent Network.