About The Role

Business Intelligence Analyst III interacts with the business to identify goals and needs for data and analytics needs.

Responsibilities

Expert knowledge to define and build custom reports that meet the needs of our business.
Work with wider FIN, HCM, SCM teams to define functional reporting requirements, agreeing the toolset that will be used to best deliver these.
Work with implementation partner to define and build custom OBTI and XML reports with Oracle HCM/SCM/FIN cloud
Advise on reporting gaps creating BI publisher reports where requirements cannot be met through out of the box (OOTB)/Oracle Transactional Business Intelligence (OTBI)/OTBI-Enterprise.
Manage a team of Business Analysts and BI Specialists, supporting the wider team.
Work with wider HR team to define functional reporting requirements, agreeing the toolset that will be used to best deliver.
Work with the workstream leads to create functional reporting specs that accurately document required functionality.
Work with implementation partner to define and build custom OBTI and XML reports with Oracle HCM/SCM/FIN cloud
Advise on reporting gaps creating BI publisher reports where requirements cannot be met through out of the box (OOTB)/Oracle Transactional Business Intelligence (OTBI)/OTBI-Enterprise.
Create dashboards and infolets that provide an increased overall end user experience for reporting
Provide guidance to the creation of end user training ensuring that functionality of reports are fully understood when documentation is created.
Support the unit testing and user acceptance testing for Oracle HCM reporting raising/fixing any potential bugs found.
Identify requirements for data that will be held within Business Intelligence Cloud Service (BICs) data warehouse to meet overall people reporting requirements

Essential Job Functions

Develops a thorough understanding of business processes, data sets and clinical knowledge of operations to translate work for report writers.
Collaborate with vendors to gather detailed scope of work and technical specs for extracts.
Add access for additional approved users to existing Power BI reports
Ensure delivered data supports the line of business requirements.
Develops understanding of enterprise data architecture, data platforms and data operations.
Understands data model structures and extract transform and load (ETL) services in relation to business intelligence duties.
Provides hands on technical knowledge and capabilities of the use of Power BI.
Responsible for ensuring the people reporting requirements of the business are met using reporting tools contained within Oracle ERP/ HCM/ SCM Cloud.
Supports environment change management control by complying with change management standards for data needs and approvals.
Supports the organization and sourcing of data for business intelligence initiatives from approved data sources to support and enable strong enterprise data management standards.
Provides ongoing support for developed business intelligence solutions inclusive of reports, visual analytics and limited data model development.
Operates in a coordinated manner with the Director of Organization Effectiveness and Productivity and the Business Intelligence Developers team.
Builds rapport and an understanding with the Executive team, Site Leaders, Service Line Leaders and team members requiring data needs/ reports
Maintains good punctuality and attendance at work.
Regularly exercises discretion and judgment in the performance of essential job functions.
Consistently views data as a secure asset providing access only to those that must utilize for daily decision making, strategic planning and business initiatives.
Troubleshoot problems and questions from end users to provide daily support.
Collaborate with BID Manager and Dir of Organizational Effectiveness and Productivity to prioritize and assign urgent requests.

Education

Minimum of HS Diploma or GED, Bachelors in Comp Sci, MIS or other technical degrees highly preferred.

Minimum of 2-4 years of experience working as a Reporting Developer using Oracle based technologies.
Minimum 1-3 years’ experience Architect Reporting & Analytics solutions for Oracle ERP cloud
Minimum 1-3 years of Oracle cloud data model knowledge in HCM, finance, and supply chain
Minimum 1-2 year of experience in BI Publisher, OTBI, OAC, and Oracle ADW
Minimum 1-3 years expertise in building Analytics solutions like Tableau or PowerBI.
Expertise in SQL/PLSQL
Fusio Knowledge/experience
Experience running workshops to gather reporting requirements.
Capable of creating complex BI Publisher data models (SQL) and the creation/amendment of BI Publisher templates
Expert user of OBTI & BI Publisher
Capable of design BICs data/schema design
Experience of XML & Java preferred
Understanding and experience of advanced reporting functionality such as bursting and scheduled reports
Experience creating role specific dashboards and Infolets in Oracle HCM/SCM/FIN
Detailed understanding of the Fusion / HCM Cloud security model and its application for reporting purposes
Functional experience of Oracle ERP modules.