Senior Consultant – Oracle PCMCS / EPCM

Constellation Cg; San Francisco, Northern (CA, KY); Hybrid; USD 140,000 - 180,000; Full time

Job summary

Constellation Consulting Group (CCG) is seeking a Senior Consultant to drive Oracle PCMCS/EPCM implementations in our San Francisco team. You will translate complex business needs into scalable technical designs, lead technical workstreams, and ensure seamless profitability model integration with financial systems.

You will mentor junior staff, conduct design sessions, and manage end-to-end implementation and ongoing support, including performance tuning for data accuracy.

Qualifications

• 5+ years in Oracle EPM with PCMCS implementation and support.
• Ability to lead technical workshops and mentor staff in a fast-paced consulting environment.
• Experience with Essbase calculations and Groovy rules.
• Hands-on integration with Data Management/Integration and cross-module EPM workflows.

Responsibilities

• Requirements & Design: Stakeholder sessions to gather requirements and translate into technical designs; architect profitability modeling and driver-based analysis.
• Implementation & Support: Own the end-to-end implementation lifecycle; manage ongoing support and troubleshooting for long-term stability.
• Technical Leadership: Lead technical discussions, justify architectural decisions; perform performance tuning for scalability and data accuracy.
• Mentorship: Guide junior team members, perform code reviews for Essbase and Groovy scripts, oversee deliverables quality.
• Integration & Automation: Design and manage financial data integrations using FDMEE, Data Exchange, and EPM Automate; integrate PCMCS with EPBCS.
• Reporting & Training: Develop reporting structures with Smart View and Financial Reporting; deliver documentation and training for end-users.

Skills

Oracle EPM

PCMCS

Essbase

Groovy

FDMEE

EPM Automate

Smart View

EPBCS

Data Management

Data Exchange

Tools

Data Management/Integration (FDMEE)

Data Exchange

EPM Automate

Smart View

Job description

Job Location :Senior Consultant – Oracle PCMCS / EPCM

Job Description :

Constellation Consulting Group (CCG) is looking for talented professionals to join our
team. As seasoned consultants, we are committed to fostering an environment that provides employees
with a healthy balance between work and lifestyle.

The candidate will drive the delivery of high-value Oracle EPM solutions, specializing in PCMCS/EPCM. You
will be responsible for translating complex business needs into scalable technical designs, leading technical workstreams, and ensuring the seamless integration of profitability models with broader financial systems.

Primary Responsibilities :

• Requirements & Design: Involved in stakeholder engagement sessions to gather business requirements and convert them into comprehensive technical designs. Architect solution strategies, including profitability modeling, cost allocation logic, and driver-based analysis.
• Implementation & Support: Own the end-to-end implementation lifecycle. Beyond deployment,
  you will manage ongoing support activities, troubleshooting system issues, and ensuring longterm application stability.
• Technical Leadership: Lead technical discussions with clients and internal teams to justify architectural decisions. Conduct performance tuning and optimization to ensure application scalability and data accuracy.
• Mentorship: Guide junior team members through technical hurdles, perform code reviews for Essbase and Groovy scripts, and oversee the quality of project deliverables.
• Integration & Automation: Design and manage financial data integrations using Data Management (FDMEE), Data Exchange, and EPM Automate. Ensure unified reporting by integrating PCMCS with other modules like EPBCS.
• Reporting & Training: Develop advanced reporting structures using Smart View and Financial Reporting. Deliver comprehensive documentation and training sessions to empower end-users.

Job Requirements :

• Modeling: Advanced allocation rules and driver-based methodologies for cost transparency.
• Scripting: Expert-level Calculation Scripts (Essbase) and Groovy Business Rules.
• Cloud Operations: Proven track record in cloud migration and performance optimization.
• Integration: Hands-on experience with Data Management/Integration and cross-module EPM flow.

Required Attributes :

• Experience: 5+ years in Oracle EPM, with a deep focus on PCMCS implementation and support.
• Soft Skills: Proven ability to lead technical workshops and mentor staff in a fast-paced consulting environment.