Oracle Fusion Reporting Consultant Job at Ampcus, New York, NY

  • Ampcus
  • New York, NY

Job Description

Job-ID32175874Reference26-06089Remote100% RemoteAmpcus Inc. is a certified global provider of a broad range of Technology and Business consulting services. We are in search of a highly motivated candidate to join our talented Team.Job Title: Oracle Fusion Reporting ConsultantLocation: New York, NY (Remote)Key Responsibilities:Lead reporting and analytics workshops to understand business and functional reporting requirements across Oracle Fusion Financials, and EPM modules.Analyze current-state reporting solutions and design future-state enterprise reporting architecture aligned with Oracle Fusion Cloud and Analytics best practices.Design, develop, and support reporting solutions using BI Publisher (BIP), OTBI, Oracle Analytics Cloud (OAC), and Fusion Analytics Warehouse (FAW).Develop pixel-perfect operational and statutory reports using BI Publisher with complex SQL, RTF/EText templates, bursting, and scheduling.Create and optimize OTBI subject area–based real-time reports and dashboards, including security-aware reporting.Design analytical dashboards and semantic models in Oracle Analytics Cloud (OAC) for cross-functional and executive reporting.Leverage Autonomous Data Warehouse (ADW) as a reporting and analytics platform, supporting data modeling and performance optimization.Design and maintain data pipelines and transformations using Oracle Data Integrator (ODI) or equivalent ELT/ETL tools for analytics use cases.Implement and customize Fusion Analytics Warehouse (FAW), including KPI definitions, extensions, and validation of prebuilt dashboards.Collaborate with functional consultants and integration teams to source data from Fusion transactional tables, REST APIs, FBDI outputs, and upstream systems.Develop and maintain reporting design documents, data models, KPI definitions, and technical specifications.Ensure role-based access controls, data security, and compliance in all reporting solutions.Support reporting data validation, reconciliation, and audit requirements across financial and operational reports.Create and execute test scenarios for SIT, UAT, regression testing, and performance testing of reporting solutions.Provide reporting support during cutover, go-live, post-go-live stabilization, and hypercare phases.Support quarterly Oracle Cloud updates by assessing impact on OTBI, BIP, FAW, and OAC artifacts.Required Qualifications:Bachelor’s degree in Computer Science, Information Systems, Finance, Accounting, Engineering, or related discipline.10–15 years of overall reporting and analytics experience with 7 years in Oracle Fusion Cloud reporting and analytics.Strong hands-on experience with BI Publisher (BIP), OTBI, Oracle Analytics Cloud (OAC), and Fusion transactional reporting.Experience designing enterprise analytics solutions using ADW and ODI (or equivalent data integration tools).Strong understanding of Fusion data models, subject areas, and transactional-to-analytical data flows.Hands-on experience with SQL, performance tuning, joins, and complex reporting logic.Experience implementing and extending Fusion Analytics Warehouse (FAW).Familiarity with Financials, SCM, or HCM business processes to effectively translate requirements into reporting solutions.Experience with integrations using REST APIs, FBDI, and reporting data extracts.Strong understanding of data security, role-based access control, and reporting governance.Excellent communication, documentation, and stakeholder management skills.Experience supporting multi-ledger, multi-currency, and multi-region (NA, EMEA, APAC) Oracle Fusion environments.Experience building executive dashboards and KPI frameworks for Finance and Operations leadership.Exposure to EPM, FAW extensions, and cross-platform analytics is a plus.Experience managing reporting impact of quarterly Oracle Cloud updates.Preferred Certifications:Oracle Analytics Cloud Certification.ShiftPST/EST 08:00 AM - 05:00 PMAmpcus is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, protected veterans or individuals with disabilities.

Job Tags

Remote work

Similar Jobs

Canter Power Systems LLC

In-Home Sales Consultant | High Commission | Company-Provided Leads Job at Canter Power Systems LLC

 ...Description: In-Home Sales Consultant | High Commission | Company-Provided Leads A Personal Invitation from Our Leadership Team...  ...generator installations each year while maintaining a 4.8-Star Google Rating . Our continued growth has created an opportunity for... 

Headway

Licensed Clinical Social Worker (LCSW) Job at Headway

 ...0 for every licensed provider you refer to the platform. Dedicated Support: Personalized practice partner and administrative back-office assistance. Requirements Licensure: Fully licensed at the Masters level or above (LCSW, LICSW, or LCSCW) Credentials:... 

Feedinkoo

Remote Junior Web Developer: Grow in Full-Stack Skills Job at Feedinkoo

 ...Scopic is seeking a Junior Web Developer for a fully remote position. Join a global team where you can develop your skills while tackling exciting projects. As part of a growing IT Services company, you will have the opportunity to work in a collaborative virtual environment... 

Hear Wright

Audiologist or Hearing Aid Specialist Job at Hear Wright

 ...OverviewJob DescriptionAudiologist or Hearing Aid SpecialistPosition Type: Full-Time In-OfficeLocation: Wooster, OHHearingLife is seeking a full-time Audiologist or Hearing Aid Specialist to join our inoffice clinical team. This role is responsible for providing... 

US Department of Veterans Affairs

Health Physicist - Radiation Safety Officer Job at US Department of Veterans Affairs

 ...Health Physicist - Radiation Safety Officer Duties include, but are not limited to, the following: Sets up all work and trains in all areas of radiation safety, including, but not limited to, machine-produced radiation and radioactive materials; Implements...