Data Analytics / Power BI Developer w / M365

AECOM; Cape Town; Hybrid; ZAR 600 000 - 800 000; Full time

Job summary

A global infrastructure firm in Cape Town is seeking a Data Analytics / Power BI Developer to drive innovative solutions using Microsoft Power Platform. This full-time role includes building Canvas Power Apps and Power BI reports. The ideal candidate will have a Bachelor's degree and 3 years of hands-on experience with Power BI, supporting both client and business needs while working collaboratively within a dedicated team.

Benefits

Comprehensive benefits package

Flexible work options

Career development programs

Qualifications

• 3 years experience in industry.
• Hands-on experience with Power BI Desktop.
• Experience in connecting Power BI to various data sources.

Responsibilities

• Build Canvas Power Apps and Model-Driven Power Apps.
• Design & implement Dataverse databases within the Power Platform.
• Build data models harnessing PowerBI.

Skills

Power BI

Microsoft Power Platform

DAX

Data Modeling

SQL

Power Query

Education

Bachelor's degree in computer science

Microsoft accreditation

Tools

Power BI Desktop

Power Automate

Azure services

Job description

Here you will have the freedom to grow in a world of opportunity

AECOM has an exciting opportunity for a Data Analytics / Power BI Developer w / M365. This position offers a hybrid work schedule and will be in one of our Enterprise Capabilities Centers in South Africa.

Our clients count on us to think without limits. By harnessing the power of digital technology and innovation and connecting our technical experts and visionaries around the world we deliver tailored solutions and transformative outcomes for our clients and the communities they serve.

The successful candidate will be joining the Data and Analytics team within the Europe region. You will report directly to the Data and Analytics team lead and assist with developing Microsoft Power Platform solutions. Your primary focus will be building Canvas Power Apps and PowerBI reports according to defined standards working together with Power Platform Lead to demonstrate the art of the possible and elevate the adoption of Power Platform solutions.

To ensure success as the Power Apps Developer you should have a strong working knowledge of Power Platform and all the related elements including Canvas Power Apps Model-Driven Power Apps Dataverse Power Automate Power BI Power Portals and Microsoft 365 services.

Responsibilities

• Build Canvas Power Apps and Model-Driven Power Apps to meet requirements of clients and business
• Design & implement Dataverse databases within the Power Platform
• Build data models harnessing PowerBI with insightful visualization layer on top
• Support team and organisation in growing capability with Power Platform
• Identify and solve business problems with the Power Platform and low code / no code solutioning
• Utilize problem‑solving skills to understand and troubleshoot established Power Platform solutions as challenges arise
• Support and work together with wider digital organisation such as Data Analysts and Data Scientists to provide holistic digital solutions
• Collect and evaluate requirements from users and stakeholders for solution development
• Illustrate delivery cadence through regular engagement with end stakeholders both internally and externally
• Work with our UX Designer and Power Platform Lead to ensure best in class solution development
• Design solutions both independently and with UX Designer
• Be able to provide estimates for pipeline work
• Build Flows & Robotic Process Automations (RPA) within Power Automate
• Build chatbots using Power Virtual Agent
• Build external‑facing portals using Power Portals
• Incorporating feedback into your development process
• Testing work against the requirements and acceptance criteria

About Enterprise Capabilities

Enterprise Capabilities is a service‑led organization within AECOM enabling access to a global talent pool. With offices in China India Philippines Poland Romania South Africa and Spain our teams of technical professionals provide around the clock project support helping AECOM teams around the world to deliver faster smarter and better. Enterprise Capabilities supports AECOMs ability to work as one global team by standardizing design processes deploying collaboration technologies and utilizing a connected network of technical expertise. By joining Enterprise Capabilities you have the unique opportunity to work on AECOMs monumental projects located around the world contributing to our purpose of delivering a better world.

Qualifications: MINIMUM REQUIREMENTS

• Bachelors degree in computer science and (or) Microsoft accreditation
• 3 years experience in industry
• Hands‑on experience with Power BI Desktop
• Familiarity with Power BI Service (publishing & sharing reports)
• Basic knowledge of DAX (Data Analysis Expressions)
• Experience in connecting Power BI to various data sources (Excel SQL Server SharePoint etc.)
• Ability to create and customize visuals charts and slicers
• Understanding of data modeling (relationships calculated columns / measures)
• Experience in building dashboards and interactive reports
• Knowledge of filters slicers and drill‑through capabilities
• Experience with data transformation using Power Query
• Exposure to scheduled refresh and Power BI Gateway (optional but good to have)
• Experience in real‑world Power BI projects (domain doesnt matter)
• Basic understanding of security / sharing (Row‑Level Security is a plus)
• Good communication skills to understand reporting requirements

PREFERRED QUALIFICATIONS

• A portfolio & history of previous Power Platform / web development work
• Exposure to Azure services
• Experience and of basic coding languages including Python C# HTML5 and JavaScript
• Experience working with different types of API including OAuth

Additional Information

About AECOM

AECOM is proud to offer comprehensive benefits to meet the diverse needs of our employees. Depending on your employment status AECOM benefits may include medical dental vision life AD&D disability benefits paid time off leaves of absences voluntary benefits perks flexible work optionswell-being resources employee assistance program business travel insurance service recognition awards retirement savings plan and employee stock purchase plan.

AECOM is the global infrastructure leader committed to delivering a better world. As a trusted professional services firm powered by deep technical abilities we solve our clients complex challenges in water environment energy transportation and buildings. Our teams partner with public- and private‑sector clients to create innovative sustainable and resilient solutions throughout the project lifecycle from advisory planning design and engineering to program and construction management. AECOM is a Fortune 500 firm that had revenue of $16.1 billion in fiscal year 2024. Learn more at .

What makes AECOM a great place to work

You will be part of a global team that champions your growth and career ambitions. Work on groundbreaking projects - both in your local community and on a global scale - that are transforming our industry and shaping the future. With cutting‑edge technology and a network of experts youll have the resources to make a real impact. Our award‑winning training and development programs are designed to expand your technical expertise and leadership skills helping you build the career youve always envisioned. Here youll find a welcoming workplace built on respect collaboration and community - where you have the freedom to grow in a world of opportunity.

As an Equal Opportunity Employer we believe in your potential and are here to help you achieve it. All your information will be kept confidential according to EEO guidelines.

Remote Work

Remote Work : No

Employment Type

Employment Type : Full-time

Key Skills

Business Intelligence,Cognos,SQL,Power BI,QlikView,Microsoft SQL Server,ssrs,Tableau,SSIS,T Sql,Data Modeling,Data Warehouse

Experience

Experience : years

Vacancy

Vacancy : 1