Oracle EPM Specialist - IT Architect

Work Schedule

Standard (Mon-Fri)

Environmental Conditions

Office

Job Description

As part of the Thermo Fisher Scientific team, you’ll discover meaningful work that makes a positive impact on a global scale. Join our colleagues in bringing our Mission to life every single day to enable our customers to make the world healthier, cleaner and safer. We provide our global teams with the resources needed to achieve individual career goals while helping to take science a step beyond by developing solutions for some of the world’s toughest challenges, like protecting the environment, making sure our food is safe or helping find cures for cancer.

DESCRIPTION:
Join Thermo Fisher Scientific as an IT Architect III and be part of our mission to enable customers to make the world healthier, cleaner, and safer. In this role, you'll design and implement effective cloud solutions, focusing on EPM architecture and automation. You'll contribute to technology advancement, transforming on-premise applications into cloud-centric solutions while ensuring reliability and disaster recovery. This position offers the opportunity to collaborate with cross-functional teams, propose innovative approaches, and advance cloud technology. You'll support and guide application owners while maintaining expertise in emerging technologies and industry best practices. Your work will directly impact operations through the implementation of sophisticated machine learning solutions, cloud infrastructure optimization, and the development of scalable IT architectures.

We are seeking an Oracle EPM Consultant with strong expertise in Enterprise Planning and Budgeting Cloud Service (EPBCS) to support, develop, and optimize enterprise planning, budgeting, forecasting, and reporting solutions.

The consultant will serve as the primary functional and technical resource for EPBCS, ensuring application stability, data accuracy, security, and performance during planning and financial close cycles. This role involves translating business requirements into scalable solutions, managing integrations, troubleshooting issues, and delivering application enhancements.

Working closely with Finance, IT, implementation partners, and Financial Systems leadership, the consultant will take ownership of knowledge transfer and support the execution of the EPM roadmap. Exposure to PCMCS and EDMCS is desirable, with these applications representing a secondary area of responsibility.

Key Responsibilities

EPBCS Solution Design & Development

• Gather business requirements and translate them into functional designs, technical specifications, and EPBCS solutions.
• Configure and maintain planning applications, dimensions, hierarchies, forms, dashboards, navigation flows, task lists, and approval workflows.
• Develop and optimize business rules, calculation scripts, member formulas, and allocation logic using Calculation Manager and, where applicable, Groovy.
• Support planning models across scenarios, versions, entities, currencies, and business units.
• Enhance budgeting, forecasting, long-range planning, and management reporting processes.
• Configure and support relevant EPBCS frameworks, such as Financials, Workforce based on business requirements.

Data Integration & Management

• Configure, administer, and monitor Data Integration/Data Exchange processes, data mappings, pipelines, and import/export definitions.
• Manage actuals, budget, forecast, and metadata integrations between EPBCS and source systems.
• Validate and reconcile financial data to ensure completeness, accuracy, and consistency.
• Collaborate with upstream and downstream system owners to assess dependencies and resolve integration issues.
• Automate routine data loads, metadata updates, and application processes using EPM Automate, REST APIs, or scripting.

Application Support & Troubleshooting

• Provide functional and technical support during budgeting, forecasting, financial close, and reporting cycles.
• Investigate and resolve data load failures, mapping errors, calculation issues, validation failures, and performance problems.
• Support users with forms, dashboards, approvals, reporting, and Smart View queries.
• Perform root cause analysis, implement preventive fixes, and manage Oracle Service Requests through resolution.
• Monitor scheduled jobs, business rules, integrations, and application performance.

Security, Maintenance & Release Management

• Administer user access, predefined roles, application permissions, and dimension-level security.
• Review monthly Oracle EPM release notes, assess impacts, and coordinate regression testing.
• Manage controlled migration of application changes across development, test, and production environments.
• Maintain application backups, configuration documentation, support runbooks, and operating procedures.
• Follow change management processes and support audit and internal control requirements.

Business Partnership & Continuous Improvement

• Partner with Finance and IT teams to improve planning processes, application usability, and operational efficiency.
• Assess the downstream impact of application and integration changes.
• Lead knowledge transfer from implementation partners and establish sustainable application support practices.
• Work with Financial Systems leadership to prioritize enhancements and deliver EPM roadmap initiatives.

Secondary Support – PCMCS & EDMCS

• Provide limited support for PCMCS allocation models and profitability processes, as required.
• Assist with EDMCS metadata updates, hierarchy maintenance, and subscriptions.
• Coordinate with application specialists for complex PCMCS and EDMCS requirements.

Required Qualifications & Skills

• Strong hands-on experience implementing, developing, or supporting Oracle EPBCS/EPM Planning applications.
• Understanding of financial planning, budgeting, forecasting, management reporting, and financial close dependencies.
• Experience with dimensions, forms, dashboards, approval workflows, business rules, calculation scripts, and Smart View.
• Strong knowledge of Essbase concepts, multidimensional modeling, and calculation performance optimization.
• Experience with Data Integration/Data Exchange, data mappings, metadata management, and financial data reconciliation.
• Experience managing application security, migrations, monthly update testing, and production support.
• Strong analytical, troubleshooting, documentation, and stakeholder communication skills.
• Ability to translate Finance requirements into practical, maintainable technical solutions.

Preferred Qualifications

• Experience with Groovy, EPM Automate, REST APIs, and scripting.
• Experience with EPBCS Financials, Workforce.
• Exposure to Oracle ERP or other financial source-system integrations.
• Familiarity with PCMCS and EDMCS.