You will be part of the Data Science & Analytics team, supporting departments across the business by transforming raw data into meaningful insights. You will play a hands-on role in building SQL data models, designing user-friendly dashboards in Power BI, and automating data workflows to ensure timely, accurate, and actionable reporting.
Main responsibilities
Business Intelligence & Analytics
Design clear and intuitive Power BI dashboards for teams across sales, operations, and executive leadership.
Develop reusable data models and DAX measures to enable self-service insights and scalable reporting.
Translate business questions into data-driven visual stories that support better decision-making.
Data Engineering & SQL
Write clean, efficient SQL queries to extract and prepare data from multiple sources.
Optimise stored procedures, views, and data transformations for clarity and performance.
Build and maintain lightweight, reproducible data pipelines using Python and/or Databricks.
Automation & Workflow Optimisation
Develop scripts to automate ETL, reporting refreshes, or data quality checks using Python (pandas, SQLAlchemy, or PySpark).
Use Git for version control and deploy code using basic CI/CD pipelines when needed.
Documentation & Quality Assurance
Document dashboards, datasets, and SQL logic for transparency and maintainability.
Write tests to validate critical SQL queries or Python code and reduce the risk of data errors.
Collaboration
Work closely with senior data scientists, analysts, and business owners to clarify requirements and deliver value quickly.
Proactively identify and raise data quality issues -- and suggest practical solutions rather than short-term fixes.
Minimum requirements
Qualifications & Technical Skills
A Bachelor's Degree in Mathematics, Statistics, Computer Science, Engineering, Biology, or equivalent experience
Strong SQL skills -- including data modelling, query optimisation, and advanced joins/window functions
Power BI expertise -- from semantic model design to interactive dashboard creation (Desktop & Service)
Python proficiency -- especially using pandas for data manipulation and SQL integration
Comfortable with Git (GitHub, GitLab, or Azure Repos) and basic command-line tools
Experience working across Windows and Linux environments
Nice to Have
Familiarity with dbt, Delta Lake, or Databricks
CI/CD workflows for Power BI using tools like Azure DevOps or GitHub Actions
Exposure to high-volume transactional domains such as insurance
Experience with cloud data platforms (e.g., Azure SQL, AWS RDS, or Google BigQuery)
Basic understanding of Docker or containerised deployments
MNCJobs.co.za will not be responsible for any payment made to a third-party. All Terms of Use are applicable.