Intermediate ETL Developer

Found in: beBee S ZA - 1 month ago

Gauteng, South Africa Hollard Insurance Full time
Hollard Insurance’s job vacancy, Career and Recruitment

Job title : Intermediate ETL Developer – Parktown jobs in Gauteng

Job Location : Gauteng,

Deadline : March 27, 2024

Quick Recommended Links

Jobs by Location Job by industries

Job Advert Summary    

Working in the Central Data, Analytics & Data Science team, collaborating closely with Analytics Consultants and Data Engineers, the candidate will design, build and support data pipelines and data assets closely aligned to Business requirements, primarily in SQL on-premise, but also with some solutions in Azure. There is also opportunity to deliver Power BI reporting related to the data assets built.

Key responsibility:

ETL development
Outputs required to achieve this accountability:

In collaboration with business users and the Central Data, Analytics & Data Science team, design, develop, test, maintain and support ETL processes, programs and scripts that reflect best practices for data management, error handling, operations logging and alerting, scheduling, job control, etc., whilst adhering to standards, guidelines, quality assurance reviews, testing protocol and Hollard Group standards. Assist with the management and ongoing maintenance and support of the overall ETL architecture by which systems are interconnected and data is passed among systems. Conduct root cause analysis and resolve production problems and data integrity issues and eliminate such through the application of process/system enhancements. Raise critical technical issues to vendors or key stakeholders in a timely manner where they would impact on delivery and quality of services and follow up on the technical resolution of such issues. Validate the data integrity and develop and maintain data validation routines. Key responsibility: Data warehouse development

Outputs required to achieve this accountability:

Design, develop and administrate databases and data structures/models with due consideration to: the potential data queries and system feeds that will be generated from the tables; addition of timestamp and user ID columns as appropriate to identify the user and the time of the row addition or change; the use of standard abbreviations in table and column names; assignment of data types, nullability, and defaults for columns as appropriate. Create database objects such as tables, views, stored procedures, and indices. Create and update database documentation and procedures as appropriate. Key responsibility: General Role Expectations

Outputs required to achieve this accountability:

To design, develop and maintain processes that extract data from transactional systems and other sources at set frequencies, manipulating this data according to set rules, and then loading the data into storage data structures to facilitate reporting and analytics. To design, develop and maintain the different data structures required to optimally structure, store and generally administrate this data depending on the way in which it is to be accessed and consumed for reporting and analytics. To design, develop and enhance reports and data extracts through which the business can consume the data and convert it to insights. Work with the team to support and enhance existing data assets and data pipelines. Provide the additional capacity required in the team to meet all Internal Customer needs, and build a pipeline of talent in the team with the objective to grow the candidate into the role of a Senior ETL Developer over time.

Required Knowledge and Experience    

2 years’ experience in ETL integration with transactional systems / sources and 3 years (can overlap) working in a role close to solving business problems in a complex environment. Experience specifically in relational database design, modelling, implementation and maintenance is an advantage Experience in Python coding (within or outside of ETL development) is an advantage Any experience in the management/analysis of insurance processes is an advantage

* Candidates who do not meet the exact experience requirements will still be considered if they can demonstrate exceptional skills and aptitude for problem solving and learning for the period of their work history.

Educational Requirements    

Preferred: BCom Informatics, BSc Computer Science, BSc Engineering or related qualification. Minimum: National Diploma in Information Technology or related qualification. Financial qualification/knowledge would be an advantage. BI Certification (e.g. Microsoft MCITP, Kimball Certification, etc.) would be an advantage.

*Accounting / Financial Services jobs in south africa

