Hyperion Developer Business Intelligence Hub

Job Description

Hyperion Developer Business Intelligence Hub Global Shared services | Gurgaon 32 , India | Full TimeJob DescriptionIDP Education is a world leader in international student placement services. With a network of over 110 international student placement centres, we have a global presence in more than 32 countries.Student placementIDP Education Limited is an ASX listed company that is 50 PERCENT owned by 38 Australian universities. For nearly 50 years, we have played a major role in international education. We have placed more than 500,000 students into quality institutions in Australia, the United Kingdom, the United States of America, Canada and New Zealand.IELTSWe are a proud co-owner of IELTS (International English Language Testing System). IELTS is jointly owned by British Council, IDP: IELTS Australia and Cambridge English Language Assessment. Since its launch in 1989, IELTS has become the worlds most popular high-stakes English language proficiency test.Over 10,000 organizations worldwide accept IELTS as evidence of English language proficiency. Last year, more than 3 million tests were taken globally. IDP Education offers the IELTS test in more than 400 test locations in 55 countries.English language teachingIDP Education has been involved in English language teaching since 1988 and runs English language schools in Thailand, Vietnam and Cambodia.HotcoursesHotcourses Ltd the leading International student search and discovery business is an IDP company with 17 websites and more than 70 million unique visits per annum across its websites.IDPs global business is overseen by the Global Leadership Team (GLT). Led by the CEO it comprises Chief Operating Officer, Chief Financial Officer, Chief Strategy Officer, Head of People Experience, Director Corporate Development and Regional Directors for Greater China, South East Asia, South Asia, Hotcourses, Australasia and the Middle East.Position PurposeIDP has created a separate team (Business Intelligence Hub) under Global Shared Services function to host Reporting Shared Services which is responsible for creating/ developing, revising, reviewing & publishing host of reports on Oracle BI platform. Source of data can be operating application platforms used by Student counselling team (CRM, marketing and commerce platforms SAP cloud based), Financial ERP (Oracle 12R platform) & various other applications/ sources.Team will be co-located along with Global Finance Shared Services function which is headed by Director FP&A & CFO Shared Service.Developer Business Intelligence Hub will be Oracle Business Intelligence expert and will be responsible for the development of customised data analytics and reporting solutions, including interactive dashboards and infographics on IDP Reporting platform Oracle BI. The incumbent will develop custom reports and data visualization products using large datasets, of structured and unstructured data, to transform data into actionable insightsIt is expected that a structured, methodical and standardised reporting model is in place including but not limited to logical data models, data dictionaries, data modelling capabilities so that IDP has a consistent and reliable reporting framework. This role will be accountable for leading the best practices required for an enterprise grade reporting suite of business intelligence.Key Requirements from this position - Adhering to reporting standards, data sets and data definitions and the audienceProven analytical and problem solving skillsEnsuring data accuracy and integrity - provide support in data reconciliation efforts and post-implementation support including troubleshooting of system and data related issuesAble to communicate effectively with finance professionals (of all levels) and ITStrong technical acumen with Agile way of workingTeam player with the ability to work independently and be accountable for results Self-motivation and a proven track record of effective time managementJOB Description Oracle Hyperion EPM Applications:Oracle EPM applications: Hyperion Planning 11.1.2.4.000 and Essbase 11.x or higher (Hyperion on Cloud experience, preferred)Essbase Excel add in, Smartviewo Knowledge of Essbase (BSO / ASO cube design, load Rules, calculation scripts, and MaxL Scripts)Shared Services AdminPerformance Management WorkspaceModify/ Create Hyperion planning calculations (calc scripts, business rules) including performance tuning and optimisation of scriptsDevelop and Modify Financial/Management Reports using Financial Reporting StudioHyperion Planning System Administration (Dimension updates including alternate hierarchies, Webform Planning maintenance)Support for development/integration projects and process improvement initiativesDevelops test plan, Essbase test sheets and performs unit testing, system integration testing and organise User Acceptance Testing of Hyperion development, enhancement and new Hyperion releases ensuring compliance to companys change management process.Ensuring data accuracy and integrity - provide support in data reconciliation efforts and post-implementation support including troubleshooting of system and data related issuesQualificationo Master/Bachelor degree or equivalent professional qualifications.Experienceo Minimum 8-9 years of relevant experience in a mid-sized MNC or Consulting/Service Organisation on Oracle BI developer role.Technology acumen:o Data structures technical knowledge of the ERP application e.g. Oracle e-Biz 12c and SAP.o Data Warehousing Data Modelling Conceptso Hand on expertise in Administration & Development of Oracle Hyperion EPM tools like Hyperion Planning, Budgeting, FR Reporting and Essbase.Other Skills:o Develops test plans, performs Unit Testing, SIT - System Integration Testing and organise UAT - User Acceptance Testing of Hyperion applications and Essbase development, enhancements.Governance understanding of release management (Service Now) & code deployment management ensuring compliance to companys Agile change management process

Keyskills :
reportsdata reconciliationhyperioncommercereportingerpsapchief financial officermanagement reportsteam playerbudgetingexcelfinancial reportingfinance