Hyperion (HFM/HP) - Software Developer

About BNP Paribas India Solutions Established in 2005, BNP Paribas India Solutions is a wholly owned subsidiary of BNP Paribas SA, European Union’s leading bank with an international reach. With delivery centers located in Bengaluru, Chennai and Mumbai, we are a 24x7 global delivery center. India Solutions services three business lines: Corporate and Institutional Banking, Investment Solutions and Retail Banking for BNP Paribas across the Group. Driving innovation and growth, we are harnessing the potential of over 10000 employees, to provide support and develop best-in-class solutions.

About BNP Paribas Group BNP Paribas is the European Union’s leading bank and key player in international banking. It operates in 65 countries and has nearly 185,000 employees, including more than 145,000 in Europe. The Group has key positions in its three main fields of activity: Commercial, Personal Banking & Services for the Group’s commercial & personal banking and several specialised businesses including BNP Paribas Personal Finance and Arval; Investment & Protection Services for savings, investment, and protection solutions; and Corporate & Institutional Banking, focused on corporate and institutional clients. Based on its strong diversified and integrated model, the Group helps all its clients (individuals, community associations, entrepreneurs, SMEs, corporates and institutional clients) to realize their projects through solutions spanning financing, investment, savings and protection insurance. In Europe, BNP Paribas has four domestic markets: Belgium, France, Italy, and Luxembourg. The Group is rolling out its integrated commercial & personal banking model across several Mediterranean countries, Turkey, and Eastern Europe. As a key player in international banking, the Group has leading platforms and business lines in Europe, a strong presence in the Americas as well as a solid and fast-growing business in Asia-Pacific. BNP Paribas has implemented a Corporate Social Responsibility approach in all its activities, enabling it to contribute to the construction of a sustainable future, while ensuring the Group's performance and stability Commitment to Diversity and Inclusion At BNP Paribas, we passionately embrace diversity and are committed to fostering an inclusive workplace where all employees are valued, respected and can bring their authentic selves to work. We prohibit Discrimination and Harassment of any kind and our policies promote equal employment opportunity for all employees and applicants, irrespective of, but not limited to their gender, gender identity, sex, sexual orientation, ethnicity, race, colour, national origin, age, religion, social status, mental or physical disabilities, veteran status etc. As a global Bank, we truly believe that inclusion and diversity of our teams is key to our success in serving our clients and the communities we operate in.

About Business Line/Function The Intermediate Holding Company (“IHC”) program structured at the U.S. level across poles of activities of BNP Paribas provides guidance, supports the analysis, impact assessment and drives adjustments of the U.S. platform’s operating model due to the drastic changes introduced by the Enhanced Prudential Standards (“EPS”) for Foreign Banking Organizations (“FBOs”) finalized by the Federal Reserve in February 2014, implementing Section 165 of U.S. Dodd-Frank Act. The IT Transversal Team is part of the Information Technology Group which works simultaneously on a wide range of projects arising from business, strategic initiatives, and regulatory changes and reengineering of existing applications to improve functionality and efficiency.

Job Title Hyperion Developer

Date Jan-26

Department ITG- FRS (Finance & Risk) Location: Chennai, Mumbai

Business Line / Function Finance Dedicated Solutions

Reports To (Direct)

Grade (if applicable) (Functional)

Number Of Direct Reports NA

Directorship / Registration NA Position Purpose The Hyperion Developer has a critical role in developing, implementing, and maintaining Oracle Hyperion (including Hyperion Planning, Essbase, Financial Management (HFM), Hyperion Financial Data Quality Management (FDM/FDMEE), and Hyperion Reporting & Dashboards) to support financial planning, consolidation and reporting processes. This position ensures the integrity, performance, and scalability of Hyperion applications while collaborating with finance, IT, and business stakeholders to deliver accurate, timely, and actionable financial insights. A sound understanding of financial principles, data governance, and regulatory compliance is critical to success in this role, ensuring that Hyperion solutions align with business objectives, audit requirements, and industry best practices. The detailed responsibilities mentioned below.

Responsibilities Direct Responsibilities

