Oracle Fusion Reporting & Analytics Developer - Innovee Consulting LLC - Long Island City, NY, US | Dice.com

Innovee Consulting LLC

Apply Now

Oracle Fusion Reporting & Analytics Developer

Long Island City, NY, US • Posted 6 days ago • Updated 11 hours ago

Contract W2

On-site

$DOE

Apply Now

Fitment

Dice Job Match Score™

To see how well you match this job, please log in or create an account.

Once logged in, be sure to complete your profile to get the most accurate match score.

Fitment

Dice Job Match Score™

📋 Comparing job requirements...

Job Details

Skills

SQL
PL/SQL
Jira
Confluence
Oracle Fusion Cloud suite
OAC
ADW
Agile/Scrum framework

Summary

Job Title: Oracle Fusion Reporting & Analytics Developer

Duration: Long Term

Location: Long Island City, NY

Note: Only W2 Consultants

Overview:

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.

Key Responsibilities: Reporting & Analytics Development

Design, develop, and maintain Oracle Transactional Business Intelligence (OTBI) reports and dashboards using Oracle Fusion Cloud applications
Create advanced analytics and data visualizations in Oracle Analytics Cloud (OAC)
Develop and maintain reports in Oracle Analytics Server (OAS) for on-premises requirements
Build pixel-perfect reports using BI Publisher for regulatory compliance and operational needs
Create and optimize dashboards leveraging Fusion Data Intelligence (FDI) capabilities

Data Architecture & Integration

Work with Oracle Autonomous Data Warehouse (ADW) to design and implement robust data models
Understand and leverage Fusion Data Intelligence subject areas and data pipelines
Design and optimize data warehouse schemas to support enterprise reporting requirements
Integrate data from multiple sources including Oracle Fusion ERP, HCM, SCM modules
Perform data modeling and create logical business models aligned with business requirements

Legacy Modernization

Analyze and modernize custom PL/SQL processes and reports from Oracle E- Business Suite (EBS)
Migrate legacy OBIEE reports and dashboards to OAC/OTBI frameworks
Refactor inefficient database procedures and optimize for cloud-based architecture
Document migration paths and transformation logic for legacy report conversions

Performance & Optimization

Optimize query performance across OTBI, OAC, and ADW environments
Implement best practices for report caching, aggregation, and indexing strategies
Monitor and tune SQL queries and PL/SQL procedures for optimal performance
Conduct performance testing and implement improvements based on usage patterns

Collaboration & Support

Partner with business analysts to translate requirements into technical reporting solutions
Provide training and support to business users on OTBI, OAC, and OAS tools
Collaborate with IT teams to integrate analytics solutions with enterprise applications
Work with data governance teams to ensure data quality and compliance standards

Documentation & Compliance

Document technical designs, data flows, and reporting specifications
Maintain comprehensive documentation for audit and compliance purposes
Create user guides and training materials for report consumers
Follow change management processes and maintain version control

Project Management

Participate in agile/scrum ceremonies including sprint planning, daily standups, and retrospectives
Provide regular progress updates and status reporting to stakeholders
Utilize SCA project management and requirements tracking tools
Manage multiple priorities and adapt to changing business needs

Required Skills & Experience: Oracle Fusion & Cloud Analytics (Required)

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

Education

Bachelor's Degree in Computer Science, Information Systems, Business, or related technical discipline
Equivalent combination of education and relevant work experience will be considered

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.

Dice Id: 90987422
Position Id: 2025-4969
Posted 6 days ago

Create job alert

Never miss an opportunity! Create an alert based on the job you applied for.

New York, New York

•

6d ago

UNIVERSAL Technologies is seeking an experienced Oracle Fusion Reporting & Analytics Developer for an onsite role for the first 90 days in Long Island City, NY, may change to hybrid after. The right candidate will support enterprise-wide reporting, analytics, and data intelligence initiatives. This role is responsible for designing, developing, and modernizing reporting solutions across Oracle Transactional Business Intelligence (OTBI), Oracle Analytics Cloud (OAC), Oracle Analytics Server (OAS)

Easy Apply

Full-time

Depends on Experience

Oracle Fusion Reporting & Analytics Developer

No location provided

•

Today

Job Title: Oracle FusionReporting&AnalyticsDeveloper Duration: Long Term Location: Long Island City, NY Note: Only W2 Consultants Overview: 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 cand

Full-time

Senior Manager, Data Center Construction Business Analytics & Reporting

No location provided

•

Today

Job Description The Data Center Infrastructure Construction organization at Oracle Cloud Infrastructure (OCI) delivers large-scale, high-performance data centers that power Oracle's global cloud platform. This team is made up of project managers, construction professionals, technical specialists, and commissioning experts who work together to ensure efficient, high-quality, and on-time delivery of complex facilities worldwide. As OCI's development pipeline expands, actionable insights, strong

Full-time

USD 120,100.00 - 251,600.00 per year

SAP Reporting and Analytics Analyst/Developer

Remote

•

14d ago

We are helping a long-term privately held client with the recruiting of a talented and experienced Reporting and Analytics Analyst. This is a full-time, fully-remote, non-consulting role. This a unique opportunity to make significant contributions across all functional areas of a business that runs SAP S/4. You will get daily opportunities to help business leaders make the most of their data in order to reach their business goals, be hands-on with reporting and analytics and solutions, imaginin

Easy Apply

Full-time

Depends on Experience

Oracle Fusion Reporting & Analytics Developer

Dice Job Match Score™

Dice Job Match Score™

Job Details

Skills

Summary

Similar Jobs

Dice Job Match Score™