Oracle HR Report Developer

Overview

Design, develop and manage enterprise HR reporting and analytics across Oracle BIP, OTBI, FDI and FAW / Lakehouse, turning business requirements into reliable reports, dashboards and data pipelines for global HR, Compensation, Talent, Payroll and Operations teams.

What you'll do

• Design, develop and maintain BIP reports and templates (RTF, Excel, and eText) for HCM, Talent, Benefits, and Compensation.
• Build and optimize data models, SQL queries, and flexfield-based reporting solutions.
• Configure report bursting, scheduling, and automated distribution.
• Develop regulatory, compliance, audit, and operational reporting extracts.
• Manage BIP catalog governance, security, version control, and environment migrations.
• Develop and maintain OTBI analyses, dashboards, KPIs, and self-service reporting solutions across Oracle HCM modules.
• Design user-friendly analytics using filters, prompts, hierarchical views, and interactive dashboards.
• Govern OTBI content through catalog administration, naming standards, usage audits, and lifecycle management.
• Enable business self-service reporting through user support, training, and best-practice guidance.
• Assess and remediate report impacts resulting from Oracle quarterly releases and subject area changes.
• Design, develop and maintain enterprise-grade FDI dashboards, reports, and analytics solutions supporting HR, Finance, Compensation, Talent Management, and Workforce Planning functions.
• Configure and manage FDI subject areas, semantic model extensions (SME), custom calculations, KPIs, dimensions, and measures.
• Implement and troubleshoot FDI security, including row-level security, data access roles, Area of Responsibility (AOR)-based security, and custom subject-area access controls.
• Develop interactive dashboards, visualizations, drill-through analyses, and executive scorecards for leadership teams and business stakeholders.
• Integrate data from Oracle Fusion HCM, Payroll, Recruiting, Compensation, and Workforce Management modules into unified analytics and reporting solutions.
• Support quarterly Oracle releases, regression testing, validation activities, and production issue resolution for FDI analytics environments.
• Configure, administer, and optimize FAW environments, including pipeline activation, data synchronization, incremental refresh schedules, and semantic model enhancements.
• Extend the FAW/FDI Lakehouse architecture by ingesting and integrating non-Oracle HR and workforce data sources (including Eightfold AI, Celergo, ADP GlobalView, compensation benchmarking platforms, and other third-party applications) into Oracle Autonomous Data Warehouse (ADW) using ODI, OCI Object Storage, APIs, and custom ETL frameworks.
• Develop and maintain custom ADW data models, staging structures, and transformation processes to support advanced reporting and cross-functional analytics.
• Design and publish workforce analytics dashboards covering headcount, attrition, hiring, promotions, compensation, diversity, compliance, and organizational effectiveness metrics.
• Monitor and troubleshoot data pipelines, refresh jobs, synchronization failures, schema changes, and data quality issues across FDI, FAW, ADW, and ODI environments.
• Maintain data governance standards, documentation, lineage tracking, security policies, and audit-compliant access controls across analytics platforms.
• Maintain reporting inventory, ownership, data classification, and refresh schedules.
• Administer row-level security (RLS) and role-based access controls.
• Support analytics data integration from Boomi, HCM Extracts, and other enterprise sources.
• Lead regression testing and remediation activities for Oracle quarterly releases.
• Contribute to HR analytics and AI reporting strategy through continuous improvement and innovation.
• Maintain technical documentation, data dictionaries, operational procedures, and support runbooks.
• Provide end-user support, troubleshoot system defects, and promote reporting best practices.
• Analyze business requirements, identify process improvements, and assess downstream impacts.
• Serve as a subject matter expert on reporting platforms, data models, and analytics solutions.
• Mentor, coach, and share knowledge with team members to build organizational capability.
• Work on critical defects, product enhancement requests, and production issues.

What you'll need

• 5+ years of Oracle HCM reporting and analytics experience in a SaaS environment.
• Hands-on expertise with Oracle BI Publisher (BIP), including data models, SQL, flexfields, bursting, and report development.
• Strong experience designing and maintaining BIP templates (RTF, Excel, and eText).
• Advanced knowledge of OTBI analyses, dashboards, KPIs, and Oracle HCM subject areas.
• Proficiency in Oracle SQL and PL/SQL for reporting, analytics, and data extraction.
• Experience with Oracle FDI, FAW, or Oracle Analytics Cloud (OAC), including dashboard development and semantic modeling.
• Understanding of data warehousing concepts, including dimensional modeling and incremental data loads.
• Ability to translate complex business requirements into scalable reporting and analytics solutions.
• Strong analytical, troubleshooting, and data validation skills with a focus on data accuracy and governance.

Nice to have

• Experience with Oracle Fusion Data Intelligence (FDI) and workforce analytics solutions.
• Knowledge of Oracle Autonomous Data Warehouse (ADW), Lakehouse architecture, and external data integrations.
• Experience with Power BI or similar enterprise analytics platforms.
• Understanding of HR data governance, privacy, and security controls.
• Oracle Cloud HCM Reports and Analytics certification.
• Exposure to AI-enabled analytics, predictive insights, and dashboard automation.
• Experience supporting global HCM environments with multi-country reporting and compliance needs.
• Strong stakeholder management, training, and knowledge-sharing skills.
• Experience with HCM Extracts and enterprise reporting integrations.

Details

• Location: Bengaluru South, Bengaluru North or Bengaluru East, Karnataka, India.
• Work mode: Hybrid.
• Employment type: Full-Time.
• Level: Mid to Senior Individual Contributor.
• Reports to: Technical Manager, HR Technology – Platform & Engineering.