Oracle Fusion Reporting

5 days ago

New York, NY, United States Yale University Full time
Job Title: Oracle FusionReporting&AnalyticsDeveloper

Duration: Long Term

Location: Long Island City, NY

Note: Only W2 Consultants
Overview:

The Oracle Fusion Reporting & Analytics Developer will provide comprehensive reporting, analytics, and data intelligence solutions for our Oracle Fusion Cloud environment. This role will design, develop, and maintain enterprise reports using OTBI, Oracle Analytics Cloud (OAC), Oracle Analytics Server (OAS), and Fusion Data Intelligence (FDI). The ideal candidate will work closely with business stakeholders and data analysts to deliver actionable insights while modernizing legacy reporting processes.
Key Responsibilities:
Reporting & Analytics Development
  • Design, develop, and maintain Oracle Transactional Business Intelligence (OTBI) reports and dashboards using Oracle Fusion Cloud applications
  • Create advanced analytics and data visualizations in Oracle Analytics Cloud (OAC)
  • Develop and maintain reports in Oracle Analytics Server (OAS) for on-premises requirements
  • Build pixel-perfect reports using BI Publisher for regulatory compliance and operational needs
  • Create and optimize dashboards leveraging Fusion Data Intelligence (FDI) capabilities
Data Architecture & Integration
  • Work with Oracle Autonomous Data Warehouse (ADW) to design and implement robust data models
  • Understand and leverage Fusion Data Intelligence subject areas and data pipelines
  • Design and optimize data warehouse schemas to support enterprise reporting requirements
  • Integrate data from multiple sources including Oracle Fusion ERP, HCM, SCM modules
  • Perform data modeling and create logical business models aligned with business requirements
Legacy Modernization
  • Analyze and modernize custom PL/SQL processes and reports from Oracle E- Business Suite (EBS)
  • Migrate legacy OBIEE reports and dashboards to OAC/OTBI frameworks
  • Refactor inefficient database procedures and optimize for cloud-based architecture
  • Document migration paths and transformation logic for legacy report conversions
Performance & Optimization
  • Optimize query performance across OTBI, OAC, and ADW environments
  • Implement best practices for report caching, aggregation, and indexing strategies
  • Monitor and tune SQL queries and PL/SQL procedures for optimal performance
  • Conduct performance testing and implement improvements based on usage patterns
Collaboration & Support
  • Partner with business analysts to translate requirements into technical reporting solutions
  • Provide training and support to business users on OTBI, OAC, and OAS tools
  • Collaborate with IT teams to integrate analytics solutions with enterprise applications
  • Work with data governance teams to ensure data quality and compliance standards
Documentation & Compliance
  • Document technical designs, data flows, and reporting specifications
  • Maintain comprehensive documentation for audit and compliance purposes
  • Create user guides and training materials for report consumers
  • Follow change management processes and maintain version control
Project Management
  • Participate in agile/scrum ceremonies including sprint planning, daily standups, and retrospectives
  • Provide regular progress updates and status reporting to stakeholders
  • Utilize SCA project management and requirements tracking tools
  • Manage multiple priorities and adapt to changing business needs
Required Skills & Experience:
Oracle Fusion & Cloud Analytics (Required)
  • Oracle Transactional Business Intelligence (OTBI): 3+ years developing subject area analyses, dashboards, and reports
  • Oracle Analytics Cloud (OAC): 2+ years creating data visualizations, data flows, and advanced analytics
  • Oracle Analytics Server (OAS): 2+ years developing dashboards and reports
  • BI Publisher: 4+ years building complex templates, layouts, and data models
  • Fusion Data Intelligence (FDI): 2+ years working with FDI subject areas, pipelines, and data warehouse
Database & Data Warehouse
  • Oracle Autonomous Data Warehouse: 2+ years experience with ADW architecture, SQL optimization, and data modeling
  • Oracle Database 19c/21c: 5+ years with advanced SQL, PL/SQL stored procedures, functions, and packages
  • Data Modeling: Strong understanding of dimensional modeling, star schemas, and data warehouse concepts
  • ETL/Data Integration: Experience with Oracle Data Integrator (ODI) or similar tools preferred
Legacy Systems & Migration
  • Oracle E-Business Suite (EBS): Understanding of EBS data model and custom reports
  • OBIEE 12c: Experience migrating from OBIEE to OAC/OTBI preferred
  • PL/SQL Modernization: Proven ability to refactor and optimize legacy database code
  • Migration Methodologies: Knowledge of cloud migration strategies and best practices
Technical Skills:
  • Strong SQL and PL/SQL programming capabilities
  • Understanding of REST APIs and web services for data integration
  • Experience with version control systems (Git, SVN)
  • Knowledge of Oracle Cloud Infrastructure (OCI) fundamentals
  • Familiarity with data security and role-based access controls
Soft Skills & Work Style
  • Excellent verbal and written communication skills
  • Strong client interface and training abilities
  • Ability to work under pressure and adapt to changing priorities
  • Detail-oriented with strong process improvement mindset
  • Collaborative team player who can also work independently
  • Experience in agile/scrum methodology and ceremonies
