Senior OneStream Administrator

Caterpillar Inc.•Irving, TX

6d•$147,760 - $240,110•Onsite

About The Position

This role reports to the Director of Enterprise Applications and leads the design, delivery and support of Enterprise Resource Planning (ERP) – Plan to Produce capabilities. The Senior OneStream Administrator serves as the enterprise owner of the OneStream administration function and is accountable for platform reliability, security, governance, operational controls, and supportability. The role ensures compliance with financial, audit, cybersecurity, and change-management requirements while enabling scalable financial consolidation, reporting, and planning capabilities across a global organization.

Requirements

Demonstrated hands-on experience administering, configuring, developing, and supporting OneStream in a production enterprise environment.
Deep knowledge of OneStream application components, including metadata, dimensions, workflows, business rules, Cube Views, dashboards, reporting, data management, security, and environment promotion.
Experience supporting SOX-regulated public company environments with complex financial reporting and control requirements
Experience defining operational standards, administration practices, governance frameworks, and technical roadmaps for enterprise EPM platforms.
Experience writing and troubleshooting OneStream business rules using VB.NET, SQL and OneStream APIs.
Strong knowledge of financial consolidation and close processes, including currency translation, intercompany activity, eliminations, ownership, financial controls, and management reporting.
Experience supporting budgeting, forecasting, scenario modeling, or other planning and xP&A processes.
Experience with data integration, transformation, mapping, validation, reconciliation, and troubleshooting across ERP or enterprise data platforms.
Ability to diagnose complex issues using logs, application data, configuration analysis, and structured root-cause methods.
Experience with testing, release management, controlled deployments, upgrades, regression validation, and technical documentation.
Knowledge of role-based security, segregation of duties, audit controls, and access governance.
Ability to work independently, manage competing priorities, support critical close windows, and collaborate effectively with global teams.

Nice To Haves

OneStream certification, such as OneStream Certified Associate – Administration R2, where applicable to the candidate’s experience.
Experience with OneStream Administration in a multi currency, multi environment implementation.
Experience integrating OneStream with major ERP platforms such as SAP or Oracle and with enterprise data warehouses.
Finance, Accounting, Information Systems, Computer Science, or related educational background; accounting or EPM professional credentials are a plus.
Experience supporting a complex global organization with multiple entities, currencies, reporting hierarchies, and regulatory requirements.

Responsibilities

Perform day-to-day administration across Development, Pre-Production, and Production environments. Monitor application health, investigate performance issues, execute maintenance activities, and ensure reliable platform operation.
Create and maintain metadata, dimensions, hierarchies, cubes, workflows, transformation rules, data-management sequences, dashboards, Cube Views, reports, security, and other application artifacts.
Write, modify, test, and troubleshoot OneStream business rules and calculation logic. Use VB.NET, SQL and OneStream APIs where required to deliver scalable, supportable solutions.
Provide direct technical and functional support during monthly, quarterly, and annual close. Run and troubleshoot data loads, validations, consolidations, translations, eliminations, workflows, and reporting processes to keep close activities on track.
Serve as the senior escalation point for application, calculation, workflow, reporting, data-quality, performance, and integration incidents. Reproduce issues, analyze logs and data, identify root causes, implement fixes, and document preventive actions.
Configure, operate, and troubleshoot integrations between OneStream and ERP, data warehouse, master-data, and other source systems. Validate mappings, transformations, data loads, reconciliations, and error handling.
Provide direct technical and functional support during budgeting, forecasting, scenario modeling, analytics, and planning cycles.
Develop deployment packages, conduct technical testing, support user acceptance testing, promote changes through environments, perform post-deployment validation, and support OneStream platform upgrades and regression testing.
Establish and enforce OneStream administration standards, configuration management practices, naming conventions, migration procedures, documentation requirements, and operational controls to ensure a stable, scalable, and supportable enterprise platform.
Configure and maintain role-based access, security groups, permissions, workflow access, and authentication integrations. Execute periodic user access reviews, support segregation-of-duties controls, maintain adit evidence, coordinate remediation activities, and ensure compliance with internal controls, cybersecutiry, and regulatory requirements.
Partner with Internal Audit, External Audit, Cybersecurity, and Finance Control organizations to provide system evidence, demonstrate control effectiveness, support compliance testing, remediate findings, and maintain platform alignment with enterprise governance standards.
Manage application promotion processes, deployment approvals, release governance, configuration baselines, and environment controls to ensure production stability and adherence to enterprise change-management policies.
Maintain metadata governance, master data standards, hierarchy integrity, and reconciliation controls. Collaborate with Finance, Data Management, and source-system teams to ensure data accuracy, consistency, traceability, and stewardship across the OneStream ecosystem.
Support disaster recovery planning, backup validation, business continuity testing, platform recovery procedures, and operational readiness activities to minimize business disruption and maintain critical financial processes.
Automate repetitive work, tune performance, simplify support processes, maintain technical documentation and operating procedures, and build internal capability through knowledge transfer and mentoring.
Work closely with global Finance, Accounting, FP&A, Data Management, IT, service providers, and OneStream support while retaining direct ownership of technical execution and outcomes.