Business Intelligence (BI) Analyst

iOCO

Are you a aspiring BI Analyst who thrives on transforming data into meaningful insights and driving smarter business decisions? Do you have the expertise to migrate BI reports and dashboards while ensuring a seamless transition to a new Data Warehouse environment? This is your opportunity to showcase your technical capabilities by supporting existing reporting solutions and developing innovative dashboards that meet evolving business needs. This role is suited to a candidate with strong analytical capabilities, excellent communication skills, and the ability to work independently with minimal supervision.

What you'll do

• Assist with the migration and repointing of existing Power BI dashboards and reports to a new Data Warehouse.
• Collaborate with the BI team to ensure data accuracy, consistency, and performance optimisation during the migration process.
• Analyse business requirements and implement Change Requests (CRs) relating to new dashboards, reports, and enhancements.
• Develop, maintain, and enhance Power BI reporting solutions and visualisations.
• Design and optimise data models to support reporting and analytical requirements.
• Write, troubleshoot, and optimise SQL queries for data extraction, transformation, and reporting.
• Work closely with business stakeholders to understand reporting requirements and deliver actionable insights.
• Perform data validation and quality assurance testing on reports and dashboards.
• Provide support and recommendations to improve reporting processes and BI best practices.

Your Expertise:

• Strong experience with Power BI development and dashboard design.
• Advanced SQL skills, including query writing, optimisation, and data analysis.
• Solid understanding of Data Modelling principles and best practices.
• Experience developing and maintaining management dashboards and operational reports.
• Experience working with Data Warehouses and enterprise reporting environments.
• Strong data analysis and problem-solving capabilities.
• Ability to work independently and with minimal supervision.
• Strong analytical and critical-thinking skills.
• Excellent verbal and written communication skills.
• Strong stakeholder engagement and requirements-gathering abilities.
• Ability to manage multiple priorities and deliver within agreed timelines.
• Previous experience supporting data migration or Data Warehouse implementation projects.
• Experience working within large corporate or enterprise BI environments.
• Exposure to data governance and reporting best practices.

Qualifications

• Relevant Degree or Diploma in Information Systems, Computer Science, Data Analytics, Statistics, or a related field.
• Relevant Microsoft Power BI certifications will be advantageous.

Other information applicable to the opportunity:

• Contract position

• Location: Johannesburg

• Apply