TRD Fall Commercial Intern

Stfrancis; California; Presencial; USD 56.000 - 92.000; Tempo parcial

Resumo da vaga

Stfrancis is offering a part-time finance internship in California. You'll support budget tracking and variance analysis, prepare cost reports, and assist with cost-per-unit and program cost analysis.

You will build recurring financial and commercial reports and pull data from internal systems and third-party sources. You will conduct market research on trends and benchmarks while performing data analysis to identify drivers and opportunities across commercial metrics.

Qualificações

• Pursuing a bachelor’s degree with minimum 3.0 GPA.
• On-site 24 hours per week during the academic year.
• Strong Excel and PowerPoint skills.

Responsabilidades

• Support budget tracking and variance analysis.
• Prepare cost reports and unit/program cost analysis.
• Build and maintain recurring financial reports.
• Pull, clean, reconcile data from internal and third-party sources.
• Conduct market trend research and industry benchmarking.
• Analyze data to identify trends, drivers, opportunities.
• Provide analytical support for Aftermarket Accessories and Customer Racing.
• Prepare charts and presentations for leadership reviews.
• Maintain trackers and documentation for initiatives.
• Support ad hoc analysis requests from Commercial Operations.
• Document and improve repeatable processes and templates.

Conhecimentos

Excel pivot tables lookups

PowerPoint

Data analysis

Communication

Formação

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

Ferramentas

Power BI

Tableau

SQL

Descrição da vaga

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.