Oracle Consultant

About AscendionAscendion is an AI-native software engineering disruptor helping businesses innovate faster, smarter, and with greater impact. We partner with enterprise clients across North America, the UK, Europe, and APAC to solve complex challenges in data, experience design, software product engineering, and workforce transformation. Powered by expert engineers, thousands of AI agents, and our Engineering to the Power of AI (EngineeringAI) method, we deliver measurable outcomes that build trust, unlock value, and accelerate growth.Learn more at to the Power of AI™, AAVA™, EngineeringAI, Engineering to Elevate Life™, Enterprise PlatformsAI, Data & InsightsAI, ExperienceAI, GCCAI, OperationsAI, Platform EngineeringAI, ProductAI, and Quality EngineeringAIare trademarks or service marks of Ascendion®. AAVA™ is pending registration. Unauthorized use is strictly prohibited.Ascendion | Engineering to elevate lifeWe have a culture built on opportunity, inclusion, and a spirit of partnership. Come, change the world with us:Build the coolest tech for the world’s leading brandsSolve complex problems - and learn new skillsExperience the power of transforming digital engineering for Fortune 500 clientsMaster your craft with leading training programs and hands-on experienceExperience a community of change makers!Join a culture of high-performing innovators with endless ideas and a passion for tech. Our culture is the fabric of our company, and it is what makes us unique and diverse. The way we share ideas, learning, experiences, successes, and joy allows everyone to be their best at Ascendion.About AscendionAscendion is a full-service digital engineering solutions company. We make and manage software platforms and products that power growth and deliver captivating experiences to consumers and employees. Our engineering, cloud, data, experience design, and talent solution capabilities accelerate transformation and impact for enterprise clients. Headquartered in New Jersey, our workforce of 6,000+ Ascenders delivers solutions from around the globe. Ascendion is built differently to engineer the next.Ascendion | Engineering to elevate lifeWe have a culture built on opportunity, inclusion, and a spirit of partnership. Come, change the world with us:Build the coolest tech for world’s leading brandsSolve complex problems - and learn new skillsExperience the power of transforming digital engineering for Fortune 500 clientsMaster your craft with leading training programs and hands-on experienceExperience a community of change makers!Join a culture of high-performing innovators with endless ideas and a passion for tech. Our culture is the fabric of our company, and it is what makes us unique and diverse. The way we share ideas, learning, experiences, successes, and joy allows everyone to be their best at Ascendion.Job Title: Oracle Essbase / Hyperion Planning DeveloperLocation:Remote - USAExperience:4-8 YearsJob OverviewWe are seeking an experienced Oracle Essbase / Hyperion Planning Developer to develop, enhance, and support enterprise financial planning and reporting applications. The ideal candidate will have strong hands-on experience with Oracle Essbase (BSO/ASO), Hyperion Planning, calculation scripts, business rules, and financial data integrations.This role will focus on maintaining application stability, troubleshooting production issues, supporting financial planning processes, and ensuring data accuracy across enterprise systems. The candidate will collaborate closely with Finance, Infrastructure, and Business teams to deliver reliable and efficient Enterprise Performance Management (EPM) solutions.Experience with AWS environments and general application maintenance, including patching and infrastructure-related troubleshooting, is Highly preferred.Key ResponsibilitiesDesign, develop, enhance, and maintain Oracle Essbase BSO/ASO cubes and financial reporting structures.Develop and maintain Essbase calculation scripts, Hyperion Planning business rules, and MaxL scripts.Build and support financial data integrations using FDMEE/Data Management, Oracle Data Integrator (ODI), and enterprise ERP systems.Troubleshoot data load failures, calculation errors, reporting discrepancies, and integration issues.Support Hyperion Planning applications used for budgeting, forecasting, financial planning, and reporting.Perform SQL-based data validation, reconciliation, and troubleshooting to ensure data integrity.Provide production support, investigate application incidents, and implement corrective actions to maintain system stability.Support application maintenance activities, including patching, upgrades, performance monitoring, and issue resolution, as applicable to the environment.Collaborate with Infrastructure teams on application availability, environment stability, and technical troubleshooting.Participate in production support and on-call rotations as required.Work with Finance and business stakeholders to gather requirements, implement enhancements, and support financial reporting needs.Required Qualifications4-8 years of hands-on experience withOracle Essbase (BSO/ASO) and Hyperion Planning.Strong proficiency inEssbase calculation scripts, MaxL, and Hyperion Planning business rules.Experience withFDMEE/Data Management or Oracle Data Integrator (ODI)for financial data integration.Strong SQL skills for data validation, reconciliation, and troubleshooting.Experience supporting enterprise financial planning, budgeting, forecasting, and reporting applications.Understanding of financial data flows, application dependencies, and production support processes.Experience troubleshooting application issues and maintaining data accuracy and system reliability.Ability to collaborate effectively with Finance, Business, and Infrastructure teams.Preferred QualificationsExperience with Oracle Cloud EPM, including PBCS or EPBCS.Familiarity with EPM Automate for application administration and automation.Experience integrating Hyperion Planning or Essbase with Oracle EBS, SAP, or other ERP systems.Scripting experience with Shell or Python for automation and operational support.Familiarity with AWS environments, particularly application maintenance, patching, environment support, and infrastructure-related troubleshooting.Experience working with high-volume enterprise data environments.Knowledge of performance optimization, release management, and enterprise application support best practices.Ideal Candidate ProfileThe ideal candidate combines strong Oracle Essbase and Hyperion Planning development skills with practical production support experience.They should be comfortable developing calculation logic, maintaining financial data integrations, resolving complex application issues, and supporting enterprise financial planning systems in a remote environment.Salary Range: The salary for this position is between $150,000 - $160,000 annually. Factors which may affect pay within this range may include geography/market, skills, education, experience and other qualifications of the successful candidate.Benefits : The Company offers the following benefits for this position, subject to applicable eligibility requirements: [medical insurance] [dental insurance] [vision insurance] [401(k) retirement plan] [long-term disability insurance] [short-term disability insurance] [personal days accrued each calendar year. The Paid time off benefits meet the paid sick and safe time laws that pertains to the City/ State] [12-15 days of paid vacation time] [6-8 weeks of paid parental leave after a year of service] [9 paid holidays and 2 floating holidays per calendar year] [Ascendion Learning Management System] [Tuition Reimbursement Program]Want to change the world? Let us know.Tell us about your experiences, education, and ambitions. Bring your knowledge, unique viewpoint, and creativity to the table. Let’s talk!