NYC SCA Oracle Fusion Reporting & Analytics Developer

Opportunity Details

Full Time NYC SCA #R4120 Oracle Fusion Reporting & Analytics Developer

Long Island City, NY

Outcomes. Delivered.

Voyatek delivers outcome-driven technology solutions to public sector agencies and higher education institutions nationwide.

For example, our technology:

Facilitates access to nutritious food for children of mothers participating in the WIC program

Supports first responders in reducing opioid overdoses within their communities

Empowers colleges and universities to identify and thwart financial aid fraud

Equips teachers with valuable insights to identify students requiring additional support

Enhances efficiency for state tax agencies, leading to 99% faster return processing and quicker refunds for taxpayers

With a focus on Tax & Revenue, Health & Human Services, and Justice & Public Safety, Voyatek combines the scale to support large complex projects with the agility and accessibility of a boutique solutions provider. Together, Voyatek and its customers work to improve population wellbeing, create safer communities, and foster a thriving economy.

We're more than a technology company -- we're an outcomes company.

We encourage our employees to think differently, ask tough questions, and relentlessly pursue what's best for our customers and the residents they serve.

We believe that the value of technology is defined by its human impact. If you agree, you've come to the right place.

Voyatek is seeking applicants to occupy the position of Oracle Fusion Reporting & Analytics Developer within our team NYC School Construction Authority located in New York, NY. This is a contract position through January 2027. )

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

Qualifications:

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

Bachelor's Degree in Computer Science, Information Systems, Business, or related technical discipline. Equivalent combination of education and relevant work experience will be considered

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

The wage range for this role reflects the wide array of factors considered in compensation decisions. These factors include, but are not limited to, skill sets, experience, training, licensure certifications, and geographic location. Compensation decisions are based on the unique facts and circumstances of each case. A reasonable estimate of the hourly range is $ 80 .00 - $ 90 .00.

At Voyatek, we believe in supporting our employees with a comprehensive benefits package designed to enhance their well-being and professional growth. Please note that eligibility for certain benefits may vary based on your role and employment status.

Flexible Work Schedules

Health, Dental, and Vision Insurance

Medical, Limited, & Dependent Flexible Spending Accounts (FSA)

Health Savings Account (HSA) with Employer Contributions

Company-Paid and Voluntary Life Insurance

Long and Short-Term Disability Insurance

Accident, Critical Illness, & Hospital Indemnity Insurance

401(k) Retirement Plan with Company Match and Immediate Vesting

Wellhub Fitness and Wellness Platform

Pet Insurance

Training Opportunities

Employee Referral Bonus Program

We are committed to fostering a workplace that supports both your personal and professional aspirations.

As part of our commitment to maintaining a compliant workplace, all final candidates will undergo and must successfully pass a pre-employment (post offer) background check. The background check may include, but is not limited to, verification of employment history, education, criminal records, and other relevant checks. Background check results will be evaluated in accordance with applicable law. For certain positions, additional client-specific background screenings may be required at the time of hire or in the future, in accordance with client requirements.

If you think you are a good fit for us, we encourage you to apply. Check out our career website for all open positions!

Voyatek provides equal employment opportunities to all employees and applicants for employment. Voyatek will make employment decisions without regard to race, color, creed, ancestry, national origin, citizenship, sex or gender (including pregnancy, childbirth, and pregnancy-related conditions), gender identity or expression (including transgender status), sexual orientation, marital status or domestic violence victim status, religion, age, disability, genetic information, service in the military, or any other characteristic protected by applicable federal, state, or local laws and ordinances. Employment decisions include all terms and conditions of employment, including recruitment and hiring, job assignment/ placement, promotion, upgrading, demotion, termination, layoff, recall, transfer, leave of absence, rates of pay or other compensation, internship, and training.