Oracle EPBCS Senior Analyst

CREATIVITY IS OUR SUPERPOWER. It’s our heritage and it’s also our future. Because we don’t just make toys. We create innovative products and experiences that inspire fans, entertain audiences and develop children through play. Mattel is at its best when every member of our team feels respected, included, and heard—when everyone can show up as themselves and do their best work every day. We value and share an infinite range of ideas and voices that evolve and broaden our perspectives with a reach that extends into all our brands, partners, and suppliers.

The Team:

We are seeking an experienced Oracle EPBCS Analyst (5–8 years) to design, implement, and support enterprise planning and budgeting solutions using Oracle EPM Cloud, specifically Enterprise Planning and Budgeting Cloud Service (EPBCS). 

The role focuses on delivering end-to-end financial planning, forecasting, workforce planning, and profitability modeling solutions, working closely with Finance, FP&A, and business stakeholders.

Key Responsibilities 

EPBCS Application Design & Development 

• Design and implement EPBCS applications covering: 

• Financial Planning (Revenue, Expense, OPEX, CAPEX) 

• Workforce Planning 

• Capital Asset Planning 

• Profitability and Cost Allocation models 

• Configure: 

• Cubes, dimensions, hierarchies, and metadata 

• Forms, dashboards, and task lists 

• Business rules and validation logic 

 

Business Rule Development & Automation 

• Develop and maintain calculation logic using: 

• Business Rules (Calculation Manager) 

• Groovy scripts (for validation and automation) 

• Implement: 

• Allocations 

• Driver-based planning 

• Currency conversions 

• Forecasting models 

• Optimize calculation performance and data processing efficiency. 

 

Data Integration & Management 

• Manage data integrations between EPBCS and source systems (ERP, Data Warehouses). 

• Work with: 

• Data Management (FDMEE / EPM Data Integration) 

• Smart Push / Data Maps 

• REST APIs (where applicable) 

• Perform data validation, reconciliation, and troubleshooting. 

 

Reporting & Analysis 

• Build and support financial reports and dashboards using: 

• Smart View (Excel-based reporting) 

• Management reports / Financial reporting tools 

• Support ad-hoc analysis for FP&A teams and business users. 

 

Production Support & Enhancements 

• Provide L2/L3 support for EPBCS applications. 

• Troubleshoot application, data, and performance issues. 

• Support monthly/quarterly budgeting and forecasting cycles. 

• Handle enhancements, change requests, and system improvements. 

 

Business Collaboration 

• Work closely with Finance, FP&A, Accounting, and Business stakeholders. 

• Translate business requirements into EPBCS design and configurations. 

• Facilitate requirement gathering, solution design, and UAT support. 

 

Testing & Deployment 

• Lead testing activities including: 

• Unit testing 

• System integration testing 

• UAT support 

• Manage migrations across environments (DEV / TEST / PROD). 

• Ensure proper documentation of releases and changes. 

 

Governance & Documentation 

• Maintain functional and technical design documents. 

• Ensure compliance with financial governance and audit requirements. 

• Support change management and release processes. 

Required Skills & Qualifications 

• Bachelor’s degree in IT, Computer Science, Finance, Accounting, or related field. 

• 5–8 years of experience in Oracle EPM / Hyperion / EPBCS implementations. 

• Strong hands-on experience in: 

• EPBCS configuration and administration 

• Financial planning and forecasting models 

• Business rules and calculation logic 

• Strong understanding of FP&A processes (budgeting, forecasting, variance analysis). 

• Experience with: 

• Data integration tools (FDMEE / Data Management) 

• Smart View reporting 

• Metadata and dimensional modeling 

 

Preferred Skills 

• Experience with **Oracle Enterprise Planning and Budgeting Cloud Service implementations. 

• Knowledge of Groovy scripting in EPM Cloud. 

• Exposure to Essbase architecture and optimization. 

• Experience with REST APIs and automation. 

• Strong Excel and financial modeling skills. 

• Experience in Agile project environments. 

 

Soft Skills 

• Strong analytical and problem-solving skills 

• Excellent communication with Finance and IT stakeholders 

• Ability to handle financial close and planning cycles under deadlines 

• Strong attention to detail and accuracy 

• Stakeholder management and requirement translation skills 

Job Location : Hyderabad  

Work Mode : 4 days from office 

Timings :  Flexible to work in shifts (depending on the role) 

Don’t meet every single requirement? At Mattel, we are dedicated to an inclusive workplace and a culture of belonging. If you’re excited about this role but your past experience doesn’t align perfectly with every qualification in the job description, we still encourage you to apply. You may be just the right candidate for this or other roles.

How We Work:

We are a purpose driven company aiming to empower generations to explore the wonder of childhood and reach their full potential. We live up to our purpose employing the following behaviors:

• We collaborate: Being a part of Mattel means being part of one team with shared values and common goals. Every person counts and working closely together always brings better results. Partnership is our process and our collective capabilities is our superpower.
• We innovate: At Mattel we always aim to find new and better ways to create innovative products and experiences. No matter where you work in the organization, you can always make a difference and have real impact. We welcome new ideas and value new initiatives that challenge conventional thinking.
• We execute: We are a performance-driven company. We strive for excellence and are focused on pursuing best-in-class outcomes. We believe in accountability and ownership and know that our people are at their best when they are empowered to create and deliver results.

Our Approach to Flexible Work:

We embrace a flexible work model designed to empower a culture of growth, optimism, and wellbeing, where every employee can reach their full potential. Combining purposeful in-person collaboration with flexibility, our focus is to optimize performance and drive connection for moments that matter.

Who We Are:

Mattel is a leading global toy and family entertainment company and owner of one of the most iconic brand portfolios in the world. We engage consumers and fans through our franchise brands, including Barbie, Hot Wheels, Fisher-Price, American Girl, Thomas & Friends, UNO, Masters of the Universe, Matchbox, Monster High, MEGA and Polly Pocket, as well as other popular properties that we own or license in partnership with global entertainment companies. Our offerings include toys, content, consumer products, digital and live experiences. Our products are sold in collaboration with the world’s leading retail and ecommerce companies. Since its founding in 1945, Mattel is proud to be a trusted partner in empowering generations to explore the wonder of childhood and reach their full potential.

Mattel’s award-winning workplace culture has been recognized by Forbes, Fast Company, Newsweek, Great Place to Work, TIME, and more.

Visit us at https://jobs.mattel.com/ and www.instagram.com/MattelCareers.

Mattel is an Equal Opportunity Employer where we want you to bring your authentic self to work every day. We welcome all job seekers, and all applicants will receive consideration for employment.

Videos to watch:

The Culture at Mattel

Corporate Philanthropy