Financial Analyst, FP&A jobs in Gary, IN

National Material Company (NMC) was established in 1964 and is considered a leader in metals sales, processing and supply-chain management solutions. Servicing the needs of the steel and rolled aluminum industry, NMC supports prominent industrial and consumer product manufacturers across a wide variety of industries. National Material Processing (NMP) is the toll processing company operating alongside NMC. For further information, please see the Company’s website, www.nationalmaterial.com.

The Financial Analyst position will be responsible for reporting/analysis on the performance of National Material Company’s US steel service center and processing businesses based in East Chicago, IN.

Duties and Responsibilities:

Direct Steel Sales Business Unit Responsibilities (approximately 50% time allocation):

• Perform various revenue, cost of goods sold and margin analysis
• Create required templates and lead the collection/consolidation of quarterly forecast volume projections
• Participate in the development of overall quarterly forecast and annual operating plan projections of the income statement and balance sheet and other requirements as well as lead development of new tools/procedures to drive consolidation/reporting efficiencies
• Support development of and reporting requirements for Annual Plan, quarterly forecasts as well as monthly/quarterly division financial reviews and presentations to senior management
• Provide analytical support for customer pricing and develop tools to monitor actual performance vs quote expectations
• Complete variance analysis on key P&L and Balance Sheet accounts vs AOP/Forecast and Prior Year projections/results
• Provide sales and gross margin analysis by customer and sales person. Provide periodic reports to management and sales team
• Management/distribution of daily margin, price variance reports, including potential to develop/improve reporting processes via use of new tools such as Tableau
• Develop new ROWC reporting models to be updated and completed consistently and efficiently. Utilize new technology to improve the process
• Complete adhoc analysis as required

Toll Processing Responsibilities (approximately 50% time allocation)

• Create required templates and lead the collection/consolidation of quarterly forecast volume projections.
• Participate in the development of overall quarterly forecast and annual operating plan projections of the income statement and balance sheet and other requirements as well as leading development of new tools/procedures to drive efficiencies
• Contribute to customer profitability reporting for toll processing businesses key accounts and maintain cost/quoting models
• Lead specific expense line review and cost analysis with Plant Management teams to support cost reduction initiatives and expense controls
• Continue development of daily invoice reporting process and improve efficiency
• Complete capital project analysis and IRR calculations when applicable
• Complete adhoc analysis as required
• Occasional travel to steel processing locations in the Chicagoland and Northwest Indiana areas

Education and Experience:

• Bachelor’s degree in accounting, Finance or Business. Candidates with accounting or analytic experience without a bachelor’s degree will also be considered
• Manufacturing experience a plus
• Microsoft Dynamics (AX) ERP experience preferred
• 1-3 years of experience in accounting, internal controls, financial reporting, financial budgeting/planning and analytical projects

Knowledge, Skills, and Abilities:

• Intermediate to Advanced Excel skills (pivots, vlookups, hlookups, xlookups, arrays, IFS, references, etc.)
• Ability to navigate large data sets
• Familiar with the latest technical accounting pronouncements
• Deadline-oriented
• Team player
• Organized, efficient and attention to detail
• Strong interpersonal, oral and written skills