Oracle Fusion Reporting & Analytics Developer

New York, NY, US • Posted 60+ days ago • Updated 8 hours ago

Full Time

On-site

Depends on Experience

UNIVERSAL Technologies

Fitment

Dice Job Match Score™

📋 Comparing job requirements...

Job Details

Skills

Advanced Analytics
Agile
Analytical Skill
Analytics
Apache Subversion

Summary

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), Fusion Data Intelligence (FDI), and Autonomous Data Warehouse (ADW) while partnering closely with business stakeholders, data teams, and IT leadership. The ideal candidate brings strong SQL/PLSQL expertise, deep knowledge of Oracle Cloud reporting frameworks, and hands-on experience modernizing legacy EBS/OBIEE reporting into cloud platforms.

***Candidate must be able to work for UNIVERSAL Technologies directly.

WHO WE ARE

UNIVERSAL Technologies is a certified Women-Owned Business Enterprise (WBE/MWBE) IT consulting firm with over 20 years of experience providing top-tier technology talent and solutions to government and commercial clients. We specialize in delivering high-quality IT professionals across application development, infrastructure, cybersecurity, PMO, analytics, and emerging technology domains.

WHAT WE OFFER

UNIVERSAL Technologies offers competitive compensation, comprehensive benefits, career development opportunities, and the chance to support large-scale, mission-critical technology projects across New York and nationwide.

MANDATORY SKILLS/EXPERIENCE
• Bachelor’s degree in Computer Science, Information Systems, Business, or related technical field (or equivalent experience)

Oracle Fusion & Cloud Reporting
• 3+ years developing Oracle Transactional Business Intelligence analyses, dashboards, and reports
• 2+ years building advanced analytics and visualizations using Oracle Analytics Cloud (OAC)
• 2+ years developing reports in Oracle Analytics Server (OAS)
• 4+ years creating BI Publisher templates, layouts, and data models
• 2+ years working with Fusion Data Intelligence (FDI) subject areas, pipelines, and warehouse structures

Database, Data Warehouse & Integration
• 2+ years working with Oracle Autonomous Data Warehouse (ADW), including SQL tuning and data modeling
• 5+ years advanced SQL/PLSQL (packages, procedures, functions, triggers) using Oracle 19c/21c
• Strong understanding of dimensional modeling, star schemas, and data warehouse concepts
• Experience with ODI or similar ETL/integration tools preferred

Legacy System Modernization
• Knowledge of Oracle EBS data models and custom reporting
• Experience migrating OBIEE 12c reports/dashboards to Oracle Analytics Cloud (OAC)/ Oracle Transactional Business Intelligence (OTBI)
• Proven ability to refactor and modernize legacy PL/SQL reporting
• Understanding of cloud migration methodologies

Technical Expertise
• Strong SQL/PLSQL optimization and performance tuning
• Experience with REST APIs/web services for data integration
• Familiarity with Git/SVN for version control
• Knowledge of Oracle Cloud Infrastructure fundamentals and cloud security/role-based access controls

Soft Skills
• Excellent verbal and written communication skills
• Strong ability to translate business requirements into technical reporting solutions
• Ability to support, train, and interface with business users
• Strong attention to detail and process-improvement mindset
• Ability to work independently and in cross-functional teams
• Experience working in Agile/Scrum environments

Preferred (Nice-to-Have)
• Oracle Cloud certifications (OAC, Fusion Apps, Autonomous Data Warehouse)
• Experience with Oracle Integration Cloud (OIC)
• Familiarity with Oracle ERP/HCM/SCM modules
• Experience with data governance or MDM
• Knowledge of AI/ML capabilities within Oracle Analytics Cloud (OAC)
• Python or R for advanced analytics

SCOPE OF SERVICES

Design, develop, and maintain reporting solutions across Oracle Transactional Business Intelligence (OTBI), Oracle Analytics Cloud (OAC), Oracle Analytics Server (OAS), Fusion Data Intelligence (FDI) and, BI Publisher
• Build dashboards, visualizations, and pixel-perfect reports for operational, regulatory, and analytical needs
• Develop, enhance, and optimize data models, schemas, subject areas, and pipelines supporting enterprise reporting
• Integrate and transform data across ADW, Fusion Cloud modules (ERP/HCM/SCM), and additional data sources
• Modernize legacy reports, PL/SQL code, and OBIEE dashboards for cloud-native architectures
• Conduct performance tuning, SQL optimization, caching strategies, and aggregation enhancements
• Support business analysts and end users with training, troubleshooting, and reporting best practices
• Document technical designs, data flows, migration paths, and reporting specifications
• Ensure audit readiness, compliance, version control, and adherence to change management processes
• Participate in Agile/Scrum ceremonies; provide status updates and manage work items using standard project tools
• Collaborate with IT, data governance, analytics, and application teams to ensure data quality, consistency, and compliance

UNIVERSAL Technologies is an equal opportunity employer.

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: 10205691a
Position Id: 3921
Posted 30+ days ago

Company Info

About UNIVERSAL Technologies

“Our Mission is to become an extension of our client’s IT organization”

— JOAO RAQUEL, CEO

UNIVERSAL Technologies, LLC, focuses on supporting client engagements by seamlessly integrating our staff with the client’s existing Information Technology environment. Headquartered in New York City with additional offices in Albany, New York, we provide decades of experience to deliver measurable results within State and local government agencies and other large organizations.

What We Do

UNIVERSAL Technologies provides projects, personnel and solutions with a focus on ensuring that our clients’ infrastructure and computing environments are well designed, well managed, stable, and secure. We offer a wide range of services and products, from individual engagements to enterprise-wide solutions.

UNIVERSAL’s consulting practice and resources cross the technology boundaries of product specializations and its application requirements. Practice areas include but are not limited to:

· IT SUPPORT FOR HETEROGENEOUS ENTERPRISE

· SOFTWARE DEVELOPMENT

· PROJECT MANAGEMENT

· PROGRAM MANAGEMENT

· BUSINESS ANALYSIS

· SYSTEM ADMINISTRATION

· SYSTEMS ARCHITECTURE

Our Systems Integration management experience and core competencies span the life cycle of enterprise implementation from requirements analysis through design, deployment, and operation in a wide range of disciplines:

•DATA CENTER ARCHITECTURE

•VIRTUAL CLOUD ARCHITECTURE AND DEPLOYMENT

•VIRTUALIZATION ARCHITECTURE, DESIGN AND DEPLOYMENT

•ENTERPRISE SYSTEMS AND NETWORK INTEGRATION

•ENTERPRISE DISASTER RECOVERY PLANNING, DESIGN AND DEPLOYMENT

•STORAGE MANAGEMENT

•ENTERPRISE SECURITY ARCHITECTURE, DESIGN AND DEPLOYMENT

•ENTERPRISE OPERATIONS MANAGEMENT

Our Clients

UNIVERSAL Technologies has a history of providing IT services to some of the leading New York State and New York City government agencies.

Create job alert

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