Senior Analytical Engineer | Data Modeling & Analytics Lead

Edge Executives; Johannesburg; On-site; ZAR 900,000 - 1,350,000; Full time

Job summary

Edge Executives is seeking a Senior Analytical Engineer to design, develop 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-structured and performance-optimised datasets for reporting, BI and advanced analytics.

You will also provide acting Team Lead cover when required and have opportunities to progress into a

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

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

Agile methodologies

SDLC methodologies

Git workflows

CI/CD

Data governance

Data modelling

Education

Bachelor's or Master's degree in a related field

Tools

Power Automate

Microsoft Azure

SAS tooling

CI/CD tooling

Job description

Edge Executives is seeking a Senior Analytical Engineer to design, develop 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-structured and performance-optimised datasets for reporting, BI and advanced analytics.

You will also provide acting Team Lead cover when required and have opportunities to progress into a