Oracle Fusion Reporting & Analytics Developer

Universal Technologies; United States; On-site; USD 110,000 - 140,000; Full time

Benefits offered by this job

Competitive compensation

Career development opportunities

Job summary

Universal Technologies is seeking an experienced Oracle Fusion Reporting & Analytics Developer for an onsite role in Long Island City, NY for the first 90 days with potential hybrid later. You will design, develop, and modernize reporting solutions across OTBI, OAC, OAS, FDI and ADW while partnering with business stakeholders and IT leadership.

The ideal candidate has deep Oracle Cloud reporting experience, strong SQL/PLSQL skills, and a track record of migrating legacy OBIEE/PLSQL reporting to

Qualifications

• Bachelor's degree or equivalent in a technical field.
• 3+ years developing Oracle Fusion & Cloud Reporting and OTBI analyses, dashboards and reports.
• 2+ years using Oracle Analytics Cloud (OAC).
• 2+ years developing reports in Oracle Analytics Server (OAS).
• 4+ years creating BI Publisher templates and data models.
• 2+ years with Fusion Data Intelligence (FDI) pipelines and ADW structures.
• 2+ years with Oracle Autonomous Data Warehouse (ADW) and SQL tuning.
• 5+ years advanced SQL/PLSQL (Oracle 19c/21c).
• Strong dimensional modeling and data warehouse concepts.

Responsibilities

• Design, develop, and maintain cloud-based reporting Solutions.
• Modernize legacy OBIEE/PLSQL reports into cloud native architectures.
• Build dashboards and data models across OTBI, OAC, OAS, and FDI.
• Collaborate with stakeholders, data teams, and IT leadership.
• Support data governance, performance tuning, and change management.
• Participate in Agile/Scrum ceremonies and document requirements.

Skills

Oracle Fusion & Cloud Reporting

SQL/PLSQL

Oracle Analytics Cloud (OAC)

Oracle Analytics Server (OAS)

BI Publisher

Oracle Autonomous Data Warehouse (ADW)

Data modeling

ETL tools (ODI)

OBIEE modernization

Cloud migration

Education

Bachelor's degree in Computer Science / Information Systems / Business

Tools

ODI

OBIEE

Git/SVN

REST APIs

Job description

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 SQLPLSQL expertise deep knowledge of Oracle Cloud reporting frameworks and hands on experience modernizing legacy EBSOBIEE 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 WBEMWBE 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

• competitive compensation comprehensive benefits career development opportunities and the chance to support large scale mission critical technology projects across New York and nationwide

MANDATORY SKILLSEXPERIENCE

• Bachelors 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 SQLPLSQL packages procedures functions triggers using Oracle 19c21c
• Strong understanding of dimensional modeling star schemas and data warehouse concepts
• Experience with ODI or similar ETLintegration tools preferred
• Legacy System Modernization Knowledge of Oracle EBS data models and custom reporting
• Experience migrating OBIEE 12c reportsdashboards to Oracle Analytics Cloud OAC Oracle Transactional Business Intelligence OTBI Proven ability to refactor and modernize legacy PLSQL reporting Understanding of cloud migration methodologies

Technical Expertise

• Strong SQLPLSQL optimization and performance tuning Experience with REST APIsweb services for data integration Familiarity with GitSVN for version control Knowledge of Oracle Cloud Infrastructure fundamentals and cloud securityrole 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 AgileScrum environments

Preferred Nice to Have

• Oracle Cloud certifications OAC Fusion Apps Autonomous Data Warehouse Experience with Oracle Integration Cloud OIC Familiarity with Oracle ERPHCMSCM modules Experience with data governance or MDM Knowledge of AIML 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 ERPHCMSCM and additional data sources Modernize legacy reports PLSQL 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 AgileScrum 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