Etl Developer

2 weeks ago

South Africa Sanlam Limited Full time
Press Tab to Move to Skip to Content Link
Select how often (in days) to receive an alert: Create Alert

Location:
Bellville, Western Cape, South Africa

The Business Intelligence team within Santam BITS (Business Information Technology Services) has a position available for a Data Warehouse Developer (ETL), who will be based in Bellville, Cape Town or Johannesburg JOB DESCRIPTIONThe main responsibility of this role is to make the source system data available in the warehouse, using either in-house developed or off-the-shelf ETL tools.

This role ensures that the data warehouse is populated with timely, accurate and complete data, adhering to the Data Warehouse design principles and methodologies.

Required to work under general direction within a clearly defined accountability framework Extract, Transform & Load information, according to requirements, using the defined metadataEstimate the effort involved to perform project tasks (per specification)Develop according to the Data Warehouse Architecture principles and standardsDevelop in accordance with the Systems Development Methodologies and Frameworks Create and maintain complete documentation as required throughout the Systems Development Life Cycle (SDLC)Perform Impact Analysis/Assessments to ensure interrelationships between programs are considered for every change.

Jobs & programs must be developed in a structured manner to ensure optimal data warehouse performance Unit, integration & performance testing of delivered code Problem solving and root cause analysis of errors in production Pro-actively document programming shortfalls and resolutions for future reference Quality Assurance & Governance Component

Ensure that developed code and SDLC artefacts adhere to the systems design standards and methodologiesEnsure integrity and delivery of data from the source systems to the target system/sCompliance to Data Management Service Level Agreements (SLA) with businessEnsure that source data quality issues affecting the warehouse are escalated via the correct channelEnsure compliance to Data Management policies and proceduresReport non-compliance to ManagementAdhere to change approval process to initiate changes in production.

Responsible for quality of information on change request and could be asked to present change to the Change Approval Board (CAB).

Additional Responsibilities
Responsibilities may require evening and weekend work in response to needs of the systems being supported or ad-hoc project requirements After-hours support according to standby schedulQUALIFICATIONS AND EXPERIENCERelevant Tertiary IT Qualification or Qualification through experience Certificate or Diploma in Data Warehousing from industry recognised Training Institution will be an advantageAt least 2 years of IT experienceAt least 2 years of experience in a Data Warehouse Environment Experience in business, data and application analysis for data integrationExperience in ETL development, testing, deployment and post-deployment stabilisation
SKILLSTechnically strong in ETL concept, design and development especially around data warehousingQuality Assurance / Testing skillsAbility to build and maintain inter-personal relationships Verbal and written communication Methodical, systematic, organised and pay attention to detail Analytical capabilitiesFault finding and problem solving capabilitiesInformation seekingConceptual thinkingInitiativeA self-motivated personality, and able to work efficiently by himself/herself, as well as, in a teamKNOWLEDGEGood Data Warehousing knowledgeIndustry best practice knowledge for coding (ETL) and technical warehouse solutionsData modelling knowledge (Dimensional)

