JLL supports the Whole You, personally and professionally.
Our people at JLL are shaping the future of real estate for a better world by combining world class services, advisory and technology to our clients. We are committed to hiring the best, most talented people in our industry; and we support them through professional growth, flexibility, and personalized benefits to manage life in and outside of work.  Whether you’ve got deep experience in commercial real estate, skilled trades, and technology, or you’re looking to apply your relevant experience to a new industry, we empower you to shape a brighter way forward so you can thrive professionally and personally.

EPM Consultant

What this job involves:

EPBCS Administrator will support the EPBCS system at JLL.  This includes support in the use, design, development, configuration, and testing EPBCS modules.  The administrator will provide support in functional tasks of medium-to-high technological complexity.  The administrator will provide support in maximizing the value of EPBCS by identifying and recommending functional and technological solutions to improve business processes, enhance Planning and Budgeting functionality and meet internal and external reporting requirements while providing production and end user support

• Identify business requirements, translating business requirements into functional and technical design, building prototypes, creating process design (including scenario design, flow mapping), leading testing and training activities, defining support procedures and SLAs and supporting implementations post go-live.
• Understand the business processes, how the application supports the business processes, and apply this knowledge to best solve problems
• Understands dependencies and interrelationships between functional components of EPBCS
• Provide alternatives and recommendations based on best practices and application functionality.
• Interpret and transform information based on business requirements and provide the data for delivery
• Develop functional specifications and complete object development and testing
• Essbase BSO and ASO cubes – Outlines, dimensions, measures, members, metadata administration with ability to design databases and complex calculations
• Design, build and troubleshoot cubes and related objects
• Employ knowledge of Essbase to facilitate better deployment of Planning, application security, and other interface tools
• Strategic Modelling\Planning\Essbase application configuration
• Automation, SQL, Batch scripting, EPM Automate Data Loads, batch jobs
• Provide alternatives based on best practices and application functionality
• Create test plans, test cases and test scripts and perform functional testing
• Create and maintain system documentation
• Provide training and documentation for supported applications
• Develop and maintain all relevant documentation, specifically the process maintenance
• Ensure that appropriate process and systems controls are in place and maintained to guarantee the integrity of master data, including performing & reporting on periodic audits
• Ensure that all relevant parties are timeously informed of master data changes
• Contribute to achievement of master data performance and quality standards as defined by service level agreements
• Proactively identify opportunities for improvement that increase efficiency and effectiveness of MDM processes
• Seek to drive the highest standards of customer service to Finance teams globally

Sound like you? To apply you need to be:

• Experience In Oracle Planning Cloud including Strategic Modeling, Financials, Projects, Capital, and Workforce Modules
• Experience in Essbase BSO and ASO cubes, Build/Enhance Hyperion Financial Reports
• Knowledge of Metadata management and update to downstream application to EPBCS and Essbase ASO is mandatory
• Experience in Calculation Manager including Groovy Scripting
• Knowledge of SQL query in Oracle & SQL Data base will be a plus
• The candidates should have the ability to understand user requirements in EPM and Finance domain and convert them into design specs and architecting solutions
• We require candidates who can lead and support Hyperion application
• Candidate having experience in end to end Hyperion EPM Implementation and Support
• The candidates should be able to understand the existing system and do the reverse engineering on the existing system.
• Strong financial and analytical skills and an advanced understanding of the financial planning process is additive.
• Automation of Metadata/Data load script using epmAutomate and PowerShell commands.
• Implementation experience of above products including:
• Analysing and documenting business requirements
• Writing functional specifications
• Testing and troubleshooting
• Interfacing with clients and business users
• 6-8 yrs EPBCS / Hyperion Planning administration experience
• At least a bachelor’s degree (or equivalent) or relevant experience
• Oracle Data Management or FDMEE experience
• Competency in Microsoft Office and Smart View
• Good knowledge of English (written and spoken)
• Good understanding of how data flows and systems work
• Understanding of Budgeting and Forecasting related Leading Practices
• Experience with Financial statements to include Income Statement, Balance Sheet, and Cash Flow
• Self-motivated, confident and energetic
• Proactive and able to work with remote oversight; demonstrates initiative, autonomy and independence
• High attention to detail
• Strong communicator and relationship builder
• Strong customer service focus
• Willingness to work under monitored targets
• Flexible and adaptable
• Must be a team player with the ability to work independently and be accountable for results
• Strong team player - proven success in contributing to a team-oriented environment
• Proven ability to work creatively and analytically in a problem-solving environment
• Excellent communication (written and oral) and interpersonal skills
• Excellent troubleshooting and problem resolution skills
• Detail oriented, self-starter

What we can do for you:

At JLL, we make sure that you become the best version of yourself by helping you realize your full potential in an entrepreneurial and inclusive work environment. We will empower your ambitions through our dedicated Total Rewards Program, competitive pay and benefits package.

Apply today!