Oracle EPM Analyst - Atlanta, GA - AMAT Corporate

Job ID:  501898

CRH's Americas Materials, a division of CRH, is the leading vertically integrated supplier of aggregates, asphalt, ready mixed concrete and paving and construction services in North America.  Our operations span North America with over 28,000 employees at close to 1,600 locations in 43 US States and 2 Canadian provinces.

Position Overview

The Analyst role will have the primary responsibility of supporting CRH Americas Materials’ EPM applications (financial reporting, forecast and budgeting applications). This involves maintaining existing EPM applications that includes Hyperion Planning, HFM, FCCS, ODI (data integration). Additionally, this position requires daily interactions with various EPM application users (from the finance team), resolution of queries, and supporting the monthly tasks. 

The ideal candidate will provide training to finance users on using excel smart view and reports, data validation and any relevant topics within the EPM space when required.  You will collaborate with finance end users to resolve data variance related issues, new accounts or new members setup, reports updates etc.  as well as take new requirements from finance users on any new request and implement them in the applications. you will monitor system performances, and develop new functionality when required.

This is a hybrid role and requires coming to the office located in Atlanta GA at least 3 days a week.

Key Responsibilities (Essential Duties and Functions)

To perform this job successfully, an individual must be able to perform each essential duty satisfactorily.

• Build good relationship with the key finance users and grow as an integral resource.
• Data integrations - Perform routine loading of data into EPM applications using ODI, scripts, SQL. FDMEE, SQL query knowledge will be a plus.
• Maintain financial reporting systems for CRH Americas Materials. One of which is to maintain the metadata in existing Hyperion Planning and HFM applications
• Support the development of new Oracle EPM applications in Cloud (PBCS, FCCS etc) to replace existing on prem applications
• Maintain calc scripts in EPM
• Maintain and develop report scripts for data migration
• Design and maintain reports, web forms, scripts, task lists, security and any other artifacts required
• Update business rules, scripts, variables, ETL reference tables, and other system artifacts
• Monitor audit logs and system activity required to ensure a stable Hyperion environment
• Monitor calc times, server load, logs, database statistics: fragmentation ratios, member counts, etc
• Create and implement process improvements, including testing, validating and recording of change process
• Maintain and update the documentation on close related tasks. Develop new documentation if required.
• Perform other duties as assigned

Qualifications

Education/Experience

• Bachelor’s degree in Computer Science, Info Science, Engineering.
• 1 to 2 years of relevant experience working with different financial systems. Oracle Essbase, Hyperion Planning system on version 11.1.2.x. or Cloud EPM will be a plus.
• At least One full life cycle experience of design and implementation of related EPM applications is preferred
• Oracle Planning and Budgeting Cloud Services experience a plus
• Oracle Data Integration (ODI), HFM, FDM, SQL experience a plus
• Must be able to multi-task, be detailed oriented and possess strong organizational skills
• Scripting experience will be a plus

Work Requirements

• Must have expert proficiency in Microsoft Word, Excel, PowerPoint, and Outlook
• Must be willing to learn and develop new skills in the EPM and finance space.
• Must be 18 years in age or older
• Must pass pre-employment drug screen and criminal background check
• Strict adherence to safety requirements and procedures as outlined in the Employee Handbook
• Willingness to work independently within in a team environment and assist the team with other duties as required

Knowledge/Skill Requirements

• Excellent technical and analytical skills
• Self-motivation and ability to operate independently
• Demonstrate close attention to details and accuracy
• Proactive problem solver able to anticipate issues and provide timely resolution
• Ability to work comfortably in a changing environment
• Able to retain and quickly apply the knowledge learned to the job function
• Team player with excellent interpersonal skills to build effective company relationships

Physical Requirements

The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job

• Able to communicate with others by telephone and in person
• Able to utilize a computer for word processing, email communication, and preparation of documents and presentations
• May require sitting for extended periods of time

Work Environment

The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job

• Usually, normal office working conditions.  The noise level in the work environment is usually quiet.
• The position may require work outside of normal business hours

The statements included in this job description are not intended to be all-inclusive.  They represent typical elements and criteria necessary to successfully perform the job.  Other duties may be assigned as required.  Requirements for this job are subject to modification by the Company and its designees, and reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

What CRH Offers You

• Highly competitive base pay
• Comprehensive medical, dental and disability benefits programs
• Group retirement savings program
• Health and wellness programs
• A diverse and inclusive culture that values opportunity for growth, development, and internal promotion

About CRH

CRH has a long and proud heritage. We are a collection of hundreds of family businesses, regional companies and large enterprises that together form the CRH family. CRH operates in a decentralized, diversified structure that allows you to work in a small company environment while having the career opportunities of a large international organization.

If you’re up for a rewarding challenge, we invite you to take the first step and apply today! Once you click apply now, you will be brought to our official employment application. Please complete your online profile and it will be sent to the hiring manager. Our system allows you to view and track your status 24 hours a day. Thank you for your interest!

CRH Americas Materials Inc. is an Affirmative Action and Equal Opportunity Employer.

EOE/Vet/Disability--If you want to know more, please click on this link.