Finance Data Analyst

If you are unable to complete this application due to a disability, contact this employer to ask for an accommodation or an alternative application process.

Regular Full-Time Cincinnati, OH, US

9 days ago Requisition

Salary Range: $75,000.00 To $95,000.00 Annually

Treasury | AP | AR | Cash Flow | Power BI | AI & Automation

Full Finance Operations Scope — Analytics & Automation Function

Department:
Finance & Treasury Operations

Salary Range: $75,000 – $95,000

Reports To:

Director of Finance

Bonus:
Up to 10% annual performance bonus

Employment Type:

Full-Time, Exempt

Start Date:

Immediate / Negotiable

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.

• 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, MR ) 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…