Data Warehouse Bachelor's Intern
Navigating the Hiring Process
We're here to support you!
Having trouble with your account or have questions on the hiring process?
Please visit the FAQ page on our website for assistance.
Need help with your computer and browser settings?
Please visit the Technical Information page for assistance or reach out to the web manager at kp-hires@kp.org.
Do you need a reasonable accommodation due to a disability?
A reasonable accommodation is any modification or adjustment that enables you to fully participate in completing the following:
- Online Submissions
- Pre-Hire Assessments
- Interview Process
Please submit your accommodation request and an HR Representative will contact you.
2025 Summer Internship Program
Location:
This role is scheduled to be 100% remote. While remote, finalists MUST reside in a one of the following states to be eligible for employment with Kaiser Permanente: CA, CO, DC, GA, HI, MD, NY, OR, VA, or WA.
Department Description:
The Membership Data Warehouse is the System of Information for Reporting and Analytics Data across the Enterprise of Kaiser Permanente. Our team uses Informatica Power Center to perform Extract, Transform and Load from source systems to our Oracle Exadata Warehouse platform. We acquire the data from multiple sources, we harmonize the data into easy-to -use tables and views, and we create extracts that go outside of our firewall to Vendor partners. We also assist internal Cloud and other Information Technology teams to pull data into their systems.
Intern Project(s):
Revamping website and writing Data Literacy documentation
Analyzing and profiling data to perform engineering tasks under the guidance of a Lead Engineer.
Report, Dashboard, and/or Extract creation.
Target Majors:
Math/Statistics; Data Science; Computer Science
Target Skills:
End-to-end Data Warehousing understanding
Oracle Database understanding, Exadata usage preferred
Informatica Power Center familiarity
SQL query scripting language used to interrogate and learn from data
Job Summary:
Lay the groundwork for a dynamic future with an industry leader. At Kaiser Permanente, you'll forge lasting relationships with colleagues across the organization while enjoying the opportunity to grow your experience and hone your expertise on assignments that have real impact. Our interns have worked on everything from analyzing financial software and developing new marketing strategies, to designing mobile apps and helping clinicians improve care delivery. We want you to get the most out of your time here and will give you projects that challenge you to think freely, question thoroughly, and explore deeply.
Essential Responsibilities:
- Contributing to a designated project or initiative to meet a KP business objective.
- N/A
- High School Diploma or General Education Development (GED) required.
- Pursuing a bachelors degree or have graduated with a Bachelors degree from an accredited university within the last year.License, Certification, Registration
- N/A
- Aptitude to perform data and process analytics and formulating solutions
- Proven ability to build effective working relationships as well as strong interpersonal skills
- Working knowledge of MS Word, Excel, PowerPoint.
- 3.0 GPA or above
- Advanced analytical and problem-solving skills
- Proven ability to build effective working relationships as well as strong interpersonal skills
- Excellent verbal and written communication skills
- Ability to learn quickly and experience producing high quality work in short periods of time.
- Required skills: Excellent analytical skills, experience with database programming, know SQL, experience or knowledge of Unix. Any Oracle Data base
Kaiser Permanente is an equal opportunity employer committed to a diverse and inclusive workforce. Applicants will receive consideration for employment without regard to race, color, religion, sex (including pregnancy), age, sexual orientation, national origin, marital status, parental status, ancestry, disability, gender identity, veteran status, genetic information, other distinguishing characteristics of diversity and inclusion, or any other protected status. Submit Interest
