Voyatek
Oracle Fusion Reporting & Analytics Developer
Contract position through January 2027 located in New York, NY within the NYC School Construction Authority team.
Pay range: $80.00/hr - $90.00/hr.
Overview Voyatek delivers outcome‑driven technology solutions to public sector agencies and higher education institutions. In this role, you will design, develop, and maintain reporting and analytics solutions using Oracle Fusion Cloud applications to support tax, revenue, health, and public safety initiatives.
Key Responsibilities Reporting & Analytics Development
Design, develop, and maintain 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
Work with Oracle Autonomous Data Warehouse (ADW) to design and implement robust data models
Understand and leverage FDI 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, and 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
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
OTBI: 3+ years developing subject area analyses, dashboards, and reports
OAC: 2+ years creating data visualizations, data flows, and advanced analytics
OAS: 2+ years developing dashboards and reports
BI Publisher: 4+ hours building complex templates, layouts, and data models
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
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
Cloud migration strategies and best practices
Technical Skills
Strong SQL and PL/SQL programming capabilities
REST APIs and web services for data integration
Version control systems (Git, SVN)
Oracle Cloud Infrastructure (OCI) fundamentals
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 discipline (equivalent education and experience considered)
Preferred Qualifications
Oracle Cloud certifications (OAC, Fusion Applications, ADW)
Oracle Integration Cloud (OIC) experience
Knowledge of Oracle HCM, ERP, or SCM Cloud modules
Data governance and master data management experience
AI/ML capabilities in Oracle Analytics Cloud
Python or R programming for advanced analytics
Benefits
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
Employee Referral Bonus Program
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.
#J-18808-Ljbffr
Pay range: $80.00/hr - $90.00/hr.
Overview Voyatek delivers outcome‑driven technology solutions to public sector agencies and higher education institutions. In this role, you will design, develop, and maintain reporting and analytics solutions using Oracle Fusion Cloud applications to support tax, revenue, health, and public safety initiatives.
Key Responsibilities Reporting & Analytics Development
Design, develop, and maintain 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
Work with Oracle Autonomous Data Warehouse (ADW) to design and implement robust data models
Understand and leverage FDI 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, and 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
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
OTBI: 3+ years developing subject area analyses, dashboards, and reports
OAC: 2+ years creating data visualizations, data flows, and advanced analytics
OAS: 2+ years developing dashboards and reports
BI Publisher: 4+ hours building complex templates, layouts, and data models
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
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
Cloud migration strategies and best practices
Technical Skills
Strong SQL and PL/SQL programming capabilities
REST APIs and web services for data integration
Version control systems (Git, SVN)
Oracle Cloud Infrastructure (OCI) fundamentals
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 discipline (equivalent education and experience considered)
Preferred Qualifications
Oracle Cloud certifications (OAC, Fusion Applications, ADW)
Oracle Integration Cloud (OIC) experience
Knowledge of Oracle HCM, ERP, or SCM Cloud modules
Data governance and master data management experience
AI/ML capabilities in Oracle Analytics Cloud
Python or R programming for advanced analytics
Benefits
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
Employee Referral Bonus Program
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.
#J-18808-Ljbffr