Senior Finance Data Analyst - Chicago, IL

Job Description

Senior Finance Data Analyst - Chicago, IL
ADM Investor Services, Inc.

Position Summary:
The Senior Financial and Data Analyst will drive high-impact financial insights and reporting by building robust models and interactive dashboards to inform strategic decisions across the business. The role combines end-to-end FP&A support with data engineering-lite responsibilities, leveraging advanced Excel and very strong Power BI to translate complex data into actionable recommendations. The ideal candidate is highly analytical, detail-oriented, and comfortable interfacing with senior leadership and internal partners and stakeholders in a fast-paced financial services environment. This is a full-time, exempt position based in Chicago, IL, reporting directly to the Finance Director -FP&A, Financial Information Systems & Project Management.

Job Responsibilities:

• Own development of interactive Power BI dashboards and semantic models (Power Query/M, DAX) for executive and operational reporting, enabling drill-through analysis and automated refresh across multiple data sources.
• Build and maintain advanced Excel financial models, scenario analyses, and rolling forecasts; optimize with dynamic arrays, Power Pivot, and VBA where appropriate.
• Partner with Finance, Treasury, Risk, and Business leaders to deliver monthly forecast packages, variance analysis, KPI tracking, and management reporting aligned to strategic and capital allocation frameworks.
• Design standardized data pipelines to ingest, cleanse, and transform finance and operational data for analysis (Power Query, dataflows; familiarity with SQL a plus) to improve accuracy, timeliness, and governance.
• Lead ad hoc deep dives on profitability, pricing, liquidity, and productivity; synthesize findings into concise executive materials and board-ready visuals.
• Monitor and operationalize key metrics including revenue/volume drivers, margin, cost-to-serve, and working capital; propose corrective actions and track outcomes.
• Collaborate with IT, Accounting, Risk/Operations and Treasury on data integrity, reconciliations, and exception monitoring; build alerting and control views in Power BI to improve oversight.
• Support budget/plan cycles and 5-year outlooks with scalable modeling templates and driver-based planning approaches.
• Document data lineage, calculations, and definitions; promote a consistent KPI dictionary and self-service reporting culture

• Bachelor’s degree in Finance, Accounting, Economics, Data Analytics, Engineering, or related field; 4–7+ years of progressive experience in FP&A, corporate finance, risk/operations analytics, or similar analytical roles.
• Advanced Excel expertise: complex nested formulas, dynamic arrays, Pivot/Power Pivot, Power Query, advanced charting, and model auditing; VBA automation experience preferred.
• Very strong Power BI skills: data modeling with star schemas, DAX measures, M/Power Query transformations, parameterization, row-level security, dataflows, incremental refresh, and performance tuning.
• Proven ability to translate business questions into analytical frameworks and executive-ready narratives; exceptional storytelling and visualization.
• Experience integrating and reconciling data across ERP, trading, risk, or operations systems; familiarity with SQL helpful.
• Strong communication and stakeholder management skills; comfortable operating in fast-paced environments and managing competing priorities.

• MBA, CFA, CPA, or relevant analytics certifications (e.g., Microsoft Power BI Data Analyst Associate).
• Exposure to capital planning/forecasting, liquidity analysis, or risk analytics in financial services, commodities, or trading environments.
• Experience with SharePoint, Office 365, and collaboration workflows supporting report distribution and governance

Before applying for an exempt, non-exempt or hourly job opportunity, you are expected to initiate a discussion and share your intentions with your supervisor.  * If you’ve been in your current position for more than 18 months, supervisor approval is not required.  * If you’ve been in your current position for less than 18 months, verbal supervisor approval is required.  
​Hiring Manager-  Enrique Rodriguez   ​
Recruiter-  Monte Washington

City

Chicago

State

IL - Illinois

Location Country

United States

About ADM

At ADM, we unlock the power of nature to provide access to nutrition worldwide. With industry-advancing innovations, a complete portfolio of ingredi