Finance Business Analyst

KEY RESPONSIBILITIES
• Serve as the primary Business Analyst for Finance application processes and initiatives, partnering with Accounting, FP&A, Treasury, Payroll, Operations, and technology teams to understand priorities and business outcomes.
• Analyze current-state and future-state processes for record-to-report, procure-to-pay, order-to-cash, project accounting, budgeting, forecasting, consolidation, close, and management reporting as applicable to the organization.
• Translate business needs into clear requirements, process flows, business rules, data definitions, user stories, acceptance criteria, control requirements, and implementation decisions.
• Perform functional analysis and support solution design across Microsoft Dynamics, OneStream Consolidation, finance-related integrations, and connected enterprise applications while promoting practical use of standard platform capabilities.
• Maintain requirements traceability and ensure approved business needs are carried through configuration, testing, training, release, and post-production stabilization.
• Plan and coordinate user acceptance testing, financial reconciliation, regression testing, defect review, business validation, and sign-off for application changes and implementation releases.
• Use advanced Microsoft Excel to transform and reconcile data, build dynamic financial and operational models, evaluate scenarios, identify exceptions, validate system results, and present findings clearly to business stakeholders.
• Analyze process, data, and application issues across Finance and connected systems; coordinate resolution with ERP, Integration, Application Support, vendors, and other technology resources as appropriate.
• Maintain and prioritize the Finance application backlog using business value, controls, risk, dependencies, effort, and readiness; communicate recommendations and tradeoffs when priorities conflict.
• Create and maintain process documentation, business procedures, training materials, release communications, testing evidence, and change-impact information that support adoption and reduce dependence on undocumented knowledge.
EDUCATION AND EXPERIENCE
Bachelor’s degree in finance, accounting, business, information systems, or a related field, or an equivalent combination of education and relevant professional experience. Minimum of 5 years of progressive experience in finance systems, enterprise business analysis, ERP implementation, financial transformation, accounting operations, or related consulting. Strong working knowledge of core accounting and finance processes, financial controls, data reconciliation, requirements analysis, and enterprise system implementation practices is required.
PLATFORM & TECHNOLOGY EXPERIENCE
Candidates should have strong functional experience with Microsoft Dynamics in a finance or ERP environment and meaningful exposure to OneStream Consolidation or a comparable consolidation platform. Advanced Microsoft Excel skills are required, with emphasis on data transformation, dynamic modeling, scenario analysis, reconciliation, and clear presentation of business and financial information. Expected Excel capabilities include advanced formulas and lookup logic, PivotTables/PivotCharts, dynamic arrays, Power Query or comparable transformation techniques, and development of structured models that can be updated and explained to stakeholders. QuickBooks, Sage, Power BI exposure is a nice-to-have rather than a core requirement. Familiarity with payroll/HCM platforms such as UKG and ADP and experience using an enterprise ticketing or ITSM system such as ServiceNow for requests, defects, changes, and implementation support are beneficial.
CORE COMPETENCIES Finance process and controls knowledge Business analysis and requirements definition Advanced Excel data transformation and modeling UAT, reconciliation, and release coordination
Data analysis and business-rule definition Cross-functional facilitation and prioritization Process documentation and change support Clear stakeholder communication
KEY SUCCESS MEASURES
• Quality and completeness of Finance requirements and process designs
• Accuracy of financial analysis, reconciliation, and testing
• Reduction in manual effort, rework, and data issues
• Successful UAT, release readiness, and user adoption
• Delivery of backlog priorities aligned to Finance value and controls
• Stakeholder confidence in Finance application solutions