Finance Consolidation & Reporting Lead – OneStream/Workday

McNeil & Co.; City of White Plains (NY); Hybrid; USD 123,000 - 167,000; Full time

Benefits offered by this job

Medical plans

401k with matching

PTO 20 days

Paid holidays

Parental leave

Student loan assistance

Job summary

Arch Capital Group Ltd. in White Plains, NY seeks a Manager of Financial Consolidation to lead OneStream administration and advance cross‑system reporting (Workday to OneStream).

This role reports to the AVP of Consolidations and requires strong accounting and analytical skills. Ideal candidates have 5–8 years in accounting within insurance/financial services, a CPA, and proficiency with Excel, Power BI, and AI-enabled tools like Copilot.

Qualifications

• 5–8 years of accounting experience in insurance or financial services.
• Proficient with Excel, PowerPoint; capable of complex spreadsheets, lookups, and pivots.
• CPA required; Bachelor's degree in Accounting.
• Experience with OneStream and Workday is preferred.

Responsibilities

• Serve as OneStream administrator, managing access, COA, structures, mappings and reports.
• Support evolving financial reporting across Workday and OneStream, incl. integrations and data reconciliations.
• Prepare and analyze financial results, including flux analysis for quarterly and annual reporting.
• Partner with cross‑functional teams to resolve reporting differences and improve processes.
• Develop and maintain financial reports with clear variance explanations and actionable insights.
• Leverage AI tools (e.g., Microsoft Copilot) to enhance reporting efficiency and commentary.
• Drive process transformation through ad hoc analysis and continuous improvement initiatives.
• Develop, update, and maintain documentation of the consolidation process.
• Monitor internal controls and drive remediation where needed.

Skills

Analytical mindset

Self-motivated

Ownership mentality

Cross-functional collaboration

Education

Bachelor's degree in Accounting

CPA

Tools

OneStream

Workday

Microsoft Copilot

Alteryx

Power BI

Excel

Job description

Arch Capital Group Ltd. in White Plains, NY seeks a Manager of Financial Consolidation to lead OneStream administration and advance cross‑system reporting (Workday to OneStream).

This role reports to the AVP of Consolidations and requires strong accounting and analytical skills. Ideal candidates have 5–8 years in accounting within insurance/financial services, a CPA, and proficiency with Excel, Power BI, and AI-enabled tools like Copilot.