Financial Analyst 2

Job Description:

Business Description:

ITW (Illinois Tool Works Inc.) is a Fortune 200 company and is one of the world's leading diversified manufacturers of specialized industrial equipment, automotive components, consumables, and related service businesses. ITW businesses serve local customers and markets around the globe, with operations in 55 countries and an employee base of more than 46,000 women and men who adhere to the highest ethical standards. These talented individuals, many of whom have specialized engineering or scientific expertise, contribute to our global leadership in innovation. We are proud of our broad portfolio of more than 17,000 granted and pending patents.

ITW Shakeproof Fasteners supplies cold-headed & metal-stamped fasteners totaling approximately $200M in revenue annually. Manufacturing / distribution locations include Watertown, WI, Milwaukee, WI, Machesney Park, IL, Broadview, IL, Elgin, IL, and Iron Ridge, WI. We serve major OEMs and their tier suppliers direct and through distribution channels in the industrial market. ITW Shakeproof Fasteners drives profitability by leveraging its innovative solutions and application engineering, allowing us to enhance our customers' competitive advantage.

Position Summary:

The Commercial Financial Analyst will be a critical role for supporting the organic growth initiatives of the Division. This role will report directly to the Division Controller. The Commercial Financial Analyst is the primary liaison between the finance and the commercial functions and will develop deep partnerships and domain expertise with the Sales team. In addition, this role will need to collaborate with other cross-functional teams including Engineering, Innovation, Operations, IT and HR, across a multi-site Division for driving growth initiatives.

Primary Duties:

• Revenue & Margin Forecasting: Drive the revenue forecasting process to develop short-term and long-term forecasts for Monthly/Quarterly Outlook, Annual Plan and Long-range Plans for the Division using existing tools such as Saphran and real time customer demand such as open orders & EDI.
• Revenue Analytics for Actionable Insights:
• Monthly and quarterly revenue analysis with meaningful variance commentary
• Analysis of Revenue by OEM, Market, $/car, Product, Region, etc.
• Sold Order Reporting: Report Division sold orders
• Sold Order Audit: Perform monthly audit of booked sold orders
• Quads & Quartiles: Prepare and maintain Quad and Quartiles reporting for the Division
• Segmentation Analysis: Strategic analysis to support appropriate Segmentation for revenues
• Price & Cost: Track Price (customer pricing) and Cost (vendor pricing of raw materials) for Shakeproof Division, track changes and margins over time to make recommendations during negotiations with customers
• KPIs & Dashboards: Develop and monitor Sales KPIs; and implement Dashboards for KPI reporting
• Support Division with ad-hoc reporting on sales margin as needed
• Participate in ITW Toolbox Initiatives within the business (FTB 80/20, USa, PLS).
• Perform other duties as assigned.

Position Skills and Experience Requirements:

To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonable accommodation may be made to enable individuals with disabilities to perform the essential functions.

• Bachelor's degree in Business, Engineering, Supply Chain, Finance, Marketing, or related field
• 2+ years progressive experience in a manufacturing environment with cross-functional exposure to commercial, operations, finance, and supply chain.
• Experience partnering with the commercial or sales organization
• Strong analytical and problem-solving skills
• Attention to detail and a high level of accuracy is a must
• Exceptional communication skills and ability to effectively communicate across various levels
• Strong computer skills: Microsoft Office (Excel, Word, PowerPoint etc.) with proficiency in MS Excel and the ability to manage large data sets using VLOOKUP's and Pivot Tables
• Ability to manage and prioritize daily functions as well as the ability to multi-task is critical
• Prior-experience with Power-BI or other BI-Dashboard tools is a plus
• Eagerness to work in a fast-paced environment that's deadline driven and focused on creating cross-functional value-added partnerships

Compensation Information:

$75,000 - $87,000 / annually

ITW is an equal opportunity employer. We value our colleagues' unique perspectives, experiences and ideas and create workplaces where everyone can develop their careers and perform to their full potential.

As an equal employment opportunity employer, ITW is committed to equal employment opportunity and fair treatment for employees, beginning with the hiring process and continuing through all aspects of the employment relationship.

All qualified applicants will receive consideration for employment without regard to race, color, sex, gender identity, sexual orientation, religion, national origin, age, disability, protected Veteran status or any other characteristic protected by applicable federal, state, or local laws.