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

6 days ago Requisition

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

FINANCE DATA ANALYST

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…