What are the responsibilities and job description for the Oracle Fusion Reporting & Analytics Developer position at UNIVERSAL Technologies?
Job Details
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
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 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.
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 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
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
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.
Oracle Fusion Finance SME
Capgemini -
York, NY
Oracle Fusion Project Manager
Ampcus, Inc -
York, NY
Oracle Fusion Technical Lead
Ampcus, Inc -
York, NY