6 Jobs in Cranberry, PA
PPG Industries is Hiring a Hyperion Administrator Near Cranberry, PA
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.
- 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.About us:
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
Full Time
Durable Manufacturing
$72k-92k (estimate)
02/07/2024
05/27/2024
ppg.com
PITTSBURGH, PA
15,000 - 50,000
1883
Public
MICHAEL H MCGARRY
$10B - $50B
Durable Manufacturing
Related Companies
About PPG Industries
PPG manufactures and distributes industrial coatings, architectural paints and packaging sealants for aerospace and construction sectors.
The job skills required for Hyperion Administrator include Analysis, Planning, SQL, Leadership, Commitment, Initiative, etc. Having related job skills and expertise will give you an advantage when applying to be a Hyperion Administrator. That makes you unique and can impact how much salary you can get paid. Below are job openings related to skills required by Hyperion Administrator. Select any job title you are interested in and start to search job requirements.
The following is the career advancement route for Hyperion Administrator positions, which can be used as a reference in future career path planning. As a Hyperion Administrator, it can be promoted into senior positions as a Systems Administrator III that are expected to handle more key tasks, people in this role will get a higher salary paid than an ordinary Hyperion Administrator. You can explore the career advancement for a Hyperion Administrator below and select your interested title to get hiring information.
Similar Jobs
Popular Articles
