Strategic FP&A Analyst: Forecasts, Investments & Insights

ACS; Columbus (OH); On-site; USD 65,000 - 90,000; Full time

Job summary

CAS, the scientific information solutions division of the American Chemical Society, seeks a Finance Analyst in Columbus, Ohio.

You will support Divisional FP&A through financial planning, reporting, and analysis, contributing to month‑end close, budgeting, and long‑range planning, while delivering data‑driven insights to CAS leadership.

The role emphasizes ownership, high‑quality execution, and collaboration across teams to inform strategic decisions for CAS.

Qualifications

• Bachelor's degree in Finance, Accounting, or a similar business‑related field, or equivalent combination of education and experience.
• Three or more years of direct financial planning and analysis or related experience.
• Advanced Excel skills, including complex functions, financial modeling, and dashboard/report building.
• Experience with financial systems tools such as PeopleSoft and Workday Adaptive Planning.
• Experience using AI tools and Power Automate for data analysis and workflow automation a plus.

Responsibilities

• Prepare and analyze monthly forecasts to ensure accurate financial planning.
• Perform variance analysis to identify key drivers and recommend actions to improve performance.
• Translate complex financial data into clear, decision‑ready insights for Divisional and Finance leadership.
• Support ad hoc financial and strategic analysis requests from Finance and CAS leadership.
• Build financial models, dashboards, and reports using advanced Excel, AI tools, and Power Automate flows.

Skills

Advanced Excel

Financial analysis

Forecasting

Communication

Education

Bachelor's degree in Finance/Accounting or related field

Tools

PeopleSoft

Workday Adaptive Planning

Power Automate

Job description

CAS, the scientific information solutions division of the American Chemical Society, seeks a Finance Analyst in Columbus, Ohio.

You will support Divisional FP&A through financial planning, reporting, and analysis, contributing to month‑end close, budgeting, and long‑range planning, while delivering data‑driven insights to CAS leadership.

The role emphasizes ownership, high‑quality execution, and collaboration across teams to inform strategic decisions for CAS.