Location: Pasadena, CA
Cap-Exempt H-1B Position — No lottery required
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, Eco