Finance Intern: Build Dashboards, Automate Reports (Hybrid)

BMW; Santa Monica (CA); Hybride; USD 34 000 - 44 000; Plein temps

Avantages offerts par ce poste

Medical Insurance

Paid Time Off

Hybrid work environment

Intern Vehicle Lease Program

Résumé du poste

BMW in Santa Monica offers a Spring 2027 Full-Time Internship from January 11, 2027 to May 14, 2027. You will assist project managers, support finance operations, build Excel models, write Python scripts, and develop HTML dashboards to visualize project health and financial performance.

The role requires enrollment in a bachelor's or master's program, US work authorization, a 3.0+ GPA, and 60+ credits. Hybrid work with in-office days and onsite vehicle lease benefits are available.

Qualifications

• Currently enrolled in a bachelor's or master's degree program at an accredited college or university.
• US Work Authorization required.
• Minimum cumulative GPA of 3.0 (overall, not just major).
• Completed at least 60 college credit hours at the time of application.
• Ability to work full-time (40.0 hours/week).
• Must submit an unofficial college transcript with your application.

Responsabilités

• Support project managers in planning, tracking, and reporting on active projects, including timelines, budgets, resourcing, and deliverables in Adobe Workfront.
• Support the CFO and the Project Management Manager on finance, studio operations and resource-planning tasks, including preparing reports and data visualization.
• Build and maintain Excel models using advanced formulas, pivot tables, and lookups to keep project and financial data accurate and current.
• Write Python scripts to clean, combine, and analyze data from multiple sources, and automate recurring reporting tasks.
• Develop and update HTML dashboards that give teams a clear, real-time view of project health and financial performance.
• Explore the potential of AI tools to improve efficiency, productivity, data visualization, communication, etc
• Translate tables and numbers into simple, visual takeaways for design teams, helping non-technical colleagues understand what the data means and what to do next.
• Create clear, well-structured PowerPoint presentations for project reviews, client updates, and internal leadership meetings.
• Identify opportunities to improve project management and finance processes, and help put those improvements into practice.

Connaissances

Python

Excel

Data analysis

Communication

Math

Formation

Currently enrolled in bachelor's or master's degree program

Outils

Adobe Workfront

Asana

Smartsheet

Jira

HTML/CSS

Adobe Creative Suite

Description du poste

BMW in Santa Monica offers a Spring 2027 Full-Time Internship from January 11, 2027 to May 14, 2027. You will assist project managers, support finance operations, build Excel models, write Python scripts, and develop HTML dashboards to visualize project health and financial performance.

The role requires enrollment in a bachelor's or master's program, US work authorization, a 3.0+ GPA, and 60+ credits. Hybrid work with in-office days and onsite vehicle lease benefits are available.