Location: Bryanston / Centurion


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, and a broad range of geo-spatial and analytic projects to a range of property, business-to-consumer, government, and financial services clients.

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


Role Overview

An Analytical Engineer at Lightstone is responsible for the design, maintenance, development, enhancement, optimization, and implementation of analytical systems that help in data-driven decision-making. The role requires an innovative mindset to approach complex problems and the ability to translate these into clear, actionable solutions for stakeholders across the company. Furthermore, the role requires the candidate to drive scalability, automation, and efficiency while maintaining set standards for best practices.


Qualifications / Requirements:

  • Bachelor's or Master's degree in Engineering, Computer Science, Mathematics, Statistics, or a related field.
  • At least 5 years working experience in a relevant field.
  • Very strong proficiency in SQL and experience with at least one programming language such as Python or R.
  • Hands-on experience with database standards.

Experience

Required skills:

  • Agile Methodologies
  • Advanced Excel
  • Advanced MS SQL Server
  • Relational Database Design
  • Python, R
  • SQL query optimization

Advantageous skills:

  • Microsoft Azure Environment
  • Power BI
  • SAS code
  • SQL Server Integration Services (SSIS)

Non-technical skills:

  • Analytical and critical thinking.
  • Inquisitive and innovative mindset.
  • Ability to take ownership of processes and projects.
  • Structured approach to problem-solving, identifying problems and fixing the issue. Must be excellent at troubleshooting and finding resolutions to issues as they arise.
  • Teamwork driven. Collaborate and assist team members, ensuring collective success through shared knowledge and support in various tasks.
  • Excited about learning, pushing technical limits, and finding new solutions.
  • Strong communication skills to effectively collaborate with various stakeholders and team members within the organization.
  • Best practices focused. Implement, enforce, and follow best practices in order to ensure efficiency of production processes.
  • Commitment to ongoing professional development and staying current with the latest industry trends in IT analytics.
  • Ability to work under pressure.
  • Proficiency in documenting processes.