Data Engineer II

Boardroom Appointments; Stellenbosch; On-site; ZAR 700,000 - 1,100,000; Full time

Job summary

Boardroom Appointments in Stellenbosch is seeking a senior BI/MIS analyst to design and develop new applications and systems for the Data & Analytics environment. You will analyse business and data requirements, contribute to solution design documentation with the Architect, and work on ETL processes, data modelling and data warehousing using SQL Server and cloud technologies (AWS).

Candidates should have 6+ years MIS / systems analysis with IT or Data Analysis qualifications and experience in

Qualifications

• Relevant tertiary qualification required.
• Experience in MIS / systems analysis with 6+ years.

Responsibilities

• To contribute to the design and development of new applications / systems to meet the business requirements of the Data and Analytics (D&A) environment.
• To analyse business or system requirements and data to enhance understanding of the D&A environment.
• To participate in and provide input to the Architect during the compilation of solution design documentation for new and existing D&A products and systems

Skills

Python

Open Source development tools

Cloud environments

AWS

ETL processes

Data analysis

Data architecture

QA/testing practices

Data modelling

Relational databases

Education

Tertiary qualification in Information Technology or Data Analysis

Information Technology - Computer Science or Data Analysis (Ideal)

3 year tertiary qualification

Tools

SSIS

SSRS

SSAS

Data warehousing

Job description

• A relevant tertiary qualification in Information Technology or Data Analysis
• A relevant tertiary qualification in Information Technology - Computer Science or Data Analysis (Ideal)
• At least 6 years proven experience within management information systems / systems analysis together with a relevant 3 year tertiary qualification

OR

• At least 6 - 8 years proven experience within management information systems / system analysis
• SQL Server and / or business intelligence tools (SSIS, SSRS, SSAS)
• Data Warehousing
• Data Management Lifecycle

Knowledge:

• Python and/or Open Source development tools
• Cloud Environment
• Experience working in an AWS environment as well as with AWS Technologies
• Participation in PBT Graduate Programme / Training / Skills Development, PBT Academy, e.g. Dat Engineering, BI Business Analysis, Data Modelling
• ETL processes
• Rational database system and cloud data warehousing
• Standards and governance
• Testing practices
• Data analysis and design
• Data architecture (technical design and implementation processes)
• Banking business model
• Best practices for Quality Assurance (QA)

Responsibilities:

• To contribute to the design and development of new applications / systems to meet the business requirements of the Data and Analytics (D&A) environment.
• To analyse business or system requirements and data to enhance understanding of the D&A environment.
• To participate in and provide input to the Architect during the compilation of solution design documentation for new and existing D&A products and systems