Financial Systems Analyst III
AmTrust Group

Jersey City, New Jersey

Posted in Financial Services


This job has expired.

Job Info


Overview

Purpose:

The Oracle Cloud ERP Financials Report Developer will work with the Oracle suite of reporting tools consisting of (Financial Reporting Studio (FRS), Oracle Transactional Business Intelligence (OTBI), and Business Intelligence Publisher (BIP)) to develop new reports and enhance standard ERP Cloud reports. This role will also act as a technical expert of the Oracle reporting tools as we continue to build out the AmTrust finance reporting function as part of the Finance Transformation program. The role requires expert knowledge of SmartView functionality for AD Hoc analysis and report builds.

This role will report into the Global Head of Finance Data & Reporting as a dedicated member of the Finance Transformation program.



Responsibilities

Key Responsibilities:

Reporting:
  • Responsible for taking business requirements from the business analysts and translating them into the technical build of various reports.
  • Manage the builds through the appropriate development and testing/UAT cycles following established governance procedures.
  • Develop dashboard & scorecards and implement sustainable distribution mechanisms.
  • Develop reporting KPIs to continuously monitor and manage performance to ensure success.
  • Periodically testing the code of the current set of reports as the financial systems architecture evolves and/or upgraded to ensure that the reports are producing the desirable results in most efficient manner possible.
  • Perform report debugging when needed.
  • Develop and provide ongoing training and guidance to users/customers on the reporting and analytics tools as well as the associated change control processes.
  • Provide reporting solutions out of the Enterprise Data Warehouse (EDW) replacing current reporting needs fulfilled by alternate hierarchies in HFM.


Policy/Governance
  • Responsible for ensuring that all governance policies are adhered to throughout the report development and testing cycles.
  • Assist in the development and testing of any new and/or updated governance procedures.

Data Feeds
  • Assist in the development and testing of new and/or existing data feeds from the source systems into the General Ledger. Ability to assist with the reconciliation and the development of the reconciliation of new and/or existing data feeds from the source systems into the General Ledger.
  • Ensure accurate mappings are defined and data is reconciled between source systems and the landing zone

Oracle Technical Knowledge
  • Ability to troubleshoot and weigh in on issues relating to Oracle Integration Cloud (OIC), Oracle Cloud Infrastructure (OCI) and BI Connector and provide solutions liaising with Oracle customer service reps.


Key Stakeholders & Partners:
  • CFO
  • Global Head of Finance Transformation
  • Head of Business Analytics
  • Head of Finance Operations
  • Corporate Controller
  • Actuarial
  • Investments
  • Treasury
  • Tax
  • IT Department
  • Internal Audit
  • Enterprise Risk Management
  • Claims
  • HR


Qualifications

Key Competencies:
  • Financial reporting professional with 8-10 years of report design and build experience.
  • Minimum 3 years of hands on experience working with Oracle ERP Cloud Reporting, including at least one end to end Oracle ERP Cloud integration project as a Senior Report Developer.
  • Strong knowledge of financial systems, data, and reporting environments, including robust experience with the Oracle reporting tools (FRS, OTBI, BIP) supporting the source to report architecture.
  • Strong knowledge of SQL, PL/SQL and performance tuning skills.
  • Ability to create custom formulas, advanced reports, and dashboards within OTBI.
  • Ability to develop BI Publisher data models.
  • Strong familiarity with Oracle's Cloud ERP Financials out-of-the-box reports.
  • Strong understanding of global insurance accounting and analytical requirements and how to build the tools and capabilities required.
  • Experience identifying, prioritizing, and facilitating data and reporting improvements.
  • Excellent technical problem solving skills with ability to work independently and in a team-oriented manner.
  • Experience leading strategic initiatives to achieve desired business outcomes.
  • Able to support execution of a strategic vision.
  • Experience in delivering projects on time, in full and to budget.
  • Ability to communicate clearly and effectively across the different functions of the organization.
  • Able to work with people in different countries; sensitive to cultural differences.
  • Flexible; able to deal constructively with changes to role and responsibilities.
  • Positive 'can-do' attitude; comfortable with ethos of a shared-services environment.



This job has expired.

More Financial Services jobs


NEWMARK
Freeport, Texas
Posted 21 minutes ago

NEWMARK
Redmond, Washington
Posted 21 minutes ago

NEWMARK
Pleasanton, California
$70,000.00 - $85,000.00 per year
Posted 20 minutes ago

Get Hired Faster

Subscribe to job alerts and upload your resume!

*By registering with our site, you agree to our
Terms and Privacy Policy.