Finance Intern (Year-Round)

BorgWarner; Auburn Hills (DE); On-site; USD 20,000 - 31,000; Part time

Job summary

BorgWarner is seeking a Finance Intern to support the PowerDrive Systems finance team in Auburn Hills, MI. The role focuses on financial analysis, reporting, and process automation using AI tools to improve insights and efficiency in month-end close, forecasting, dashboards, and cost analyses.

Ideal candidates will have strong Excel skills, data analysis abilities, and an interest in AI‑assisted analytics. Collaboration with Supply Chain, Operations, and Engineering is expected.

Qualifications

• Strong Excel skills (VLOOKUP, XLOOKUP, PivotTables).
• Analytical mindset with attention to data accuracy.
• Interest in AI-assisted analysis and automation.
• Clear written and verbal communication.

Responsibilities

• Utilize AI tools to automate data preparation and analysis, and generate insights.
• Support enhancement of Power BI dashboards and analytical templates.
• Assist month-end close activities, journal entries, reconciliations, and variance analysis.
• Reconcile GL balances in SAP and OneStream; support intercompany confirmations.
• Collaborate with cross-functional teams on data-driven initiatives.

Skills

Excel

Data analysis

AI tools interest

Communication

Tools

Power BI

SAP

OneStream

Copilot/AI tools

Job description

Position

Finance Intern – PDS (Year-Round)

Location

Auburn Hills, MI

About us

BorgWarner is a global product leader in delivering innovative and sustainable mobility solutions for the vehicle market. We are a company of innovators and independent thinkers that brings together talented employees, meaningful work, and amazing technology in a unique environment. At BorgWarner we constantly work towards our vision of a clean and energy-efficient world.

Our Culture

We believe health and safety of our employees are a top priority, we care about our local communities and the global environment. BorgWarner promotes and nurtures a diverse and inclusive environment, honors integrity, strives for excellence, commits to responsibility for our communities and the environment, and builds on the power of collaboration.

Career Opportunities

We manage talent as seriously as we manage our businesses and encourage you to learn about our proud history, strong culture, technologies and future vision. We offer a strong local presence and interesting global opportunities. Start your future with BorgWarner now!

Job purpose

BorgWarner PowerDrive Systems is currently seeking a Finance Intern to join our PowerDrive System business unit team. The intern will support the Finance team with financial analysis, reporting, and process improvement initiatives. This role is ideal for a student with a good foundation in finance or accounting who is eager to leverage AI-driven tools, data analytics, and automation to improve financial insights, efficiency, and decision-making. The intern will gain hands‑on experience in a global manufacturing environment, supporting activities such as month‑end close, forecasting, dashboards, cost analysis, and ad‑hoc management reporting, while applying AI tools to streamline and enhance finance processes.

Key responsibilities

• Utilize AI tools (e.g., Copilot, ChatGPT style tools, Power BI AI features) to: Automate data preparation and recurring analysis, generate insights and explanations for financial trends and Improve efficiency in reporting and documentation

• Support enhancement of Power BI dashboards, Excel models, and analytical templates.

• Identify opportunities for process automation or standardization using AI and digital tools

• Assist with month‑end close activities, including journal entries, reconciliations, and variance analysis.

• Integrates data from multiple data sources into relevant reports

• Use SAP to prepare monthly intercompany AR confirmations and send to each reporting unit

• Reconcile GL balances in SAP and OneStream monthly

• Reconcile journal entries in journal entry tracker to entries posted in SAP

• Prepare monthly account reconciliations for prepaid assets, accrued liabilities, and intercompany receivable/payables

• Collaborate with cross functional teams (Supply Chain, Operations, Engineering) on data‑driven initiatives

What we’re looking for

• Working knowledge of Microsoft Excel (e.g., VLOOKUP/XLOOKUP, IF statements, PivotTables) and comfort working with large datasets to compare results and research variances.

• Strong quantitative aptitude and attention to detail, with an interest in checking data for accuracy, completeness, and consistency.

