Consolidation Lead

Spencer Ogden; Boca Raton (FL); On-site; USD 120,000 - 180,000; Full time

Job summary

Spencer Ogden seeks a Consolidations Lead to own the global close, intercompany eliminations, and reporting for a multi-entity portfolio in a high-demand environment.

You will collaborate with FP&A, Financial Reporting, Tax, IT, and Audit to deliver accurate, timely statements, ensure SOX readiness, and drive continuous improvement in consolidation processes using Oracle EPM and ERP tools.

Qualifications

• Bachelor's degree in Accounting or Finance.
• 5+ years of progressive accounting experience or 3+ years in public accounting with Big Four preferred.
• CPA or CPA-eligible preferred.
• Strong consolidation accounting experience in a multi-entity environment with Oracle knowledge.

Responsibilities

• Run the consolidated close for multiple entities and ensure timely reporting.
• Review intercompany eliminations, balance sheets, and income statements monthly.
• Coordinate with FP&A, Tax, IT, and Audit on close deliverables and SOX readiness.
• Maintain finance master data, entity hierarchies, and reporting structures.
• Support acquisitions, new entity setups, and portfolio reporting changes.
• Identify opportunities to automate and strengthen close processes using Oracle tools.

Tools

Oracle ERP

Oracle EPM FCCS

Oracle ARCS

Oracle EDMCS

Smart View

Job description

The Consolidations Lead will be key point of contact for consolidation, reporting, financial master data, and system-related questions assist with the consolidated corporate accounting close. This role is responsible for supporting accurate, timely, and well-controlled consolidated financial results across legal entities, portfolios, and reporting dimensions.

The role works closely with FP&A, Operations, Financial Reporting, Technical Accounting, Revenue Accounting, Project Accounting, Corporate Accounting, Tax, Treasury, IT, and other cross-functional stakeholders to support the monthly and quarterly close, internal reporting deliverables, financial statement support, SOX readiness, audit requirements, and finance transformation initiatives.

As the Consolidation Lead, you will:

Perform the Consolidation & Corporate closing procedures, such as:

• Manage the consolidated corporate accounting close process and related timelines.
• Ensure correct intercompany balances are reflected at the end of each month.
• Review balance sheet and income statement intercompany eliminations on a monthly basis.
• Review monthly and quarterly financial statements for a subset of corporate entities with a high volume of intercompany balances.
• Review journal entries for accuracy, completeness, and appropriate support.
• Support foreign currency accounting, entity ownership changes, acquisitions, reorganizations, and other complex transactions impacting consolidation.
• Research and resolve consolidation variances, data issues, and unusual financial statement fluctuations.

Support internal reporting and financial statement reporting through:

• Providing and supporting monthly and quarterly deliverables for Financial Reporting team.
• Prepare and review supporting schedules, analysis, and reporting packages for management, executive leadership, auditors, and other stakeholders.
• Drive consistency and accuracy in internal reporting across legal entities, portfolios, lines of business, projects, and corporate reporting structures.

Perform Financial analysis, such as:

• Quarterly analytics at a consolidated level, including key balance sheet items and any significant fluctuations and business drivers.
• Prepare year-to-date variance analysis at the consolidated level, including analysis of actual results against prior periods, forecasts, budgets, and other relevant benchmarks.
• Maintain audit-ready support for quarterly analytics, consolidated flux analysis, YTD variances, and related explanations used in internal and external reporting deliverables.

Oversee Financial Systems, Master Data & Governance through:

• Acting as a key point of contact for consolidation, reporting, financial master data, and system-related questions.
• Maintaining complete knowledge of the Company's financial master data, including dimensions, legal entity hierarchies, cost centers, lines of business, ledgers, projects, chart of accounts, ownership structures, reporting hierarchies, and related metadata.
• Designing, managing, and maintaining portions of the consolidation and reporting system, including entity structures for various portfolios and appropriate financial reporting hierarchies.
• Working with system administrators and Finance Transformation teams to ensure accurate entity setup and appropriate flow of financial data into consolidated financial statements and management reporting.
• Serving as a finance subject matter expert for Oracle ERP and Oracle EPM, including FCCS, ARCS, EDMCS, Smart View, and related reporting and reconciliation processes.
• Supporting acquisitions, new entity setup, organizational changes, new projects, legal entity changes, and portfolio reporting changes through proper master data and reporting structure design.
• Identifying opportunities to automate, standardize, and strengthen close, consolidation, reconciliation, and reporting processes using Oracle ERP/EPM functionality.

Perform specific financial and consolidation-specific controls, SOX & Audit Support such as:

• Owning, supporting, and enhancing SOX controls related to the accounting close, consolidation, intercompany eliminations, financial reporting, journal entries, system data flows, and master data governance.
• Developing, maintaining, and improving documentation, process narratives, controls, reconciliations, and audit-ready support for consolidation and reporting activities.
• Supporting deliverables for external auditors during quarterly reviews and annual audits.
• Maintaining strong control discipline over financial reporting, system data flows, journal entries, eliminations, and master data governance.

Other responsibilities, such as:

• Assist with special projects on an ad hoc or as-requested basis, including acquisitions, system implementations, reporting improvements, and process transformation initiatives.
• Partner effectively with cross-functional teams to resolve issues, improve processes, and ensure timely reporting deliverables.
• Perform other duties as required.

Qualifications:

• Bachelor's degree in Accounting or Finance.
• 5+ years of progressive accounting experience or 3+ years in public accounting, with Big Four experience preferred, plus relevant industry experience.
• High attention to detail and accuracy, with strong organizational skills.
• Ability to multi-task and work independently, as well as collaboratively within a team environment.
• Experience working under tight deadlines and producing timely, accurate deliverables.
• CPA or CPA eligible preferred.
• Strong consolidation accounting experience in a multi-entity environment, with preference to Oracle cloud knowledge/experience more specifically on areas listed below:

Oracle ERP

• General Ledger, ledgers, legal entities, chart of accounts, cost centers, projects, transaction data flows, and accounting impacts.

Oracle EPM / FCCS

• Consolidation processes, entity hierarchies, ownership structures, intercompany eliminations, reporting dimensions, Smart View, and consolidated reporting.

Oracle ARCS

• Account reconciliation processes, data integrations, reconciliations, exception management, and close control support.

Oracle EDMCS

• Enterprise data management, master data governance, dimension maintenance, hierarchy management, mappings, approvals, and downstream impacts.

Master Data & Dimensions

• Complete knowledge of Company dimensions, legal entity hierarchies, cost centers, lines of business, ledgers, projects, chart of accounts, portfolios, and reporting structures.