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
