ETL Data Analyst

1 week ago

Johannesburg, Gauteng, South Africa LINKFIELDS INNOVATIONS (PTY) LTD Full time
ETL Consultant-Testing Job Description

We are seeking a highly skilled ETL professional to join our team at LINKFIELDS INNOVATIONS (PTY) LTD. The ideal candidate will have a strong background in data analysis, data mapping, and data modeling for ETL processes.

Key Responsibilities
  • Data Analysis and Data Mapping: Perform thorough data analysis and mapping to ensure accurate data transformation and integration within ETL processes.
  • Data Modeling: Develop and maintain data models for ETL processes, ensuring efficient data storage and retrieval.
  • SQL Script Development and Validation: Develop, validate, and optimize SQL scripts for ETL processes to ensure data integrity and performance.
  • Troubleshooting: Identify and resolve issues related to SQL queries, ETL jobs, and data warehouse/data mart/data store models.
  • Data Validation Testing: Conduct data validation testing for various data sources to ensure data accuracy and completeness.
  • Validation of Data Mappings: Validate data mappings to ensure correct data transformations and integrations.
  • End-to-End Testing: Perform end-to-end testing of ETL processes, ensuring all components function correctly from source data extraction to final data load.
  • Requirements Creation: Collaborate with stakeholders to create detailed requirements for ETL processes, ensuring they meet business needs and technical specifications.
  • Procedure Creation: Develop and document procedures for ETL processes, ensuring clear and concise guidelines for development and testing.

