Junior Data Analyst

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). Contact Hire Resolve for your next career-changing move. Our client is offering a highly competitive salary for this role based on experience. Apply for this role today, contact Adrienne Steyn at Hire Resolve on adrienne.steyn@hireresolve.us or on LinkedIn You can also visit the Hire Resolve website: hireresolve.us or email us your CV: itcareers@hireresolve.za.com We will contact you telephonically in 3 days should you be suitable for this vacancy. If you are not suitable, we will put your CV on file and contact you regarding any future vacancies that arise.