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.
