Jobs
>
Cape Town

    SQL Data Engineer - Cape Town, South Africa - PBT Group

    PBT Group
    PBT Group Cape Town, South Africa

    3 days ago

    PBT Group background
    Full time
    Description

    PBT Group, leaders in Business Intelligence, has a vacancy for a Microsoft SQL Data Engineer.

    Duties:

    Plan and analyse complex business requirements and implement technology enabled solutions to address multi-discipline business opportunities/problems.

    Conduct planning, analysis and design activities in conjunction with other development specialists.

    Participate in analysis of complex business opportunities/problems to deliver designs meeting requirements.

    Participate in estimation of tasks and assist in the development of project plans.

    Code or makes modifications to programs of high complexity, according to specifications.

    Conduct medium to high complexity evaluations for product releases, stand-alone products, etc.

    Conduct walkthroughs and quality review of deliverables.

    Knowledge of design and developing end-to-end data acquisition processes to be used in population of data warehouse/data marts and/or in the creation of interfaces.

    Provide guidance and mentoring on business intelligence technology and systems in general, especially in the area of ETL processes.

    Participate in the formulation of standards to support the data acquisition development process.

    Design, develop and execute complex data acquisition or interface routines using ETL tool, ensuring that business and technical requirements are met.

    Ensure compliance with established policies, standards and methodologies.

    Required Skills:

    Strong MS SQL Data Engineering experience

    Solid SSIS (SQL Server Integration Services) experience.

    Solid SSRS (SQL Server Reporting Services) experience.

    Ability to analyse and define requirements

    Database design

    Intimate knowledge of source systems as well as a basic understanding of dimensional models.

    Conventional database- and data warehouse modeling skills, in order to understand the data warehouse data models.

    A sound knowledge of the programming language used to write the data staging programs or ETL tool.

    A sound knowledge of SQL, or the language used to access the source databases and the data warehouse from the data staging programs or ETL tool.

    A sound knowledge of the capabilities of the ETL tools, to know what their capabilities and shortcomings are – in order to exploit or avoid those aspects in the data staging programs.

    Pride of work, thoroughness and attention to detail.

    Required Qualifications / Training:

    Course on the ETL / related toolset.

    Relevant data warehouse and BI solution training is essential.

    B.Sc. or related degree is advantageous.

    2+ years programming experience.

    * In order to comply with the POPI Act, for future career opportunities, we require your permission to maintain your personal details on our database. By applying for the vacancy via this job ad, you give PBT your consent.

  • Phanda Personnel CC

    Product Data Engineering

    2 days ago

    Phanda Personnel CC Cape Town, South Africa

    **Purpose of the job** · The Product Data Engineer will need to define and populate the Product Breakdown Structures and the associated product defining and product associated data within the appropriate product data management (PDM) tools, for a set of assigned development produ ...

  • Dynamic Outsourced Solutions

    Data Engineer

    1 day ago

    Dynamic Outsourced Solutions Cape Town, South Africa Full time

    The data engineer is ultimately accountable for preparing and manipulating data for further analysis, including ETL and will support testing across the development lifecycle The Data Engineer is responsible for extracting and transforming data from source systems, understanding h ...

  • IOCO

    Data Engineer

    3 hours ago

    IOCO Cape Town, South Africa

    We are seeking an experienced Data Migration Engineer to join our team on a contract basis to facilitate this migration process. The ideal candidates will have strong expertise in data engineering, particularly with Azure Synapse services, SSIS, and API integration. · What you'll ...

  • Dimension Data

    Data Engineer

    3 hours ago

    Dimension Data Cape Town, South Africa temporary

    As a Data Engineer, you'll design and build the data architecture of our products. You will use your technical knowledge to help us develop new products by taking an idea from concept to reality. You'll work on projects across multiple teams in order to achieve company goals and ...

  • NTT

    Data Engineer

    3 hours ago

    NTT Cape Town, South Africa Full time

    JOB DESCRIPTION NTT is a leading global IT solutions and services organisation that brings together people, data and things to create a better and more sustainable future. · In today's 'iNTTerconnected' world, connections matter more now than ever. By bringing together talented ...

  • DLK Group

    Data Engineer

    3 hours ago

    DLK Group Cape Town, South Africa Contract

    Job Description · Modifying the database structure, asnecessary, from information given by application developers. · Enrolling users and maintaining systemsecurity. · Controlling and monitoring user accessto the database. · Monitoring and optimizing the performanceof the databas ...

  • iSanqa

    Data Engineer

    2 days ago

    iSanqa Cape Town, South Africa Full time

    Requirements · Solid 5+ years of experience with Azure Data Factory, Databricks, and Power BI. · Degree in Computer Science, IT, or a related field with a strong analytical focus. · Proficiency in Python, particularly in the context of data manipulation and notebook-based analyti ...

  • Armstrong Appointments

    IT Data Engineer

    4 days ago

    Armstrong Appointments Cape Town, South Africa

    Our client based in Cape Town are currently seeking the skills of an IT Data Engineer to assist in designing and implementing scalable and robust processes to support the data engineering capability. This role will be responsible for extracting and transforming massive amounts of ...

  • DLK Group (PTY) Ltd

    Data Engineer

    3 days ago

    DLK Group (PTY) Ltd Cape Town, South Africa

    · Modifying the database structure, as necessary, from information given by application developers. · Enrolling users and maintaining system security. · Controlling and monitoring user access to the database. · Monitoring and optimizing the performance of the database. · Maintai ...

  • 60degrees

    Data Engineer

    2 days ago

    60degrees Cape Town, South Africa Permanent Full time

    Job Description · Data Engineer (Gauteng) · Compensation: R – R per annum · Working model: Hybrid · The opportunity that awaits you: · Our client, a solutions energy engineering solution provider with projects mainly in Sub-Saharan Africa seeks to expand their team. Our cl ...

  • PBT Group

    Data Engineer

    19 hours ago

    PBT Group Cape Town, South Africa Full time

    PBT Group has a requirement for an intermediate Data Engineers skilled in AWS, SQL, Oracle, legacy systems, infrastructure, Cobol. · Duties: · Design, develop, test and deploy ETL for ODS and data mart projects, as well as application and management reports. · Provide technical s ...

  • PBT Group

    DevOps Data Engineer

    3 hours ago

    PBT Group Cape Town, South Africa

    PBT Group has a requirement for an intermediate DevOps Data Engineer. · Duties: · Strong experience with AWS, Terraform, CI/CD, Git · Design, build and operationalize large scale enterprise data solutions and applications using one or more of AWS data and analytics services in co ...

  • PBT Group

    DevOps Data Engineer

    3 hours ago

    PBT Group Cape Town, South Africa Full time

    PBT Group has a requirement for an intermediate DevOps Data Engineer. · Duties: · Design, build and operationalize large scale enterprise data solutions and applications using one or more of AWS data and analytics services in combination with 3rd parties – Glue, Step-functions, K ...

  • PBT Group

    AWS Data Engineer

    2 days ago

    PBT Group Cape Town, South Africa Full time

    PBT Group is currently offering an opportunity for an AWS Data Engineer with 2 to 5 years of relevant experience. · The role of a Data Engineer involves constructing and maintaining data pipelines and datamarts, emphasizing scalability, repeatability, and security. Data Engineers ...

  • PBT Group

    Data Streaming Engineer

    3 hours ago

    PBT Group Cape Town, South Africa Full time

    PBT Group has an opportunity for a Data Streaming Engineer to build, enhance, and maintain real-time data pipeline. Work with various infrastructure and operations teams to maintain data infrastructure. As a senior engineer on the Data Streaming Platform team, you will be respons ...

  • IO Global

    Senior Data Engineer

    5 days ago

    IO Global Cape Town, South Africa Full time

    Summary · IO Global (IOG), the creator of the Cardano blockchain platform, is searching for a Senior Data Engineer, preferably with a DeFi background. IOG is creating a spinout venture that combines crypto/Web3/DeFi innovations with traditional finance (TradFi) to make borrowing ...

  • Hire Resolve

    Senior Data Engineer

    3 hours ago

    Hire Resolve Cape Town, South Africa Full time

    Hire Resolve is currently seeking a highly skilled Data Engineer to join their client's internationally based team. Their Data Engineer will be based in Cape Town with the Data Team, who work on a hybrid work model. · Requirements · Bachelor's degree in Computer Science or a rela ...

  • NTT

    Data Centre Engineer

    3 days ago

    NTT Cape Town, South Africa Full time

    JOB DESCRIPTION NTT is a leading global IT solutions and services organisation that brings together people, data and things to create a better and more sustainable future. · In today's 'iNTTerconnected' world, connections matter more now than ever. By bringing together talented ...

  • NTT DATA

    Data Centre Engineer

    2 days ago

    NTT DATA Cape Town, South Africa

    Job Description · NTT is a leading global IT solutions and services organisation that brings together people, data and things to create a better and more sustainable future. · In today's 'iNTTerconnected' world, connections matter more now than ever. By bringing together talented ...

  • NTT

    Data Centre Engineer

    15 hours ago

    NTT Cape Town, South Africa Full time

    NTT is a leading global IT solutions and services organisation that brings together people, data and things to create a better and more sustainable future. · In today's 'iNTTerconnected' world, connections matter more now than ever. By bringing together talented people, world-cla ...