Business Intelligence Developer III

Atlantic Health System; United States; On-site; USD 90,000 - 120,000; Full time

Job summary

Atlantic Health System is seeking a Business Intelligence Analyst III to partner with business units to identify analytics needs and translate them into actionable reports and dashboards.

Strong experience in Power BI and OTBI is required, along with collaboration across FIN, HR, SCM and IT teams to deliver data-driven insights and scalable BI solutions.

Qualifications

• Experience defining and building custom reports for business needs.
• Strong knowledge of Power BI and OTBI reporting tools.
• Experience with Oracle ERP/HCM/SCM Cloud reporting.
• Ability to translate business requirements into technical specs.

Responsibilities

• Define and build custom reports to meet business needs.
• Collaborate with HR, FIN, SCM teams to define reporting requirements.
• Create dashboards and infolets to improve end user experience.
• Support testing and user acceptance for BI reports.
• Provide guidance on data requirements for BI Cloud Service data warehouse.

Skills

Power BI

ETL

Oracle OTBI

Reporting

Team leadership

Tools

Power BI

BI Publisher

Oracle OTBI

Job description

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.