Fall Commercial Analytics Intern - Automotive Finance

NWU; California; On-site; USD 56,000 - 92,000; Part time

Job summary

NWU is seeking a student intern in California to support budget tracking, variance analysis, and cost reporting. You will build recurring financial reports and reconcile data from internal systems and external sources, providing insights on market trends and operational drivers.

You will present findings to leaders, collaborate across Sponsorship, Finance, Manufacturing, and Customer Racing teams, and help standardize processes and templates.

Qualifications

• Currently enrolled in a bachelor’s degree program with preferred fields (Finance, Accounting, Business, Economics, Analytics).
• Rising junior or senior with minimum 3.0 GPA.
• Proficient in Microsoft Excel (pivot tables, lookups, basic financial modeling).
• Proficient in Microsoft PowerPoint.
• Experience or exposure to Power BI, Tableau, or SQL is a plus but not required.
• Strong written and verbal communication; able to present to a small group.
• Detail-oriented and organized with multiple deadlines and limited supervision.
• Available to work 24 hours per week on-site; must be located in California.

Responsibilities

• Support budget tracking and variance analysis; monitor spending against plan.
• Prepare cost reports and assist with cost-per-unit and program cost analysis.
• Build and maintain recurring financial and commercial reports for leadership.
• Pull, clean, and reconcile data from internal systems and third-party sources.
• Conduct business research on market trends, competitive activity, and benchmarks.
• Perform data analysis to identify trends, drivers, and opportunities across commercial metrics.
• Provide analytical and reporting support for Aftermarket Accessories and Customer Racing.
• Prepare charts, summaries, and presentations for leadership reviews.
• Maintain trackers and documentation for ongoing commercial initiatives.
• Support ad hoc analysis requests from Commercial Operations leadership.
• Document and improve repeatable processes, including templates and data definitions.

Skills

Excel Pivot/Lookups

PowerPoint

Power BI

Tableau

SQL

Communication

Attention to detail

Education

Bachelor's degree in Finance/Accounting/Business/Economics/Analytics

Job description

NWU is seeking a student intern in California to support budget tracking, variance analysis, and cost reporting. You will build recurring financial reports and reconcile data from internal systems and external sources, providing insights on market trends and operational drivers.

You will present findings to leaders, collaborate across Sponsorship, Finance, Manufacturing, and Customer Racing teams, and help standardize processes and templates.