Commercial Financial Analyst

Job Description

COMPANY DESCRIPTION

Illinois Tool Works, Inc. (NYSE: ITW) is a Fortune 200 global industrial company centered in a differentiated business model. The company’s seven business segments leverage the 80/20 business model to generate solid growth, best-in-class margins and favorable returns in markets where innovative, customer-focused solutions are required. ITW delivers specialized expertise, innovative thinking and value-added products to meet critical customer needs in a variety of industries targeting sustainable and profitable organic growth.

Division Description

ITW’s Automotive segment designs and manufactures innovative fasteners, interior and exterior components, and powertrain and braking systems for OEMs and their top-tier suppliers. ITW’s automotive businesses have a high level of customer intimacy, enabling customer-back innovation to address complex needs such as vehicle efficiency, safety, and quality. Deep market knowledge and strong manufacturing process capabilities allow ITW’s automotive businesses to be nimble, niche problem solvers for their sophisticated customers.

The Smart Components Division drives profitability by leveraging its innovative solutions and application engineering. In addition to ITW’s industry-leading research and development capabilities, ITW Smart Components enhances our customers’ competitive advantage. Smart Components is a business group within ITW’s Automotive segment with manufacturing locations in North America. Our products are made up of housings and doors, innovative Capless solutions and charge ports for major OEMs around the world.

Job Summary

The Commercial Finance Analyst will be responsible for top line revenue forecasting and analytics for the SCNA division. This role is on the Division Controller’s staff and is the primary liaison between the Commercial and Finance functions o which this role will include dotted line reporting structure to the SCNA Sales & Engineering Director. The Commercial Finance Analyst will be a key contributor to organic growth initiatives and develop deep partnerships and domain expertise with the Commercial Group. In addition to the long-term revenue forecasting and analytics, the Commercial Finance Analyst will also be the finance lead on a full suite of commercial finance tools including volume, mix, and price analytics, discounted cash flow modeling of commercial opportunities and sold order/backlog conversion analysis.

Essential Duties And Responsibilities

• Key finance contact with management of the forecasting and planning system
• Manage the data collection and publication of Annual Plan and Long Range Plan (LRP) revenue forecasts by Business Unit
• Oversee and reconcile the monthly revenue reporting updates based on updates from market research data (i.e. IHS builds)
• Manage customer price recovery reports, forecasting, and the tracking of the material cost impact to ensure that changes in commodity pricing is continually be monitored and captured with the customer base.
• Perform analytics on the product segmentation mix to assist in the ongoing updates to the divisional Segmented Profit/Loss statement to further assess margin performance and growth opportunities
• Key Finance contact from a Commercial perspective in the development of financial models/analyses for customer quotes and participate in quote reviews
• Oversee the planning/reporting of sold orders and the impact on sales incentive plan (SIP) bonuses
• Produce insight into sold order conversion to revenue to improve overall accuracy/conversion rates
• Key Finance contact for the preparation of the Commercial Tooling budget and will provide assistance in the preparation of select capital tooling requests
• Key Finance liaison with the Commercial financial analysis (i.e. Quarterly Revenue Bridge) and other Annual Plan and LRP reports
• Recommend ways to improve, simplify, or eliminate tasks in the department
• Participate in ITW Toolbox initiatives within the business (0/20, Usa, PLS)
• Other Commercial Focused finance projects as needed
  
  

Qualifications

• Bachelor’s degree in Finance, Accounting, or Business Administration and/or related analytical field, while a Masters of Business Administration (MBA) degree is a plus
• 3-6 years commercial or finance experience in a manufacturing environment
• Experience partnering with he Commercial/Sales organization
• Excitement to work in a fast-paced environment that’s deadline driven and focused on creating a value-added partnership with operations
• Strong analytical and problem-solving skills are necessary
• Attention to detail and a high level of accuracy is a must
• Ability to manage and prioritize daily functions as well as the ability to multi-task is critical
• Exceptional written and verbal communication skills required
• Ability communicate effectively with all levels in the organization and work well within a team
• Maintain confidentiality about sensitive data such as budgeting information, operational results, and profit margin
• Administer and adhere to accounting policies and divisional procedures
• Strong computers skills; Microsoft Office (Excel, Word, PowerPoint) with proficiency in MS Excel and the ability to manage large data sets using VLOOPUP’s and Pivot Tables
• Experience with Saphran, Trans4M, QAD, and/or another AS400 based computer system is a plus
• Drive and excitement to grow and develop as a finance professional
  
  

Ability to learn new skills and the desire for upward mobility and professional growth

Compensation Information

$110k - $125k