Job Description

Business Intelligence Developer III Oracle Specific

Position Overview

The Business Intelligence Developer interacts with the business to identify goals and needs for data and analytics needs. The BI developer will then write down the requirements and communicate them directly to the BI team or a solutions developer and deliver the solutions to the business.

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.

Oracle Certified/ Oracle Training/ Oracle reporting experience required

Qualifications

Oracle Certification preferred

Oracle reporting experience

Qualifications/ Education:

• 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
• 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.

About Us

About the Team

Atlantic Health System is at the forefront of medicine, setting standards for quality health care powered by a workforce of more than 18,000 team members and 4,800 affiliated physicians dedicated to building healthier communities, the system offers more than 400 sites of care, including eight award-winning medical centers. Specializing in cardiovascular care, cancer care, orthopedics, neuroscience, pediatrics, women's health and rehabilitation medicine. Atlantic Medical Group, comprised of 1,000 physicians and advanced practice providers, represents one of the largest multi-specialty practices in New Jersey and includes finance, legal, marketing, human resources, talent acquisition, ISS and more. Caring for our patients, our team members and the communities we serve is our central mission.