Recruitment Room Team

Junior Data Analyst

Cape Town, Western Cape
3 hours ago
Apply Now
Deadline date:

Job Description


A Cape Town based data analytics and consulting team of engineers and data scientists building Azure-first solutions across multiple industries is seeking Junior Data Analysts to join their team.

Responsibilities: 

  • Wrangle data on Azure: organise, clean, and consolidate messy sources using Azure SQL, Data Factory and Fabric; and sensible data models (star schema).

  • Design end-to-end flows: from ingestion to semantic model to Power BI dashboards that business users can actually use.

  • Build robust calculations: model relationships and write clean DAX (incl. RLS, time intelligence, performance-aware measures).

  • Apply analytics: use statistics/predictive methods where they move the needle; validate results with clear checks.

  • Own delivery: gather requirements, run workshops, iterate fast, document decisions, and deploy to prod.

  • Work flexibly: hybrid structure; travel to client sites when it helps (plant walkthroughs, commissioning, training).

Minimum Requirements: 

  • Bachelor’s degree or equivalent experience.

  • Track record delivering BI solutions in consulting or internal BI.

  • 2+ years in BI/analytics with Power BI + DAX + SQL as core tools.

  • Real exposure to Azure data services (Data Factory/Fabric/ Azure SQL).

  • Solid dimensional modelling (facts/dimensions, relationships, incremental refresh basics).

  • Can troubleshoot across pipeline → model → report (perf issues, data quality, calc errors).

  • Stakeholder skills: translate vague asks into concrete backlog items and shipped dashboards.

  • Git-based workflow (branches, PRs) and basic promotion (Dev/Test/Prod).

  • Databricks/Spark/Delta, Python for data prep/validation.

  • CI/CD for Power BI (Deployment Pipelines, PBIP, semantic-model versioning).

  • PL-300 / DP-500 / DP-203 (Microsoft Certifications).

Benefits:

  • Competitive salary based on experience (salary can potentially be more based on experience/skills)

IF you meet the above requirements and want to make a career-changing move, apply today by emailing your CV to [email protected]