Business Intelligence Developer III

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.
  
  Certifications:
  
  Preferred: Oracle Certified/ Oracle Training/ Oracle reporting experience