Mid-Level Data Analytics Engineer

The role is responsible for designing, developing, and maintaining data solutions. The successful candidate will work closely with business stakeholders, implementation teams, and clients to transform data into meaningful insights and support operational decision-making.

Key responsibilities include:

• Developing and maintaining data pipelines, integrations, and ETL processes.
• Ensuring data quality, accuracy, and integrity across multiple systems.
• Supporting reporting, analytics, and business intelligence requirements.
• Collaborating with clients and internal teams to understand business needs and deliver data-driven
• solutions.
• Troubleshooting data issues and optimizing data processes.
• Assisting with client implementations and ongoing support.
• Technical requirements:
• Strong SQL and data analysis skills.
• Experience with data warehousing, data modelling, and integration processes.
• Exposure to cloud-based data platforms and reporting tools.
• Ability to translate business requirements into technical solutions.

Preferred profile:

• Based in Cape Town.
• Qualification in Cost Accounting, Management Accounting, Finance, or a related field.
• CIMA qualification (completed or in progress) would be highly advantageous.
• Strong commercial and financial acumen with the ability to interpret business performance data.
• Comfortable working at the intersection of finance, analytics, and technology.

Technical Lead: Data Engineer

Our client is looking for a Senior Data Engineer (Azure Data & Microsoft Fabric).
This role is hands-on and requires a true player-coach — someone who can architect solutions, build them, code,
deploy, and engage directly with clients. The successful candidate must be comfortable working across multiple
workstreams simultaneously and driving delivery outcomes through strong technical leadership.
Our client base is largely small to medium-sized businesses, meaning solutions must be fit-for-purpose, scalable, and
cost-optimized. We are looking for someone who understands how to apply best practice without over-engineering —
delivering high-quality solutions that balance value, complexity, and budget.

Primary duties & responsibilities:

  • Provide technical leadership across a delivery team supporting multiple client projects.
  • Design, build, and implement Azure-based modern data platform solutions.
  • Lead and guide Microsoft Fabric implementations, including Lakehouse, Warehouse, OneLake, Pipelines,
  • Dataflows Gen2, Notebooks, and semantic models.
  • Work directly with clients to understand business requirements and translate them into sprint deliverables.
  • Support sprint planning, backlog refinement, estimation, and delivery execution.
  • Define and improve delivery standards, engineering frameworks, and best practices.
  • Provide technical mentorship and uplift junior engineers through coaching and hands-on support.
  • Drive DevOps and automation best practices across environments and projects.
  • Act as a technical escalation point for complex delivery and troubleshooting issues.
  • Contribute to continuous improvement of the team’s “way of work” and operating model.

Data Integration & API Responsibilities:
A key component of this role is strong capability in integrating data from multiple business systems, including SaaS
platforms and on-premise databases.

  • Design and implement robust ingestion and integration patterns.
  • Build and support API-based integrations (REST/JSON) between business applications and the Azure/Fabric
  • platform.
  • Integrate systems such as Xero, Sage, SQL databases, ERP systems, CRM platforms, and other third-party
  • applications.
  • Implement authentication patterns such as OAuth2, API keys, service principals, managed identities, and secure
  • credential storage.
  • Implement monitoring, logging, error handling, retry logic, and data validation for integrations.

Required skills & experience:

  • Strong delivery ownership and accountability mindset.
  • Comfortable working in ambiguity and guiding clients who don’t fully know their requirements upfront.
  • Able to balance best practice with practical execution and cost realities.
  • Strong ability to context switch between multiple clients and priorities.
  • Able to build scalable solutions without unnecessary complexity.
  • Hands-on, proactive, and willing to get involved at engineering level.
  • Strong experience in Microsoft Azure Data technologies, including:
  • Azure Data Factory / Fabric Pipelines
  • ADLS Gen2 / Azure Storage
  • Azure SQL / SQL Server / SQL MI
  • Azure Key Vault, Managed Identity, RBAC
  • Strong experience with Microsoft Fabric architecture and implementation.
  • Strong SQL and data modelling capability.
  • Strong ETL/ELT architecture experience and implementation capability.
  • Strong understanding of security, governance, and environment design.
  • Strong understanding of Azure cost drivers, optimization approaches, and cost-conscious architecture.
  • Proven experience working with DevOps methodologies and tooling, including:
  • Git workflows and branching strategiesCI/CD pipelines
  • Deployment automation
  • Release governance and environment control
  • Infrastructure as Code (Bicep / Terraform) is advantageous.

Required qualifications & experience:

  • 5+ years’ experience in data engineering
  • Degree in data or IT related field
  • Microsoft Azure and data certifications highly preferred, such as:
  • Azure Solutions Architect Expert
  • Azure Data Engineer Associate
  • Fabric Analytics Engineer Associate

NON NEGOTIALBE: Must have exp with Databricks and Data Fabric. Must have exp taking things from
on-prem to cloud

Behavioural Competencies:

  • Delivery-focused and accountable.
  • Proactive and willing to step in where needed.
  • Comfortable with ambiguity and iterative scope definition.
  • Strong team leader — willing to lead and support others and contribute to overall success.
  • Comfortable working in and leading a sprint-based agile delivery model.
  • Able to deliver with evolving requirements and changing priorities.
  • Strong ability to context switch between clients and projects.
  • Strong communication skills and ability to engage directly with clients when required.
  • Comfortable defining scope iteratively with clients and aligning sprint outcomes to evolving requirements.

Senior Data Engineer

Our client is looking for an experienced Data Engineer to help design, build, and optimise
data platforms that enable powerful insights and better decision-making. You will work with modern Azure data
technologies, building scalable data pipelines and data warehouses that support advanced analytics and visualisation
through Power BI and Tableau. If you enjoy solving complex data challenges and turning raw data into meaningful
insights, we would love to hear from you.