Requirements

  • Bachelor's degree in Computer Science, Information Technology, or a related field, or equivalent work experience.
  • Proven experience in data analysis, data mapping, and data modeling for ETL processes.
  • Strong proficiency in developing and validating SQL scripts for ETL.
  • Experience in troubleshooting SQL queries, ETL jobs, and data warehouse/data mart/data store models.
  • Demonstrated experience in data validation testing for various data sources.
  • Ability to validate data mappings to ensure accurate data transformation and integration.
  • Comprehensive understanding of end-to-end testing processes.
  • Experience in creating detailed requirements for ETL processes.
  • Strong skills in developing and documenting procedures for ETL processes.

  • Data Analyst

    2 weeks ago

    Johannesburg, Gauteng, South Africa KPMG-SouthAfrica Full time

    Job Title: Junior Data AnalystWe are seeking a highly motivated and detail-oriented Junior Data Analyst to join our team at KPMG-SouthAfrica. As a Junior Data Analyst, you will play a key role in assisting the Data and Analytics Centre in executing the ETL process, developing data models for analytics, and communicating results to Audit teams.Key...

  • Data Analyst

    3 weeks ago

    Johannesburg, Gauteng, South Africa KPMG-SouthAfrica Full time

    Job Title: Junior Data AnalystWe are seeking a highly motivated and detail-oriented Junior Data Analyst to join our team at KPMG-SouthAfrica. As a Junior Data Analyst, you will play a key role in assisting the Data and Analytics Centre in executing the ETL process, developing data models for analytics, and communicating results to Audit teams.Key...

  • ETL Developer

    1 month ago

    Johannesburg, Gauteng, South Africa TMF Group Full time

    About the RoleTMF Group is seeking an experienced ETL Developer to join our team. As an ETL Developer, you will be responsible for designing, implementing, and maintaining data integration solutions using Azure Data Factory and Alteryx.Key ResponsibilitiesDesign and implement data integration solutions using Azure Data Factory and Alteryx.Develop and...

  • ETL Consultant

    2 weeks ago

    Johannesburg, Gauteng, South Africa LINKFIELDS INNOVATIONS (PTY) LTD Full time

    Job Title: ETL Consultant-TestingWe are seeking a highly skilled ETL Consultant to join our team at LINKFIELDS INNOVATIONS (PTY) LTD. The ideal candidate will have a strong background in data analysis, data mapping, and data modeling for ETL processes.Key Responsibilities:Data Analysis and Data Mapping: Perform thorough data analysis and mapping to ensure...

  • Data Analyst

    4 weeks ago

    Johannesburg, Gauteng, South Africa Capital Recruit Full time

    Job Title: Intermediate BI Data AnalystCapital Recruit is seeking a highly skilled Intermediate BI Data Analyst to join our team. As a key member of our data analytics team, you will be responsible for extracting insights from complex data sets and presenting them in a clear and actionable manner.Key Responsibilities:Develop and maintain data models and...

  • Data Analyst

    2 weeks ago

    Johannesburg, Gauteng, South Africa Capital Recruit Full time

    Job Title: Intermediate BI Data AnalystCapital Recruit is seeking an experienced Intermediate BI Data Analyst to join our team. As a key member of our data analytics team, you will be responsible for analyzing and interpreting complex data sets to inform business decisions.Key Responsibilities:Develop and maintain data models and pipelines to support...

  • Data Analyst

    3 weeks ago

    Johannesburg, Gauteng, South Africa Capital Recruit Full time

    Job Title: Intermediate BI Data AnalystJob Summary:We are seeking an experienced Intermediate BI Data Analyst to join our team at Capital Recruit. The successful candidate will be responsible for generating insights and logic through our unique informal market data asset, establishing and implementing analytical models to enrich and automate our insights,...

  • Data Engineer

    2 weeks ago

    Johannesburg, Gauteng, South Africa E-Merge Full time

    Job Title: Junior Data EngineerE-Merge is seeking a talented Junior Data Engineer to join our team in Johannesburg. As a Junior Data Engineer, you will play a key role in helping us drive value from our data by building and maintaining data flows, ETL processes, and reporting databases.Responsibilities:Collaborate with the development team, data analysts,...

  • Data Analyst

    4 days ago

    Johannesburg, Gauteng, South Africa Express Employment Professionals Midrand Full time

    Job Title: Data AnalystWe are seeking a highly skilled Data Analyst to join our team at Express Employment Professionals Midrand. As a Data Analyst, you will play a crucial role in collecting, processing, and transforming large volumes of data to support strategic decision-making within the company.Key Responsibilities:Collect, clean, and process large...

  • Data Scientist

    3 weeks ago

    Johannesburg, Gauteng, South Africa Capital Recruit Full time

    Job Title: Data EngineerWe are seeking a highly skilled Data Engineer to join our team at Capital Recruit. As a Data Engineer, you will play a critical role in helping our clients understand the rich data we collect from the traditional retail market in South Africa and Africa broadly.Key Responsibilities:Design and develop scalable data pipelines to...

  • Data Analyst

    3 weeks ago

    Johannesburg, Gauteng, South Africa Agile Bridge Full time

    Job Title: Intermediate Data AnalystJob Summary:The role of a Data Analyst at Agile Bridge involves developing strategies for clients by leveraging data management principles. This includes conducting experiments, researching, and analyzing data from the platform and external sources to highlight market insights, generate key reports, and design functional...

  • Data Scientist

    3 weeks ago

    Johannesburg, Gauteng, South Africa Capital Recruit Full time

    Job Title: Data EngineerWe are seeking a highly skilled Data Engineer to join our team at Capital Recruit. As a Data Engineer, you will play a critical role in helping our clients understand the rich data we collect from the traditional retail market in South Africa and Africa broadly.Key Responsibilities:Design and develop scalable data pipelines to...

  • Data Scientist

    3 weeks ago

    Johannesburg, Gauteng, South Africa Capital Recruit Full time

    Job Title: Data EngineerWe are seeking a highly skilled Data Engineer to join our team at Capital Recruit. As a Data Engineer, you will play a critical role in helping our clients understand the rich data we collect from the traditional retail market in South Africa and Africa broadly.Key Responsibilities:Design and develop scalable data pipelines to...

  • Data Engineer

    2 weeks ago

    Johannesburg, Gauteng, South Africa Capital Recruit Full time

    About the RoleWe are seeking a highly skilled Data Engineer to join our team at Capital Recruit. As a Data Engineer, you will play a key role in helping our clients understand the rich data we collect from the traditional retail market in South Africa and Africa broadly.Key ResponsibilitiesDesign, build, and maintain data pipelines to support our reporting...

  • Data Scientist

    3 weeks ago

    Johannesburg, Gauteng, South Africa Capital Recruit Full time

    Job Title: Data EngineerWe are seeking a highly skilled Data Engineer to join our team at Capital Recruit. As a Data Engineer, you will play a critical role in helping our clients understand the rich data we collect from the traditional retail market in South Africa and Africa broadly.Key Responsibilities:Design and develop scalable data pipelines to...

  • Data Scientist

    3 weeks ago

    Johannesburg, Gauteng, South Africa Capital Recruit Full time

    Job Title: Data EngineerWe are seeking a highly skilled Data Engineer to join our team at Capital Recruit. As a Data Engineer, you will play a critical role in helping our clients understand the rich data we collect from the traditional retail market in South Africa and Africa broadly.Key Responsibilities:Work closely with our development team, data...

  • Business Intelligence Analyst

    2 weeks ago

    Johannesburg, Gauteng, South Africa LINKFIELDS INNOVATIONS (PTY) LTD Full time

    Job Title: Business Intelligence AnalystJob Summary:We are seeking a highly skilled Business Intelligence Analyst to join our team at LINKFIELDS INNOVATIONS (PTY) LTD. As a Business Intelligence Analyst, you will play a crucial role in designing and implementing robust ETL processes to streamline data integration and support our advanced analytics...

  • Data Analyst

    2 weeks ago

    Johannesburg, Gauteng, South Africa Network Recruitment Full time

    Unlock Your Potential as a Data AnalystAre you a detail-oriented data professional with a passion for analytics? We're seeking a skilled Business/Data Analyst to join our team at Network Recruitment, where you'll play a pivotal role in the Fintech space. This is a fantastic opportunity to harness your skills in SQL, data modeling, and business analysis,...

  • Data Analyst

    6 days ago

    Johannesburg, Gauteng, South Africa NTT DATA Full time

    About the RoleNTT DATA is seeking a seasoned Business Intelligence Analyst to join our team. As a key member of our analytics team, you will be responsible for transforming data into critical information and knowledge that can be used to make sound business decisions.Key Responsibilities:Analyze complex business problems and issues using data from internal...

  • Data Analyst

    3 weeks ago

    Johannesburg, Gauteng, South Africa NTT DATA Full time

    About the RoleNTT DATA is seeking a seasoned Business Intelligence Analyst to join our team. As a key member of our analytics team, you will be responsible for transforming data into critical information and knowledge that drives business value.Key Responsibilities:Analyze complex business problems and issues using data from internal and external sources to...