FINANCE DATA ANALYST
3 days ago
Cincinnati
Job Description 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 1. 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 1. 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 1. 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 1. 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 1. 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 1. 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 KEY POWER BI DELIVERABLES — SCOPE SUMMARY DOMAIN REPORT / DASHBOARD KEY METRICS Treasury 13-Week Rolling Cash Flow Weekly net cash, inflow/outflow by category, vs. forecast Treasury Daily Cash Position Bank balances, intraday movement, liquidity headroom AP AP Aging & DPO Dashboard Aging buckets, DPO trend, on-time payment rate AP Vendor Recon Exception Tracker Matched/partial/exception counts, aging, AP owner status AP Spend Analysis Disbursements by vendor, cost center, GL account AR AR Aging & DSO Dashboard Aging buckets, DSO trend, credit limit utilization AR Collections Intelligence Promise-to-pay, dispute status, collector effectiveness FP&A P&L Variance Report Actuals vs. budget/forecast, waterfall, commentary FP&A Business Line P&L Margin by segment, volume/price/mix bridge FP&A Working Capital Dashboard CCC = DSO + DIO − DPO, trend and alert thresholds 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