Standard Bank

Data Engineer

Job description

Overview

    Job ID:

    60319

    Job Sector:

    Banking

    Country:

    South Africa

    Region/State/Province/District:

    Gauteng

    Location:

    Johannesburg - 5 Simmonds Street

    Work Arrangement:

    Fully Office Based

Job Details

Real Estate: identifying new premises, locations and buildings, leasing real estate, buying and selling property, construction and maintenance.

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 tasks and define the technology components that best deliver to user stories, in the context of epics, by conducting the following activities:
  • 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 2
• 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

Minimum Qualification and Experience

  • BSc Degree
  • Certification in MS SQL (including SSRS, SSAS and SSIS)
  • 5-7 Years experience in Building databases, warehouses and reporting solutions
  • 5-7 Years experience in Building data integration solutions
  • 1-2 Years experience in Operating within an agile team
  • 1-2 Years experience in Working with Risk Management data in Financial Services industry
  • Development: The design, creation, testing and documenting of new and amended programs from supplied specifications in accordance with agreed standards.
  • 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.
  • Use of Build Automation: The ability to use script builders as well as other related automation like continuous integration, automated deployments, and static code analysis tools.

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

Please let the company know that you found this position on this Job Board as a way to support us, so we can keep posting cool jobs.