Senior Software Engineering Lead - Oracle BI and HCM Reporting Specialist

Optum is a global organization that delivers care, aided by technology to help millions of people live healthier lives. The work you do with our team will directly improve health outcomes by connecting people with the care, pharmacy benefits, data and resources they need to feel their best. Here, you will find a culture guided by inclusion, talented peers, comprehensive benefits and career development opportunities. Come make an impact on the communities we serve as you help us advance health optimization on a global scale. Join us to start Caring. Connecting. Growing together.

We are seeking a highly skilled Oracle BI & HCM Reporting Specialist to design, develop, and optimize reporting solutions across Oracle HCM modules. This role is hands-on and requires deep expertise in OTBI, BI Publisher, HCM Extracts, and HDL, with strong SQL skills and a proven ability to deliver accurate, scalable reporting solutions in a fast-paced environment.

Primary Responsibilities:

• Report Development:
  • Design and maintain BI Publisher and OTBI reports for Payroll, Core HR, Compensation, Time & Labor, Talent Management, and Absence Management
  • Implement automated email delivery using bursting features
  • Develop templates using XSL, Word, Excel, and eText formats
  • Customize payslip and check printing formats using BI Publisher
• Data Integration & Extracts:
  • Create and manage HCM Extracts combining multiple user entities and configure delivery methods
  • Utilize HDL for data loading and reporting
  • Parameterize reports using Payroll Flows for dynamic execution
• Performance & Optimization:
  • Optimize complex SQL queries for performance and scalability
  • Ensure compliance with security and data privacy standards
• Version Control & Migration:
  • Oversee migration of report objects between environments using GitHub, including version control and approval workflows
• Collaboration & Documentation:
  • Work closely with functional leads and end users to gather requirements and translate them into technical specifications
  • Document report designs, data mappings, and testing results
• Comply with the terms and conditions of the employment contract, company policies and procedures, and any and all directives (such as, but not limited to, transfer and/or re-assignment to different work locations, change in teams and/or work shifts, policies in regards to flexibility of work benefits and/or work environment, alternative work arrangements, and other decisions that may arise due to the changing business environment). The Company may adopt, vary or rescind these policies and directives in its absolute discretion and without any limitation (implied or otherwise) on its ability to do so

• Bachelor's degree in Computer Science, Information Systems, or related field
• 8+ years of hands-on experience in Oracle OTBI, BI Publisher, and HCM Extracts
• Experience with GitHub for version control and migration workflows
• Solid understanding of Oracle HCM data structures and modules (Core HR, Payroll, Compensation, Absence, Talent, Time & Labor)
• Familiarity with data governance principles and HR data privacy/security standards
• Proven advanced SQL skills for high-volume data queries
• Proven solid analytical and problem-solving skills with attention to detail
• Proven effective communication and ability to work with cross-functional teams
• Proven proactive use of AI tools such as Microsoft Copilot or M365 Copilot for productivity

Preferred Qualifications:

• Oracle Cloud HCM certifications
• Experience with Payroll Flows and seeded payroll processes
• Knowledge of secure file delivery and encryption practices for HCM Extracts

#nic