Financial Planning And Analysis Analyst

Introduction

Come move the world with us!

Wake up each day to be part of a  global movement. A movement to make an impact. A movement to go for it! A movement to provide best-in class solutions. A movement to be empowered. A movement to do the right thing.

Make AIT Worldwide Logistics the next stop on your career journey!

See what our teammates say about working at AIT Worldwide Logistics.

Overview

The FP&A Financial Analyst role will be responsible for overseeing the AIT North America sales commissions process, ensuring integrity of the underlying data that feeds into the Global Transaction Activity ("GTA") and overseeing Power BI reporting.

Responsibilities

• Forecasting Financial Performance by gathering financial data daily from multiple systems and business segments for forecasting company financial performance. Analyzes results and review with Director of FP&A before distributing to Executive Management

• Prepare Monthly Financial Reporting package which includes preparing Income Statement, Balance Sheet and Cash flow trends and comparison reports of actual, budget and proforma activity. Other schedules: Customer, Vendor, New Business, Capital Expenditures, Headcount, etc. Analyze results and review with manager and Director of FP&A before distributing to Executive Management

• Oversight of North American sales commissions calculations. This includes AIT US, AIT Canada, AIT Mexico, AIT Home Delivery. As new North American companies are acquired, gaining an understanding, and eventually absorbing sales commissions calculations.

• Ensure that all accounting entries related to sales commissions accruals are completed on a timely and accurate basis. Train others on sales commissions calculation and process to delegate and balance early month workload.

• Ensure payroll files to pay North American sales commissions are provided to HR (or Non-Trade for 1099 reps) on a timely and accurate basis.

• Develop global sales commissions calculation and process, in lockstep with Global Transaction Activity ("GTA") logic. Contribute to the finalization of GTA and ensure data points contribute to sales commission automation and reporting.

• Establish global sales commissions reporting through Power BI.

• Establish data integrity oversight to ensure data entered into operating systems flows into GTA, and sales commissions automatically to limit manual corrections and adjustments. Assist with reconciliation and efforts to ensure GTA data integrity.

• Participate in management of the annual budget process.

• Produce and deliver the Return on Sales Investment (ROSI) report monthly. Build enhancements as needed.

• Design and develop and administer new and existing Power BI reports aside from Commissions reports previously mentioned.

• Assists in performing various special projects as assigned

• Identifies opportunities to improve/refine current processes

• Ensures all reporting complies and aligns with reported financial information.

Qualifications

Education Qualifications

• Bachelor's Degree Required

Experience Qualifications

• 5+ years Multi-entity, international company experience Preferred and
• 1+ years Freight industry experience Preferred

Skills and Abilities

• Ability to develop and maintain appropriate business relationships with internal and external customers. Respond to inquiries from management, auditors and other authorities regarding the commissions/BI reporting issues. Maintain response time within 24 hours of commissions email inbox. (High proficiency)
• Possess strong analytical and quantitative skills; having the ability to analyze numbers and draw logical conclusions (High proficiency)
• Ability to plan & organize work schedule, establish workload priorities and perform assigned tasks in a timely manner (Medium proficiency)
• Must be extremely proficient with spreadsheets and database query skills (High proficiency) (SQL)
• Self-starter able to handle multiple tasks and work at a very rapid pace (Medium proficiency)
• AS400, CargoWise, Power BI, OneStream experience (Nice to have)

Other Skills We Hope to See:

• A team player who works well with others - being respectful to our teammates is a Core Value!

• A strong work ethic with an appreciation for ownership, independence, accountability, and autonomy in your role.

• Growth mindset - being passionate about your craft, always looking for ways to improve yourself and the company, being open to change and doing things differently.

• Customer service focus - we serve a wide variety of customers, both internal and external, and building relationships is a part of our culture!

What AIT Can Offer You

In addition to your base compensation, you may be eligible for a bonus based on achievement of business and/or individual performance metrics (dependent on position). Benefits offered include Medical, Prescription, Health Savings Account, Flexible Spending Accounts, Dental, Vision, Life, AD&D, Disability, Supplemental Health, Employee Support program, Paid Parental Leave, Pet Insurance, 401(k) and Tuition Reimbursement for your personal development. In addition, teammates may be eligible for up to 10 to 20 days of vacation (depending on tenure), 2 personal days, 5 sick days, 5 volunteer hours, and 6 company holidays (plus Veterans Day for Veterans) annually.

About AIT Worldwide

AIT Worldwide Logistics is a global freight forwarder that helps its customers grow by expanding access to markets all over the world where they can sell and/or procure raw materials, components, and finished goods. For more than 40 years, the America's-based supply chain solutions leader has relied on a consultative approach to build a global network and trusted partnerships in nearly every industry, including aerospace, automotive, consumer retail, food, government, healthcare, high-tech, industrial and life sciences. Backed by scalable, user-friendly technology, AIT's flexible business model customizes door-to-door deliveries via sea, air, ground, and rail-on time and on budget. With expert teammates staffing more than 100 worldwide locations in Asia, Europe, India, and North America, AIT's full-service options also include customs clearance, warehouse management and white glove services. Learn more about AIT Worldwide Logistics, our culture and core values in action here.

AIT Worldwide Logistics is an Equal Opportunity Employer - M/F/Veterans/Disabled. If you are unable to apply online due to a disability, contact Human Resources at 630-766-8300 ext 5218.