Oracle Fusion Reporting & Analytics Developer

Amtex Systems Inc

New York (NY)

On-site

USD 120,000 - 160,000

Full time

46 hours ago
Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

Amtex Systems Inc. in New York seeks an Oracle Fusion Reporting & Analytics Developer to deliver enterprise reports and analytics for the Fusion Cloud environment.

You will design and maintain OTBI, OAC, OAS, and FDI solutions, collaborating with business stakeholders and data analysts to provide actionable insights.

Join a team focused on modernizing legacy reporting while driving data-informed decisions across the organization.

Qualifications

  • 3+ years OTBI development for subject areas, dashboards, and reports.
  • 2+ years OAC data visualizations, data flows, and advanced analytics.
  • 2+ years OAS dashboards/reports.
  • 4+ years BI Publisher templates, layouts, and data models.
  • 2+ years FDI subject areas, pipelines, and data warehouse.
  • 2+ years ADW architecture, SQL optimization, and data modeling.
  • 5+ years Oracle Database 19c/21c; advanced SQL/PL/SQL.
  • ODI or similar ETL tools experience.
  • OBIEE migration to OAC/OTBI knowledge.
  • PL/SQL modernization and cloud migration awareness.

Responsibilities

  • Design, develop, and maintain enterprise reports and analytics.
  • Deliver insights for Oracle Fusion Cloud through OTBI, OAC, OAS, and FDI.
  • Collaborate with business stakeholders and data analysts.
  • Modernize legacy reporting processes and optimize data flows.

Skills

OTBI
OAC
OAS
BI Publisher
FDI
SQL
PL/SQL
REST APIs
Git/SVN
OCI

Education

Bachelor's Degree in CS/IS/IT

Tools

ODI
OBIEE 12c

Job description

Title: Oracle Fusion Reporting & Analytics Developer

Duration: Full Time

Statement of the Job

The Oracle Fusion Reporting & Analytics Developer will provide comprehensive reporting, analytics, and data intelligence solutions for our Oracle Fusion Cloud environment. This role will design, develop, and maintain enterprise reports using OTBI, Oracle Analytics Cloud (OAC), Oracle Analytics Server (OAS), and Fusion Data Intelligence (FDI). The ideal candidate will work closely with business stakeholders and data analysts to deliver actionable insights while modernizing legacy reporting processes.

Required Skills & Experience
  • Oracle Transactional Business Intelligence (OTBI): 3+ years developing subject area analyses, dashboards, and reports
  • Oracle Analytics Cloud (OAC): 2+ years creating data visualizations, data flows, and advanced analytics
  • Oracle Analytics Server (OAS): 2+ years developing dashboards and reports
  • BI Publisher: 4+ years building complex templates, layouts, and data models
  • Fusion Data Intelligence (FDI): 2+ years working with FDI subject areas, pipelines, and data warehouse
Database & Data Warehouse
  • Oracle Autonomous Data Warehouse: 2+ years experience with ADW architecture, SQL optimization, and data modeling
  • Oracle Database 19c/21c: 5+ years with advanced SQL, PL/SQL stored procedures, functions, and packages
  • Data Modeling: Strong understanding of dimensional modeling, star schemas, and data warehouse concepts
  • ETL/Data Integration: Experience with Oracle Data Integrator (ODI) or similar tools preferred
Legacy Systems & Migration
  • Oracle E-Business Suite (EBS): Understanding of EBS data model and custom reports
  • OBIEE 12c: Experience migrating from OBIEE to OAC/OTBI preferred
  • PL/SQL Modernization: Proven ability to refactor and optimize legacy database code
  • Migration Methodologies: Knowledge of cloud migration strategies and best practices
Technical Skills
  • Strong SQL and PL/SQL programming capabilities
  • Understanding of REST APIs and web services for data integration
  • Experience with version control systems (Git, SVN)
  • Knowledge of Oracle Cloud Infrastructure (OCI) fundamentals
  • Familiarity with data security and role-based access controls
Soft Skills & Work Style
  • Excellent verbal and written communication skills
  • Strong client interface and training abilities
  • Ability to work under pressure and adapt to changing priorities
  • Detail-oriented with strong process improvement mindset
  • Collaborative team player who can also work independently
  • Experience in agile/scrum methodology and ceremonies
Preferred Qualifications
  • Oracle Cloud certifications (OAC, Fusion Applications, ADW)
  • Experience with Oracle Integration Cloud (OIC)
  • Knowledge of Oracle HCM, ERP, or SCM Cloud modules
  • Experience with data governance and master data management
  • Familiarity with AI/ML capabilities in Oracle Analytics Cloud
  • Python or R programming for advanced analytics

Bachelor's Degree in Computer Science, Information Systems, Business, or related technical discipline

Equivalent combination of education and relevant work experience will be considered

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Oracle Fusion Reporting & Analytics Developer
Oracle Fusion Reporting & Analytics Developer

Innovee Consulting LLC • New York (NY)

On-site
USD 110,000 - 160,000
Senior Oracle Fusion Data Intelligence (FDI) Architect / Consultant
Senior Oracle Fusion Data Intelligence (FDI) Architect / Consultant

TechDigital Group • New York (NY)

On-site
USD 180,000 - 240,000
Senior Oracle Fusion Data Intelligence (FDI) Architect - Only W2
Senior Oracle Fusion Data Intelligence (FDI) Architect - Only W2

Saransh Inc • New York (NY)

On-site
USD 140,000 - 200,000
Senior Oracle Fusion Analytics Architect
Senior Oracle Fusion Analytics Architect

TechDigital Group • New York (NY)

On-site
USD 180,000 - 240,000
Oracle Analytics FDI Design / Developer
Oracle Analytics FDI Design / Developer

accenturefederalservices • United States

Remote
USD 92,000 - 179,000
Oracle Cloud HCM BI Reporting & Dashboards Analyst
Oracle Cloud HCM BI Reporting & Dashboards Analyst

Compunnel Inc. • Denton (TX)

On-site
USD 80,000 - 100,000
Oracle Cloud HCM BI, Reporting & Dashboard Analyst
Oracle Cloud HCM BI, Reporting & Dashboard Analyst

Compunnel Inc. • Denton (TX)

On-site
USD 80,000 - 100,000
Oracle Fusion HCM Reporting Developer
Oracle Fusion HCM Reporting Developer

Prophecy Technologies Corp • United States

On-site
USD 90,000 - 130,000
Oracle Fusion Consultant
Oracle Fusion Consultant

Iresh Technologies LLC • Dallas (TX)

On-site
USD 120,000 - 160,000
Oracle Data Architect
Oracle Data Architect

International Business Machines Corporation • Denver (CO)

On-site
USD 120,000 - 150,000