Data / BI Engineer

Reposted 27 Days Ago
Be an Early Applicant
Cape Town, Western Cape, ZAF
In-Office
Mid level
Agency • Information Technology • Professional Services
The Role
Design, build, and optimize scalable data pipelines, data warehouses, and Power BI solutions. Translate business requirements into ETL and semantic models, write complex T-SQL queries, deploy solutions on Azure, ensure data quality and performance, monitor and troubleshoot pipelines, and document architectures while contributing to BI architecture and modernization efforts.
Summary Generated by Built In

We are seeking a Mid/Senior Data Engineer to design, build, and optimize scalable data solutions that support business intelligence, analytics, and strategic decision-making. This is a hands-on role focused on developing modern data pipelines, data warehouses, and Power BI solutions while ensuring data quality, performance, and reliability.

Working closely with business and technical teams, you will translate business requirements into robust data solutions and contribute to the ongoing evolution of the organization's data platform and architecture.



RequirementsKey Responsibilities and Skills
Technical Solution Development
  • 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.
  • Visualisation and Dashboarding: 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.
Data Modeling and Management
  • Understanding of Data Warehouse modeling and Techniques: Data schemas, Facts, dimensions and building data warehouses.
  • Writing complex SQL queries, joins, views and stored procedures to extract and manipulate data.
  • Apply knowledge and practical experience in the Data Warehouse Life Cycle.
  • Perform data modeling including dimensional, multi-dimensional, and relational models.
  • Utilize TSQL for database management and querying.
  • Support batch processing and scheduling tasks.
Documentation and Support
  • 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.
Monitoring and Optimization
  • Monitor data pipeline and infrastructure performance.
  • Identify bottlenecks and optimize for scalability, reliability, and cost-efficiency.
  • Troubleshoot and resolve data-related issues.
Strategic and Emerging Technology Contributions
  • 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.

 



Skills Required

  • Design and implement ETL/data pipelines using Azure Data Factory (ADF)
  • Develop and manage Power BI semantic models and reports
  • Proficiency with DAX for Power BI/semantic models
  • Strong SQL skills including complex queries, joins, views, and stored procedures
  • Experience with T-SQL for database management and querying
  • Data warehouse modeling knowledge: facts, dimensions, dimensional and relational models
  • Deploying and managing data solutions on Azure/cloud platforms
  • Monitor, troubleshoot, and optimize data pipelines and infrastructure for performance and cost
  • Integrate data between legacy and modern systems and support batch processing/scheduling
  • Create and maintain technical documentation, participate in code reviews, provide operational support
  • Familiarity with OLAP cubes and multi-dimensional modeling
  • Awareness of Azure Cloud Solutions and AI initiatives
Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
Year Founded: 2013

What We Do

Sabenza IT is a niche recruitment company specializing in Information Technology, SAP, Finance, and Engineering roles, with over 23 years of experience.

Similar Jobs

CDW Logo CDW

Sales Support Associate

Information Technology
Hybrid
Cape Town, Western Cape, ZAF
15100 Employees

Morningstar Logo Morningstar

Infrastructure Engineer

Artificial Intelligence • Big Data • Enterprise Web • Fintech • Software • Financial Services
Remote or Hybrid
South Africa
11500 Employees

Xero Logo Xero

Small Business Onboarding Specialist

Cloud • Fintech • Information Technology • Machine Learning • Software
Hybrid
Kenridge, City of Cape Town, Western Cape, ZAF
4500 Employees

Morningstar Logo Morningstar

Counsel

Artificial Intelligence • Big Data • Enterprise Web • Fintech • Software • Financial Services
Hybrid
Cape Town, Western Cape, ZAF
11500 Employees
506K-709K Annually

Similar Companies Hiring

Axle Health Thumbnail
Artificial Intelligence • Healthtech • Information Technology • Logistics
Santa Monica, CA
25 Employees
NODA AI Thumbnail
Artificial Intelligence • Information Technology • Software • Cybersecurity
Sydney, AU
54 Employees
Golden Pet Brands Thumbnail
Digital Media • eCommerce • Information Technology • Marketing Tech • Pet • Retail • Social Media
El Segundo, California
178 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account