Marsh McLennan

Oracle EPM Analyst

Toronto - Bremner Full time

Company:

Marsh

Description:

We are seeking a talented individual to join our IT Product Development team at Marsh as an Oracle EPM Analyst .This role will be based in Toronto. This is a hybrid role that has a requirement of working at least three days a week in the office.

We are seeking a highly experienced professional with a minimum of 4 years of experience in implementing Enterprise Planning and Budgeting Cloud Services (EPBCS/PBCS) or Hyperion Planning or Essbase Applications. The ideal candidate will have a strong functional knowledge of financial systems and processes, as well as a deep understanding of accounting principles such as GAAP, GASP, FASB, and FASAB.

We will count on you to:

  • Implement and configure EPBCS/PBCS or Hyperion Planning or Essbase Applications, including building metadata, designing web forms, conducting data reconciliation, building dashboards, and automating business rules.

  • Gather business requirements, design and prototype solutions, conduct testing, provide training, define support procedures and SLAs, and implement robust and scalable solutions.

  • Demonstrate proficiency in the creation of member formulas and any customizations in EPBCS, as well as the creation of complex business rules such as custom consolidations/aggregations, custom currency conversions, and dynamic calculations.

  • Build integration artifacts in Cloud Data Management and FDMEE, including locations, maps, custom/import scripts, and handling file-related or custom automation using Python Scripts.

  • Develop scripts using Python/Groovy/CDM APIs for scripting purposes.

  • Conduct testing, including system, integration, performance, and user acceptance testing, and prepare deliverables such as design documents, test documentation, training materials, and administration/procedural guides.

  • Utilize excellent Excel and VB Scripting skills to support various tasks.

  • Collaborate with clients to understand their needs and provide effective solutions.

What you need to have: 

  • Minimum of 4+ years of experience in implementing EPBCS/PBCS or Hyperion Planning or Essbase Applications.

  • Strong functional knowledge of financial systems and processes.

  • Proficiency in EPBCS Standard dimensions, member formulas, and customizations, along with creating complex business rules

  • Good working knowledge of EPM Automate.

What makes you stand out:

  • Working knowledge of the functional aspects of Income Statement, Balance Sheet, currency translations, inter-company eliminations, and consolidation accounting under various GAAPs.

  • Strong problem-solving and troubleshooting skills.

  • Ability to collaborate effectively with clients

Why join our team:

  • We help you be your best through professional development opportunities, interesting work, and supportive leaders.

  • We foster a vibrant and inclusive culture where you can work with talented colleagues to create new solutions and have an impact for colleagues, clients, and communities.

  • Our scale enables us to provide a range of career opportunities, as well as benefits and rewards to enhance your well-being.

#LI-JG3

Marsh (NYSE: MRSH) is a global leader in risk, reinsurance and capital, people and investments, and management consulting, advising clients in 130 countries. With annual revenue of over $27 billion and more than 95,000 colleagues, Marsh helps build the confidence to thrive through the power of perspective. For more information, visit corporate.marsh.com, or follow us on LinkedIn and X.

Marsh is committed to embracing a diverse, inclusive and flexible work environment. We aim to attract and retain the best people and embrace diversity of age background, disability, ethnic origin, family duties, gender orientation or expression, marital status, nationality, parental status, personal or social status, political affiliation, race, religion and beliefs, sex/gender, sexual orientation or expression, skin color, or any other characteristic protected by applicable law. In accordance with the Accessibility for Ontarians with Disabilities Act, 2005, Marsh will provide a reasonable accommodation to employees and prospective employees to the point of undue hardship upon request and as required in respect of the individual’s particular restrictions and limitations. If you require a specific accommodation because of a disability or medical need, please contact reasonableaccommodations@mmc.com.

Marsh is committed to hybrid work, which includes the flexibility of working remotely and the collaboration, connections and professional development benefits of working together in the office. All Marsh colleagues are expected to be in their local office or working onsite with clients at least three days per week. Office-based teams will identify at least one “anchor day” per week on which their full team will be together in person.

The applicable base salary range for this role is $71,900 to $107,700.

The base pay offered will be determined on factors such as experience, skills, training, location, certifications, education, and any applicable minimum wage requirements. Decisions will be determined on a case-by-case basis. In addition to the base salary, this position may be eligible for performance-based incentives.

We are excited to offer a competitive total rewards package which includes health and welfare benefits, tuition assistance, retirement programs as well as employee assistance programs.

This is a Replacement position.