FINANCE DATA ANALYST

Emery Oleochemicals LLC•Cincinnati, OH

2d•$75,000 - $95,000•Hybrid

About The Position

The Finance Data Analyst is a high-visibility, cross-functional role sitting at the intersection of Treasury, Accounts Payable, Accounts Receivable, and Financial Planning & Analysis. This position owns the design and delivery of our Power BI reporting infrastructure, leads automation initiatives across the full AP/AR/Treasury cycle, and serves as the analytical engine for the finance function — from 13-week cash flow visibility to customer aging analysis to vendor reconciliation automation. You will report directly to the Director of Finance with regular CFO exposure. The role is intentionally broad — covering the full working capital and cash management lifecycle — designed for a candidate who wants to build a modern finance analytics function rather than maintain a legacy one. If you are energized by turning messy ERP data into clean, decision-ready dashboards and by replacing manual processes with intelligent automation, this role is built for you.

Requirements

Bachelor's in Finance, Accounting, Data Analytics, or Information Systems; CPA, CMA, or CTP a plus
3–5 years in finance, FP&A, controller, or data analytics role; manufacturing/chemicals industry a plus
Proficient in Power BI Desktop & Service; strong DAX and Power Query (M) skills required
Advanced Excel: financial modelling, Power Query, dynamic arrays, pivot tables, structured references
Familiarity with SAP FI/MM/SD modules; experience with FBL1N, FBL5N, ME2M, MIRO data extraction strongly preferred
Power Automate and/or Python (pandas) for process automation; AI Builder document processing a plus
Working SQL for direct queries against data warehouse or staging tables; experience with SSMS or similar
Hands-on experience with cash flow forecasting, AR collections reporting, or AP reconciliation processes
Ability to translate data findings into executive narratives; comfortable presenting to leadership

Nice To Haves

CPA, CMA, or CTP a plus
manufacturing/chemicals industry a plus
AI Builder document processing a plus

Responsibilities

Design, build, and maintain Power BI dashboards covering the full finance lifecycle: P&L, cash flow (13-week), working capital, AP aging, AR aging, DSO/DPO/DIO KPIs, and variance reporting
Own the data model layer — DAX measures, calculated columns, star schema table relationships, incremental refresh, and row-level security
Build the 13-week rolling cash flow Power BI report: weekly cash inflows (AR collections by customer cohort), outflows (AP disbursements, payroll, debt service, capex), and net position vs. forecast
Establish report governance: naming conventions, version control, workspace access management, dataset certification, and report documentation
Deliver monthly close reporting packages with actuals, variance commentary, and trend visualization for CFO and leadership review
Train finance business partners and department heads on Power BI self-service analytics and report navigation
Own the 13-week cash flow forecast model — build, maintain, and enhance the rolling weekly forecast integrating AR receipts, AP disbursements, payroll, tax, and financing cash flows
Develop daily/weekly cash position reporting: bank balances by account, intraday liquidity monitoring, and variance to forecast dashboard
Build interest expense and debt service tracking dashboards aligned to revolving credit facility draws and repayment schedules
Model cash conversion cycle (DSO + DIO − DPO) trends and alert when working capital metrics breach threshold
Support FX exposure reporting where applicable; track intercompany settlements and cross-entity cash pooling activity
Automate bank statement reconciliation reporting and flag unposted items against SAP GL using Power Query + FBL3N data
Lead the build of the AI-assisted vendor statement reconciliation tool: Power Automate + AI Builder for PDF extraction, Python/Power Query tiered matching engine (exact, fuzzy, exception), and Power BI exception dashboard
Build AP aging dashboard: open invoices by vendor, aging bucket (0-30, 31-60, 61-90, 90+), DPO trend, and on-time payment rate KPIs
Develop parked invoice and blocked invoice monitoring reports from SAP (MR11, MRBR) to reduce month-end surprises
Automate duplicate invoice detection and vendor credit limit utilization alerts via Power Automate workflow
Build spend analysis reporting: AP disbursements by vendor, cost center, GL account, and business unit for budget owners
Track AP process KPIs: invoice cycle time (receipt to posting), first-pass match rate, exception rate, and resolution cycle time
Build AR aging dashboard: open receivables by customer, aging bucket, credit limit utilization, and dispute status — with drill-through to invoice level
Develop DSO trending report by customer cohort, business line, and region; alert when DSO exceeds contract terms or historical norms
Create collections effectiveness dashboard: promise-to-pay tracking, collector activity, dispute resolution cycle time, and bad debt provision trend
Build customer payment behavior scoring model (frequency, timeliness, average days late) to support credit review process
Automate dunning effectiveness reporting and integrate with SAP FBL5N open items for real-time collection status
Support cash application matching analysis: unapplied cash, short payments, and deduction aging by reason code
Perform actuals vs. budget/forecast variance analysis across all P&L lines; produce narrative commentary for monthly close reporting packages
Support annual budgeting cycle: aggregate departmental submissions, build consolidated model, and produce board-ready budget presentation data
Maintain rolling 12-month forecast model with scenario analysis capability (base, upside, stress) for CFO review
Build business line P&L dashboards with margin waterfall, volume/price/mix analysis, and YoY comparison
Develop cost analysis tools: freight/logistics cost per unit, raw material cost pass-through lag modeling, and overhead absorption variance
Conduct ad hoc financial deep-dives — margin compression analysis, customer profitability, working capital optimization scenarios
Extract and transform data from SAP ECC across all modules: FI (FBL1N, FBL5N, FBL3N), MM (ME2M, MIRO), CO, and SD for reporting use
Build and maintain Power Query / Python pipelines from SAP source to Power BI dataset layer; reconcile report figures to GL on a weekly basis
Develop automation routines using Power Automate and Python to eliminate recurring manual data pulls across AP, AR, and Treasury workflows
Partner with IT on data warehouse development, staging table design, and source system integration for finance reporting
Maintain data dictionary: document all metric definitions, DAX measures, data source lineage, and refresh schedules for audit and SOX compliance
Lead continuous improvement initiatives to reduce close cycle time through automation of data aggregation and report production