Financial Analyst

Financial Analyst

Vernon Hills, IL

Reporting directly to the Director of Finance, the Financial Analyst will play a key role in financial planning, operational support, and business intelligence. This position will be responsible for collating and transforming data from multiple ERP and operational systems into trusted information, including financial models, forecasts, analyses, and decision-support tools.

The role will build financial models from scratch, validate data integrity, create dashboards and ad-hoc reports as needed to support the business, and develop actionable insights despite incomplete or inconsistent data. Success in this role requires intellectual curiosity, skepticism of data that does not reconcile, attention to detail, strong problem-solving skills, and the ability to independently identify, investigate, and resolve data quality issues.

The position sits at the intersection of FP&A, accounting, data analytics, and financial systems and will play a key role in supporting business growth, acquisitions, and strategic decision-making.

Advanced Excel skills, and experience with ERP systems (e.g., Net Suite, Sage X3, Quickbooks) and reporting/analytics tools (SQL, Microsoft Power BI, Fabric) is required.

• Build and maintain financial models from the ground up to support budgeting, forecasting, long-range planning, profitability analysis, scenario modeling, and strategic initiatives.
• Perform complex ad hoc analyses to support business decisions, operational initiatives, and executive leadership requests.
• Analyze financial and operational performance, identify trends and drivers, and provide actionable recommendations.
• Support annual budgeting, monthly forecasting, and long-term planning processes.
• Develop business cases and ROI analyses for strategic investments and operational initiatives.

• Integrate data from multiple ERP, accounting, operational, and third-party systems into a unified financial reporting and modeling environment.
• Design scalable financial models that combine financial and operational data into meaningful business insights.
• Create data mapping, transformation, and validation processes to improve consistency and usability of financial information.
• Develop and maintain advanced Excel-based models utilizing Power Query, data connections, and complex formulas.
• Leverage SQL and other data tools to extract, transform, validate, and analyze large datasets.

• Own the integrity of financial and operational datasets used for management reporting, forecasting, and analysis.
• Ensure all financial models, forecasts, analyses, and dashboards reconcile to source-system reports, general ledger balances, and approved financial statements.
• Investigate discrepancies between systems, reports, and analyses and determine root causes.
• Establish controls, validation checks, and reconciliation processes to ensure data accuracy and reliability.
• Document assumptions, methodologies, and data sources to improve transparency and auditability.
• Partner with finance and business teams to improve data quality, automation, and reporting efficiency.

• Identify opportunities to improve reporting efficiency, reduce manual processes, and enhance financial data quality.
• Participate in ERP implementations, acquisitions, system integrations, and finance transformation initiatives.
• Collaborate with cross-functional teams to improve reporting processes and establish a trusted source of financial data.
• Support the development and maintenance of dashboards and reporting tools used by finance and operational leadership.

• Ba…