FINANCE DATA ANALYST

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