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.Discipline Specific Output / TaskRequired 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 ComponentEnsure 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 ResponsibilitiesResponsibilities 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 Our recruitment process AdvertiseStep 1Our vacancies are advertised between 3-5 days depending on the market availability of the skills required. Our recruitment process Step 2Could take a couple of days depending on the volume and the screening process, which various according to the complexity of the role. Our recruitment process Step 3Long listed candidates are sent to the hiring manager to review and consider for the next stage of the selection process. Our recruitment process Telephonic screeningStep 4Candidates may be contacted for a short screening interview to get to know them better and to ask any clarity seeking questions. Our recruitment process Your interviewStep 5We use a competency interview model. Interview dates will be confirmed via e-mail. During the interview you will be introduced to the panel and the process will be explained. Remain calm and sell yourself. This is our opportunity to match your skills to the job. You only get one shot! Our recruitment process AssessmentStep 6Should we like what you bring to the table, depending on the job you are being considered for, you may be invited to complete a psychometric assessment. Further employment checks are conducted the ensure the validity of your credentials. Our recruitment process Step 7Prior to an offer being made, there may be a second interview to meet with the Head of Department.Should there be a need for any further interviews, be sure to bring the same charm that got you through your first interview. Our recruitment process OnboardingStep 8You made it. Here we ensure we receive all your documents to get you onto our payroll system.TIPS & TRICKSGetting ready for your interviewThere is not just one way to be successful at Santam, nor is there one way to interview with us. Interviewing is a two-way process - it helps us learn about you, and it helps you learn about us, our people, and what you could do here.Santam has been officially recognised by the Top Employers Institute as a Top Employer 2024 for excellence in people practices. This is the eighth consecutive year that we have achieved this accolade.#J-18808-Ljbffr