HCM BI Publisher (BIP)/ OTBI Senior Analyst

Job description

As an BIP Sr. Associate, you will work with technical and projects teams to deliver cutting edge reporting solutions on Oracle cloud platforms for some of our Fortune 1000 clients. You will have the opportunity to contribute to work that may involve building new Oracle cloud solutions; migrating applications to co-exist in the hybrid cloud (On-Premise and Cloud); deploying a global cloud application across multiple countries. Our teams have a diverse range of skills and we are always looking for new ways to innovate and help our clients succeed. Primary focus on developing custom solutions using BIP/ OTBI reports Key Responsibilities Gather and analyze reporting requirements from HR and business stakeholders Design and develop reports and dashboards using OTBI and BI Publisher (BIP) Build custom data models using SQL, and create RTF, Excel templates Create and configure OTBI analyses, subject area queries, and dashboards Develop reports for HCM areas such as Core HR, Absence, Payroll, Talent, Compensation, and Benefits Optimize report performance and troubleshoot data and logic issues Support unit testing, SIT, UAT, and production issues Prepare technical specifications, test cases, and user documentation Technical Skills Strong hands-on experience in BI Publisher (BIP): data models, templates, bursting, and scheduling Strong hands-on experience in OTBI: subject areas, analyses, and dashboards Good knowledge of Oracle Fusion HCM data model and tables Strong SQL and PL/SQL skills Experience with HCM Extracts Understanding of Fusion security, roles, and data access Good communication and documentation skills