Oracle EPM Specialist -Hybrid

This role will support the Budget and Forecast processes for Capital, Personnel, and Operating budgets within the EPM Planning applications. It will design and implement enhancements to the Capital and Operating planning modules based on requirements from the Office of Management and Budget. The role will also support integration updates that connect EPM Planning to Oracle HCM Cloud as part of the Digital Modernization initiative. Additional responsibilities include developing the Operating Position Budget using the Public Sector Planning and Budgeting (PSPB) module, as well as maintaining and managing metadata for Oracle EPM Planning and Oracle Fusion applications through EDMCS. *, * Create and maintain enterprise metadata repository.

• Create and maintain data models (logical and physical) at the enterprise level and lower.
• Support Budget and Forecast processes for Capital, Personnel, and Operating Budgets for EPM planning applications.
• Use modeling and metadata tools to reverse engineer database structures.
• Support the definition and decision process to designate conformed dimensions for the enterprise data warehouse.
• Support data governance effort in the proper allocation and usage of data sources.
• Maintain and support the integrations from PeopleSoft HCM/FSCM into EPM Planning using Data Exchange.
• Create and maintain extensive metadata documentation.
• Create and disseminate informational materials regarding the data management function
• Support data stewards and other stakeholders, as needed.
• Maintain metadata using Oracle Enterprise Data Management (EDMCS).
• Build various SmartView templates for data loading and financial analysis.
• Support integration updates for connecting EPM Planning to Oracle HCM Cloud as part of Digital Modernization Projects.

• Experience in entity relationship modeling.
• Experience in dimensional and DMR modeling.
• Experience with metadata management for large models (200 or more entities).
• Experience assisting development teams and database administrators in creating, understanding, and using enterprise metadata.
• Experience implementing and maintaining ESRI ArcGIS software and Oracle RDBMS, which are the metadata and modeling tool(s)
• Support Budget and Forecast processes for Capital, Personnel, and Operating Budgets for EPM planning applications.
• Support development of Operating Position Budget using the Public Sector Planning and Budgeting Module (PSPB).
• Excellent communication skills.

Preferred Qualifications:

• Support Budget Book Development using Oracle EPM Cloud Narrative Reporting.
• Experience creating or maintaining an enterprise data warehouse and/or related data marts.
• Experience with one or more of the following systems: Maximo, PeopleSoft HCM/FSCM.
• Develop reports for Operating and Capital applications using Narrative Reporting.
• Experience in the transit industry.

1. Our Commitment to You - We offer competitive pay, multi-year projects, and a list of exciting clients.

2. Work-Life Balance - We work hard; we work smart and have quality time for family and “life.”

3. Our Mantra - We treat our consultants the way we want to be treated: with integrity, professionalism, and trust.

4. Career Development - We help you meet your career goals and continuously support your efforts to build your skillset.