Finance Data Analyst

Position Details

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

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.

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