Primary duties & responsibilities:

  • Designing and building data pipelines and ETL processes using Azure Data Factory and SQL.
  • Developing and maintaining data warehouses and data models (relational and star schema).
  • Integrating data from multiple sources and ensuring data quality, governance, and security.
  • Designing and implementing data integration solutions using Azure Synapse, Azure SQL, Data Lake and/or
  • Databricks.
  • Monitoring and optimising data pipelines and integration processes.
  • Supporting and maintaining existing data environments and BI platforms.
  • Collaborating with stakeholders to understand business requirements and translate them into data solutions.
  • Supporting the development of Power BI or Tableau dashboards and reporting solutions.
  • Troubleshooting technical and data issues and improving overall data platform performance.

Required skills & experience:

  • 4–7 years’ experience in a Data Engineering, BI, or data warehouse environment.
  • Strong understanding of data warehousing and data modelling concepts.
  • Azure Data Factory
  • Azure SQL / SQL Server
  • Azure Synapse Analytics
  • Azure Data Lake / Storage Accounts
  • Databricks (advantageous)Strong SQL development skills using SSMS and Visual Studio.
  • Experience working in Agile environments.
  • Exposure to Power BI and/or Tableau.

NON NEGOTIALBE: Must have exp with Databricks and Data Fabric. Must have exp taking things from on-
prem to cloud.

What Makes You Successful:
You are someone who:

  • Thinks analytically and enjoys solving complex data challenges.
  • Can translate business needs into technical data solutions.
  • Communicates clearly with both technical and business stakeholders.
  • Takes ownership and manages priorities effectively.
  • Continuously learns and adapts in a fast-moving data environment.

Mild-Level Data Engineer

Primary Duties and Responsibilities: 

The Data Engineer will have a knack for data analysis, data manipulation and data modelling. The consultant will be responsible for understanding and driving the overall technical vision and planning of a client’s organisation and translating business needs into technical strategy.

 

Required Qualifications:

  • Tertiary degree, diploma or certificate in a related field (BSc Computer Science, B.IT or Informatics related degrees).
  • DP-203: Data Engineering on Microsoft Azure Certification.

Experience and Knowledge:

  • 5- 8years’ working experience as a Data Engineer / Database Developer.
  • Experience in data mining, large scale data modelling and business requirements gathering/analysis.
  • Understanding and working experience in data integration and transformation.
  • Experience implementing data modelling methodologies like Dimensional Modeling and / or Data Vault.
  • Working knowledge of data quality processes and master data management.
  • Experience implementing design support systems using Database Management Systems (DBMS) such as SQL Server or Oracle.
  • Proficiency in designing and implementing data integration and ETL solutions using SSIS, Azure Data Factory and / or SQL Server stored procedures.
  • Understanding of several Big Data technologies like Hadoop, MapReduce and Spark as well as event processing or message ingestion services like Kafka, Event Hub and Stream Analytics.
  • Experience in database query languages such as T-SQL, ANSI SQL, PL/SQL.
  • Some experience developing software solutions using Visual Basic, C++, C#, Java or Python.
  • Experience using SQL Server management Studio and Visual Studio.
  • Experience implementing solutions using Azure SQL databases, Azure Synapse (Previously SQL Data Warehouse), Azure Storage Accounts (Data Lake) and / or Databricks.
  • Analytical mind and business acumen
  • Additional skills in the following will be taken into consideration: Tableau, Power BI, strong math skills (e.g. statistics, algebra), Scala, Python or R.

 

Key Responsibilities:

  • Identify valuable data sources and automate collection processes.
  • Undertake preprocessing of structured and unstructured data.
  • Analyze large amounts of information to discover trends and patterns.
  • Data Modelling (Relational and Star Schema).
  • Database design.
  • Database development.
  • Data Warehouse Design – Build and Development.
  • Database Administration.
  • Database Performance Tuning and Optimisation.
  • Present information using data visualization techniques.
  • Propose solutions and strategies to business challenges.
  • Collaborate with engineering and product development teams.
  • An understanding and hands on experience on Hadoop/Spark based distributed storage and computing frameworks.
  • Real-Time analytics and batch processing.
  • Strong experience in architecting analytical applications in cloud environment such as Amazon Web Services and Microsoft Azure.

 

Competencies: 

  • Critical Thinking: Using logic and reasoning to identify the strengths and weaknesses of alternative solutions, conclusions or approaches to problems.
  • Active Learning: Understanding the implications of new information for both current and future problem-solving and decision-making.
  • Systems Analysis: Determining how a system should work and how changes in conditions, operations, and the environment will affect outcomes.
  • Complex Problem Solving: Identifying complex problems and reviewing related information to develop and evaluate options and implement solutions.
  • Deductive Reasoning: The ability to apply general rules to specific problems to produce answers that make sense.
  • Inductive Reasoning: The ability to combine pieces of information to form general rules or conclusions (includes finding a relationship among seemingly unrelated events).
  • Excellent communication skills: Ability to engage with C-level stakeholders, both verbal and non-verbal and communicate a deep understanding of the business and a broad knowledge of technology and applications.
  • Technical Literacy: Possess a high level of technical literacy, which helps them determine how a software solution fits into an organization’s current structure and assists in the development of specifications and requirements.
  • Analytical Assessment: A high level of analysis to examine current systems and determine overall project needs and scope.
  • Schedule Management: Extensive time management skills to determine development schedules and milestones and ensure that deliverables are completed on time for oneself and your team.
  • Team Leadership: To oversee and direct development teams throughout the project development lifecycle, experience with team leadership and motivation is essential.
  • Ability to translate strategy and strategic objectives into measurable and executable projects.
  • Experience working on large project(s) incorporating processes and procedures and standards