Total Compensation Bachelor's Intern - Full-time / Part-time

divspanstrong2026 Summer Internship/strong/span/divdivspanspanFLEXIBLE: 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 from the following location: /span/spanspanspanstrong393 E. Walnut St., Pasadena, 91188./strong/span/span/divdiv /divdivspanstrongJob Summary:/strong/span/divpspanUnder supervision assists in the provision of information, maintenance of databases, report production and routine data analysis. Work is reviewed for completeness, accuracy and soundness./span/ppspanstrongDepartment Description:/strong/span/ppspanThe PHR Total Compensation Leader Compensation Team manages all aspects of physician leadership, from changes in the leader population and hierarchy to defining processes to introduce greater parity for leaders at different levels. Typical tasks include data query, summary, and audit as well as development of communication skills through PowerPoint and other means./span/ppspanstrongIntern Project Description:/strong/span/ppspanThis intern will assist with one or more process-improvement projects related to management of our physician leadership population. They may also be involved in more general operational activities within the Total Compensation team related to the onboarding and offboarding of physicians. Examples of possible projects include but are not limited to the following: /spanbrbrspan- Creation of "one-pager" documents for new physician leaders complete with FAQs and information tailored to each stipended position in the Rules and Regulations./spanbrspan- Leveraging Microsoft 360 applications to create workflows that streamline internal processes./spanbr /ppspanstrongDesired Majors:/strong/span/ppspanHuman Resources, Business Administration, Finance Accounting, Math/Statistics, Liberal Arts, Public Health, Healthcare Administration./span/ppspanstrongDesired Skillsets:/strong/span/ppspanWe are looking for someone with an analytical mindset who thinks critically about information/data being presented and is not afraid to ask questions. Someone who may not know the answers, but willing to do the research and has a good attitude toward learning new things and lending a hand to their coworkers. Eagerness to learn, willingness to do some data entry, organized, team-oriented, can-do/above-and-beyond attitude are all great attributes of a strong candidate./span/ppspanThe Total Compensation Team leverages data for a number of analytic processes including external reporting, consultations with physician leadership, and auditing. It would be a great benefit for the selected individual to be familiar with at least basic summary and search functions in Excel including vlookup/xlookup and pivot tables as well as how best to apply these functions in practice./span/pdivbrstrongEssential Responsibilities:/strong/divpExamples of project support include: Collects, prepares and tracks reports and summaries such as: budget to actual expenditures, production statistics, and utilization of services and statistical records of performance. Performs a variety of data collection and analysis assignments. Prepares ad hoc data requests as directed. Prepares and/or formats graphs, spreadsheets and reports by utilizing office software. May be asked to maintain databases on a regular basis by entering data and preparing data extracts. May extract information from different sources to compile data. Executes existing queries for established reports.  Schedules conference calls and meetings. Contributes to the development of presentations materials. Provides administrative and project support as assigned such as copying, filing, entering and extracting data. Engages in and supports project work.  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./pbr div bBasic Qualifications:/b/div div uExperience/u/div ul liN/A/li /uldiv uEducation/u/div ulliCurrent enrollment in an accredited college or university program Or recent graduate./li/uldiv uLicense, Certification, Registration/u/div ulliN/A/li/uldiv bAdditional Requirements:/b/div ulliExcellent written and oral communication skills./liliProficiency with Microsoft Office Suite - excel, word, access and PowerPoint./liliProficient with a variety of software applications./liliMust be able to work in a Labor/Management Partnership environment./li/uldiv bPreferred Qualifications:/b/div ulliKnowledge of Access and database experience desirable. /lili Prior office experience also desirable./li/ul