Oracle HCM Reporting

Senior Software Engineer – Oracle HCM Reporting

Job Summary:

We are seeking a highly skilled and experienced Senior Software Engineer to join HR Technology team and lead the development of reporting solutions within our Oracle HCM Cloud environment. This role demands a strong technical background and extensive experience in building complex reports and dashboards using Oracle Business Intelligence Publisher (BIP) and Oracle Transactional Business Intelligence (OTBI) across HR, Benefits, Compensation, Performance, and Talent modules. The ideal candidate will be a technical leader, capable of designing, developing, and optimizing high-performance reporting solutions.

Experience:

•           Minium 2 years of extensive experience with Oracle HCM Reporting.

•           Total 5 years of IT experience in building reports and dashboards using Oracle BI Publisher and OTBI.

Responsibilities:

•           Advanced Report and Dashboard Development:

o           Design and develop complex, high-performance reports and dashboards using Oracle BI Publisher and OTBI, leveraging advanced features and techniques.

o           Create and maintain parameterized report, interactive dashboards, and analytical tools to provide strategic insights.

o           Optimize report performance through efficient SQL queries, data modeling, and report design.

o           Develop and implement best practices for report development and deployment.

•           Data Modeling and Integration:

o           Design and implement efficient data models to support reporting requirements.

o           Integrate data from various Oracle HCM modules and external sources.

o           Ensure data accuracy, consistency, and security across all reports and dashboards.

•           Performance Optimization and Troubleshooting:

o           Identify and resolve performance bottlenecks in reports and dashboards.

o           Conduct performance tuning and optimization of SQL queries and report designs.

o           Troubleshoot and resolve complex technical issues related to Oracle BIP and OTBI.

•           Technical Documentation and Standards:

o           Develop and maintain comprehensive technical documentation for reports, dashboards, and data models.

o           Establish and enforce coding standards and best practices.

o           Implement version control best practices.

•           Collaboration and Communication:

o           Collaborate with business stakeholders, analysts, and other technical teams to deliver effective reporting solutions.

o           Communicate technical concepts and solutions to non-technical audiences.

o           Participate in agile development processes.