Senior Analytical Engineer | Bryanston / Centurion | Permanent

Edgexec (Pty) Ltd; Johannesburg; On-site; ZAR 850,000 - 1,250,000; Full time

Job summary

Edgexec (Pty) Ltd in Johannesburg invites a Senior Analytical Engineer to design, develop and optimise scalable data models and analytics platforms. You will bridge data engineering and analytics, turning raw data into reliable, well-modelled datasets for reporting and advanced analytics.

The role includes leading automation, governance, data quality initiatives, and acting Team Lead when required, with a clear path to formal leadership based on performance and business needs.

Qualifications

• Bachelor's or Master's degree in a related field (Engineering/CS).
• 7+ years of relevant professional experience.
• Advanced SQL with dynamic queries and performance tuning.
• Advanced Python programming.
• Experience with data warehousing and Azure.
• Experience with Power BI reporting.

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

Advanced SQL

Advanced Python

Power BI

Azure

Git workflows

SDLC

Agile

Data warehousing

Security principles

Education

Bachelor's or Master's in Engineering/CS

Tools

Microsoft Azure

Power Automate

Relational DB design

Job description

Senior Analytical Engineer | Bryanston / Centurion | Permanent

Build scalable analytical data solutions that turn complex data into reliable, high-performing insight. This is an opportunity for an experienced data professional who wants to combine hands-on technical engineering with the opportunity to grow into team leadership.

Our client is looking for a Senior Analytical Engineer to design, develop, maintain and optimise scalable analytical data models and systems that support data-driven decision-making across the organisation. The role sits at the intersection of data engineering and analytics, transforming raw data into reliable, well-modelled and performance-optimised datasets for reporting, business intelligence and advanced analytics.

You will work across data transformation, automation, data quality, governance, reporting and process optimisation while translating complex business requirements into structured and reusable data solutions. The role also provides acting Team Lead cover when required, with a clear opportunity to develop into a formal Team Lead position over time based on performance and business requirements.

Our client is an established intelligent solutions business with specialist capabilities across data management, GIS, analytics and software development. Its collaborative, non-corporate culture encourages flexibility, innovation and participation, with a strong emphasis on continuous improvement, shared success and delivering practical technology solutions.

What You'll Do

• 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.

What You Bring

• 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, query 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.

SAS coding and data-modelling experience would be advantageous.

What Success Looks Like

• Reliable, scalable and well-structured analytical data solutions.

• High-performing SQL queries, data processes and analytical systems.

• Effective automation that reduces manual intervention and improves efficiency.

• Accurate, governed and trusted datasets for reporting and analytics.

• High-quality Power BI reporting and business intelligence solutions.

• Well-maintained processes, documentation and technical standards.

• Fast and effective troubleshooting of production and data-related issues.

• Consistent application of development, security and governance best practices.

• Strong collaboration and knowledge sharing across the technical team.

• Successful acting Team Lead support when required.

• Growing leadership capability and readiness to progress into a Team Lead position.