Spatial Data Analyst with Statistical Competency

iX; Centurion; Hybrid; ZAR 600,000 - 900,000; Full time

Benefits offered by this job

Market-related salary

25 days Leave

Hybrid working model

Job summary

Lightstone is seeking a highly analytical Spatial Data Analyst with statistical competency to join our team, focusing on property and retail analytics. The role involves querying massive datasets, applying predictive and descriptive models, and building lightweight dashboards for client prototyping and stakeholder communication.

You will work with SQL, Python (geopandas, shapely, GDAL), and Power BI to translate complex findings into actionable business insights, in a hybrid environment across

Qualifications

• Strong stats focus within GIS/Geoinformatics or econometrics.
• 1–3 years of hands-on, data-heavy experience in corporate/consulting environments.

Responsibilities

• Data interrogation and spatial SQL work, including geographic joins and distance calculations.
• Query, clean, and manipulate large datasets; profile data to identify anomalies and trends.
• Conduct EDA and run hypothesis tests using Python; assist in building predictive/descriptive models.
• Develop quick prototypes and POC tools using Power BI or Python web frameworks for client demos.
• Present visual data concepts to clients and stakeholders to demonstrate business value.
• Design and maintain reports tracking spatial trends and model performance.

Skills

SQL

Spatial SQL

Python

Power BI

DAX

Education

BSc/BCom (Hons preferred) in Statistics or GIS

Tools

geopandas

Shapely

GDAL

Job description

Role Overview

We are looking for a highly analytical, hands-on Spatial Data Analyst with Statistical Competency to join our team, focussed within the property (primary) and retail (secondary) arms of the business. This role is designed for a self-starter who loves digging into data, applying statistical principles to real-world geography, and using modern tech to quickly bring data concepts to life. In this role, you will bridge the gap between deep data interrogation, spatial analytics, and client-facing prototyping. You won't just analyze data in isolation—you will query massive datasets, run statistical models in Python, and build lightweight, interactive dashboards to showcase your concepts to clients and internal stakeholders before we build them into production.

Key Responsibilities

• Data Interrogation & Spatial SQL
• Query, clean, and manipulate massive, complex datasets using SQL.
• Leverage Spatial SQL to perform geographic joins, buffer analyses, and distance calculations to understand spatial relationships.
• Investigate and profile data to identify anomalies, trends, and structural patterns.
• Statistical Analysis & Modelling
• Conduct exploratory data analysis (EDA) and run hypothesis tests using Python.
• Assist in the build and calibration of predictive and descriptive models (e.g., regression analysis, spatial clustering) to support our property and geographic risk engines.
• Translate complex statistical findings into practical, real-world business insights.
• Rapid Prototyping & Client POCs
• Use Power BI (or Python-based web frameworks) to quickly "hack together" interactive dashboards and Proof of Concept (POC) tools.
• Present raw data concepts visually to clients and stakeholders to gather feedback and prove business value before committing engineering resources.
• Design and maintain reports that track spatial trends and model performance.

Qualifications / Experience

• BSc or BCom (Hons preferred) in Statistics, Geoinformatics / GIS (with a strong stats focus), Econometrics, or a highly quantitative field
• 1 to 3 years of professional, hands-on experience in a data-heavy corporate or consulting environment.

Technical Skills

• SQL: Strong query-writing skills are essential. You must understand database structures and have practical experience with Spatial SQL concepts (spatial joins, working with geometry/geography data types).
• Python: Proficient in Python for data manipulation and spatial analysis (geopandas, shapely, and GDAL).
• Power BI: Skilled in building interactive, user-friendly dashboards, setting up data relationships, and writing DAX where needed.

Non-technical Skills

• Mindset: A "builder" mentality. You enjoy tinkering with tools to find creative ways to visualize and solve problems. A passion/interest for the Automotive Industry

Company overview

Lightstone is an intelligent solutions company with strong, industry-specific expertise and core capabilities in data management, GIS, analytics, and software development.

We specialize in delivering integrated, online knowledge solutions, batch and real-time data quality solutions.

We hire exceptional people and provide them with the environment where they can excel. Our non-corporate culture encourages flexibility, collaboration, and innovation.

We pride ourselves in our core values to Encourage Participation, Respond to Changing Needs and Win Together, which are reflected in each development, project, product, or service we undertake to deliver.

What We Offer

• Rich Datasets: Work with some of the most comprehensive property, automotive, and spatial datasets in South Africa.
• Fast-Paced Innovation: A collaborative space where you can quickly test out new ideas, build prototypes, and see your work impact real clients immediately.
• Mentorship & Growth: Learn from senior data scientists and GIS experts in a supportive, hybrid environment.
• Market-related salary
• 25 days Leave
• Hybrid working model