Data Engineer

PBT Group; Cape Town; On-site; ZAR 500 000 - 700 000; Full time

Job summary

A prominent technology solutions provider in Cape Town is seeking an Intermediate Data Engineer with expertise in AWS, SQL, and Cobol. Responsibilities include designing ETL processes, providing support, and ensuring data quality. The ideal candidate will have a B.Sc. or related degree and over 5 years of programming experience. Competitive salary and opportunities for career growth in a dynamic environment offered.

Qualifications

• 5+ years programming experience is required.

Responsibilities

• Design, develop, test, and deploy ETL for ODS and data mart projects.
• Provide technical support on ETL and database related issues.
• Research and evaluate IT solutions to meet management information needs.
• Perform root cause analysis and application related issues.
• Review IT work products for completeness and quality.
• Translate business requirements to technical documentation.
• Analyse and map data from source systems to data marts.
• Provide application support in production.
• Code or folder migration as part of release management.
• Participate in quality assurance processes.
• Involve in systems integration and user acceptance testing.

Skills

Modular system design skills

AWS

SQL

Oracle

Legacy systems

Infrastructure

Cobol

Data warehouse modeling

System analysis and design

ETL tools expertise

Organisational skills

Interpersonal communication

Decision making

Problem solving

Education

Relevant data warehouse and BI solution training

B.Sc. or related degree

Job description

PBT Group has a requirement for an intermediate Data Engineer skilled in AWS, SQL, Oracle, legacy systems, infrastructure, and Cobol.

Responsibilities

• Design, develop, test and deploy ETL for ODS and data mart projects, as well as application and management reports.
• Provide technical support, troubleshooting and upgrade setup or support on ETL and database related issues.
• Research and evaluate alternative IT solutions to make appropriate recommendations to meet the business needs for management information.
• Perform root cause analysis, performance monitoring and application related issues.
• Review IT work products from the team members for completeness and quality.
• Accurately translate business requirement to technical documentation and test case or results.
• Analyse and map data from source systems to target operational data stores and data marts.
• Maintain and provide application support in production.
• Code or folder migration from one environment to another as part of release management.
• Participation in all aspects of quality assurance.
• Active participation in systems integration and user acceptance testing.

Required Skills

• Strong modular system design skills.
• Solid working experience in AWS, SQL, Oracle, legacy systems, infrastructure, Cobol
• Conventional and data warehouse modeling skills are required, in order to understand the various data models and to define the mappings between them.
• System analysis and design skills are necessary to design and document the data extractions and transformations.
• Expert knowledge of the capabilities of the ETL tools being used, to know what their capabilities and shortcomings are – in order to exploit or avoid those aspects in the ETL program designs.
• Good organisation, planning and basic management skills.
• Good interpersonal and communication skills.
• Decision making and problem solving skills.

Required Qualifications / Training

• Relevant data warehouse and BI solution training is essential.
• B.Sc. or related degree is advantageous.
• 5+ years programming experience.
• In order to comply with the POPI Act, for future career opportunities, we require your permission to maintain your personal details on our database. By completing and returning this form you give PBT your consent