Developer - Reporting and BI

ENGINEERINGUK; Cape Town; On-site; ZAR 30 000 - 70 000; Full time

Job summary

An established industry player is seeking a talented individual to join their growing digital centre of excellence in Cape Town. This role offers a unique opportunity to collaborate with a professional team, enhancing project delivery through innovative digital tools and data-driven decision-making. As part of a dynamic environment, you will have the chance to develop your technical skills while working with cutting-edge technologies like Power BI and the Microsoft Power Platform. If you are passionate about data analytics and eager to contribute to transformative projects, this position is perfect for you.

Qualifications

• Experience in consultancy and stakeholder management.
• Knowledge of data security and role-based permissions.

Responsibilities

• Create effective visual layers for impactful UI/UX.
• Use DAX to create context-based measures.
• Work with Power BI and support tools.

Skills

ETL processes

DAX

Data structure knowledge

Python

SQL

Power BI

Data analytics

Tools

Power BI

Microsoft Power Platform

SharePoint

Teams

Job description

Job Description

You will need to login before you can apply for a job.

Position status: We are growing our team in 2025. Please get in touch if you would like to hear about working with Mace.

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, especially 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:

• 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.

Responsibilities

• Create effective visual layers, using techniques such as bookmarks, tooltips, and drill-through to provide an impactful UI/UX.
• Understand effective visual layering and select appropriate visuals for the information displayed.
• Proficient with ETL processes, creating efficient queries following good query hygiene principles.
• Structure data appropriately for reporting, loading only necessary fields and records.
• Use basic DAX, including the calculate() function, to create context-based measures.
• Have working knowledge of star and snowflake schemas, relationships, and query joins.
• Understand fact and dimension tables, normalization concepts, and their application to real-world data sets.
• Be capable of creating a functional semantic model independently.
• Work with Microsoft's Power Platform suite, primarily Power BI, and support tools like SharePoint, Teams, and the Office suite. Opportunities exist to grow into other Power Platform applications such as Power Apps, Power Automate, and Fabric.
• Knowledge or experience with BI & data analytics software and languages like Python, JSON, R, JavaScript, SQL, etc., is beneficial but not required.

Minimum Requirements

• Knowledge of good data structure and development processes.
• Awareness of data security and role-based permissions.
• Understanding of Power BI capabilities and supporting tools, with the ability to recommend suitable tools.
• Experience working in a consultancy environment and managing stakeholders, including clients, project managers, and data owners.

Additional Qualities

• Ability to work collaboratively as part of a team.
• Willingness to share knowledge and support others' development.
• Excellent written and spoken communication skills in English, with strong presentation skills.
• Commitment to inclusive working practices.
• Aptitude for problem-solving.
• Good interpersonal skills.

Mace is an inclusive employer and welcomes candidates from diverse backgrounds. Even if you do not meet all criteria, please apply as you may be the best fit for this or other roles within our organization.

Please remember the Employee Referral Scheme. If you know talented individuals, use the 'Refer a friend' feature within the relevant job posting.

Create a job alert to receive personalized job recommendations directly to your inbox.