FINANCE DATA ANALYST

Treasury | AP | AR | Cash Flow | Power BI | AI & Automation Full Finance Operations Scope — Analytics & Automation Function POSITION DETAILS Compensation & Benefits Department: Finance & Treasury Operations Salary Range: $75,000 – $95,000 Reports To: Director of Finance Bonus: Up to 10% annual performance bonus Location: Cincinnati, OH, Hybrid Benefits: Medical, Dental, Vision, 401(k) match Employment Type: Full-Time, Exempt Start Date: Immediate / Negotiable About The Role 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. Core Responsibilities Power BI & Reporting Infrastructure 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 Treasury & Cash Management Analytics 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 Accounts Payable Analytics & Automation 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 Accounts Receivable Analytics & Collections Intelligence 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 FP&A, Budgeting & Financial Modelling 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 Data Management, ERP Integration & Automation 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 Qualifications AREA Requirements Education Bachelor's in Finance, Accounting, Data Analytics, or Information Systems; CPA, CMA, or CTP a plus Experience 3–5 years in finance, FP&A, controller, or data analytics role; manufacturing/chemicals industry a plus Power BI Proficient in Power BI Desktop & Service; strong DAX and Power Query (M) skills required Excel Advanced Excel: financial modelling, Power Query, dynamic arrays, pivot tables, structured references SAP ECC Familiarity with SAP FI/MM/SD modules; experience with FBL1N, FBL5N, ME2M, MIRO data extraction strongly preferred Automation Tools Power Automate and/or Python (pandas) for process automation; AI Builder document processing a plus SQL Working SQL for direct queries against data warehouse or staging tables; experience with SSMS or similar Treasury / AR / AP Hands‑on experience with cash flow forecasting, AR collections reporting, or AP reconciliation processes Communication Ability to translate data findings into executive narratives; comfortable presenting to leadership Why Join Us High-visibility role with direct CFO access — your dashboards drive weekly leadership decisions Greenfield scope: you are building the analytics and automation function, not inheriting a legacy system Exposure to the full working capital and cash management lifecycle across a multi‑entity business We are an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, nati #J-18808-Ljbffr