Data Engineer

About the Position

We are seeking a Data Engineer to join our team in Cape Town, South Africa. They will be responsible for creating scalable data solutions to support data-intensive applications and analytics. This includes not only the technical development of data pipelines and reports but also overseeing data engineering projects and contributing to the strategic direction of data initiatives within the organization.

Responsibilities

• Translate business requirements into technical data solutions.
• Participate in and contribute to architectural forums within the Business Intelligence (BI) team.
• Design and implement ETL/data pipeline architectures using tools like ADF (Azure Data Factory).
• Automate processes and design system architectures.
• Develop and manage Power BI semantic models, including understanding DAX queries and cubes.
• Visualize and dashboard: translate metrics into visual Power BI reports.
• Integrate data between legacy and modern systems.
• Create ad-hoc SQL scripts to support user queries.
• Deploy and manage data solutions on cloud platforms like Azure.
• Understand Data Warehouse modeling and Techniques: Data schemas, Facts, dimensions, and building data warehouses.
• Write complex SQL queries, joins, views, and stored procedures to extract and manipulate data.
• Perform data modeling including dimensional, multi-dimensional, and relational models.
• Utilize T-SQL for database management and querying.
• Support batch processing and scheduling tasks.
• Create and maintain technical documentation such as data architecture diagrams, ETL workflows, and system documentation to ensure maintainability.
• Participate in design, peer, and code reviews.
• Provide daily technical, functional, and operational support for existing BI solutions.
• Monitor data pipeline and infrastructure performance.
• Identify bottlenecks and optimize for scalability, reliability, and cost-efficiency.
• Troubleshoot and resolve data-related issues.
• Contribute to evolving the architecture towards modern platforms, whether on-premise or cloud-based.
• Maintain working knowledge of Power BI reporting.
• Ensure technical skills stay relevant to emerging industry trends and organizational strategies, including Azure Cloud Solutions and Artificial Intelligence initiatives.

Requirements

• Qualifications:

  • Matric essential
  • Degree in Computer Science / Engineering / Mathematics or related discipline (could be replaced with 10+ years relevant experience)
  • 4-5 years total experience (some experience may be replaced by post-graduate qualifications if the practical component was relevant)

• Core Skills:

  • ETL architecture
  • Azure Data Factory (ADF)
  • SQL
  • Power BI
  • Data Warehouse modeling
  • T-SQL

• Secondary Skills:

  • Data pipeline architecture
  • Process automation
  • Batch processing
  • Data modeling
  • Cloud / Azure
  • Architecture

We Offer

• Hybrid working option

About the Company

Geolance is a leading company in the AI and professional services sector, dedicated to delivering high-quality work and real answers. We pride ourselves on our innovative approach and commitment to excellence.

Employment Type

• CONTRACTOR

Location

• Cape Town, Western Cape, South Africa

Work Type

• On-site