FINANCE DATA ANALYST
Emery-Oleochemicals-LL
- Cincinnati, Ohio, United States
- Cincinnati, Ohio, United States
À propos
FINANCE DATA ANALYST Regular Full-Time Cincinnati, OH, US
6 days ago Requisition ID: 1417
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
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
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
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
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 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 Treasury
13‑Week Rolling Cash Flow — weekly net cash, inflow/outflow by category, vs. forecast
Daily Cash Position — bank balances, intraday movement, liquidity headroom
AP
Aging buckets, DPO trend, on‑time payment rate
Matched/partial/exception counts, aging, AP owner status
Spend Analysis — disbursements by vendor, cost center, GL account
AR
Aging buckets, DSO trend, credit limit utilization
FP&A
P&L Variance Report — actuals vs. budget/forecast, waterfall, commentary
Business Line P&L — margin by segment, volume/price/mix bridge
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
#J-18808-Ljbffr
Compétences linguistiques
- English
Avis aux utilisateurs
Cette offre provient d’une plateforme partenaire de TieTalent. Cliquez sur « Postuler maintenant » pour soumettre votre candidature directement sur leur site.