UnitedHealth Group
Senior Software Engineering Lead - Oracle BI and HCM Reporting Specialist
UnitedHealth Group, Indiana, Pennsylvania, us, 15705
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 solid 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
The company’s terms, including transfer, re‑assignment, team changes, shifts, policy changes, alternative arrangements, etc., and its discretionary ability to adopt, vary, or rescind policies.
Required Qualifications
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)
Advanced SQL skills for high-volume data queries
Familiarity with data governance principles and HR data privacy/security standards
Solid analytical and problem‑solving skills with attention to detail
Effective communication and ability to work with cross‑functional teams
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
At UnitedHealth Group, our mission is to help people live healthier lives and make the health system work better for everyone. We believe everyone - of every race, gender, sexuality, age, location and income - deserves the opportunity to live their healthiest life. Today, however, there are still far too many barriers to good health which are disproportionately experienced by people of color, historically marginalized groups and those with lower incomes. We are committed to mitigating our impact on the environment and enabling and delivering equitable care that addresses health disparities and improves health outcomes - an enterprise priority reflected in our mission.
#J-18808-Ljbffr
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 solid 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
The company’s terms, including transfer, re‑assignment, team changes, shifts, policy changes, alternative arrangements, etc., and its discretionary ability to adopt, vary, or rescind policies.
Required Qualifications
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)
Advanced SQL skills for high-volume data queries
Familiarity with data governance principles and HR data privacy/security standards
Solid analytical and problem‑solving skills with attention to detail
Effective communication and ability to work with cross‑functional teams
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
At UnitedHealth Group, our mission is to help people live healthier lives and make the health system work better for everyone. We believe everyone - of every race, gender, sexuality, age, location and income - deserves the opportunity to live their healthiest life. Today, however, there are still far too many barriers to good health which are disproportionately experienced by people of color, historically marginalized groups and those with lower incomes. We are committed to mitigating our impact on the environment and enabling and delivering equitable care that addresses health disparities and improves health outcomes - an enterprise priority reflected in our mission.
#J-18808-Ljbffr