What are the responsibilities and job description for the Oracle EPM - EDMCS Lead Architect position at LTM?
Role description
We are seeking a seasoned Oracle EPM Solution Architect to lead onsite solution design and delivery for Oracle EPM Cloud implementations, with deep hands-on expertise in EPBCS (Planning & Budgeting Cloud Service), EDMCS (Enterprise Data Management Cloud Service), and ASO cube design and implementation.
The role requires strong client-facing skills, end-to-end architectural ownership, and the ability to translate complex business requirements into scalable, high performance EPM solutions.
________________________________________
Key Responsibilities
Solution Architecture & Design
• Act as overall EPM Solution Architect for EPBCS, EDMCS, and ASO based analytical solutions
• Lead architecture definition, dimensional modeling, metadata strategy, and system integration design
• Define ASO cube designs for high-volume, high-performance reporting and analytics use cases
• Design hybrid BSO–ASO architectures aligned with forecasting, planning, and reporting needs
• Ensure adherence to Oracle EPM best practices, performance standards, and scalability guidelines
________________________________________
EPBCS Implementation Leadership
• Lead end-to-end EPBCS implementations including:
o Workforce, CapEx, Financials, and Project Planning
o Custom planning applications and predictive planning use cases
• Oversee business rule design (Groovy / Calc Scripts), approvals, forms, and dashboards
• Optimize EPBCS performance through effective dimensionality and sparse/dense design
• Guide budgeting, forecasting, rolling forecasts, and scenario modeling processes
________________________________________
EDMCS Ownership
• Architect and implement EDMCS for master data governance across EPM and downstream systems
• Define data governance models, viewpoints, subscriptions, and workflows
• Integrate EDMCS with EPBCS, FCCS, and external systems
• Establish enterprise-wide metadata ownership, change control, and impact analysis processes
________________________________________
ASO Cube Implementation
• Design, build, and deploy ASO cubes for:
o Management reporting
o Operational analytics
o Large dimensional data models
• Implement aggregation strategies, hierarchies, and data optimization techniques
• Integrate ASO cubes with EPBCS, Smart View, and reporting tools
• Troubleshoot and fine-tune ASO performance issues
________________________________________
Client Engagement & Leadership
• Serve as primary onsite EPM architect and trusted advisor to senior finance and IT stakeholders
• Lead requirements workshops, solution walkthroughs, and design sign offs
• Translate business needs into clear functional and technical designs
• Provide architectural guidance to offshore and onsite delivery teams
• Review and sign off on solution design documents, build artifacts, and test results
________________________________________
Governance, Quality & Support
• Establish architectural standards, design principles, and reusable frameworks
• Drive UAT, performance testing, and production readiness activities
• Provide L3 support and guidance during post-production stabilization
• Support AMS transitions and define long-term support models and documentation
________________________________________
Required Skills & Qualifications
Mandatory
• Deep expertise in Oracle EPBCS (Cloud Planning)
• Strong hands-on experience with EDMCS implementations
• Proven experience designing and implementing ASO cubes
• Strong understanding of EPM dimensional modeling techniques
• Experience with Smart View, dashboards, and management reporting
• Excellent onsite client-facing communication and stakeholder management skills
________________________________________
Preferred / Good to Have
• Exposure to FCCS, Narrative Reporting, ARCS, or EPM Automate
• Experience with Groovy scripting
• Integration exposure using FDMEE / Data Integration / REST APIs
• Experience in multi-country or global rollouts
• Background in Finance, FP&A, or Controllership processes
________________________________________
Soft Skills
• Strong consulting mindset with problem-solving orientation
• Ability to mentor and lead cross-functional teams
• Clear, structured communication with business and technical audiences
• Comfortable working in onsite, high-visibility client environments
________________________________________
Certifications (Preferred)
• Oracle EPM Cloud Certification(s)
• Oracle Hyperion Planning / Essbase Certification
Benefits/perks listed below may vary depending on the nature of your employment with LTIMindtree (“LTIM”):
Benefits and Perks:
- Comprehensive Medical Plan Covering Medical, Dental, Vision
- Short Term and Long-Term Disability Coverage
- 401(k) Plan with Company match
- Life Insurance
- Vacation Time, Sick Leave, Paid Holidays
- Paid Paternity and Maternity Leave
The range displayed on each job posting reflects the minimum and maximum salary target for the position across all US locations. Within the range, individual pay is determined by work location and job level and additional factors including job-related skills, experience, and relevant education or training. Depending on the position offered, other forms of compensation may be provided as part of overall compensation like an annual performance-based bonus, sales incentive pay and other forms of bonus or variable compensation.
Disclaimer: The compensation and benefits information provided herein is accurate as of the date of
this posting.
LTIMindtree is an equal opportunity employer that is committed to diversity in the workplace. Our
employment decisions are made without regard to race, color, creed, religion, sex (including
pregnancy, childbirth or related medical conditions), gender identity or expression, national origin,
ancestry, age, family-care status, veteran status, marital status, civil union status, domestic
partnership status, military service, handicap or disability or history of handicap or disability, genetic
information, atypical hereditary cellular or blood trait, union affiliation, affectional or sexual orientation
or preference, or any other characteristic protected by applicable federal, state, or local law, except
where such considerations are bona fide occupational qualifications permitted by law.
Salary : $130,000 - $150,000