Data Engineer.

We are seeking a skilled Data Engineer to join our dynamic team. As the Data Engineer, you will play a pivotal role in designing, implementing and maintaining data solutions leveraging industry leading data management practices as well as best fit for purpose technology solutions, including but not limited to, Microsoft Azure services and Power BI tooling. You will work closely with stakeholders to understand business requirements and translate them into efficient data models, visualisations, and reports. Additionally, you will need to assist with building and managing a small team of data professionals, providing guidance, mentoring, and ensuring the successful execution of data architecture initiatives, including data strategy development.

Location: Johannesburg
Starting Date: Immediately
Direct Report: Head of Technology

Key Roles and Responsibilities

  • Data Strategy Development: Collaborate with key stakeholders to develop and implement a comprehensive data strategy aligned with business goals and objectives. Define data governance policies, data quality standards, and data management processes to ensure consistency, reliability, and security of data assets.
  • Data Architecture Design: Design scalable and efficient data architectures using Azure Power BI, ensuring alignment with the data strategy and adherence to data governance principles. Establish best practices and standards for data modelling, ETL development, and data visualisation to support the organisation's data-driven decision-making needs.
  • Data Modeling: Develop logical and physical data models to support business requirements, optimise data storage, and enable easy access and analysis. Define canonical data models and data integration patterns to facilitate data interoperability and consistency across systems.
  • Data Dictionary: Develop and maintain a comprehensive data dictionary to ensure consistency, clarity, and accuracy in data definitions across the organisation. The data dictionary serves as a centralised repository of metadata that documents key information about the organisation's data assets, including data sources, data elements, and their attributes.
  • ETL Development: Design and implement Extract, Transform, Load (ETL) processes to integrate data from various sources into Azure Power BI, ensuring data quality and consistency. Implement data cleansing, validation, and enrichment techniques to improve data accuracy and reliability.
  • Dashboard and Report Development: Lead the development of visually compelling dashboards and reports using Azure Power BI, incorporating best practices for data visualisation and storytelling. Collaborate with business users to understand their reporting needs and deliver insights that drive informed decision-making.
  • Performance Optimization: Identify and resolve performance bottlenecks in data pipelines, queries, and visualisations to ensure optimal performance and user experience. Implement caching, indexing, and partitioning strategies to improve query performance and reduce latency.
  • Data Governance and Security: Implement data governance policies and security measures to ensure compliance with regulatory requirements and protect sensitive data. Define roles and permissions, data access controls, and encryption mechanisms to safeguard data privacy and confidentiality.
  • Team Management: Lead and mentor a small team of data professionals, providing guidance, coaching, and support to foster their growth and development. Set clear goals and objectives, monitor performance, and provide regular feedback to ensure the team's success and effectiveness.

Qualifications and Work Experience

  • Bachelor's degree in Computer Science, Information Systems, or related field; Master's degree preferred.
  • Proven experience as a Data Engineer or similar role, with a focus on designing and implementing data solutions using Azure tools and Power BI.
  • Strong proficiency in SQL and experience working with relational and non-relational databases.
  • Hands-on experience with Azure services such as Azure Data Factory, Azure SQL Database, Azure Synapse Analytics, and Azure Analysis Services, as well as Microsoft Fabric.
  • Experience with data modelling, ETL development, and data visualisation using Power BI.
  • Knowledge of data governance principles, data security best practices, and regulatory compliance requirements.
  • Excellent analytical, problem-solving, and communication skills.
  • Ability to lead and manage a team effectively, fostering collaboration and driving results.

Personal Attributes

  • Leadership: Strong leadership skills with the ability to inspire, motivate, and mentor team members to achieve their full potential.
  • Adaptability: Flexible and adaptable approach to work, able to thrive in a fast-paced and dynamic environment with evolving priorities.
  • Collaboration: Excellent collaborative skills with the ability to work effectively with cross-functional teams and stakeholders to achieve common goals.
  • Communication: Exceptional communication skills, both verbal and written, with the ability to convey complex technical concepts to non-technical stakeholders.
  • Problem-Solving: Strong problem-solving skills with the ability to analyse complex issues, identify root causes, and develop innovative solutions.
  • Attention to Detail: Meticulous attention to detail with a focus on quality and accuracy in all aspects of work.
  • Initiative: Proactive and self-motivated with a strong sense of initiative and the ability to drive projects forward independently.
  • Integrity: High level of integrity, ethics, and professionalism in dealing with sensitive and confidential information.

Package

  • CTC Per Annum: R 942,000.00 pa
  • 5% Pension Fund Contribution - Employer
  • Death and Disability Funds – Employer
  • Unlimited LTE Data for work
  • Mileage reimbursed at rate linked to AA rates
  • Annual leave: 22 days

To apply send CV and a short covering letter outlining your suitability for the position to careers@clicklearning.org

Apply Now