Position Financial Analyst Intern 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 Financial Analyst to join our PowerDrive System business unit team. The financial Analyst will be responsible for supporting both our global supply chain and finance teams through the analysis of complex pricing data, presenting data withing usable formats, preparing price impact reports, communicating, and ensuring standardization across various global reporting units. The candidate will utilize their skills to monitor and support our internal BorgWarner Supplier Liability Price Adjustment System and corresponding reporting. Key responsibilities + Facilitates monthly supply chain forecasts, annual budget and corresponding variance analysis + Works collaboratively with global supply chain and finance team members to collect and review data for accuracy and consistency + Ensures compliance with supply chain and financial reporting policies and procedures + Integrates data from multiple data sources into relevant reports + Provides support at month and quarter end by consolidating and reconciling relevant reports. + Prepare the monthly journal entry to record intercompany charges from corporate + 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 What we’re looking for + Intermediate level skills within Microsoft Excel required (VLookup, if statements, pivot tables, ability to data mine and compare large data sets and research issues) + Applicant must have excellent quantitative skills and extremely detail oriented with an interest in mining large data sets for accuracy and consistency + Exceptional analytical and problem-solving skills, with an ability to produce under pressure and manage multiple competing deliverables + Ability to take initiative to develop and implement new projects and process to improve forecast accuracy and supporting data trends + Self-driven individual, ability to work independently as well as with global team members + Strong written and verbal communication skills + Schedule flexibility to support global team members within other regions as needed (Americas, Europe & Asia) 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. 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 (https://www.borgwarner.com/legal/privacy-policy-for-online-applications) , 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.