Oracle EPM Business Systems Analyst
Posted on 6/5/2023

1,001-5,000 employees

Digital payment processor
Company Overview
Square's mission is to ensure that all businesses are able to participate and thrive in the economy. The company is building infrastrucutre for online payments.
San Francisco, CA, USA • Remote in USA
Experience Level
Desired Skills
IT & Security
  • 3-5 years of experience in a Business System Analyst role supporting Oracle EPM, with specific expertise in Planning and PCM modules
  • Strong understanding of financial planning and analysis processes and systems
  • Experience gathering and documenting business requirements and translating them into system designs and specifications
  • Experience configuring, testing, and deploying Oracle EPM system changes and enhancements
  • Strong analytical and problem-solving skills
  • Experience with Operational support and project management methodologies, tools and processes
  • Excellent communication and interpersonal skills
  • Ability to work independently and as part of a team in a fast-paced environment
  • Act as a key resource in the projects and enhancement of the Oracle EPM system with a focus on Planning and PCM modules
  • Analyze and document business processes, procedures, and requirements to identify areas for improvement and implement system enhancements
  • Work closely with business stakeholders to gather requirements and translate them into system designs, specifications, and test plans
  • Configure, develop, test, and deploy system changes and enhancements
  • Manage system testing and validation, including user acceptance testing and end-to-end testing
  • Develop and deliver training and support materials for end-users
  • Stay up-to-date on Oracle EPM product releases and new features, provide recommendations for system improvements, and participate in regression testing of Oracle software updates and patches
  • Create and maintain EPCM business rules, models and custom MDX allocation scripts for supporting Segment Allocation and Tax transfer pricing processes
  • Create and maintain EPBCS Business Rules and Forms and integrations between EPM and other systems using EPM Agent, Data Management, Python, Groovy and SQL
  • Support Oracle Planning Cloud (EPBCS), Data Management, EPM Automate, Oracle Profitability and Cost Management Cloud Services (PCMCS), Strategic Modeling, Oracle Hyperion Essbase, Smartview for Mac and windows
  • Develop applications for Balance Sheet and P&L forecasting, Cash Flow and GAAP reporting, and alternate hierarchy and COA enhancements
  • Support, Oracle SQL, ETL processes, multidimensional analysis, databases, data calculation, and aggregation techniques
  • Manage security across different EPM applications based on the access requests
  • Support recurring day-to-day operation and on-call rotation for the Oracle EPM solution and Oracle OCI Infrastructure
Desired Qualifications
  • Experience with FCCS and EDMCS is a plus