FINANCE DATA ANALYST
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
2. 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
3. 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
4. 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
5. 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
6. 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