Preferred Qualifications
  • Oracle Cloud certifications (OAC, Fusion Applications, ADW)
  • Experience with Oracle Integration Cloud (OIC)
  • Knowledge of Oracle HCM, ERP, or SCM Cloud modules
  • Experience with data governance and master data management
  • Familiarity with AI/ML capabilities in Oracle Analytics Cloud
  • Python or R programming for advanced analytics
Education
  • Bachelor's Degree in Computer Science, Information Systems, Business, or related technical discipline
  • Equivalent combination of education and relevant work experience will be considered

  • Oracle Fusion Consultant

    2 weeks ago

    New York, NY, United States Tech Tammina Full time

    Title: Oracle Fusion Consultant Work Location: 26th Street and Madison Ave, NY, NY Duration: 1yr renewable contracts. Must report to the work site for 4 months then will offer a remote option. The Job is Data migration and Oracle Fusion Cloud ERP Transformation - Financials.Skills Need: Must have 10+ years of experience working for US companies in the US....

  • Oracle Fusion Technical Lead

    2 weeks ago

    New York, NY, United States Ampcus Full time

    Ampcus Inc. is a certified global provider of a broad range of Technology and Business consulting services. We are in search of a highly motivated candidate to join our talented Team. Job Title: Oracle Fusion Technical Lead Location(s): New York City, NYRole Overview: The Oracle Fusion Technical Lead will provide leadership and hands-on support for...

  • Oracle Fusion Technical Lead

    3 days ago

    New York, NY, United States Ampcus Full time

    Ampcus Inc. is a certified global provider of a broad range of Technology and Business consulting services. We are in search of a highly motivated candidate to join our talented Team. Job Title: Oracle Fusion Technical Lead Location(s): New York City, NYRole Overview: The Oracle Fusion Technical Lead will provide leadership and hands-on support for...

  • Data Engineer with Oracle Fusion

    2 hours ago

    New York, NY, United States Tech Tammina Full time

    Title: Senior Consultant - Oracle Cloud Work Location: 26th Street and Madison Ave, NY, NY Duration: 1yr renewable contracts. Must report to the work site for 4 months then will offer a remote option. The Job is Data migration and Oracle Fusion Cloud ERP Transformation - Financials.Skills Need: Must have 10+ years of experience working for US companies in...

  • Oracle Fusion Project Manager

    1 week ago

    New York, NY, United States Ampcus Full time

    Ampcus Inc. is a certified global provider of a broad range of Technology and Business consulting services. We are in search of a highly motivated candidate to join our talented Team. Job Title: Oracle Fusion Project Manager Location(s): New York City, NYRole Overview: The Oracle Fusion Project Manager will be responsible for leading and coordinating...

  • Oracle Fusion Project Manager

    3 days ago

    New York, NY, United States Ampcus Full time

    Ampcus Inc. is a certified global provider of a broad range of Technology and Business consulting services. We are in search of a highly motivated candidate to join our talented Team. Job Title: Oracle Fusion Project Manager Location(s): New York City, NYRole Overview: The Oracle Fusion Project Manager will be responsible for leading and coordinating...

  • Oracle Fusion Cloud HCM Developer

    2 days ago

    New York, NY, United States Kaav Inc. Full time

    JOB DESCRIPTIONAssignment Description We have recently completed the implementation of Oracle Fusion Cloud HCM, encompassing Core HR, Recruitment, Benefits, Absence, T&L, Payroll, and HR Helpdesk modules. We are seeking an experienced individual to assist with ongoing support for integrations & reports and for building new integrations from scratch, testing,...

  • Oracle Fusion Cloud HCM Developer

    1 week ago

    New York, NY, United States Kaav Inc. Full time

    JOB DESCRIPTIONAssignment Description We have recently completed the implementation of Oracle Fusion Cloud HCM, encompassing Core HR, Recruitment, Benefits, Absence, T&L, Payroll, and HR Helpdesk modules. We are seeking an experienced individual to assist with ongoing support for integrations & reports and for building new integrations from scratch, testing,...

  • Oracle Fusion Cloud HCM Developer

    4 days ago

    New York, NY, United States Kaav Inc. Full time

    JOB DESCRIPTIONAssignment Description We have recently completed the implementation of Oracle Fusion Cloud HCM, encompassing Core HR, Recruitment, Benefits, Absence, T&L, Payroll, and HR Helpdesk modules. We are seeking an experienced individual to assist with ongoing support for integrations & reports and for building new integrations from scratch, testing,...

  • Senior Consultant

    2 days ago

    New York, NY, United States Tech Tammina Full time

    Title: Senior Consultant - Oracle Cloud/BigData Work Location: 26th Street and Madison Ave, NY, NY Duration: 1yr renewable contracts. Must report to the work site for 4 months then will offer a remote option. The Job is Data migration and Oracle Fusion Cloud ERP Transformation - Financials.Skills Need: Must have 10+ years of experience working for US...