Business Analyst Summer Intern

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 SummaryThe 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 DutiesParticipate in meetings with Directors, Project Managers, and Group Leads to understand reporting needsAssist in gathering, cleaning, and preparing data from Oracle Analytics Cloud (OAC) and MS Project for reportingSupport the design, development, and testing of Power BI dashboards focused on CPI and SPI metricsCollaborate with the COO Business Analyst to document data sources, data flows, and reporting logicPerform basic data validation and quality checks to ensure accuracy and consistencyHelp translate analytical findings into clear, concise summaries for internal customersContribute to process documentation, workflow diagrams, and presentation materialsAssist with general business analysis tasks as assignedBasic QualificationsHigh School GraduateDemonstrated interest in Business, Economics, Communication, or Data AnalysisProficiency with Microsoft Office 365 tools or similar (Outlook, Word, PowerPoint, Excel, Access)Enjoys tackling and solving problemsStrong written and verbal communication skillsAbility to work independently and collaboratively in a professional environmentPreferred QualificationsHigh School Graduate with some university-level coursework in business, economics, data analytics, or a related disciplineAdvanced proficiency in Microsoft Office 365, especially ExcelBasic coding or scripting experience (e.g., Python, SQL, VBA)Experience using Power BI or other data visualization toolsFamiliarity with project management concepts or tools (e.g., MS Project)Required DocumentsResumeCover Letter Hiring Range $19.00 - $21.25 Per HourThe 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 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 atAdditionally, 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