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.