Data Analyst Consultant

We are looking for a client-facing Data Analytics Consultant with proven experience working directly with clients to design, build and deliver high-quality data and AI solutions that help Dataloop clients make better decisions, improve efficiency and create long-term business value.

This is not a behind-the-scenes role. The successful candidate will take ownership of client engagements from problem definition through to delivery, acting as a trusted advisor and primary point of contact throughout. You will be expected to engage confidently with stakeholders at all levels, translate business problems into technical solutions, and communicate complex insights in a clear, commercially relevant way.

​

At Dataloop, we help organisations unlock the power of data. We partner with clients to break down data silos, build integrated data ecosystems, automate reporting, and deliver analytics and AI solutions that improve how businesses operate. Our work is grounded in Microsoft technologies, shaped by real business challenges, and delivered with a strong focus on quality, accountability and long-term client partnership .

MAIN OUTCOMES

• Deliver robust, production-ready Azure-based

data solutions that integrate, clean and structure data effectively.

• Build clear, useful and

decision-ready Power BI models and dashboards for client stakeholders.

• Translate client needs into practical

data and AI solutions that solve real operational and reporting challenges.

• Support the delivery of AI-powered workflows and

solutions as part of Dataloop’s growing AI capability.

• Own

delivery across client engagements with professionalism, accountability and attention to quality.

• Contribute

to a consulting environment that values innovation, intellectual honesty, high standards and getting things done.

KEY RESPONSIBILITIES

• Design and build Azure data pipelines from source to clean, modelled, production-ready

datasets using tools such as SQL, Azure Data Factory and Microsoft Fabric.

• Develop Power BI semantic models and dashboards that provide meaningful insight for

executive and operational decision-making.

• Write clean, efficient and reliable DAX, including time intelligence,

row-level security and more advanced measures.

• Work

with structured and messy datasets to consolidate, transform and prepare data for reporting and analytics use.

• Use AI tools and large language models to improve delivery speed and contribute to

AI-powered client solutions.

• Facilitate

client workshops, gather requirements, clarify scope, and translate ambiguous briefs into clear deliverables.

• Take ownership of delivery from solution design through build, testing, stakeholder

feedback and production release.

• Contribute to the development of Dataloop’s AI practice, including testing, refining and

implementing agentic and generative AI solutions.

• Follow

sound engineering practices across Git workflows, documentation, version control and environment promotion.

• Build trusted relationships with clients by working as

an extension of their team and delivering solutions that are accurate, useful and fit for purpose.

Requirements

KNOWLEDGE AND EXPERIENCE

• 1–5 years’ experience in a

data-related role, ideally within a consulting or client-facing environment.

• Strong SQL capability and hands-on

experience with Azure data services, particularly Azure Data Factory, Azure SQL and Microsoft Fabric.

• Proven experience developing Power

BI dashboards, semantic models and dimensional data models.

• Good understanding of DAX and best

practice reporting design.

• Exposure to using AI tools or LLMs

in a practical work context.

• Ability to take ownership, ask

strong questions, and turn broad business problems into tangible solutions.

• Strong communication skills and

the confidence to engage with stakeholders professionally.

• Based

in Cape Town and comfortable working in a hybrid model.

Advantageous:

• Experience with Python, Databricks

or Spark.

• Familiarity with CI/CD practices

for Power BI, including deployment pipelines, PBIP and semantic model versioning.

• Relevant Microsoft certifications

such as PL-300, DP-500 or DP-203.

• Exposure

to building or deploying AI solutions using APIs, agents or prompt engineering approaches.

Benefits

• Exposure to

meaningful, real-world client projects across industries.

• Opportunity to

work across both modern data engineering and practical AI solution delivery.

• A hybrid working

model based in Cape Town.

• A high-trust

environment where people are empowered to take ownership and make an impact.

• The chance to

work in a small, fast-moving team with strong growth momentum.

• Hands-on

experience with Microsoft-backed technologies and modern analytics tooling.

• The

opportunity to grow a genuine, commercially relevant skill set in data, analytics and AI consulting.