Data Reporting Master's Intern

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:99 S. Oakland Ave., Pasadena, 91101

Department Details:
MARS (Membership Administration Reporting Shared Service) supports Kaiser Permanente-s Membership Administration lines of business-Commercial, Medicare, Medicaid, and Individual-by delivering standardized reports and dashboards projects across the membership lifecycle. The team provides governed membership data that enables operational teams and leadership to track enrollment and eligibility, meet regulatory requirements, and support day-to-day operations and strategic planning.

Internship Projects:
Membership Open Enrollment Reporting Project
Project Overview:
The intern will support the MARS team by helping build a basic ETL workflow using Alteryx or SQL Server and build a reporting dashboard with Tableau or Power BI that tracks membership enrollment and disenrollment trends for one line of business (e.g., Commercial or Medicare).
What the Intern Would Do:
1. Assist in building or updating an ETL process (using SQL or Alteryx) to pull enrollment and eligibility data from source tables
2. Help clean and validate data by checking record counts, date ranges, and basic trends
3. Support the creation of a Power BI or Tableau dashboard showing monthly enrollment changes, net growth, and simple breakdowns (region, product, or member type)
4. Document data definitions and assumptions used in the report
5. Prepare a short presentation summarizing the dashboard, key trends observed, and lessons learned in a lesson learned
What the Intern Learns:
1. How raw membership data becomes a trusted report
2. Basics of ETL, data validation, and reporting workflows
3. How analytics supports real operational teams
4. How to explain data clearly to a non-technical audience
End-of-Summer Deliverable:
A production-ready or near-production dashboard, supporting documentation, and a final presentation to the MARS team.
Target Majors:
Computer Science; Business Administration; Math/Statistics; Finance & Accounting; Healthcare Administration; Data Science

Target Skillset:
1. Basic data skills (SQL, Excel, or coursework in data analytics or statistics)
2. Interest in data and reporting and how dashboards help teams make sense of information
3. Familiarity with BI or visualization tools (Power BI, Tableau, or similar - coursework or projects count)
4. Attention to detail and curiosity about why numbers change or don-t match
5. Ability to learn and ask good questions when requirements aren-t clear
6. Clear communication and comfort working with teammates and stakeholders
7. Basic presentation skills and willingness to explain work clearly to both technical and non-technical audiences

Job Summary:
Lay the groundwork for a dynamic future with an industry leader. At Kaiser Permanente, youll 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.
• Report development and analytics.
• Project management - planning, execution, and measurement.
• Learning new applications needed to complete assignments or support the execution of business objectives.
• Job shadowing in other functional areas.
• Performing additional duties as required.

Basic Qualifications:
Experience

• N/A

Education

• Pursuing a graduate degree or have completed a graduate program from an accredited university within the last year.
• Bachelors degree required.

License, Certification, Registration

• N/A

Additional Requirements:

• Aptitude to perform data and process analytics and formulating solutions.
• Working knowledge of MS Word, Excel, PowerPoint.

Preferred Qualifications:

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

Primary Location: California,Pasadena,Green Street/IDS
Scheduled Weekly Hours: 40
Shift: Day
Workdays: Mon, Tue, Wed, Thu, Fri
Working Hours Start: 08:00 AM
Working Hours End: 05:00 PM
Job Schedule: Full-time
Job Type: Internship
Worker Location: Flexible
Employee Status: Regular
Employee Group/Union Affiliation: NUE-PO-02|NUE|Non Union Employee
Job Level: Entry Level
Department: Bus Intelligence
Pay Range: $31.05 - $40.13 / hour Kaiser Permanente is committed to pay equity and transparency. The posted pay range is based on possible base salaries for the role and does not include the value of our total rewards package. Actual pay determined at offer will be based on years of relevant work experience, education, certifications, skills and geographic location along with a review of current employees in similar roles to ensure that pay equity is achieved and maintained across Kaiser Permanente.
Travel: No
Flexible: Work location is on-site at a KP location, with the flexibility to work from home. Worker location must align with Kaiser Permanente's Authorized States policy. Kaiser Permanente is an equal opportunity employer committed to fair, respectful, and inclusive workplaces. Applicants will be considered for employment without regard to race, religion, sex, age, national origin, disability, veteran status, or any other protected characteristic or status.