Senior Analytical Engineer - Data Modeling & BI Leader Path

Edge Executive Search Group; Johannesburg; On-site; ZAR 900,000 - 1,500,000; Full time

Job summary

Edge Executive Search Group is seeking a Senior Analytical Engineer in Johannesburg to design, develop and optimise scalable data models and systems for reporting, BI and advanced analytics. You’ll work across data transformation, automation, governance and data quality, with acting Team Lead duties possible based on performance and business needs.

The role combines hands-on engineering with leadership growth, within a collaborative culture focused on continuous improvement and practical

Qualifications

• Bachelor's or Master's degree in Engineering, Computer Science, Mathematics, Statistics or a related field.
• 7+ years' relevant professional experience.
• Advanced SQL capability, including dynamic queries, performance, and optimisation.
• Advanced Python capability.
• Practical automation experience using SQL, Python and Power Automate.
• Strong process maintenance and process-management experience.
• Experience with relational database design.
• Experience within a Microsoft Azure environment.
• Advanced Power BI and reporting capability.
• Knowledge of Agile methodologies.
• Experience with SDLC methodologies.
• Experience with data warehousing.
• Understanding of security principles.
• Experience using Git workflows and repositories.
• Exposure to CI/CD environments.
• Strong technical documentation capability.

Responsibilities

• Design, develop and maintain scalable analytical data models and systems.
• Transform raw data into reliable, structured and performance-optimised datasets.
• Develop and maintain data transformation logic and automated workflows.
• Build reusable data solutions that support reporting, BI and advanced analytics.
• Optimise SQL queries, processes and analytical data environments.
• Develop automation solutions using SQL, Python and Power Automate.
• Maintain and improve analytical processes and workflows.
• Apply strong data quality, governance and security principles.
• Translate complex business requirements into effective technical solutions.
• Support data warehousing and relational database design.
• Develop and maintain advanced Power BI reporting solutions.
• Follow SDLC and Agile methodologies across development activities.
• Use Git workflows and repositories effectively.
• Contribute to CI/CD practices and continuous improvement.
• Maintain clear and accurate technical and process documentation.
• Troubleshoot complex data and process issues and implement sustainable resolutions.
• Ensure development and production processes follow appropriate technical best practices.
• Provide acting Team Lead support when required.
• Coach, mentor and support other team members.
• Share technical knowledge and contribute to the growth of the wider team.
• Work collaboratively with stakeholders across multiple concurrent initiatives.
• Identify opportunities to improve scalability, automation, efficiency and technical standards.

Skills

SQL

Python

Automation

Relational DB design

Azure

Power BI

Git

CI/CD

Security principles

Agile

SDLC

Data warehousing

Education

Bachelor's or Master's in Engineering/CS/Math/Statistics

Tools

SQL

Python

Power Automate

Power BI

Azure

Git

Job description

Edge Executive Search Group is seeking a Senior Analytical Engineer in Johannesburg to design, develop and optimise scalable data models and systems for reporting, BI and advanced analytics. You’ll work across data transformation, automation, governance and data quality, with acting Team Lead duties possible based on performance and business needs.

The role combines hands-on engineering with leadership growth, within a collaborative culture focused on continuous improvement and practical