drjobs Data Engineer

Data Engineer

Employer Active

1 Vacancy
drjobs

Job Alert

You will be updated with latest job alerts via email
Valid email field required
Send jobs
Send me jobs like this
drjobs

Job Alert

You will be updated with latest job alerts via email

Valid email field required
Send jobs
Job Location drjobs

Cape Town - South Africa

Monthly Salary drjobs

Not Disclosed

drjobs

Salary Not Disclosed

Vacancy

1 Vacancy

Job Description

Job Advert Summary

We are seeking a Data Engineer specializing in enterprise data modelling to work at the forefront of the design and optimization of our data architecture in a dynamic logistics environment. Youll be designing and developing comprehensive data models that unify data from a wide array of sources: internal company systems ERP systems IoT sensors providing live data feeds and thirdparty data from partners and suppliers.

Your focus will be on building and maintaining the platform for realtime insights predictive analytics and machine learning by designing efficient data models implementing semantic layers and centralizing business logic. Your role will involve integrating modelling and structuring this data in a way that maximizes its utility for business intelligence realtime reporting and machine learning applications. Youll play a key role in building and maintaining our cloud based data lake using Azure Synapse Analytics and following a medallion architecture that ensures clean organized and accessible data at every stage. Collaborating closely with analytics team youll translate complex business requirements into scalable highperformance data solutions that enhance decisionmaking and operational efficiency.

You will develop indexing strategies optimize data models for performance and support the creation of feature stores for analytics and machine learning. This is a unique opportunity to leverage cuttingedge cloud technologies and advanced data modelling techniques to improve the efficiency of supply chain operations and deliver measurable business impact.



Duties & Responsibilities
  • Monitor maintain and improve data pipelines and data models and schemas in Azure Synapse
  • Design develop and optimize data models in a medallion architecture to support analytics and reporting
  • Work with third party consultants to implement data lake
  • Build and maintain data pipelines to facilitate the smooth flow of data between various systems and
  • Ensure consistency in data model design including proper use of keys indexing and semantic layers to improve query performance.
  • Provision datasets for consumption side users focusing on consistency and data
  • Migrate business logic from Qlik Sense to Azure Synapse
  • Migrate on premises data systems to the Azure
  • Test and maintain new and existing API
  • Contribute to and expand a data taxonomy to ensure consistency and clarity in data
  • Implement data security protocols across the entire data
  • Focused improvement initiatives of existing processes systems data
  • Focused improvement initiatives of crossfunctional interactions within the organisation


Minimum Requirements

Experience and Qualification

  • Bachelors degree in Computer Science Information Systems or a related field OR proven capability in working with enterprise data systems.
  • Azure Data Engineer Associate (DP203 preferred
  • Experience with Azure cloud services particularly Azure Synapse
  • Strong understanding of cloud data solutions and architectures and data modelling techniques including dimensional and relational modelling.

Skills and Attributes

  • Highly SQL proficient with experience in building and optimizing complex queries for data
  • Highly Python proficient
  • Process design and implementation
  • Proficiency in designing and maintaining data schemas and keys including primary foreign and composite
  • Familiarity with data modeling best practices in cloud data platforms and indexing
  • Familiarity with onpremises SQL Server databases and familiarity with migration processes to cloud
  • Familiarity with Qlik Sense or similar reporting and analytics
  • Familiarity with enterprise systems and working with multiple
  • Strong problemsolving skills and a demonstrated ability to learn new technologies
  • Proactive approach to problem solving
  • Ability to function within various teams and environments but also work independently
  • Excellent communication skills


Employment Type

Full-Time

Company Industry

Department / Functional Area

Administration

About Company

Report This Job
Disclaimer: Drjobpro.com is only a platform that connects job seekers and employers. Applicants are advised to conduct their own independent research into the credentials of the prospective employer.We always make certain that our clients do not endorse any request for money payments, thus we advise against sharing any personal or bank-related information with any third party. If you suspect fraud or malpractice, please contact us via contact us page.