• Design, Develop & Maintain Hyperion Applications
• Build, configure, and enhance Hyperion Planning, Essbase, HFM, and FDMEE solutions to meet financial reporting, budgeting, and forecasting needs.
• Develop calculation scripts, business rules, and data integration workflows to ensure accuracy and efficiency.
• Optimize System Performance & Scalability
• Monitor and tune Essbase cubes, database structures, and calculation processes to improve speed, reliability, and user experience.
• Conduct performance benchmarking and recommend infrastructure or configuration upgrades as needed.
• Ensure Seamless Data Integration & Validation
• Design and maintain ETL processes (FDMEE, ODI, or custom scripts) to integrate financial data from ERP, GL, and other source systems into Hyperion.
• Validate data accuracy, troubleshoot discrepancies, and implement automated reconciliation checks to ensure integrity.
• Develop Financial Reports & Dashboards
• Create standard and ad-hoc financial reports using Hyperion Financial Reporting, Smart View, and Oracle Analytics Cloud (OAC).
• Build interactive dashboards to provide real-time insights for FP&A, executive leadership, and operational teams.
• Provide Technical Support & Troubleshooting
• Resolve system errors, data inconsistencies, and user access issues with minimal downtime.
• Collaborate with IT and Finance teams to diagnose root causes and implement corrective actions.
• Enforce Security, Compliance & Governance
• Manage user roles, permissions, and audit trails to ensure SOX, GAAP, and internal compliance.
• Document system configurations, changes, and best practices to maintain governance and facilitate audits Contributing Responsibilities
• Familiarity with the Software Development Life Cycle (SDLC) process and its various stages, including experience with JIRA and Confluence.

Technical & Behavioral Competencies

• Hyperion Suite Proficiency (FDMEE, HFM, Essbase)
• 3+ years’ hands-on experience in Hyperion Financial Management (HFM) for financial consolidations, eliminations, and regulatory reporting (P&L, balance sheet, cash flow).
• Expertise in FDMEE for data integration, mapping, and validation from ERP systems (e.g., Oracle) into Hyperion, including scripted imports and error handling.
• Essbase Administration & Optimization (EAS, ASO/BSO)
• Strong Essbase Administration Services (EAS) skills for cube design, dimension builds, and partition management.
• Deep understanding of ASO (aggregation-heavy reporting) vs. BSO (calculation-intensive) cubes, including block storage tuning, hybrid analysis, and outline optimizations.
• Calculation Scripts & Automation (MaxL, Batch, Python)
• Proficient in writing and debugging Calc Scripts for complex financial logic (e.g., currency translations, intercompany eliminations, allocations).
• Experience with MaxL and batch scripting for automated data loads, consolidations, and report generation.
• Python scripting for ETL enhancements, data validation, or custom integrations, REST API calls
• Oracle 19c Database & SQL for Financial Data
• Strong SQL/PL-SQL skills to extract, transform, and validate data between Hyperion and Oracle 19c.
• Ability to optimize queries, indexes, and stored procedures for high-volume financial datasets (e.g., trade-level reconciliations).
• Reporting & Dashboard Development (HFR, Smart View, Excel)
• Skilled in Hyperion Financial Reports (HFR) and Smart View to build dynamic P&L reports, variance analyses, and regulatory filings.
• Experience creating Excel-based dashboards with drill-down capabilities for FP&A, risk, and compliance teams.
• Windows VM Performance & Troubleshooting
• Hands-on Hyperion administration on Windows VMs, including performance tuning, log analysis, and patch management.
• Ability to diagnose and resolve issues like slow calculations, memory leaks, or data load failures in a virtualized environment.
• Security, Compliance & Audit Controls
• Knowledge of Hyperion security models (user roles, data filters, audit logs) to enforce SOX.
• Experience implementing access controls, changing tracking, and encrypted data transfers for financial data.

Nice to Have

• Sound Programming & Analytical skills
• Strong communication skills to effectively collaborate with team members and stakeholders.
• Knowledge of regulatory frameworks, RISK, CCAR.

Skills Referential Specific Qualifications (if required) Behavioural Skills: (Please select up to 4 skills) Ability to collaborate / Teamwork Critical thinking Ability to deliver / Results driven Communication skills - oral & written Transversal Skills: (Please select up to 5 skills) Analytical Ability Ability to develop and adapt a process Ability to understand, explain and support change

Ability To Develop Others & Improve Their Skills Choose an item.

Education Level Bachelor Degree or equivalent Experience Level At least 3 years