Senior Data Analyst / Engineer

Blue Pearl PTY LTD; Johannesburg; Hybrid; ZAR 1,339,000 - 2,009,000; Part time

Job summary

Blue Pearl PTY LTD seeks a Senior Data Analyst/Engineer to stabilize and enhance a tactical reporting solution within a healthcare data environment, transitioning toward Power BI. The role blends data analysis, BI development, and data engineering to reduce manual work and fix data issues during go-live and early production cycles.

The ideal candidate will own Oracle-driven data profiling, advanced SQL, and report automation, while engaging with business users and delivering robust validation

Qualifications

• Must have strong experience with Oracle Database.
• Experience with Advanced SQL is required.
• Proficient in Power BI and report development.
• Experience with data analysis and profiling.
• Ability to perform data validation and reconciliation.
• Ability to perform business requirements analysis.
• Experience with User Acceptance Testing (UAT).
• Experience with quality assurance and testing.
• Ability to automate reporting.
• Experience with production reporting support.

Responsibilities

• Stabilize and improve the tactical reporting solution post go-live.
• Reduce manual data preparation and reporting effort.
• Resolve operational data issues and improve reporting processes.
• Support initial production reporting cycles and fix gaps.
• Maintain stability during transition to future-state MVP.
• Collaborate with business users to translate requirements into technical solutions.
• Document data flows, controls and reporting processes.
• Support Power BI transition and automation initiatives.

Skills

Data analysis

Profiling

Report development

Data validation

UAT

QA & testing

Automation of reporting

Business requirements analysis

Power BI

SQL

Oracle

Tools

Oracle Database

Power BI

Advanced SQL

Job description

We are seeking a Senior Data Analyst / Engineer to support a post-go-live tactical reporting solution within a healthcare and medical scheme administration environment.

This is a hybrid Data Analyst, BI Developer and Data Engineer role, requiring someone who is equally comfortable working with data, developing reports, troubleshooting operational issues and engaging directly with business users.

The role will focus on stabilizing and enhancing the tactical reporting solution, reducing manual effort, resolving data and reporting issues, and supporting the organization through its initial production reporting cycles while the future-state MVP is being delivered.

The environment contains POPIA-sensitive health data and is currently operating on a legacy Oracle estate, with a transition toward Power BI.

Contract & Location

• Position: Senior Data Analyst / Engineer
  
• Contract: 3 months
  
• Start Date: 1 October 2026
  
• Work Model: Hybrid
  
• Location: Waterfall / Midrand / Johannesburg
  

Requirements

Core Technology Requirements

The successful candidate should have strong experience with:

• Oracle Database
  
• Advanced SQL
  
• Power BI
  
• Data analysis and profiling
  
• Report development
  
• Data validation and reconciliation
  
• Business requirements analysis
  
• User acceptance testing (UAT)
  
• Quality assurance and testing
  
• Report automation
  
• Production reporting support
  

Role Summary

The Senior Data Analyst / Engineer will be responsible for stabilizing and improving the tactical reporting solution following go-live.

The role will focus on reducing manual effort, resolving operational and data issues, improving reporting processes and supporting the first production reporting cycles.

The successful candidate will effectively hold the tactical reporting solution together until the future-state MVP is delivered, while identifying opportunities to automate, simplify and improve the existing environment.

Key Responsibilities

Data Analysis & Investigation

• Analyse existing reporting processes and operational workflows.
  
• Profile and assess data to identify inconsistencies, gaps and quality issues.
  
• Investigate reporting and data discrepancies.
  
• Perform detailed root-cause analysis and implement appropriate resolutions.
  
• Validate data across source systems and reporting outputs.
  

Reporting & BI Development

• Develop, enhance and maintain operational reports.
  
• Refine existing reports to improve accuracy, usability and performance.
  
• Support the transition of reporting capabilities toward Power BI.
  
• Translate business requirements into practical reporting and data solutions.
  

Automation & Process Improvement

• Identify opportunities to reduce manual data preparation and reporting activities.
  
• Automate repetitive reporting and data processes.
  
• Implement validation and reconciliation controls.
  
• Simplify operational reporting processes and improve efficiency.
  

Production Support

• Support initial production reporting cycles following go-live.
  
• Investigate and resolve operational reporting issues.
  
• Address remaining functional, data and reporting gaps.
  
• Ensure reporting remains stable and reliable during the transition to the future-state solution.
  

Business Engagement & UAT

• Work directly with business users to understand reporting requirements.
  
• Facilitate and support UAT and business validation.
  
• Work with stakeholders to confirm data accuracy and report outputs.
  
• Transfer knowledge and support Medscheme staff in using and maintaining the solution.
  

Documentation

• Document the tactical reporting solution, processes and key data flows.
  
• Capture outstanding gaps, issues and recommended enhancements.
  
• Provide documentation to support the transition toward the future-state MVP.
  

Candidate Profile

The ideal candidate will be:

• A senior-level professional with strong Data Analyst, BI Developer and Data Engineering capabilities.
  
• Comfortable operating across multiple disciplines within a single role.
  
• Self-sufficient and capable of delivering with minimal oversight.
  
• Strong in Oracle and SQL.
  
• Experienced in Power BI and report development.
  
• Highly analytical with strong troubleshooting and root-cause analysis skills.
  
• Experienced in data reconciliation, validation and quality assurance.
  
• Comfortable working directly with business users and technical teams.
  
• Able to translate business requirements into practical technical solutions.
  
• Experienced in automating manual reporting and data processes.
  
• Comfortable working in a fast-paced, operational environment.
  
• Outcome-focused rather than activity-focused.
  
• Comfortable working with regulated and POPIA-sensitive healthcare data.
  

Key Deliverables

The successful candidate will be expected to deliver:

• A stabilized tactical reporting solution.
  
• Reduced manual effort across reporting and data preparation.
  
• Automated validation and reconciliation controls.
  
• Improved reporting accuracy and quality.
  
• Successful support of initial production reporting cycles.
  
• Resolution of outstanding functional, data and reporting gaps.
  
• Improved operational reporting processes.
  
• Comprehensive documentation of the current solution.
  
• Clearly documented future enhancements and recommendations.
  
• Support for the transition toward the future-state Power BI reporting environment.