Junior Data Analyst at Hire Resolve

Job Description

• A leading Cape Town-based data analytics and consulting firm is seeking Junior Data Analysts to join their team in a hybrid capacity. This is a fantastic opportunity for an aspiring and data-passionate professional to contribute to building Azure-first data solutions and Power BI reporting for clients across various industries. You’ll be instrumental in wrestling data into shape using Azure SQL, Data Factory, and Fabric; designing end-to-end data flows; and building robust, performance-aware DAX calculations for Power BI dashboards. If you have 1-2 years of experience or are a recent graduate eager to develop your skills in BI and cloud data services, and possess an openness to growth and a structured approach to problem-solving, we want to hear from you!

Responsibilities:

• Clean, consolidate, and structure data using cloud services like Azure SQL, Data Factory, and Fabric to build robust star schemas.
• Apply solid dimensional modelling (facts, dimensions, relationships, incremental refresh basics).
• Design and implement the full data flow from ingestion to the final semantic model that powers reporting.
• Develop precise, high-performance measures using DAX, including RLS and time intelligence.
• Incorporate and validate statistical or predictive methods as needed.
• Diagnose and resolve issues across the entire pipeline (performance, data quality, and calculation errors).
• Translate vague business needs into concrete backlog items and deliver functional dashboards.
• Own the delivery process: gather requirements, lead workshops, document decisions, and deploy successfully to production.
• Follow a Git-based workflow (branches, PRs) for code promotion (Dev/Test/Prod).
• Work flexibly in a hybrid environment, including occasional travel to client sites for commissioning or process walkthroughs.

Requirements:

• 2+ years in BI/analytics using Power BI, DAX, and SQL as core tools.
• Real exposure to Azure data services (Data Factory/Fabric/Azure SQL).
• Solid dimensional modelling including facts, dimensions, relationships, and incremental refresh basics.
• Ability to troubleshoot the full pipeline (performance, data quality, and calculation errors).
• Skills to translate vague stakeholder requests into concrete backlog items and ship dashboards.
• Experience with a Git-based workflow (branches, PRs) and basic promotion (Dev/Test/Prod).
• Experience with Databricks/Spark or Python for data preparation/validation.
• Familiarity with CI/CD for Power BI (Deployment Pipelines, PBIP, semantic-model versioning).
• Relevant Microsoft certifications (PL-300 / DP-500 / DP-203).