Junior Data Analyst at Hire Resolve

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).