Data Engineer » EltasJobs

Overview

Job ID:

49745

Job Sector:

Banking

Country:

South Africa

Region/State/Province/District:

Gauteng

Location:

Rosebank

Job Details

Information Technology: systems development, business analysis, architecture, project management, data warehousing, infrastructure, maintenance and production

Job Purpose

The purpose of this role is to construct data acquisition, warehousing and reporting solutions.

The role is expected to provide technical solutions in response to the needs of stakeholders by interpreting business requirements; defining solution; defining build and test tasks; constructing solutions; performing testing; participating in the deployment of solutions and ensure the systems meet immediate business requirements by providing third tier support and constructing enhancements to systems in Production.

The role is should construct and document solutions according to applicable architecture, solution designs, standards, policies and governance requirements; utilise DevOps practices and tools as member of an agile team with T-roles; clearly define tasks with delivery effort estimates; contribute effectively to lean management practices and iteration ceremonies; provide third Tier support when required and deliver enhancements to Production systems in the Data Management Feature Team portfolio.

Key Responsibilities/Accountabilities

Define tasks and specify required technology components:

Define a task sequence that delivers value to business promptly by applying lean management, Minimum Viable Product (MVP) and iterative delivery concepts

Ensure tasks are clearly scoped, with defined acceptance criteria, to ensure clarity of what is required to complete work

Define and performing appropriate unit and integration tests to ensure no errors are produced during and after deployments

Define tasks with effective sizing of the effort required to deliver to contribute to predictable delivery and velocity management.

Provide lean documentation to reflect the solution design and capture data management artefacts

Incorporate standard requirements – such as data quality control and future proofing – into task definition and delivery

Ensure applicable standards are addressed in the solution design

Apply best data integration, warehousing and reporting practices while utilising MS SQL 2016 technology.

Construct end to end data service solutions:

Identify data requirements and construct/extend data warehouse solutions (including ETL) to meet business requirements by conducting the following activities:

Construct mechanisms to acquire data from a range of sources with controls that deliver to required data quality standards (e.g. BCBS239).

Apply appropriate continuous integration practices to prevent defects

Build solutions that are aligned with the technology strategy and future proofed through appropriate coding practices

Apply DevOps testing practices as defined for the feature team

Test the solution in terms of the master test plan to ensure no defects are identified post deployment

Meet all governance requirements

Document the solution sufficiently

Engage with the other team members to achieve delivery objectives

Deliver solutions that are robust and future-proofed to reduce waste and manage technology deficit.

Perform work aligned with the team process; meeting governance requirements; and utilising the Continuous Integration toolset:

Team based delivery is the focus of feature team, as opposed to individual performance.

This requires the DE to participate in team practices and deliver to team standards:

Participate in team ceremonies

Perform work which is traditionally performed by non-engineering roles which requires knowledge of other traditional roles (such as business analysis and testing)

Contribute to team performance by identifying and implementing team improvements.

Provide third tier support and enhancement services:

Provide third tier support to the systems in the portfolio to restore availability, within service level agreement performance standards:

Maintain in-depth knowledge of the technology design of the system

Understand accurately and completely the impact of an incident on system functionality and business

Achieve quick response times to incidents through effective cause diagnosis

Prevent recurrence of incidents by identifying and effectively responding to root causes through effective cause diagnosis

Prevent recurrence of incidents by introducing system improvements following from effective root cause analysis

Clear and specific communication to users and other role players regarding the impact and resolution of an incident

Ensure that all incident, problem and change management requirements are met

Deliver enhancements to the system as required by business or in response to opportunities to address technology deficit or enhance solution performance.

Preferred Qualification and Experience

Qualification:

First Degree IT and Computer Sciences

Certification in MS SQL (including SSRS, SSAS and SSIS)

Experience:

5-7 Years – Building databases, warehouses and reporting solutions
5-7 Years – Building data integration solutions
1-2 Years – Operating within an agile team
1-2 Years – Working with Risk Management data in Financial Services industry

Knowledge/Technical Skills/Expertise

Knowledge:

Debugging:

The ability to analyse the behaviour of code to diagnose a problem and find the underlying cause. This includes but is not limited to using a debugger.

Refactoring:

The ability to revise existing code without impacting its functional behaviour.

PLEASE NOTE: All our recruitment and selection processes comply with applicable local laws and regulations. We will never ask for money or any form of payment as part of our recruitment process. If you experience this, please contact our Fraudline on +27 800222050 or forward to TransactionFraudOpsSA@standardbank.co.za