Gather and analyze reporting requirements from HR and business stakeholders
Design and develop reports and dashboards using OTBI and BI Publisher
Build custom data models using SQL and create RTF and Excel templates
Optimize report performance and troubleshoot data and logic issues
Support unit testing, SIT, UAT, and production issues
From the employer’s posting
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
Optimize report performance and troubleshoot data and logic issues
Support unit testing, SIT, UAT, and production issues
Tools in this posting
PL/SQL
SQL
Oracle
Source — Tool mentions in context
HCM BI Publisher (BIP)/ OTBI Senior Analyst 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 Good to have Knowledge of Fusion Data Intelligence (FDI) or Oracle Analytics Knowledge on OCI, REST/SOAP APIs and APEX/ VBCS application would be added advantage Exposure to multiple end-to-end Fusion HCM implementations Oracle HCM Cloud certification Consulting Requirements 5-8 years of relevant consulting, industry or technology experience Proven knowledge of Oracle Cloud platform and tools Excellent team player Strong problem solving and troubleshooting skills Strong communicator Willingness to travel up in case of project requirement Strong knowledge of software implementation best practices Ability to adapt quickly to an existing, complex environment and learn new concepts and software Self-motivated, independent, detail oriented, responsible team player and exhibit exceptional relationship management skills Passionate about building high-quality systems with software implementation Professionalism and integrity Strong interpersonal and written communication skills Ability to work in fast paced environment
HCM BI Publisher (BIP)/ OTBI Senior Analyst 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 Good to have Knowledge of Fusion Data Intelligence (FDI) or Oracle Analytics Knowledge on OCI, REST/SOAP APIs and APEX/ VBCS application would be added advantage Exposure to multiple end-to-end Fusion HCM implementations Oracle HCM Cloud certification Consulting Requirements 5-8 years of relevant consulting, industry or technology experience Proven knowledge of Oracle Cloud platform and tools Excellent team player Strong problem solving and troubleshooting skills Strong communicator Willingness to travel up in case of project requirement Strong knowledge of software implementation best practices Ability to adapt quickly to an existing, complex environment and learn new concepts and software Self-motivated, independent, detail oriented, responsible team player and exhibit exceptional relationship management skills Passionate about building high-quality systems with software implementation Professionalism and integrity Strong interpersonal and written communication skills Ability to work in fast paced environment
Demand for Analyst roles
New Analyst postings at the employers we follow are up 26% over the last 6 weeks compared with the 6 before.
August 17Last week
Each bar is one week of new postings. The darkest bars are the last 6 weeks.
Counted from the hiring pages we’ve followed for at least five weeks, so employers we add don’t look like growth. Updated weekly.
About the role
We file this job under Analyst, by the work the posting describes.
Analysts answer business questions with data. They pull numbers with SQL, build reports and dashboards, and explain what changed and why to the people making decisions.
Most postings ask for SQL, spreadsheets, a dashboard tool such as Tableau or Power BI, and clear writing.
Unlike a data scientist, an analyst mostly explains what happened rather than building models that predict what will.