Senior Systems Analyst

Koppers Inc. • Pittsburgh, PA

4d

About The Position

Key Responsibilities Oracle FCCS (Consolidation & Close) Lead design and configuration of Consolidation, Elimination, Translation logic; manage Ownership Management and Consolidation Methods. Build and maintain Movement/Account/Entity/Scenario dimension structures; design calculation rules and On-Demand rules. Maintain intercompany workflows (matching, elimination) and currency translation calculations. Govern metadata changes; perform impact analysis across reports, rules, security, and integrations. Oracle PBCS/EPBCS (Planning & Budgeting) Design and maintain planning models (Income Statement, Balance Sheet, Cash Flow, Workforce, CapEx, Projects). Develop business rules (Groovy & Calculation Manager), data forms, smart lists, and validations. Build driver-based planning, scenario modeling, and forecasting processes; optimize sandboxes and versions. Create and maintain Smart View ad‑hoc templates and standardized reporting packages for FP&A and business units. Integrations, Data & Automation Own EPM Data Management/Data Exchange; build end‑to‑end data pipelines (source → staging → target). Implement and monitor EPM Automate scripts; schedule daily jobs for data loads, backups, and metadata refreshes. Develop/consume REST APIs for automated metadata, data loads, and provisioning; coordinate with ERP (e.g., Oracle Fusion) and data warehouse teams. Ensure data quality with reconciliation, balancing reports, error handling, and audit trails. Governance, Security & Compliance Administer user provisioning, roles, security artifacts (read/write intersections, cell security). Maintain SOX‑aligned controls, documentation, and change management for EPM solutions. Manage non‑prod environments (DEV/TEST) and promotion to PROD with robust release processes. Stakeholder Engagement & Delivery Translate Finance requirements into scalable technical designs; create BRDs, solution designs, and test scripts. Lead UAT, training, and knowledge transfer; produce user guides, process flows, and quick reference materials. Drive continuous improvement—identify performance optimizations, usability enhancements, and process automation opportunities. Serve as Tier‑2/Tier‑3 escalation for incidents and service requests; coordinate with Oracle Support as needed.

Requirements

• Bachelor’s degree in Information Systems, Finance/Accounting, Computer Science, or related field.
• 7–10+ years of experience with Oracle EPM Cloud, including FCCS and PBCS/EPBCS.
• Strong hands‑on experience with: Dimensions, metadata, hierarchies; Data Management/Data Exchange.
• Calculation Manager, Groovy business rules, EPM Automate.
• Smart View, Management/Financial Reporting, and dashboards.
• REST APIs for Oracle EPM Cloud.
• Solid understanding of US GAAP concepts (consolidation, intercompany, FX translation) and FP&A planning processes.

Nice To Haves

• Experience integrating EPM with Oracle Fusion Cloud (GL, Projects, SCM) and/or other ERPs.
• Familiarity with EDMCS (Enterprise Data Management) for governed master data.
• Knowledge of advanced allocations, cost drivers, workforce planning, and capital/project planning.
• CPA, CMA, or Oracle EPM Cloud certifications.

Responsibilities

• Lead design and configuration of Consolidation, Elimination, Translation logic; manage Ownership Management and Consolidation Methods.
• Build and maintain Movement/Account/Entity/Scenario dimension structures; design calculation rules and On-Demand rules.
• Maintain intercompany workflows (matching, elimination) and currency translation calculations.
• Govern metadata changes; perform impact analysis across reports, rules, security, and integrations.
• Design and maintain planning models (Income Statement, Balance Sheet, Cash Flow, Workforce, CapEx, Projects).
• Develop business rules (Groovy & Calculation Manager), data forms, smart lists, and validations.
• Build driver-based planning, scenario modeling, and forecasting processes; optimize sandboxes and versions.
• Create and maintain Smart View ad‑hoc templates and standardized reporting packages for FP&A and business units.
• Own EPM Data Management/Data Exchange; build end‑to‑end data pipelines (source → staging → target).
• Implement and monitor EPM Automate scripts; schedule daily jobs for data loads, backups, and metadata refreshes.
• Develop/consume REST APIs for automated metadata, data loads, and provisioning; coordinate with ERP (e.g., Oracle Fusion) and data warehouse teams.
• Ensure data quality with reconciliation, balancing reports, error handling, and audit trails.
• Administer user provisioning, roles, security artifacts (read/write intersections, cell security).
• Maintain SOX‑aligned controls, documentation, and change management for EPM solutions.
• Manage non‑prod environments (DEV/TEST) and promotion to PROD with robust release processes.
• Translate Finance requirements into scalable technical designs; create BRDs, solution designs, and test scripts.
• Lead UAT, training, and knowledge transfer; produce user guides, process flows, and quick reference materials.
• Drive continuous improvement—identify performance optimizations, usability enhancements, and process automation opportunities.
• Serve as Tier‑2/Tier‑3 escalation for incidents and service requests; coordinate with Oracle Support as needed.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Number of Employees: 1,001-5,000 employees