Oracle Cloud EPM Developer

$100,000 - $185,000/Yr

Take-Two Interactive Software - New York, NY

Full-time - Mid Level

New York, NY

Publishing Industries

About the position

Take-Two Interactive is a leading developer, publisher, and marketer of interactive entertainment for consumers around the globe. The Company develops and publishes products principally through Rockstar Games, 2K, Private Division, and Zynga. Our products are currently designed for console gaming systems, PC, and Mobile, including smartphones and tablets, and are delivered through physical retail, digital download, online platforms, and cloud streaming services. The Company's common stock is publicly traded on NASDAQ under the symbol TTWO. While our offices (physical and virtual) are casual and inviting, we are deeply committed to our core tenets of creativity, innovation, efficiency, and individual and team development opportunities. Our industry and business are continually evolving and fast-paced, providing numerous opportunities to learn and hone your skills. We work hard, but we also like to have fun, and believe that we provide a great place to work each day to pursue your passions. Under the direction of the Senior Tech Manager of Enterprise Performance Management, the EPM Developer will be responsible for designing, developing, optimizing, and maintaining T2's Global Financial Planning & Accounting Consolidation systems to support the needs of our business partners across global locations. The EPM Developer will act on design and development via Oracle's EPM Cloud Software Suite for Enterprise Planning and Budgeting Cloud Service (EPBCS) and Financial Consolidation and Close Service (FCCS). The candidate will also provide reporting solutions to the business partners using innovative tools and solutions. The candidate works closely with both our technical and business partners on requirements gathering to design, develop, deliver, and support system functionality. The ideal candidate will align business acumen and technical ability to deliver and support best-in-class planning solutions to business partners.

Responsibilities

• Develop Complex Business Rules in both calculation manager and Groovy.
• Script using Python/Groovy/CDM APIs and utilize EPM Automate to automate data admin activities.
• Build integration artifacts in Cloud Data Management and FDMEE, such as locations, maps, custom/import scripts, using Python Scripts.
• Serve as a Subject Matter Expert (SME) in maintaining and enhancing T2's global budgeting, forecasting & long-term planning systems.
• Support multiple Planning and Consolidation applications in Oracle EPM Cloud.
• Provide innovative reporting solutions using Narrative, Management, Financial Reporting & Dashboards.
• Responsible for performance tuning and optimization of Planning and Consolidation applications.
• Conduct testing, including system, integration, performance, and user acceptance testing.
• Prepare and maintain necessary documentation including design documents, test documentation, training materials, and administration/user guides.

Requirements

• 7+ years' experience in Oracle EPM Hyperion Planning design, development and administration with 3+ years on EPM Cloud including EPBCS (Finance Modules, Freeform, Hybrid BSO, ASO), FCCS, Narrative and Management Reporting, Data Management, EPMAutomate & metadata management.
• Expert knowledge in Oracle EPM Cloud and On-Premises Hyperion Architecture using Hybrid Application methodology and Financial Modules.
• Proficient in writing complex code in Calculation Manager Business Rules.
• Proficient in writing complex code in Groovy Scripting.
• Proficient in integrations within EPM cloud across cubes and also integration with other corporate systems like JDE, Anaplan, Snowflake etc.
• Expert knowledge of all components of EPBCS including metadata administration, outlines, dimensions, complex calculations, business rules, calculation scripts, creating snapshots, backups, data and artifact migrations, security setup and configuration, data forms, charts & graphs, menus, task lists, as part of application development and configuration.
• Expert in BSO, ASO & Hybrid cube design.
• Expert knowledge on Performance Optimization of Planning application which includes data load process / Business Rules / Cal script and reporting Methods.
• Expert knowledge of creating financial reports (pdf), charts, pivots, dashboards, books, batches, snapshot reports etc. using financial reporting.
• Expert in automation, SQL, batch scripting and EPMAutomate.
• Expert knowledge in automations of data Loads and integrations using FDMEE/data management.
• Expert knowledge on Metadata Upload Process through incremental files and creating automations to seamlessly load metadata.
• Expert in SQL development and maintenance of Stored Procedures (PL), Triggers and Queries.
• Ability to be proactive in providing alternatives based on best practices and application functionality.

Nice-to-haves

• Financial process and functional knowledge required.
• Expert knowledge in analyzing business needs and developing solutions to support the business.

Benefits

• Medical (HSA & FSA)
• Dental
• Vision
• 401(k) with company match
• Employee stock purchase plan
• Commuter benefits
• In-house wellness program
• Broad learning & development opportunities
• Charitable giving platform with company match
• Fitness allowance
• Employee discount programs
• Free games & events
• Stocked pantries and more!