Not Authorized
You are currently not authorized to access this section.
Please contact your Administrator to change your authorization settings.
Please contact your Administrator to change your authorization settings.
Hyperion Administrator
Cranberry Township, PA
Job Description
The Architectural Coatings US & CanadaHyperion Essbase Administratorwill be a member of the SBU's Financial Planning and Analysis group. You will be tasked with the administration, maintenance and continual improvement of the Hyperion Essbase and Hyperion Planning applications.You will work with other departments, including Information Technology, to review business and system requirements or systems design, plans for build, test and post-implementation to ensure successful implementation and execution for the Finance Teams.You will support ad-hoc financial analysis and budgeting processes within the outlined applications. You will report to the Senior Finance Reporting Manager.
Key Responsibilities
- Administer Hyperion Essbase and Hyperion Planning applications within Architectural Coatings US & Canada.
- Collaborate with the data warehouse team, utilizing SQL for Relational Tables and Views integration into Oracle DRM and Essbase Cubes.
- Support month-end closing processes, including data loads, aggregations, calculations, and reconciliations through FDMEE.
- Utilize Data Relationship Management (DRM) for maintaining Master Data and Reference data, focusing on data analytics, modeling, views creation, validation, queries, and batch process automation.
- Assist in the annual budget process in Hyperion Planning and maintain hierarchies/outlines and properties in DRM for Planning and Essbase ASO/BSO applications.
- Adapt and optimize applications for changes in business structure and strategy.
- Perform artifact migration between different environments using Hyperion LCM.
- Validate and reconcile systems during implementations and upgrades, occasionally requiring weekend and off-hours work.
- Lead initiatives to identify and implement additional analytical tools to guide business profitability.
- Responsible for periodic upgrades to Hyperion applications to improve functionality and compatibility.
- Ensure data integrity and accuracy within Financial Planning applications. Develop and implement the necessary operational controls.
- Ensure accurate generation of all reporting, ensuring consistency and standardization amongst the types of reports and databases.
- Develop a comprehensive understanding of Planning and Incentives to identify initiatives that add value to recurring reporting needs and processes.
- Train users in all aspects of new software.
- Develop Block Storage Cubes (B.S.O) Aggregated Storage (A.S.O) cubes.
- Developed Calc Scripts, Report Scripts, Business Rule, Build Rules and Load Rules.
- Developed batch files using MaxL and ESSCMDs and rule files to upload data from system's database to Essbase cube.
- Worked with Hyperion security and Planning in developing web-based forms for the budgeting and forecasting purpose.
Qualifications
- Bachelor's degree in a business related field and 5+ years of related experience in Hyperion Essbase Administrationor Financial Consolidations is required.
- Develop and maintain Hyperion Essbase applications, data load rules, dimension build rules, calculation scripts, report scripts
- Create, maintain, and optimize Essbase outlines - manually and through MaxL scripts
- Ability to interface with users to quickly correct problems and develop solutions.
- Working knowledge of Microsoft Excel (Smart View), relational databases (Oracle), general ledger systems (predominantly SAP), Financial Reporting Studio
- Weekend and off-hours work sometimes required, particularly around month-end closing.
Benefits: medical/dental/vision/life insurance, 401K, PTO, and more! #LI-Hybrid
PPG pay ranges and benefits can vary by location which allows us to compensate employees competitively in different geographic markets. PPG considers several factors in making compensation decisions including, but not limited to, skill sets, experience and training, qualifications and education, licensure and certifications, and other organizational needs. Other incentives may apply.
Our employee benefits programs are designed to support the health and well-being of our employees. Any insurance coverages and benefits will be in accordance with the terms and conditions of the applicable plans and associated governing plan documents.
Here at PPG we make it happen, and we seek candidates of the highest integrity and professionalism who share our values, with the commitment and drive to strive today to do better than yesterday - everyday.
PPG: WE PROTECT AND BEAUTIFY THE WORLD
Through leadership in innovation, sustainability and color, PPG helps customers in industrial, transportation, consumer products, and construction markets and aftermarkets to enhance more surfaces in more ways than does any other company.. To learn more, visit www.ppg.com and follow @ PPG on Twitter.
The PPG Way
Every single day at PPG:
We partner with customers to create mutual value.
We are "One PPG" to the world.
We trust our people every day, in every way.
We make it happen.
We run it like we own it.
We do better today than yesterday - everyday.
PPG provides equal opportunity to all candidates and employees. We offer an opportunity to grow and develop your career in an environment that provides a fulfilling workplace for employees, creates an environment for continuous learning, and embraces the ideas and diversity of others. All qualified applicants will receive consideration for employment without regard to sex, pregnancy, race, color, creed, religion, national origin, age, disability status, marital status, sexual orientation, gender identity or expression. If you need assistance to complete your application due to a disability, please email recruiting@ppg.com.
PPG values your feedback on our recruiting process. We encourage you to visit Glassdoor.com and provide feedback on the process, so that we can do better today than yesterday.
Benefits will be discussed with you by your recruiter during the hiring process.
PPG provides equal opportunity to all candidates and employees. We offer an opportunity to grow and develop your career in an environment that provides a fulfilling workplace for employees, creates an environment for continuous learning, and embraces the ideas and diversity of others. All qualified applicants will receive consideration for employment without regard to sex, pregnancy, race, color, creed, religion, national origin, age, disability status, marital status, veteran status, sexual orientation, gender identity or expression. If you need assistance to complete your application due to a disability, please email recruiting@ppg.com. Pay Transparency poster: https://www.dol.gov/sites/dolgov/files/ofccp/pdf/pay-transp_ English_formattedESQA508c.pdf
EEO is the Law: https://www.eeoc.gov/sites/default/files/migrated_files/employers/eeoc_self_print_poster.pdf
EEO is the Law Supplement: http://www.eeoc.gov/sites/default/files/migrated_files/employers/eeoc_gina_supplement.pdf
Job Summary
Company
Start Date
As soon as possible
Employment Term and Type
Regular, Full Time
Required Education
Bachelor's Degree
Required Experience
5+ years
Email this Job to Yourself or a Friend