Reporting and Data Analytics Master's Intern

Job Description:

2026 Summer Intern

Location:

This internship role is scheduled to be flexible. Please be prepared to spend part of your time working remotely and part of your time working at the following address: 393 E. Walnut St. Pasadena CA 91188

Department Details

We provide Reporting and Data Analytics solutions for KP SCPMG entities and leadership. We extensively use SQL for data retrieval and consolidation and Tableau and PowerBI for the visualization. We are also transitioning our process to Databricks (Phyton, Pyspark).

Internship Projects

Intern will be involved with migration of our Tableau Dashboards to Microsoft PowerBI Business Intelligence application (SQL skill is required). An extended role could also include transition of our programs to Microsoft Databricks Cloud Platform.

Target Majors

Computer Science; Data Science; Data Analytics

Target Skillset

SQL Programing Skills

Phyton, R, C++, Java, or equivalent Programing Skills

Tableau or PowerBI Business Intelligence Tool

Job Summary

This position provides analytical support to a project or department. Under the guidance of a Project Manager/ Director, responsible for collecting and researching data, performing analysis, providing recommendations and presenting results.

Essential Responsibilities

* Responsible for contributing high level analytical support to a project or department requiring application of knowledge in marketing, information management, finance, management, economics or statistics.
* This position contributes to a full range of project components.
* Assigned to at least one project and expected to produce results and report out as a member of a project team.
* Organizes assigned project tasks, identifies and structures information collection activities, and sets timelines for completion of required tasks as directed.
* Develops tools to identify and to document best practices.
* Prepares various excel, word or PowerPoint reports, and works with access database software (or similar tool) to develop data extracts and management information reports.
* May be asked to produce graphic information using excel or PowerPoint or similar software.
* Contributes to development of management information and analysis conducted, provides recommendations and assists with preparation of formal presentations to communicate results to various management levels. Identifies alternative solutions to project issues.
* Contributes to development project plans to ensure timely deliverables and successful completion of project and demonstrates an understanding of various business intersections.
* Assists with identification and development of training information.
* Kaiser Permanente conducts compensation reviews of positions on a routine basis. At any time, Kaiser Permanente reserves the right to re-evaluate and change job descriptions, or to change such positions from salaried to hourly pay status. Such changes are generally implemented only after notice is given to affected employees.

Experience

Basic Qualifications:

* N/A

Education

* Bachelors degree required.
* Enrolled in or recent graduate of a MBA or other Masters level program with an accredited college or university.

License, Certification, Registration

* N/A

Additional Requirements

* Solid analytical skills, problem solving, project management and critical thinking.
* Strong project management skills.
* Excellent verbal and written communication skills.
* Ability to utilize at a working level Excel, Word, PowerPoint, and Access.
* Must be able to work in a Labor/ Management Partnership environment.

Preferred Qualifications

* Knowledge of SQL or SAS highly desirable