Senior BI & GIS Data Architect

Ziyana Business Consulting and Training; Sandton; On-site; ZAR 500,000 - 800,000; Full time

Job summary

Ziyana Business Consulting and Training in Sandton, South Africa seeks a Senior BI Analyst to architect data solutions, integrate data sources, and deliver interactive dashboards using Tableau and Excel. The role combines GIS data, statistical analysis, and stakeholder engagement.

You will design databases, advise on data standards, and collaborate with IT to ensure data quality, security, and timely backups, supporting public sector clients and driving data-driven decision making.

Qualifications

• At least a degree in Computer Science, Information Systems, Geo-informatics, Statistics, Engineering or related disciplines.
• Must be literate in Microsoft technologies such as Microsoft SQL Server, Excel Pivot Tables & Power Pivot and Microsoft Access.
• Must have experience in Tableau and/or other BI tools, as well as integration with statistical packages such as R.
• More than five years of current experience designing, implementing, and maintaining databases and applications in a relational environment, along with experience in data visualization, data analysis and working with large quantities of data.
• More than three years of current experience in GIS and statistical modelling.
• Experience in assessing client needs and translating them into information products and services is also required.

Responsibilities

• Establish data requirements through client consultation and data definitions.
• Identify data sources and partnerships with data custodians.
• Receive and normalize data from different sources.
• Integrate data into a unified data framework with relationships and quality checks.
• Design, develop and support BI databases and GIS reporting.
• Collaborate with IT to install, configure, and maintain database servers and ensure security and backups.
• Develop spatial geodatabases with GIS tools and visualize data using BI dashboards.

Skills

SQL

Power Pivot

Tableau

R

Excel

Data visualization

Education

Degree in Computer Science / Information Systems / Geo-informatics / Statistics / Engineering

Tools

SQL Server

GIS

Access

Excel Pivot Tables

Microsoft BI tools

Job description

Ziyana Business Consulting and Training in Sandton, South Africa seeks a Senior BI Analyst to architect data solutions, integrate data sources, and deliver interactive dashboards using Tableau and Excel. The role combines GIS data, statistical analysis, and stakeholder engagement.

You will design databases, advise on data standards, and collaborate with IT to ensure data quality, security, and timely backups, supporting public sector clients and driving data-driven decision making.