Onestream Administrator

Emerald • New York, NY

7h • Hybrid

About The Position

Emerald, a leader in building dynamic market platforms that integrate live events and media, seeks an OneStream Administrator to support FCC, FP&A and enhance a multi-system financial applications landscape in a highly audited (SOX-compliant) environment. This role is critical to ensuring data integrity, audit readiness, and operational efficiency across systems including OneStream, Hyperion and a potential other application that are integrated with OneStream. The OneStream FP&A Systems Administrator serves as the internal product owner and technical lead for enterprise financial planning and performance management systems. This role partners closely with Finance, IT, and external vendors to support financial close, consolidation, planning, reporting, and data integration processes. The position ensures system reliability, strong data governance, and seamless integration across enterprise systems. Experience with FP&A applications is required, with OneStream experience preferred.

Requirements

• Experience with user setup and security management, metadata and dimension maintenance, workflow configuration for close and planning cycles, data loading and mapping, and report generation and scheduling within FP&A systems.
• Experience supporting audits and SOX compliance within OneStream
• Experience with API technologies (REST/SOAP), ETL tools, and data integration frameworks
• Proven experience administering FP&A / EPM applications (planning, budgeting, forecasting, consolidation systems)
• Strong understanding of financial processes, data models, and reporting requirements
• Experience with user access management, security models, and audit/compliance processes (including UAR)
• Ability to code Custom calculations, Data transformations, Validation logic and Automations using the workflow tool in Onestream.
• Strong troubleshooting skills across data, system, and integration issues
• Ability to collaborate effectively with Finance, IT, and audit stakeholders

Nice To Haves

• OneStream experience preferred

Responsibilities

• Manage day-to-day administration of FP&A/EPM platforms including metadata, security, workflows, and user provisioning
• Perform OneStream user maintenance activities including user setup, role assignments, and access modifications
• Maintain system configurations supporting planning, consolidation, and reporting processes
• Develop and maintain business rules, calculation logic, and data transformation processes
• Coordinate system upgrades, patches, and release cycles with IT and Finance
• Support monthly, quarterly, and annual close, consolidation, budgeting, and forecasting cycles
• Maintain chart of accounts, entity hierarchies, and dimensional structures
• Investigate and resolve data discrepancies across end-to-end financial data flows
• Administer workflow tools including reconciliations and task management
• Design, implement, and support API-based integrations between FP&A systems and upstream/downstream applications (e.g., ERP, data warehouses)
• Manage inbound and outbound data interfaces, including automated data loads, extracts, and transformations
• Monitor data pipelines and ensure accuracy, completeness, and timeliness of data exchanges
• Troubleshoot integration failures and collaborate with IT to resolve connectivity or data issues
• Support file-based and API-driven data exchange mechanisms (REST/SOAP APIs, SFTP, etc.)
• Develop, maintain, and generate standard and ad hoc financial reports directly from the FP&A system
• Support dashboard creation and distribution for Finance and business stakeholders
• Ensure reporting outputs are accurate, timely, and aligned with business requirements
• Partner with Finance to enhance reporting capabilities and enable self-service analytics
• Gather, prioritize, and manage enhancement requests from Finance stakeholders
• Translate business requirements into functional and technical specifications
• Partner with IT or external vendors for development and complex implementations
• Lead user acceptance testing (UAT) and manage production deployments
• Drive continuous improvement and expand system functionality, including new modules or features
• Use Onestream framework to
• Perform regular user access reviews (UAR) and ensure appropriate role-based access controls
• Support internal and external audit requests, including evidence gathering and control validation
• Maintain audit trails and ensure compliance with SOX and internal control requirements
• Enforce governance standards including change management, testing protocols, and approval workflows
• Maintain detailed documentation including configurations, data mappings, integrations, and business rules
• Develop and deliver training materials and user guides
• Onboard new users and provide ongoing support to Finance teams
• Act as internal SME for FP&A systems and promote adoption and best practices

Benefits

• unlimited vacation for exempt employees
• flexible working locations
• 401(k) plan with a company match
• medical/dental/vision coverage with inclusive provisions including transgender services and fertility benefits
• parental and caregiver leave
• dependent, commuter and FSA benefits
• professional development programs like Toastmasters
• mental wellness tools

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Education Level: No Education Listed