Business Intelligence Analyst​/Specialist

Ziyana Business Consulting and Training | Full time

Sandton, South Africa | Posted on 19/05/2026

Our client in the Government and Public Sector is looking for a Business Intelligence Analyst/Specialist to join their diverse and performance driven team. If you meet the below requirements, do not hesitate to submit your CV for consideration.

People living with Disabilities are highly encouraged to apply.

Duties:

• Establish the data requirements of internal/external clients throughrunning consultation for developing data definitions and standards.
• Identify potential data sources through defining the data requirement sand hypotheses, searching the general data environment and establishingpartnerships and/or agreements with data custodians.
• Receive data in line with agreed partnerships, arrangements and/oragreements with internal/external clients as required.
• Review and normalize each set of data received from different sourcesthrough verifying the reliability, consistency and accuracy of the data interms of data infrastructure standards.
• Integrate data from different sources through creating an integrated dataframework, establishing relationships between data and identifying potentialdata conflicts or duplication.
• Design, develop and support databases required for BI/GIS reporting.
• Work closely with the IT team to install, configure, maintain and administer database servers as and when required.
• Work closely with the IT team to ensure that the security and integrityof the database is maintained at all times.
• Work closely with the IT team to ensure that backups of the database aredone and restored daily.
• Work closely with the GIS team to build spatial geodatabases.
• Analyze and manipulate raw data and create information products that canbe used across various business units of the organization based on clients’needs.
• Use GIS software to collect, analyze and interpret spatial data.
• Use statistical software packages such as Microsoft Excel or R toprocess and summarize large volumes of qualitative and quantitative data.
• Use programming, scripting and/or model builders to develop spatial and statistical models that could be used to support operational and strategic decision-making.
• Interpret findings from data analysis and develop conclusions and recommendations for application by clients.
• Use Business Intelligence tools such as Microsoft Excel Power Pivot or Tableau to visualize operational and strategic data in the form of interactivedashboards and infographics.
• Use various GIS tools to visualize spatial data effectively.
• Develop presentations and communicate findings of analyses to various clients.
• Guide principles for datavisualization and train fellow employees on best practices for datavisualization techniques

• 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,Microsoft Excel Pivot Tables & Power Pivot and Microsoft Access.
• Must have experience in Tableau and/or other BI tools, as well asintegration 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 largequantities of data.
• More than three years of current experience in GIS and statisticalmodelling.
• Experience in assessing client needs and translating them intoinformation products and services is also required.
• Comprehensive knowledge of Business Intelligence, data management anddata visualization is required.
• Excellent statistical and analytical skills are required.
• Advanced database design and SQL skills are required.
• Programming and scripting is required to develop statistical or spatialmodels.
• Good communication and presentation skills.
• Experience in Geographic Information Systems (GIS).
• Must be able to pay attention to detail and work under time constraintsto accomplish project deadlines.
• Keep abreast of new trends and innovations in business intelligence, database design, spatial and statistical modelling, as well asrelated hardware and software.
• A valid driver’s license is required as traveling is required fromtime-to-time.