Lead OneStream Application Administrator

Jobtailor; Denver (CO); On-site; USD 110,000 - 170,000; Full time

Job summary

Jobtailor seeks an experienced OneStream Administrator to own the financial consolidation, reporting, budgeting, and forecasting processes. You will partner with Accounting, FP&A, and Finance stakeholders to implement changes, ensure SOX controls, and maintain mapping inventories, runbooks, and audit-ready evidence across development, UAT, and production environments.

Strong SQL, API, and data integration skills are preferred, and a OneStream certification is a plus.

Qualifications

• Bachelor’s degree in Accounting, Finance, Information Systems, Computer Science, Business, or related field; equivalent experience may be considered.
• Minimum of three (3) years of experience implementing, administering, configuring, or supporting OneStream in production.
• Hands-on experience administering OneStream cubes, dimensions, metadata, workflows, business rules, mappings, integrations, security, cube views, and migrations.
• Strong understanding of financial reporting concepts including P&L, balance sheet, cash flow, consolidation, intercompany eliminations, and budgeting/forecasting.
• Experience with controlled development, UAT, release, and production environments, including change documentation and deployment validation.

Responsibilities

• Administer and maintain OneStream platform including cubes, dimensions, metadata, workflows, and security.
• Serve as the primary technical administrator and escalation point for OneStream issues during close, forecast, and reporting cycles.
• Configure and support functionality for financial reporting, consolidation, budgeting, forecasting, and KPIs.
• Implement approved changes to hierarchies, currency settings, security, mappings, and consolidation properties.
• Develop, maintain, and troubleshoot business rules, calculations, load workflows, and mapping rules.
• Coordinate with external partners and OneStream Support as needed.

Skills

OneStream Administration

Financial Reporting Concepts

SQL and ETL Integration

Change Management and Documentation

Problem-Solving and Root-CauseAnalysis

Education

Bachelor’s degree in Accounting/Finance/IS/CS/Business

Tools

OneStream Platform

SQL

APIs

Relational Databases

Cloud Data Platforms

Job description

• Administer and maintain the OneStream platform, including cubes, dimensions, metadata, hierarchies, workflows, scenarios, business rules, mappings, dashboards, cube views, security, and integrations
• Serve as the primary technical administrator and escalation point for OneStream issues during close, forecast, budget, and executive reporting cycles
• Configure and support functionality for financial reporting, management reporting, consolidation, budgeting, forecasting, balance sheet, cash flow, KPIs, Capital Planning, and workforce planning
• Implement approved changes to financial hierarchies, workflow assignments, currency settings, security, mappings, and consolidation properties
• Develop, maintain, and troubleshoot business rules, calculations, allocations, seeding processes, load workflows, integrations, transformation profiles, and mapping rules
• Analyze and resolve complex application, data, security, reporting, workflow, calculation, reconciliation, failed-load, and performance issues
• Coordinate advanced support with external partners and OneStream Support when needed
• Partner with Accounting, FP&A, and Finance stakeholders to translate business needs into controlled, scalable OneStream solutions
• Partner with the OneStream Product & Reporting Lead on demand intake, requirements, backlog prioritization, release planning, UAT, user support, and stakeholder communication
• Serve as designated backup for selected Product & Reporting Lead responsibilities
• Investigate and resolve reconciliation differences between consolidation and management reporting outputs
• Manage controlled changes across development, UAT, and production environments, including testing, migration, release documentation, validation, backout planning, and audit-ready evidence
• Maintain application documentation, data lineage, mapping inventories, runbooks, control evidence, access review support, and knowledge-transfer materials
• Cross-train the OneStream Product & Reporting Lead on essential technical procedures and maintain shared runbooks and documentation

Requirements

• Bachelor’s degree in Accounting, Finance, Information Systems, Computer Science, Business, or a related field; equivalent professional experience may be considered
• Minimum of three (3) years of experience implementing, administering, configuring, or supporting OneStream in a production environment
• Hands-on experience administering OneStream cubes, dimensions, metadata, workflows, business rules, mappings, integrations, security, cube views, reporting objects, and application migrations
• Strong understanding of financial reporting concepts, including P&L, balance sheet, cash flow, consolidation, intercompany eliminations, legal and management hierarchies, budgeting, forecasting, and reconciliations
• Experience supporting controlled development, UAT, release, and production environments, including change documentation, testing, deployment validation, and production support
• Working knowledge of SOX controls, access controls, segregation of duties, change management, failed-load monitoring, audit evidence, and financial systems governance
• Ability to analyze Finance and Accounting requirements, assess system impacts, recommend practical solutions, and explain technical issues in clear financial and business terms
• Strong problem-solving, root-cause analysis, documentation, communication, stakeholder management, and prioritization skills in time-sensitive reporting and close-cycle environments
• OneStream administration, implementation, or development certification (preferred)
• Experience supporting a multi-cube OneStream environment and consolidation-to-management reporting reconciliations (preferred)
• Experience with advanced OneStream business rules, extensibility rules, and dashboard development (preferred)
• Working experience with SQL, APIs, ETL/integration concepts, relational databases, and/or cloud data platforms (preferred)
• Experience integrating OneStream with ERP, HR, CRM, operational, or enterprise data warehouse platforms (preferred)
• Experience with consolidation, ownership structures, intercompany eliminations, and foreign-currency translation (preferred)

Core Competencies

Demonstrates expertise in administering and maintaining the OneStream platform, including financial reporting, budgeting, and forecasting functionalities. Proficient in managing controlled changes across development, UAT, and production environments while ensuring compliance with financial systems governance and SOX controls.

Highest-signal resume keywords

• OneStream Administration
• Financial Reporting Concepts
• SQL and ETL Integration
• Change Management and Documentation
• Problem-Solving and Root-Cause Analysis

ATS Optimization Keywords

Hard Skills

• OneStream Configuration
• Business Rules Development
• Data Mapping and Integration
• Financial Consolidation
• Reporting Object Management

Soft Skills

• Stakeholder Management
• Communication Skills
• Prioritization Skills
• Documentation Skills
• Analytical Skills

Certifications & Qualifications

• OneStream Administration Certification

Industry Keywords

• SOX Controls
• Financial Systems Governance
• Budgeting and Forecasting
• Intercompany Eliminations
• Cash Flow Management

Tools & Technologies

• OneStream Platform
• SQL
• APIs
• Relational Databases
• Cloud Data Platforms