Oracle Cloud Data Systems Analyst

Certain terms and conditions of employment for this position, including the rate of pay, benefits, etc., are currently subject to negotiation with the appropriate union.

The Oracle Reporting Analyst is responsible for designing, developing, and maintaining reports and dashboards across Oracle Cloud ERP (and related systems) to support business decision-making. This role partners with functional teams and business stakeholders to translate requirements into effective reporting solutions, ensuring data accuracy, consistency, and usability across the enterprise.

The analyst will leverage Oracle reporting tools (OTBI, BI Cloud Connector, BI Publisher, Fusion Analytics Warehouse) and other enterprise analytics platforms to meet both operational and strategic reporting needs. The ideal candidate will have a strong understanding of Oracle ERP data structures, functional business processes, and analytics best practices, coupled with technical skills in SQL, data modeling, and visualization.

Collaborates with Business Systems Analysts (BSAs), technical integration teams, and data warehouse developers to ensure consistent and integrated reporting across systems. Provide ad hoc data analysis and support to business partners during month-end, year-end, and key operational cycles.

This position includes regular onsite work, typically 1-3 days per month. The exact schedule and frequency may be adjusted as needed to meet departmental and operational demands.

The Business Informatics & Analysis team is responsible for delivering functional expertise, business process analysis, and application support across the enterprise's Oracle Cloud ERP ecosystem. This team partners with business stakeholders, technical and cross-functional teams to ensure that Oracle ERP modules-such as Finance, Procurement, Projects,Research, Supply Chain, and Human Capital Management (HCM)-are effectively configured, optimized, and aligned with organizational objectives.

The team provides both strategic and operational support, including requirements gathering, solution design, process improvement, system configuration, testing, reporting, and training. Their work ensures that Oracle Cloud ERP and the boundary systems it integrates with enable accurate, efficient, and scalable business operations.

• 25% Design, develop, and maintain reports, dashboards, and data extracts across Oracle Cloud HCM to meet operational and analytical needs. Build and optimize BI Publisher data models and templates (RTF, Excel, PDF) to support formatted reports, data extracts, and system-to-system integrations.
• 20% Build and maintain data models, BI Publisher templates, and OTBI (Oracle Transactional Business Intelligence) analyses to support operational and strategic reporting needs. Maintain documentation for reporting specifications, data definitions, and logic transformations to support transparency and continuity.
• 10% Support data validation, reconciliation, and troubleshooting for reports and dashboards. Provide ad hoc reporting and data analysis support for functional teams and leadership to enable data-driven decision-making.
• 10% Collaborate with cross-functional teams (Finance, HR, Supply Chain, IT) to ensure data integrity and consistency across reporting platforms. Promote self-service analytics by developing shared reports, dashboards, and training materials that empower business users.
• 5% Manage report security, roles, and data access in compliance with organizational standards.
• 5% Assist in the transition from legacy reporting tools to Oracle Cloud reporting solutions.
• 10% Provide user training, documentation, and ongoing support for reporting tools and dashboards.
• 10% Participate in testing, upgrades, and…