What are the responsibilities and job description for the Senior Oracle EPM Analyst position at Target Hospitality?
Description:
Senior Oracle EPM Analyst will collaborate and interact with the Accounting/Finance departments to ensure efficient delivery of finance-related technology projects. The candidate must have hands-on expertise in implementing and supporting Oracle EPM Suite.
Senior Analyst ensures that Technology solutions are developed, tested, and implemented to satisfy business requirements. Further, this position requires a high degree of practical business knowledge, creativity, customer/end-user focus, and a team-oriented collaborative mindset.
Responsibilities:
- Administer Oracle EPM: maintaining/tracking of hierarchy/system updates, regular database maintenance, validation and reconciliation, system security, backups and recovery, and troubleshooting system issues.
- Creating metadata changes in Oracle EPM environments including adding new GL accounts, new departments, new formulas/scripts, etc.
- Execute set up and provide ongoing training for Oracle EPM Financial Close and Consolidation, Oracle Planning Budgeting Cloud System (Hybrid BSO and ASO cubes), and Oracle – Narrative Reporting and Oracle Smartview add-in for application’s user base.
- Write custom Business Rules and/or Calculation Scripts for custom logic to facilitate client budgeting and forecasting needs.
- Assist with the integration of Hyperion/EPM applications with existing processes, including budgeting and forecasting, financial consolidation and close, and data warehouse/management reporting.
- Develops and enhances Oracle Narrative Reports based of Oracle ASO cube.
- Design and implement custom reports using EPM reporting tools to address company needs and improve frequency, accuracy, and timeliness of reporting.
- Configure application components, including dimensions, currency translation, intercompany eliminations, forms, reports, Smart View templates, and application rules in line with business, functional, and performance requirements.
- Leads implementation of enterprise security standards into the Cloud EPM suite of applications.
- Reviews monthly cloud releases for Oracle EPM, prepares, and executes required testing in a non-production environment, and provides recommendations for enhancements using new features.
- Participates in the identification of problem areas and development of resolutions to address them.
- Supports technical issue resolution in co-ordination with Managed Service providers and Oracle Support as needed.
- Act as system project manager as necessary to ensure the successful coordination and completion of the project.
Requirements
Bachelor’s degree in information systems, Finance/Accounting, Computer Science, Math or other related fields or equivalent job experience
Implemented end to end EPM Projects with at least 2 successful implementations on PBCS and FCCS.
Demonstrates extensive abilities and/or a proven record of success as a team leader leading practice in the following areas:
- Budgeting and Forecasting, Long Range Planning, Rolling Forecasting
- KPIs, Management Reporting
- Month End Consolidation, SEC and Statutory Reporting
- Financial Master Data Management
- Account Reconciliations
- Narrative Reporting
Demonstrates extensive abilities and/or a proven record of success as a team leader leading technical implementation of EPM (Enterprise Performance Management) tools:
- EPBCS - Enterprise Planning, Budgeting Cloud Services
- FCCS - Financial Consolidation & Close Cloud Service
- EDMCS - Enterprise Data Management Cloud Services
- ARCS - Account Reconciliation Cloud Services
- TRCS - Tax Reporting Cloud Services
Demonstrates extensive abilities and/or a proven record of success as a team leader leading technical development of:
- General Oracle EPM configuration
- Business Rule / Calculation Development
- Data Integration, EPM automate, EPM Integration Agent
- Master Data Management
- User Security Configuration and Management
- Report Development.