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

Wing Feather Saga

Production Intern - WFS Job at Wing Feather Saga

 ...Description Description: Summary/objective: Angel recently acquired The Wingfeather Saga, and Toothy Cow Productions is the studio producing the animated series. The Wingfeather Saga Animated Series is looking for a Production Intern to aid and contribute to the day-to-day... 

ABS Kids

Behavior Technician / RBT (Bonus Opportunity) Job at ABS Kids

 ...Job Requirements $1,000 bonus for current RBTs. We have variable part-time shifts available for entry-level Behavior Technicians up to seasoned RBTs. Speak with a recruiter today to see which suits your availability best! Must have availability 9:00am-6:00pm, Monday-Friday... 

Anduril Industries

Flight Sciences Engineer Job at Anduril Industries

 ...hardest problems facing our customers. We are looking for software engineers, hardware engineers, roboticists, and front-end mobile...  ...impacts of configuration changes on performance of the aircraft.Flight Simulation Development:Design, implement, and maintain high-fidelity... 

Roblox

Principal Engineer, Studio Builder Tools Job at Roblox

 ...developer-facing tools and reusable tooling frameworks for Roblox Studio, a collaborative IDE for making Roblox games. The Builder Tools...  ...making features, from 3D draggers to world-class character animation tools, tooling for making terrain for huge worlds, in-game UI authoring... 

Hermeus

Senior Flight Software Engineer Job at Hermeus

Los Angeles, CAEngineering - Flight Software /Full-time /On-siteHermeus is a venture-backed defense aviation company reclaiming the lost...  ...a highly motivated and experienced Senior Flight Software Engineer to join Hermeus, a hypersonic aircraft startup company. As a Senior...