Sound knowledge of IT Systems Development Life Cycles (SDLCKnowledge of the following will be an advantage:
COMPETENCIESClient focusDrives ResultsFlexibility and adaptabilityCompetent in problem solving and troubleshootingPrioritising objectives and planningData WarehousingQuality, Compliance and AccreditationApplying expertise and technology
ABOUT THE COMPANYSantam is the leading short-term insurer in South Africa. Along with its subsidiaries, the business transacts all classes of short-term insurance. Santam is a large, diversified, and transforming company and our success is rooted in our passion for our clients. Everything we do is centered on our delivery of Insurance Good and Proper.
Please note this appointment will be made in line with the Divisional Employment Equity targets. People with disabilities are welcome to apply
#J-18808-Ljbffr

  • Python Developer

    2 weeks ago

    South Africa Scoutit Full time

    These jobs were popular with other job seekers ScoutIT Python Developer / Data Engineer, Gauteng, R100k pm Be an early applicant Hybrid Permanent, Fixed Term Full Time Published: 13 hours ago R80k to R100k pm Non EE/AA Easy apply IntroductionThis is a great role for an engineer that has a passion for data but also the ability to make an impact with their...

  • Data Engineer

    2 weeks ago

    South Africa Network Finance Full time

    As part of our dynamic team, you'll collaborate across projects, liaising with various stakeholders to ensure accurate translation of requirements into system developments. Your focus will center on designing, building, and supporting data integration solutions across diverse internal and external systems, spanning multiple data types and network...

  • Data Scientist Gauteng

    2 weeks ago

    South Africa Professional Career Services - Gauteng Full time

    These jobs were popular with other job seekersRef: TJ ETL DEVELOPER/DATA INTEGRATOR/DATA SCIENTIST – LEADEmployer DescriptionIT consulting company with the focus on BI & Data ManagementDuties & ResponsibilitiesJob DescriptionLiaise with the Practice Principal re progress on allocated deliverablesDraw up job cards for the deliverablesAttend daily project...

  • Bi Operations Manager

    2 weeks ago

    South Africa Sanlam Full time

    Role Overview: As a BI Operations Manager, you will play a pivotal role in ensuring establishing the operation of our business intelligence (BI) data hubs and vaults. Your responsibilities will include defining the monitoring batch processes, optimizing data loading procedures, managing data incidents, and collaborating with technical teams to maintain...

  • Senior Bi Devops Engineer

    2 weeks ago

    South Africa Sanlam Limited Full time

    Press Tab to Move to Skip to Content Link Select how often (in days) to receive an alert: Create Alert Date: 17 May 2024Location: Bellville, Western Cape, South Africa Santam's Guidewire BI DataHub team is looking for a Senior DevOps Engineer, with a solid Solution Architecture background.JOB DESCRIPTIONThe incumbent will work with the broader BI Team,...

  • Data Engineer

    2 weeks ago

    South Africa Communicate Finance Full time

    I specialize in placing top talent in the IT Industry and my clients are constantly looking for Data Engineers with hands-on experience and a stable track record. I will assist you in exploring opportunities to grow your career with top-notch employers of Cape Town, where your ability can be enhanced and grow towards being the best in your field.Skills &...

  • Business Intelligence

    2 weeks ago

    South Africa Network Recruitment Full time

    Are you passionate about transforming data into actionable insights? Do you thrive on solving complex business challenges through analytics and visualization? If so, we have an exciting opportunity for you to join our client's dynamic team Job Description:The BI Analyst will play a pivotal role in crafting and refining the company's BI infrastructure to...

  • AWS Data Cloud Engineer

    1 month ago

    Johannesburg, Gauteng, South Africa GoldenRule Technology (Pty) Ltd Full time

    The RoleA leader in the insurance space is on the lookout for a AWS Data Cloud Engineer (big Data Engineer)Skills And ExperienceKnowledge /Qualifications High knowledge in AWS – security groups, permissions, VPC, roles, services.Experience developing engineering applications in Corporate companiesDemonstrated project development and leadership...

  • DaaS – Data Analyst

    2 weeks ago

    Johannesburg, City of Johannesburg Metropolitan Municipality, Gauteng, , South Africa FreeRecruit Full time

    Our client is a development company with branches in Stellenbosch and Johannesburg, specialising in the development of cutting-edge agricultural technologies. They are currently searching for a data analyst as part of their data as a service (DaaS) team. The primary goal of the DaaS team is to provide data services, which in turn will generate new revenue...

  • DaaS – Data Analyst

    4 weeks ago

    Johannesburg, City of Johannesburg Metropolitan Municipality, Gauteng, 2001, South Africa FreeRecruit Full time

    Our client is a development company with branches in Stellenbosch and Johannesburg, specialising in the development of cutting-edge agricultural technologies. They are currently searching for a data analyst as part of their data as a service (DaaS) team. The primary goal of the DaaS team is to provide data services, which in turn will generate new revenue...

  • DaaS – Data Analyst

    2 months ago

    Johannesburg, City of Johannesburg Metropolitan Municipality, Gauteng, 2001, South Africa FreeRecruit Full time

    Our client is a development company with branches in Stellenbosch and Johannesburg, specialising in the development of cutting-edge agricultural technologies. They are currently searching for a data analyst as part of their data as a service (DaaS) team. The primary goal of the DaaS team is to provide data services, which in turn will generate new revenue...