EPM Systems Administrator

About the role

At Compass, our mission is to help everyone find their place in the world. Founded in 2012, we’re revolutionizing the real estate industry with our end-to-end platform that empowers residential real estate agents to deliver exceptional service to seller and buyer clients. The EPM Systems Administrator will be responsible for the day-to-day administration, maintenance, and optimization of the Oracle EPM FCCS (Financial Consolidation and Close Cloud Service) application. This role ensures system stability, security, and performance to support finance teams with accurate and timely data for reporting and consolidation. This position is onsite based out of Manhattan, NY or Madison, NJ.

Responsibilities

• Manage user provisioning, roles, and security within Oracle EPM FCCS.
• Maintain metadata, dimensions, and hierarchies across entities and scenarios, including managing annual revisions and reconsolidations of the management reporting structure in the entity hierarchy.
• Oversee application settings, rules, and configurations to ensure compliance with corporate standards.
• Design, develop, maintain EPM Cubes (ASO or BSO), Workflows, Reports, and Integrations via APIs or Data Management tools.
• Monitor and support data mapping, data validation and data loading for 200+ global business units with multiple ERP source systems into the global standard financial structure.
• Validate data integrity and troubleshoot discrepancies in consolidation and reporting.
• Support monthly and quarterly close processes by ensuring timely refreshes and consolidations.
• Perform regular system health checks and test and apply Oracle patches or updates as required.
• Optimize calculation scripts and business rules for efficiency.
• Coordinate with IT and Oracle support for issue resolution and enhancements.
• Maintain documentation for system processes, configurations, and user guides.
• Develop and enforce best practices for EPM administration and governance.
• Provide technical support to finance team for FCCS related issues.
• Train end-users on system functionality and new features.

Requirements

• Bachelor's degree in Computer Science, Information Systems, Finance, Accounting, or related field.
• 3+ years of experience in Oracle EPM Cloud administration (FCCS experience required).
• Strong understanding of change control and testing methodologies.
• Solid understanding of financial consolidation processes and accounting principles.
• Proficiency in Smart View, Data Management, and EPM Automate.
• Advanced Excel skills for data analysis and troubleshooting.
• Excellent problem-solving and communication skills.

Skills

• Analytical Thinking: Ability to diagnose issues quickly and propose effective solutions.