Universal Group Inc. · 22 hours ago
Oracle Fusion Reporting & Analytics Developer
Long Island City, NY
Full-time
Onsite
Mid, Senior Level
$60/hr - $65/hr
5+ years expUNIVERSAL Technologies is seeking an experienced Oracle Fusion Reporting & Analytics Developer for an onsite role. The candidate will support enterprise-wide reporting, analytics, and data intelligence initiatives, designing and developing reporting solutions across various Oracle platforms while collaborating with business stakeholders and IT leadership.
FinanceProperty & Casualty InsuranceAutomotiveCommercialFinancial ServicesInsurance
Responsibilities
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
Qualification
Required
Bachelor's degree in Computer Science, Information Systems, Business, or related technical field (or equivalent experience)
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
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
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
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
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
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
Benefits
Competitive compensation
Comprehensive benefits
Career development opportunities
Company
Universal Group Inc.
Universal offers a wide range of insurance products and services, as well as financing and investment options.
501-1000 employees
H1B Sponsorship
Universal Group Inc. has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2024 (1)
2023 (2)
2022 (1)
2021 (4)
2020 (3)
Funding
Current Stage
Late StageLeadership Team
Eddie Mauro
President - CEO
Trevor Jonga
Chief Executive Officer
Recent News
2025-07-28
2025-07-24
The Express Tribune
2025-07-22
Company data provided by crunchbase