Job Description

Application Development Associate Advisor – Hyperion is responsible for ensuring the stability, efficiency, and compliance of enterprise applications across their lifecycle. This role supports both business and technology production operations, through performing coordinating fixes, maintaining architecture currency, and driving operational excellence. The position requires a strong understanding of application ecosystems, business processes, and regulatory requirements.

Qualifications

Required Skills:

• 8-11 years minimum of experience in enterprise application development using Hyperion:

  • HFM (Global)

    • Classic HFM business rules (not Calculation Manager business rules)

    • FDMEE

    • HFR

    • Knowledge of Dimension Properties for HFM

  • FCCS (Domestic / Enterprise Consolidations)

    • Knowledge of business rules

    • Data Exchange

    • Reports

    • Knowledge of Dimension Properties for FCCS

• ARCS

• Data Exchange

• Transaction Matching

• Reports

• EPM Automate

• Microsoft PowerShell Scripting

• Oracle Enterprise Project Management Cloud (EPCMCS)

• Configure and support of cost collection, burdening, capitalization, and cost allocation processes

• Experience configuring expenditure types, cost rates, project classification, and cost structure, and associated EPCMCS rules

• Integrate costing with GL and Subledger Accounting

• Manage Oracle Cloud security roles and data access for costing

• Enterprise Planning & Budgeting Cloud (EPBCS)

• Design and support budgeting, forecasting, and long-range planning applications

• Build and maintain dimensions, metadata, and hierarchies

• Develop business rules, calculations, and data maps

• Implement driver-based planning and scenario modeling

• Manage data loads and integrations

• Trouble shoot calculation, performance, and data issues

• Enterprise Data Management Cloud (EDMCS)

• Design, develop and maintain data hierarchies, metadata and master data structures to support financial and enterprise data governance.

• Configure validations, properties, property categories, blends, exports, node types, versioning and other components to ensure data integrity across financial applications.

• Set up and manage EDM applications, data chains, subscriptions, node type converters, views and viewpoints to streamline data governance.

• Perform environment migrations for EDM to ensure seamless transition across development, test, UAT and production environments.

• Develop, configure and test integrations between EDM and other Hyperion and Non-Hyperion applications (HFM, FCCS, ARM, ARCS, ARCS, EBS, ERP, Essbase, Allocations, Workday, Ariba, etc.)

• Maintain and update automation scripts (batch scripts, PowerShell, epmautomate, B2B connections.)

• Implement and enforce data governance best practices while ensuring compliance with internal controls, audit requirements, and corporate policies.

• Apply skip updates in EDM for selected Oracle updates and conduct regression testing post updates for EDM.

• Maintain up-to-date documentation on system configurations, processes and best practices.

• Support system enhancements and adhere to internal life cycle change management policies.

• DRM

• Developing properties

• Developing Action Scripts

• Developing Hierarchies

• Developing Blends and Exports

• DOS batch

• ARM

• Creating Attributes

• FDMEE

• VBScript and DOS batch

• SQL for creating reports

• How to create FDMEE custom reports

• How to create FCM custom reports

• FDMEE

• Import Format scripts

• FDMEE mapping scripts

• VBScript and DOS batch

• HFR

• Creating reports with formulas

• Smart View

• Creating reports with Function Builder

• Essbase

• Solid understanding of BSO/ASO architecture and their inner workings

• Develop Calculation scripts, rule files, partitions

• Optimization techniques for scripts as well as query response times

• MaxL scripting and automation in Unix/Linux and Windows OS environments

• Basic understanding of Custom Defined Functions is a plus

• Planning

• Designing Webforms

• Developing Business Rules in Calc Manager

• Familiarity with Member Lists, Allocations/Spreads

• Understanding of Security in Planning and how it relates to Essbase

• Understanding of corporate business processes, including fundamental finance concepts as well as forecasting and budgeting cycles, and corporate reporting requirements

• Proven experience in application support, production operations, and IT-business coordination; including experience developing applications under an onshore-offshore model.

• Strong understanding of upstream/downstream integrations between mainframe, Oracle, and distributed services.

• Experience with job scheduling tools, monitoring systems, and automation platforms.

• Knowledge of industry standard source control systems

• Strong analytical and problem-solving skills with a focus on root cause analysis and long-term fixes.

• Familiarity with regulatory compliance frameworks (SOX, CIP).

• Experience with job scheduling tools, monitoring systems, and automation platforms.

• Excellent communication (written & verbal), attention to detail, and documentation skills with the ability to interact with all levels of the organization.

• Strong interpersonal/relationship management skills.

• Strong time management skills.

Required Experience & Education:

• 8-11 years minimum of experience working in production support.

• College degree (Bachelor) in related technical/business areas or equivalent work experience.

• Microsoft certifications

Desired Experience: 

• Experience with Accounting and Finance applications

Responsibilities

Application & Production Support

• Perform production fixes including troubleshooting with technology and business partners through solution implementation and validation.

• Coordinate with upstream/downstream systems for issue resolution, scheduling, and change notifications.

• Monitor job run times and tune performance to meet SLAs/OLAs.

Operational Performance

• Support daily/weekly/monthly/annual business processes requiring close collaboration between IT and business teams.

• Manage batch cycles, code promotions, and release implementations.

• Maintain application health checks and monitor reliability/availability.

Architecture & Efficiency

• Ensure architecture currency through updates and maintenance aligned with enterprise standards.

• Identify and implement automation opportunities to improve efficiency and reduce manual effort.

• Sunset obsolete jobs, reports, and applications following retention protocols.

Documentation & Knowledge Management

• Maintain system and process documentation including CMDB audits, SMTD reviews, system runbooks, and security diagrams.

• Update knowledge bases including process and procedures documentation to reflect current operational practices and technical configurations.

Vendor & Compliance Coordination

• Collaborate with software vendors to resolve hosted solution issues including patching, packaging, and firewall coordination.

• Respond to infrastructure and compliance surveys (e.g., CSCI, CMDB Security Profiles).

• Support legal/regulatory requirements including SOX testing, CIP remediation, and segregation of duties.

Project & Portfolio Support

• Provide support for strategic initiatives

• Maintain applications/code in response to technological changes (e.g. server upgrades, mainframe rationalization).

• Perform small enhancements as directed by business or leadership.

Disaster Recovery & Risk Management

• Conduct disaster recovery testing and ensure readiness of applications.

• Support CIP initiatives and Vulnerabilities Remediation.

Reporting & Communication

• Prepare and present operational status reports (e.g., MOR decks, WSRs) to leadership.

• Communicate production health, open issues, and improvement opportunities to stakeholders.

Other Duties as Assigned

• Perform additional responsibilities as required to support the team, department, or organization’s goals and initiatives.

Equal Opportunity Statement

Evernorth is an Equal Opportunity Employer actively encouraging and supporting organization-wide involvement of staff in diversity, equity, and inclusion efforts to educate, inform and advance both internal practices and external work with diverse client populations.

About Evernorth Health Services

Evernorth Health Services, a division of The Cigna Group, creates pharmacy, care and benefit solutions to improve health and increase vitality. We relentlessly innovate to make the prediction, prevention and treatment of illness and disease more accessible to millions of people. Join us in driving growth and improving lives.