EPBCS Analyst IT

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.

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.

Qualifications Required Skills & Qualifications Bachelor’s degree in IT, Computer Science, Finance, Accounting, or related field. 3–5 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