Data Analytics - SQL, SAS, Python, Databricks - Bachelor's Intern

FLEXIBLE: 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: 199 S. Los Robles Ave., Pasadena, 91101.
Job Summary:
Under supervision assists in the provision of information, maintenance of databases, report production and routine data analysis. Work is reviewed for completeness, accuracy and soundness.
Department Description:
SCPMG Clinical Analysis empowers informed decision-making through data insights and analyses for regional and national audiences. Our department provides a wide range of clinical data analyses and regulatory reporting, program evaluations across clinical conditions and specialties, medical device surveillance and analyses, evidence-based medicine services, cancer registry, and Clarity database research and user support. We are dedicated to delivering accurate, timely, and actionable information that drives excellence in health outcomes, equity, and operational efficiency across Southern California and throughout the Kaiser Permanente regions.
Desired Skills:
Basic proficiency in Python (e.g., writing simple scripts, working with dataframes, or completing introductory coursework.
Foundational knowledge of SQL, including selecting, filtering, and joining tables.
Ability to analyze and understand existing code or logic, even if written in unfamiliar languages (e.g., SAS)
Strong analytical and problem-solving skills with attention to detail.
Ability to document processes, findings, and results clearly.
Willingness to learn new tools and platforms, including Databricks, GitHub, and Power BI.
Effective verbal and written communication skills.
Ability to work collaboratively in a fast-paced, project-driven environment.
Commitment to handling sensitive healthcare data responsibly and following data governance guidelines
Project Description:
The Intern will support the Clinical Analysis department-s SAS-to-Python migration on the Databricks platform. The work will include helping inventory and assess existing SAS programs, translating SAS logic into Python/SQL/PySpark within Databricks notebooks, and validating that new workflows produce results consistent with legacy outputs. The Intern will build and test modular notebooks, apply enterprise naming and data-governance standards, document reusable patterns, and assist with integrating migrated datasets into downstream tools such as Power BI. You will also participate in Databricks onboarding, training, and migration working sessions, contributing insights and updates to the broader transition effort.
Sample Deliverables: Migrated SAS workflows rewritten in Python/SQL within Databricks notebooks, with validated output parity.
Documentation of migration steps, coding patterns, and recommendations for scaling future conversions
A small reusable library or template (e.g., starter notebook, helper functions, or testing checklist) to support analyst teams.
A brief summary of findings, challenges, and lessons learned from the migration work.

Desired Majors:
Computer Science, Math/Statistics, Data Science, Healthcare Administration, Business Administration, Public Health.

Essential Responsibilities:
Examples 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.
Basic Qualifications:
Experience

• N/A

Education

• Current enrollment in an accredited college or university program Or recent graduate.

License, Certification, Registration

• N/A

Additional Requirements:

• Excellent written and oral communication skills.
• Proficiency with Microsoft Office Suite - excel, word, access and PowerPoint.
• Proficient with a variety of software applications.
• Must be able to work in a Labor/Management Partnership environment.

Preferred Qualifications:

• Knowledge of Access and database experience desirable.
• Prior office experience also desirable.

Primary Location: California,Pasadena,199 S. Los Robles
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: Temporary
Employee Group/Union Affiliation: NUE-SCAL-01|NUE|Non Union Employee
Job Level: Entry Level
Department: SCPMG Clinical Analysis
Pay Range: $22.06 - $28.55 / 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.

For jobs where work will be performed in unincorporated LA County, the employer provides the following statement in accordance with the Los Angeles County Fair Chance Ordinance. Criminal history may have a direct, adverse, and negative relationship on the following job duties, potentially resulting in the withdrawal of the conditional offer of employment:

Consistently supports compliance and the Principles of Responsibility (Kaiser Permanente's Code of Conduct) by maintaining the privacy and confidentiality of information, protecting the assets of the organization, acting with ethics and integrity, reporting non-compliance, and adhering to applicable federal, state, and local laws and regulations, accreditation, and licensure requirements (where applicable), and Kaiser Permanente's policies and procedures.

Models and reinforces ethical behavior in self and others in accordance with the Principles of Responsibility, adheres to organizational policies and guidelines; supports compliance initiatives; maintains confidences; admits mistakes; conducts business with honesty, shows consistency in words and actions; follows through on commitments.

Job duties with at least occasional or possible access to: (1) patients, the general public, or other employees; (2) confidential protected health information and other confidential KP information (including employee, proprietary, financial or trade secret information); (3) KP property and assets, for example, electronic assets, medical instruments, or devices; (4) controlled substances regulated by federal law or potentially subject to diversion.