Senior BI Architect: Data Warehousing & Dashboards

ATS Client; Johannesburg; On-site; ZAR 600,000 - 1,000,000; Full time

Job summary

ATS Client is seeking a Senior Business Intelligence Developer to design, build, and maintain BI solutions that deliver actionable insights. You will translate business requirements into technical specs and deploy data warehouse models, dashboards, and reports across cloud platforms.

The role requires strong experience in ETL, dimensional modeling, and modern BI tools such as Power BI and Azure Synapse. Independent work with cross‑functional collaboration will be essential.

Qualifications

• Bachelor's degree in Computer Science, Informatics, or related field.
• Microsoft BI certifications (MCSA, MCSE, Azure Data Engineer) preferred.
• Strong experience in data warehousing, ETL processes, and dimensional modeling.
• Proficiency in BI tools and technologies, including Power BI, Microsoft Fabric, Azure Synapse, SQL/T‑SQL, Python, DAX, and cloud‑based data solutions.
• Familiarity with ERP, CRM, and other business applications.
• Ability to gather requirements from stakeholders and implement solutions independently.

Responsibilities

• Translate business requirements into technical specifications.
• Design, develop, and deploy data warehouse models, dashboards, and reports.
• Evaluate and enhance existing BI systems and analytics platforms.
• Collaborate with teams to integrate systems and streamline processes.
• Write and execute database queries, conduct analyses, and troubleshoot issues.
• Maintain documentation and provide client data support.

Skills

Analytical thinking

Requirements gathering

Independent contributor

Cloud architectures

BI visualization

Education

Bachelor's degree

Tools

Power BI

Microsoft Fabric

Azure Synapse

SQL/T-SQL

Python

DAX

Cloud data solutions

Job description

ATS Client is seeking a Senior Business Intelligence Developer to design, build, and maintain BI solutions that deliver actionable insights. You will translate business requirements into technical specs and deploy data warehouse models, dashboards, and reports across cloud platforms.

The role requires strong experience in ETL, dimensional modeling, and modern BI tools such as Power BI and Azure Synapse. Independent work with cross‑functional collaboration will be essential.