• Analytical and problem‑solving skills, with the ability to prioritize tasks and meet deadlines in a fast‑paced environment (with guidance and support).

• Proactive mindset and willingness to learn; able to identify improvement ideas and support small process or reporting enhancements under supervision.

• Clear written and verbal communication skills.

• Interest in AI‑assisted analysis and automation (e.g., Microsoft Copilot) and willingness to learn prompt basics, evaluation, and documentation of AI‑assisted workflows.

• Exposure to or interest in creating AI agents and automations (e.g., Copilot Studio, Power Automate, Power Apps, or similar) to streamline recurring finance tasks is a plus.

• Understands the importance of data privacy and responsible AI use when working with financial information (e.g., using approved tools, protecting confidential data).

• Coursework or interest in data analytics, business intelligence, machine learning, or finance transformation is a plus.

What we believe

• Inclusion-We value diversity in people, ideas, and experiences.

• Integrity- We believe in transparency, authenticity, and depend on each other to deliver what we promise.

• Excellence- We contribute to our developments by seeking knowledge and sharing information.

• Responsibility- We care about our local communities and the global environment.

• Collaboration- We are one BorgWarner.

Safety

This position will adhere to Global Star Safety Program, including safety rules, practices and training as outlined in the BorgWarner PTC Safety Policy Manual, which includes the use of equipment, protective devices, or clothing that the employer requires. This individual will work in manners that stress the importance of preventing accidents and illnesses. He/she must take every precaution reasonable in the given circumstance for the protection of themselves and coworkers. In addition, he/she is responsible for reporting all injuries and/or possible dangerous situations, incidents, or occurrences to the immediate supervisor.

Equal Employment Opportunity

BorgWarner is an equal employment opportunity employer such that all qualified applicants will receive consideration for employment without regard to race, color, age, religion, sex, sexual orientation, gender identity/expression, national origin, disability or protected veteran status.

Visa Sponsorship

BorgWarner does provide sponsorship for employment visa status based on business need. However, for this role, applicants must be currently authorized to work in the United States on a full‑time basis. Applicants must be legally authorized to work in the United States without the need for immigration sponsorship now, or in the future. This includes any work authorization requiring an entry of the company as the employer of record to immigration agencies, or otherwise requiring a written submission from the company to secure, maintain, transfer, or extend such authorization (e.g. H‑1B, STEM OPT, CPT, TN, E‑3, etc.)

No Unauthorized Referrals from Recruiters & Vendors

Please note that BorgWarner and any of its affiliated companies does not seek or accept unsolicited resumes or offers from third party recruiters or staffing agencies associated with any published or unpublished employment opportunities. Any unsolicited information sent to BorgWarner will be considered as unencumbered and free from any fee or charge whatsoever. Only members of our Human Resources Team have the authority to engage or authorize recruiting services, which must be agreed upon before the unsolicited resume or offer is received.

Join the company that is creating solutions that support a cleaner, more energy‑efficient world.

For more information about BorgWarner, please visit www.borgwarner.com

Internal Use Only: Indirect Hourly

Global Terms of Use and Privacy Statement

Carefully read the BorgWarner Privacy Policy before using this website. Your ability to access and use this website and apply for a job at BorgWarner are conditioned on your acceptance and compliance with these terms.

Please access the linked document by clicking here, select the geographical area where you are applying for employment, and review. Before submitting your application you will be asked to confirm your agreement with the terms.

Career Scam Disclaimer: BorgWarner makes no representations or guarantees regarding employment opportunities listed on any third‑party website. To protect against career scams, job applicants should take the necessary precautions when interviewing for and accepting employment positions allegedly offered by BorgWarner. Applicants should never provide their national ID numbers, birth dates, credit card numbers, bank account information or other private information when communicating with prospective employers or responding to employment opportunities online. Job applicants are invited to contact BorgWarner through BorgWarner’s website to verify the authenticity of any employment opportunities.