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

Job Requirements:

• 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.

Preferred qualifications

• 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

Excited about this role but don’t think you meet every requirement listed? We encourage you to apply anyway. You may be just the right candidate for this role or another one of our openings.
ADM requires the successful completion of a background check.

• 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 cultur