New

Business Analyst Summer Intern

California Institute of Technology
vision insurance, parental leave, paid time off, sick time, tuition reimbursement
United States, California, Pasadena
May 26, 2026
Caltech is a world-renowned science and engineering institute that marshals some of the world's brightest minds and most innovative tools to address fundamental scientific questions. We thrive on finding and cultivating talented people who are passionate about what they do. Join us and be a part of the diverse Caltech community. Job Summary The Business Analyst Intern is an entry-level summer position designed for a motivated early-career candidate interested in business analysis, data visualization, and project performance reporting. Working directly with the COO Business Analyst and reporting to the COO Business Manager, the intern will support the development of a Power BI report that integrates data from both an Oracle Analytics Cloud (OAC) Data Warehouse and Microsoft Project. This report will provide key performance insights - specifically Cost Performance Index (CPI) and Schedule Performance Index (SPI) - to internal stakeholders such as Directors, Project Managers, and Group Leads. The role offers hands-on experience with enterprise data systems, performance metrics, and business communication. Essential Job Duties Participate in meetings with Directors, Project Managers, and Group Leads to understand reporting needs Assist in gathering, cleaning, and preparing data from Oracle Analytics Cloud (OAC) and MS Project for reporting Support the design, development, and testing of Power BI dashboards focused on CPI and SPI metrics Collaborate with the COO Business Analyst to document data sources, data flows, and reporting logic Perform basic data validation and quality checks to ensure accuracy and consistency Help translate analytical findings into clear, concise summaries for internal customers Contribute to process documentation, workflow diagrams, and presentation materials Assist with general business analysis tasks as assigned Basic Qualifications High School Graduate Demonstrated interest in Business, Economics, Communication, or Data Analysis Proficiency with Microsoft Office 365 tools or similar (Outlook, Word, PowerPoint, Excel, Access) Enjoys tackling and solving problems Strong written and verbal communication skills Ability to work independently and collaboratively in a professional environment Preferred Qualifications High School Graduate with some university-level coursework in business, economics, data analytics, or a related discipline Advanced proficiency in Microsoft Office 365, especially Excel Basic coding or scripting experience (e.g., Python, SQL, VBA) Experience using Power BI or other data visualization tools Familiarity with project management concepts or tools (e.g., MS Project) Required Documents Resume Cover Letter Hiring Range $19.00 - $21.25 Per Hour The salary of the finalist(s) selected for this role will be set based on a variety of factors, including but not limited to, internal equity, experience, education, specialty and training. As one of the largest employers in Pasadena, CA, Caltech is committed to providing comprehensive benefits to eligible employees and their eligible dependents. Our benefits package includes competitive compensation, health, dental, and vision insurance, retirement savings plans, generous paid time off (vacation, holidays, sick time, parental leave, bereavement, etc.), tuition reimbursement, and more. Non-benefit eligible employees will have access to some benefits such as onsite counseling and sick time. Learn more about our benefits and staff perks. EEO Statement We are an equal opportunity employer and all qualified applicants will receive consideration for employment without regard to age, race, color, religion, sex, sexual orientation, gender identity, or national origin, disability status, protected veteran status, or any other characteristic protected by law. Caltech is a VEVRAA Federal Contractor. To read more Equal Employment Opportunity (EEO) go to eeoc_self_print_poster.pdf. Disability Accommodations Caltech complies with the Fair Employment and Housing Act (FEHA) and the Americans with Disabilities Act (ADA). We consider reasonable accommodation measures that may be necessary for eligible applicants and employees to perform the essential functions of a position. If you would like to request an accommodation to complete this application, interview, or otherwise participate in the employee selection process, please contact Caltech Recruiting at employment@caltech.edu. Additionally, if you do not meet the basic qualifications of a role but believe you can perform the essential functions of the job with reasonable accommodation, please reach out to Caltech Recruiting at employment@caltech.edu.