Job Description

At Mace, our purpose is to redefine the boundaries of ambition. We believe in creating places that are responsible, bringing transformative impact to our people, communities, and societies across the globe. To learn more about our purpose, culture, and priorities, visit our strategy site.



Within our consult business we harness our unique combination of leading-edge practical expertise and project delivery consultancy to unlock the potential in every project.



The project:



This is an opportunity to work with a professional team in South Africa.



Our growing digital centre of excellence team is responsible for enabling and enhancing project delivery through the development of digital tools, processes and reports that enable data-driven decision making.

As part of your role, you will interface with the Mace project team and occasionally stakeholders from other organisations, if working on a joint venture project or directly for a client. You will be part of the digital centre of excellence community, sharing knowledge and experience with other bi & data professionals. This is an excellent opportunity to learn from experienced practitioners and further develop your technical skill set.



Our values shape the way we consult and define the people we want to join us on our journey, they are:


Safety first - Going home safe and well. Client focus - Deliver on our promise. Integrity - Always do the right thing. Create opportunity - For our people to excel.

You'll be responsible for:


Identify the best method for extracting data from source systems on a case-by-case basis. Understand, and be able to draw on, effective use of tools such as Notebooks, Dataflow Gen2 and PowerShell. Manage credentials, including service accounts and interfaces with Azure Key Vault, to ensure connections are made in the most secure way. Build integrations with appropriate error handling and business logic to ensure there is no corruption, omission or duplication of ingested data. Apply the fundamentals of data transformation (such as cleaning and optimising structure of data into fact and dimension tables) using data factory and/or supporting tools. Ensure data brought into the data platform meets the needs of downstream users, including the BI development team. Store and transform data using a medallion architecture, drawing on lake house and warehouse assets as appropriate. Oversee the operation and maintenance of daily and periodic pipelines, optimising efficiency and proactively resolving issues when they occur. You will be expected to work with Microsoft's fabric platform, principally within the data engineering and data warehousing workflows. There is opportunity to explore and grow your skill set into other elements of the platform, such as data science, as well as horizontally into Power Platform applications such as Power BI, Power Apps and Power Automate, should you choose to. A good working knowledge of Microsoft's productivity suite, including SharePoint, Teams and Office 365, is essential. A foundational understanding of SQL language is a requirement of the role. Any experience of supporting BI & data analytics software and languages such as Python, JSON, R, etc. would be a benefit but is not a requirement.

You'll need to have:


The ability to work collaboratively as part of a team. A willingness to share knowledge and support the development of others. Excellent written and oral communication skills (in English) and presentational skills. A commitment to working inclusively. An aptitude for problem-solving. Good interpersonal skills.

You'll also have:


Working in a client-facing development role requires a high degree of interaction with colleagues, both from technical and non-technical backgrounds, so the ability to work well with others and maintain open channels of communication is essential.
Mace is an inclusive employer and welcomes interest from a diverse range of candidates. Even if you feel you do not fulfil all the criteria, please apply as you may still be the best candidate for this role or another role within our organisation.



#LI-Onsite