Senior Finance Data Analyst - Chicago, IL

Archer-Daniels-Midland

  • Chicago, IL
  • $90,000-110,000 per year
  • Permanent
  • Full-time
  • 6 days ago
Department/FunctionInvestor RelationsJob DescriptionSenior 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
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.REF:101247BRRef ID#LI-NA1About ADMAt ADM, we unlock the power of nature to provide access to nutrition worldwide. With industry-advancing innovations, a complete portfolio of ingredients and solutions to meet any taste, and a commitment to sustainability, we give customers an edge in solving the nutritional challenges of today and tomorrow. We're a global leader in human and animal nutrition and the world's premier agricultural origination and processing company. Our breadth, depth, insights, facilities and logistical expertise give us unparalleled capabilities to meet needs for food, beverages, health and wellness, and more. From the seed of the idea to the outcome of the solution, we enrich the quality of life the world over. Learn more at www.adm.com.#IncludingYouDiversity, equity, inclusion and belonging are cornerstones of ADM's efforts to continue innovating, driving growth, and delivering outstanding performance. We are committed to attracting and retaining a diverse workforce and create welcoming, truly inclusive work environments - environments that enable every ADM colleague to feel comfortable on the job, make meaningful contributions to our success, and grow their career. We respect and value the unique backgrounds and experiences that each person can bring to ADM because we know that diversity of perspectives makes us better, together.We welcome everyone to apply. We are committed to ensuring all qualified applicants receive consideration for employment regardless of race, color, ethnicity, disability, religion, national origin, language, gender, gender identity, gender expression, marital status, sexual orientation, age, protected veteran status, or any other characteristic protected by lawBenefits and PerksEnriching the quality of life for the world begins by taking care of our colleagues. In addition to competitive pay, we support your diverse needs with a comprehensive total rewards package to enhance your well-being, including:
  • Physical wellness - medical/Rx, dental, vision and on-site wellness center access or gym reimbursement (as applicable).
  • Financial wellness - flexible spending accounts, health savings account, 401(k) with matching contributions and cash balance plan, discounted employee stock purchasing program, life insurance, disability, workers' compensation, legal assistance, identity theft protection.
  • Mental and social wellness - Employee Assistance Program (EAP), Employee Resource Groups (ERGs) and Colleague Giving Programs (ADM Cares).
Additional benefits include:
  • Paid time off including paid holidays.
  • Adoption assistance and paid maternity and parental leave.
  • Tuition assistance.
  • Company-sponsored training and development resources, such as LinkedIn Learning, language training and mentoring programs.
*Benefits may vary for bargained locations, confirm benefit eligibility with your recruiter.Base pay offered may vary depending on multiple individualized factors, including market location, job-related knowledge, skills, and experience. Hourly and salaried non-exempt employees will also be paid overtime pay when working qualifying overtime hours.If hired, employees will be in an “at-will position” and the Company reserves the right to modify base pay (as well as any other discretionary payment or compensation program) at any time, including for reasons related to individual performance, Company or individual department/team performance, and market factors.The pay range for this position is expected to be between:$90,000.00 - $110,000.00

Archer-Daniels-Midland