Oracle Administrator

Metropolis•Chicago, IL

4d•$120,000 - $130,000•Onsite

About The Position

Metropolis is seeking an Oracle Administrator to join our team. You will manage, maintain, and optimize our Oracle Cloud EPM (EPBCS) ecosystem while serving as the strategic bridge between our Financial Planning & Analysis (FP&A) organization and our centralized Data Engineering teams. In our high-velocity, 5,000-location enterprise, financial accuracy is inextricably linked to operational data. You will not only handle traditional EPM administration but also partner directly with data and operational teams to define technical requirements for integrating non-financial KPIs—such as location churn, new facility onboardings, occupancy rates, and transaction counts—directly from our data warehouse into our financial forecasting models. The ideal candidate brings a strong grasp of EPM architecture, SQL data structures, and the communication skills required to translate complex operational metrics into actionable financial drivers.

Requirements

7+ years of Oracle EPM (EPBCS/Planning) System Administration and development experience in a high-growth, multi-location enterprise
Bachelor’s degree in Computer Science, Finance, Economics, Accounting, Information Systems, or a related field
Strong knowledge of data integration tools (EPM Integration Agent, Data Management, EPM Automate) and deep understanding of dependencies between functional components of Oracle EPM
Proficiency in SQL and Python with a proven track record of automating financial processes
Must understand modern cloud data structures well enough to perform "handholding" and meaningful collaboration with Data Engineers
Exceptional ability to bridge the gap between technical data architecture and functional financial insights
Strong experience partnering with Senior Leadership and the ability to translate "big picture" financial concepts into tactical execution plans for IT
Ability to work independently or with a low-ego, highly collaborative, cross-functional team in a fast-paced, deadline-driven environment

Nice To Haves

Experience with Groovy scripting

Responsibilities

Oversee the end-to-end administration, configuration, and continuous optimization of the Oracle Cloud EPM suite (EPBCS)
Design, build, and troubleshoot Essbase ASO/BSO cubes to support large-scale operational scenario planning
Act as the primary technical translator between Finance and centralized Data/IT teams; partner with Data Engineering to define technical requirements, ensuring that data models in our data warehouse (e.g., Snowflake) are properly structured for seamless EPM ingestion
Collaborate with data teams to ingest high-volume non-financial KPIs (e.g., transaction counts, location churn) into EPM planning cubes
Troubleshoot integration workflows and perform root-cause analysis on data discrepancies using SQL and Python
Replace static calculation scripts with dynamic, context-aware logic to optimize system performance across thousands of sparse locations
Utilize EPM Automate alongside Python or batch scripting for complex job scheduling
Manage the volatile lifecycle of 5,000+ operational locations; ensure location additions, divestitures, hierarchical changes and associated access permissions, synchronize flawlessly across ERP, CRM, and EPM environments
Develop and maintain high-impact visualization dashboards (Tableau, Looker, Hex) with intuitive narratives to facilitate executive decision-making; provide user support, training, and documentation for supported applications