# Financial Systems Administrator
**Company:** [Metropolis](https://hotfix.jobs/companies/metropolis)
**Location:** Chicago, IL
**Salary:** $120K-$130K
**Experience:** 7+ years
**Skills:** Oracle Epm, Epbcs, Essbase, Snowflake, SQL, Python, Epm Automate, Tableau, Looker, Groovy
**Posted:** 2026-05-13
> Administers and optimizes Oracle Cloud EPM suite, designs Essbase cubes, troubleshoots integrations using SQL/Python, and builds dashboards in Tableau/Looker. Bridges Finance and Data/IT teams with 7+ years EPM experience and bachelor's degree.
## Job Description
## 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 (**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.

## 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.
- Experience leveraging **AI tools** to transform static workflows into responsive, high-output processes.

## Nice-to-Haves
- Experience with **Groovy scripting**.

## Compensation
- Anticipated base salary: **$120,000 - $130,000 USD** annually.
**Apply:** https://hotfix.jobs/jobs/financial-systems-administrator-at-metropolis-b291b2ba-1cae-4981-9ee9-b216f6847811
**Canonical:** https://hotfix.jobs/jobs/financial-systems-administrator-at-metropolis-b291b2ba-1cae-4981-9ee9-b216f6847811