TRD Fall Commercial Intern

Cagayan State University; California; On-site; USD 56,000 - 92,000; Part time

Job summary

Cagayan State University in California seeks a part-time Finance/Analytics intern to support budget tracking, variance analysis, and cost reporting. You will pull data from internal and third-party sources, build recurring reports, and prepare materials for leadership reviews.

You will gain hands-on experience in budget analysis and commercial planning, with exposure to cross-functional partners across Sponsorship, Finance, Manufacturing, Customer Racing in a fast-paced environment.

Qualifications

• Enrolled in a bachelor's degree program in finance, accounting, business, economics, or analytics.
• Rising junior or senior with GPA at least 3.0.
• Proficient in Excel (pivot tables, lookups, basic modeling) and PowerPoint.
• Exposure to Power BI/Tableau/SQL is a plus.
• Strong written and verbal communication; able to present to small groups.
• Detail-oriented with strong organization and ability to manage deadlines.
• Available for 24 hours/week on-site in California.

Responsibilities

• Support budget tracking and variance analysis.
• Prepare cost reports and assist with cost-per-unit, program cost, and expense roll-ups.
• Build and maintain recurring financial and commercial reports for leadership review.
• Pull, clean, and reconcile data from internal systems and third-party sources.
• Conduct business research on market trends, competitive activity, and industry 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 internal reviews and leadership meetings.
• Maintain trackers and documentation for ongoing commercial initiatives.
• Support ad hoc analysis requests from Commercial Operations leadership.
• Document and improve repeatable processes, including templates, report automation, and data definitions.

Skills

Budget tracking

Variance analysis

Data analysis

Excel

PowerPoint

Communication

Attention to detail

Education

Bachelor's degree in Finance, Accounting, Business, Economics, or Analytics (pursuing)

GPA 3.0+

Tools

Power BI

Tableau

SQL

Job description

Your Role

Here's what you will be doing:

• Support budget tracking and variance analysis; monitor spending against plan and flag deviations.
• Prepare cost reports and assist with cost-per-unit, program cost, and expense roll-up analysis.
• Build and maintain recurring financial and commercial reports for leadership review.
• Pull, clean, and reconcile data from internal systems and third-party sources.
• Conduct business research on market trends, competitive activity, and industry 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 internal reviews and leadership meetings.
• Maintain trackers and documentation for ongoing commercial initiatives.
• Support ad hoc analysis requests from Commercial Operations leadership.
• Document and improve repeatable processes, including templates, report automation, and data definitions.

About You

The company is looking for:

• Currently enrolled in a bachelor's degree program; Finance, Accounting, Business, Economics, or Analytics preferred.
• Rising junior or senior with a minimum 3.0 GPA.
• Proficient in Microsoft Excel, including pivot tables, lookups, and basic financial modeling.
• Proficient in Microsoft PowerPoint.
• Exposure to data analytics tools such as Power BI, Tableau, or SQL is a plus, but not required.
• Strong written and verbal communication skills with the ability to present information to a small group.
• Detail-oriented and organized, with the ability to manage multiple deadlines with limited supervision.
• Available to work 24 hours per week on-site during the academic year.
• Must be located in California.

Compensation & Benefits

• Annual base salary range: $56,400.00 - $91,700.00.

Training & Development

• Hands-on experience in budget analysis, cost reporting, and commercial financial planning.
• Practical analytics and business reporting experience using live company data.
• Direct exposure to cross-functional partners across Sponsorship, Finance, Manufacturing, Customer Racing, and other areas.
• Experience supporting business decisions through financial and commercial analysis.
• Opportunity to present work and findings to Commercial Operations leadership.
• Exposure to the automotive and motorsports industry within a fast-paced, performance-driven environment.