Back
Jun 22, 2021

Data Engineer / Analyst Developer

  • GEOTECH
  • Sandton, Gauteng, South Africa
Full time Engineering

Job Description

Duties & Responsibilities:

Department Data & Analytics

Minimum:

At least 2 years’ proven experience within management information systems / systems analysis together with a relevant 3 year tertiary qualification (degree / diploma)
OR

At least 2 - 4 years’ proven experience within management information systems / system analysis
Proven experience in:
SQL Server and / or business intelligence tools (SSIS, SSRS, SSAS)
Data Warehousing
Data Management Lifecycle
Ideal:

Proven experience in:
.Net Development
Visualization Technologies: PowerBI, Qlikview
Python
Cloud Environment
PURPOSE

To contribute to the design and development of new applications / systems to meet the business requirements of the D&A environment.
To analyse business or system requirements and data to enhance understanding of the D&A environment
Participate in and provide input to the Architect during the compilation of solution design documentation (technical specification) for new and existing D&A products and systems
KEY PERFORMANCE AREAS

Development & Design
Testing
Projects
Research and continuous improvement

KEY TASKS & ACCOUNTABILITIES

The role of Data Engineer involves generic technical tasks and responsibilities. There are distinct levels within the job which are defined by experience, skills, autonomy and the level at which the incumbent operates and contributes. Three levels have been identified for the function: Level I, Level II and Level III.

Level III is sometimes referred to as ‘Analyst Developer’ in the industry.

Generic tasks and responsibilities:

1. Development & Design

Gain an understanding of the functional description and technical specification through guidance from the Architect, ensuring clear understanding of requirements.
Apply analysis requirements for product & system development according to development best practice standards, the Data Product Life Cycle (DPLC) and CB Way of Work (WoW) agile process to:
Develop enhancements for existing products to requirements.
Develop rational database systems to the required standard and as contracted with the team in terms of the WoW.
Provide implementation instructions to the team for any new developments.
2. Testing

Perform unit and integration testing on existing environments and new developments in line with the DPLC.
Update / amend test plans according to solution development to ensure coverage of all areas
Fix minor and major bugs for the products in the D&A environment
Fix escalated bugs for existing products in the D&A environment from provided technical specifications
Provide support to the development, QA and production environments including stand-by duties; responding to and resolving issues.
3. Projects

Provision Data Engineering support for specific value stream projects through the design and development of new products:
Gain an understanding of the functional description and technical specification through guidance from the Architect, ensuring clear understanding of requirements.
Assist the Architect with the compilation of the Technical Specification (solution design documentation) using Unified Mark-up Language (UML.)
Provide technical input to the Architect during the compilation of technical specifications for new and existing products and services.
Use the Technical Specification for product & system development according to development & best practice standards
Develop rational database systems
Provide implementation instructions for new developments
Level I & II: Develop new products for specific projects with guidance from the project technical lead.
Level III : Perform as the technical lead on projects:
Provide technical expertise and input with regards to D&A during projects
Provide guidance to junior data engineers wrt D&A during projects
4. Research and Continuous improvement

Participate in knowledge transfer sessions facilitated by Architect
Level I: Collaborate during knowledge transfer process
Level II & III: Coordinate handover of technical knowledge (process flow and design) during knowledge transfer process
Take ownership to improve own technical knowledge about the D&A database and data warehouse environment.
Stay current with developments in areas of technology that are relevant to the D&A environment (i.e. MS SQL, Database servers, Source control tools, Testing tools, bug tracking tools, etc.)
Level descriptors:

Data Engineer I

Grade 12

A relevant 3 year tertiary qualification (degree / diploma) and at least 2 years’ proven experience within management information systems / systems analysis

OR

At least 2 - 4 years’ proven experience within management information systems / system analysis.

Works at a level in which the processes are defined and decision making is restricted to the procedures. The incumbent will refer to more senior Data Engineers for guidance.

Experience on the job is necessary to enable the incumbent to make satisfactory decisions about unforeseen circumstances.

Key Competencies:

Applying Expertise and Technology, Delivering Results and Meeting Customer Expectations, Following Instructions and Procedures, Learning and Researching.
Applies working knowledge and experience of Data analysis and synthesis, Data development process, Data integration design and Data modelling including tools and techniques, adopting those most appropriate for the environment
Data Engineer II

Grade 12

A relevant 3 year tertiary qualification (degree / diploma) and at least 4 years’ proven experience within management information systems / systems analysis

OR

At least 4-6 years’ proven experience within management information systems / system analysis.

Contributes to the function and organisation through their technical expertise, knowledge and skills. Knowledge shares; guides and mentors junior Data Engineers. At this level the role helps interpret and execute functional business plans and influence delivery plan.

Key Competencies:

Deciding and Initiating Action, Applying Expertise and Technology, Delivering Results and Meeting Customer Expectations, Planning and Organising, Relating and Networking, Learning and Researching
Shares knowledge and experience of Data analysis and synthesis, Data development process, Data integration design and Data modelling, including tools and techniques, defining those most appropriate for the environment, task or project.
Data Engineer III (Industry title: Analyst Developer)

Grade 12

A relevant 3 year tertiary qualification (degree / diploma) and at least 6 years’ proven experience within management information systems / systems analysis

OR

At least 6 - 8 years’ proven experience within management information systems / system analysis.

Contributes to the organisation through specialist expertise, knowledge and skills.

Provides technical expertise, support and training and development to other Data Engineers in the function.

Required to operate autonomously and independently of the Architect and BIBA (stand alone).

The type of work is similar to levels I and II but the complexity leve and scope are greater and a proactive, initiating approach is required.

Key Competencies:

Deciding and Initiating Action, Applying Expertise and Technology, Delivering Results and Meeting Customer Expectations, Planning and Organising, Relating and Networking, Formulating Strategies and Concepts, Learning and Researching, Leading & Supervising.
Is a recognised specialist and advisor in Data analysis and synthesis, Data development process, Data integration design and Data modelling including user needs, generation of ideas, methods, tools and leading or guiding others in best practice use.
At this level the role provides input to the overall strategy of the function and translates functional strategy into business plans.
KNOWLEDGE

Minimum:

Must have detailed knowledge of:

o IT systems development processes (SDLC)

o Application development

o ETL processes

o Relational database technologies

o Dimensional modelling

o Standards and governance

o Agile development life cycle

o Testing practices

Ideal:

• Knowledge of:

o Data analysis and design

o Data architecture (technical design and implementation processes)

o DPLC

• Solid understanding of:

o Banking systems environment

o Banking business model

o Best practices for Quality Assurance (QA)

Interested?
To apply for this opportunity, submit your upated and detailed CV with cover letter / profile to


Apply Now