Jobs · Finance · Illinois

Sr. Financial Systems Analyst

Composites One · Schaumburg, IL · 2 wk ago
Finance$111k–$160k/yrFull-time

Key Responsibilities

  • Administer users, roles, security, and application profiles; manage promotions and lifecycle across environments.
  • Maintain and optimize metadata (entities, accounts, scenarios, UD dimensions), hierarchies, and consolidation settings.
  • Configure and monitor workflows for close, reporting, and planning; enforce certifications and approvals.
  • Manage consolidation processes (IC matching/eliminations, ownership, allocations, FX rates/translation, overrides) and perform performance tuning.
  • Plan and execute patches/upgrades; govern Marketplace solutions and job scheduling/automation.

Data Integration, Transformation & Reconciliation

  • Monitor integrations between OneStream and upstream/downstream systems; coordinate changes and resolve issues with data consumers.
  • Build and maintain transformation rules, mappings, allocations, validations, event handlers, and exception handling.
  • Reconcile data across SAP, OneStream, Incorta, and GAAP financial statements.
  • Manage FX/rate loads, master data synchronization, versioned mappings, and data lineage documentation.

Financial Processes, Planning & Reporting

  • Partner with Accounting and FP&A on monthly close, consolidation, GAAP, and management reporting.
  • Support budgeting/forecasting models, scenarios, versions, and driver-based planning.
  • Translate finance and business requirements into scalable OneStream designs and enhancements.
  • Collaborate with finance and global process owners on integrated data design (e.g., SAP, Incorta).
  • Build and maintain GAAP and management reporting (financial statements, cube views, dashboards, report books, quick views).

Controls, Testing, Change Management & Application Support

  • Define and execute unit, system, UAT, and regression testing; manage defect triage and resolution.
  • Support SAP and Incorta testing impacting OneStream; develop traceable test cases and coordinate UAT/regression.
  • Operate formal change control (design docs, impact analysis, release notes, version history).
  • Define and enforce reporting controls (access reviews, segregation of duties, audit evidence, audit readiness).
  • Triage and resolve incidents per SLAs; perform root-cause analysis and implement preventive monitoring.
  • Coordinate with vendors and third-party support; manage escalations.
  • Maintain documentation (runbooks, metadata dictionaries, knowledge base); support training and backup/DR drills.

Expected Skills And Qualifications

  • Minimum of 7 years of hands-on experience administering and developing OneStream or comparable Enterprise Performance Management (EPM) systems.
  • Minimum of 5 years of experience in a finance-centric role with direct involvement in month-end close, US GAAP reporting, and budgeting and forecasting.
  • Bachelor’s degree in Accounting, Finance, Information Systems, Computer Science, or a related field; or equivalent combination of education, training, and professional experience.
  • Advanced proficiency in Microsoft Office (Excel, Word, PowerPoint, Outlook) and Windows environments.
  • Strong experience with financial analytics, reporting tools, and BI platforms.
  • Advanced financial modeling skills.
  • Hands-on experience with U.S. GAAP consolidations in OneStream, including intercompany eliminations, ownership structures, foreign currency translation (FX/CTA), and minority interest.
  • Strong understanding of EPM data processes, including integrations, transformations, workflows, validations, and reconciliations to source systems.
  • Experience building and maintaining OneStream solutions, including calculations, business rules, cube views, dashboards, report books, quick views, XF Get/Set functions, and financial statements.
  • Strong data governance experience, including metadata/master data management, security, auditability, documentation, and change control.
  • Excellent problem-solving and communication skills, with the ability to bridge Finance and IT stakeholders under tight timelines.

Similar jobs

Sr. Financial Systems Analyst

Depot Connect InternationalChannelview, TX· 4 mo ago
Information Technology$100k–$110k/yrapply on dci.clearcompany.com