OneStream Administrator

About Emerald

Emerald’s talented and experienced teams grow our customers’ businesses 365 days a year with products that create connections, deliver content, and drive commerce. We produce over 140 annual events, create and deliver content through print and digital channels, and power commerce through our seamlessly integrated in-person and digital platforms and channels. For more information, please visit http://www.emeraldx.com.

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.

This position will report out of our New York City office.

What You’ll Do:

System Administration & Maintenance

• 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

Finance Process Support

• 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

Integrations & Data Exchange

• 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.)

Reporting & Analytics

• 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

Enhancements & Delivery

• 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

Governance, Audit & Controls

• 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

Training & Stakeholder Support

• 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

Required Qualifications:

• 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

About Emerald

At Emerald, we strive to foster a diverse and inclusive community. We actively recruit and champion candidates who bring new perspectives from varied professional backgrounds and experiences, and we are intentional about ensuring a positive hiring experience for everyone. Our job postings don’t contain experience inflation, and most don’t require college degrees. Instead, they’re crafted to focus on outcomes and transferable experiences that are assessed in a structured interview process carried out by trained hiring teams. 

COMPENSATION & BENEFITS

Target Compensation: $120,000 - $150,000

Please note that this range reflects a reasonable estimate of the target compensation for this position. This range may ultimately vary based on a candidate’s qualifications and may be higher where required by applicable law. 

We offer a competitive benefits package designed to strengthen our employees’ physical and mental health, including 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, and mental wellness tools.

If you need accommodation in our application process or have questions about our posted salary range, please email our Talent Acquisition team at [email protected].