*Intermediate ETL Developer – Parktown in

  • Data Engineer/ETL Developer

    Found in: beBee S ZA - 3 weeks ago

    Gauteng, Johannesburg, South Africa Datafin Recruitment Full time

    Datafin Recruitment’s job vacancy, Career and Recruitment Job title : Data Engineer/ETL Developer (Remote) jobs in Gauteng Job Location : Gauteng, Johannesburg Deadline : April 20, 2024 Quick Recommended Links Jobs by Location Job by industries DUTIES: Collaborate with stakeholders to understand data requirements and deliver comprehensive ETL...

  • Snr Specialist: IT Systems Developer

    Found in: beBee S ZA - 3 weeks ago

    Gauteng, Johannesburg, South Africa Liberty Group South Africa Full time

    Liberty Group South Africa’s job vacancy, Career and Recruitment Job title : Snr Specialist: IT Systems Developer jobs in Gauteng Job Location : Gauteng, Johannesburg Deadline : May 04, 2024 Quick Recommended Links Jobs by Location Job by industries Purpose To provide advice and support in area of specialisation and enable the design, creation,...

  • Intermediate Data-Scientist

    Found in: beBee S ZA - 4 weeks ago

    Gauteng, Randburg, South Africa WesBank Full time

    WesBank’s job vacancy, Career and Recruitment Job title : Intermediate Data-Scientist jobs in Gauteng Job Location : Gauteng, Randburg Deadline : May 08, 2024 Quick Recommended Links Jobs by Location Job by industries Job Description To plan, build, optimise and implement innovative quantitative analytical methodologies, procedures, products and...

  • BI Developer

    Found in: beBee S ZA - 3 weeks ago

    Gauteng, South Africa Michael Page Full time

    About Our Client Our client, a Cell Captive Insurance organization Job Description Key Responsibilities:End to end data acquisition and data management (Event/Streaming based data pipelines, ETL, Data Lake, Data warehousing and dimensional data modelling.Import the data into the corporate data lake/ data warehouseReporting on the data acquisition progress,...

  • BI Developer

    Found in: beBee S ZA - 3 weeks ago

    Gauteng, South Africa Michael Page Full time

    About Our Client Our client, a Cell Captive Insurance organization Job Description Key Responsibilities:End to end data acquisition and data management (Event/Streaming based data pipelines, ETL, Data Lake, Data warehousing and dimensional data modelling.Import the data into the corporate data lake/ data warehouseReporting on the data acquisition progress,...

  • Intermediate Internal Auditor

    4 days ago

    City of Johannesburg, Gauteng, South Africa AGC Recruitment Full time

    **Intermediate Internal Auditor - FMCG - Sandton** Our client, in the FMCG industry, is looking for an Intermediate Internal Auditor for their office in Sandton. This is an international broad-line food service group, listed on the JSE, South Africa, and present in developed economies in five continents. Focused on food service, the business comprises of...

  • Data Quality Specialist x 2

    Found in: Whatjobs ZA C2 - 1 week ago

    Gauteng, South Africa HR Genie Full time

    My client in the government sector is looking for Data Quality Specialist x2 Location: Onsite, Pretoria Contract Duration: 3 year project Start: TBC Requirements Bachelor's degree in ICT, with a minimum of 5 years relevant experience in ETL,SQL, Data Cleansing Responsibilities Data profiling, cleansing, validation and continuos monitoring...

  • Mid - Senior: Essbase Developer x 2

    Found in: beBee jobs ZA - 2 weeks ago

    Gauteng, Jagersfontein, South Africa EQ Plus Technologies Pty Full time

    EQ Plus Technologies Pty's job vacancy, Career and RecruitmentJob title : Mid – Senior: Essbase Developer x 2 jobs in GautengJob Location : Gauteng, JagersfonteinDeadline : April 28, 2024Quick Recommended LinksJobs by LocationJob by industries Duties: Participate in business requirements analysis sessionsIdentify and document functional and derived...

  • AWS Data Engineer

    Found in: beBee S ZA - 3 weeks ago

    Gauteng, South Africa SabenzaIT Full time

    Are you a proficient IT professional with a fervor for pioneering and state-of-the-art technology? Our client is in search of a skilled AWS Data Engineer to join their vibrant team located in Midrand/Menlyn. As a prominent figure in the automotive industry worldwide, they are dedicated to shaping the future of mobility through inventive solutions and...

  • Bms/control System Business Development Executive

    4 days ago

    Gauteng, South Africa Landis and Staefa Full time

    **Introduction** Basic salary and commission to be earned Huge potential for growth for the right person. Progressional targets (based on probation and prior proven sales record) Company laptop to be supplied Cell phone allowance Petrol card **Duties & Responsibilities** - Achieve growth and achieve sales targets. - Identify leads, manage, call on...

  • Developer Operations Engineer

    Found in: beBee S ZA - 4 weeks ago

    Gauteng, Johannesburg, South Africa Airports Company South Africa Full time

    Airports Company South Africa’s job vacancy, Career and Recruitment Job title : Developer Operations Engineer – (230000I1) jobs in Gauteng Job Location : Gauteng, Johannesburg Deadline : May 04, 2024 Quick Recommended Links Jobs by Location Job by industries An exciting vacancy exists at Corporate Office for an experienced and skilled...

  • Support Consultant: Student Management System

    Found in: beBee S ZA - 3 weeks ago

    Gauteng, Johannesburg, South Africa Adapt IT Holdings Full time

    Adapt IT Holdings’s job vacancy, Career and Recruitment Job title : Support Consultant: Student Management System jobs in Gauteng Job Location : Gauteng, Johannesburg Deadline : May 10, 2024 Quick Recommended Links Jobs by Location Job by industries Job description Support Consultant Student Management System primarily supporting TVET Colleges. They...

  • Support Consultant: Student Management System

    Found in: beBee S ZA - 3 weeks ago

    Gauteng, Johannesburg, South Africa Adapt IT Holdings Full time

    Adapt IT Holdings’s job vacancy, Career and Recruitment Job title : Support Consultant: Student Management System jobs in Gauteng Job Location : Gauteng, Johannesburg Deadline : May 10, 2024 Quick Recommended Links Jobs by Location Job by industries Job description Support Consultant Student Management System primarily supporting TVET Colleges. They...

  • HR-Payroll Support Consultant

    Found in: beBee S ZA - 3 weeks ago

    Gauteng, Johannesburg, South Africa Adapt IT Holdings Full time

    Adapt IT Holdings’s job vacancy, Career and Recruitment Job title : HR-Payroll Support Consultant jobs in Gauteng Job Location : Gauteng, Johannesburg Deadline : May 10, 2024 Quick Recommended Links Jobs by Location Job by industries Job description Primary Responsibilities for the Role  Investigate incidents relating to systems, within the scope of...

  • HR-Payroll Support Consultant

    Found in: beBee S ZA - 3 weeks ago

    Gauteng, Johannesburg, South Africa Adapt IT Holdings Full time

    Adapt IT Holdings’s job vacancy, Career and Recruitment Job title : HR-Payroll Support Consultant jobs in Gauteng Job Location : Gauteng, Johannesburg Deadline : May 10, 2024 Quick Recommended Links Jobs by Location Job by industries Job description Primary Responsibilities for the Role  Investigate incidents relating to systems, within the scope of...

  • Data Specialist

    Found in: beBee S ZA - 4 weeks ago

    Gauteng, Johannesburg, South Africa Experian Full time

    Experian’s job vacancy, Career and Recruitment Job title : Data Specialist – Sandton jobs in Gauteng Job Location : Gauteng, Johannesburg Deadline : April 05, 2024 Quick Recommended Links Jobs by Location Job by industries Qualifications At least 3 years of experience in data engineering or related field Proficiency in Source Control, T-SQL,...

  • Senior Data Analyst

    Found in: beBee S ZA - 4 weeks ago

    Gauteng, Johannesburg, South Africa Experian Full time

    Experian’s job vacancy, Career and Recruitment Job title : Senior Data Analyst – Bryanston jobs in Gauteng Job Location : Gauteng, Johannesburg Deadline : April 05, 2024 Quick Recommended Links Jobs by Location Job by industries Qualifications BSc/BA in Computer Science math, software engineering, statistics, data science or a related technical...

  • Sales Executive

    3 days ago

    Gauteng, South Africa Kallvest Cleaning and Security Full time

    **Minimum Requirements and Desired Skills**: - Matric - Diploma in sales and marketing beneficial - Clear Criminal and ITC record - Valid SA Driver’s License and own vehicle - Computer literate on MS Office, with intermediate level Excel and PowerPoint - Experienced in sourcing new business and formulating proposals structured to meet Client Needs...

  • Retail Planner

    2 days ago

    Gauteng, South Africa SGRP Meridian Group Full time

    The Retail planner is responsible for identifying opportunities for stock optimisation and process efficiencies as well as facilitating an effective flow of information and communication between Meridian National personnel and clients. About us... Meridian has developed a proud history of excellence, training each member of our team from the first day on...

  • Case Manager Hbm

    5 days ago

    Gauteng, South Africa Dymaxa Recruitment Full time

    Our client, a non-profit, medical scheme is seeking a **Case Manager HBM** in the Gauteng area. Delivering of cost-effective managed healthcare service to accomplish member satisfaction. **Behavioural Competency** - Strong organizational skills, attention to detail and ability to prioritize. - Strong communication skills in English and Afrikaans. - Ability...