Data Engineer / Modeller Full Time Permanent

Data Engineer / Modeller – Cape Town

A Data Engineer / Modeller position is available in Cape Town, western Cape, South Africa.

PBT Group has an opportunity for a Data Engineer in the Financial Services sector.

The Data Engineer / Modeller will essentially be responsible:

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.

Required Skills, Knowledge & Experience – Data Engineer / Modeller:

At least 4 – 6 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
Solid understanding of:
- Banking systems environment
- Banking business model
- Best practices for Quality Assurance (QA)
Must have detailed knowledge of:
- IT systems development processes (SDLC)
- Application development
- ETL processes
- Rational database system and cloud data warehousing
- Dimensional modelling
- Standards and governance
- Agile development life cycle
- Testing practices

Preferred Skills, Knowledge & Experience – Data Engineer / Modeller:

Python and Open-Source Development tools
Visualisation Technologies: MS PowerBI, AWS QuickSight
Cloud Environment
Data analysis and design
Data architecture (technical design and implementation processes)
DPLC
Experience working in an AWS environment as well as with AWS Technologies
Participation in PBT Graduate Programme / Training / Skills Development, PBT Academy, e.g. Data Engineering, BI Business Analysis, Data Modelling

Qualifications / Certification – Data Engineer / Modeller:

A degree in Computer Science / Information Systems / Business Administration / Commerce or Data Analysis

Preferred:

Duties – Data Engineer / Modeller:

Development and Design:

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

Testing:

Perform unit and integration testing on existing environments and developments in line with the DPLC.
Update / amend test packs 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 solution design document.
Provide support to the development, Quality Assurance (QA) and production environments including standby duties, and responding to and resolving issues.

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 solution design through guidance from the Architect, ensuring clear understanding of requirements.
Assist the Architect with the compilation of the technical solution design documentation.
Provide technical input to the Architect during the compilation of technical solution design documentation for new and existing products and services.
Use the technical solution design documentation for product and system development according to development and best practice standards.
Develop rational database system and cloud data warehousing.
Provide implementation instructions for all developments.

Research and Continuous improvement:

Participate in knowledge-transfer sessions facilitated by Architect.
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.)

Stakeholder Engagement:

Coordinate handover of technical knowledge (process flow and design) during knowledge transfer process.

Quality Assurance:

Develop new products for specific projects with guidance from the project technical lead.
Contribute to the function and organisation through technical expertise, knowledge, and skills.

Level of Complexity:

Share 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.

Autonomy:

Share knowledge, and guide and mentor junior Data Engineers.
Help interpret and execute functional business plan and influence delivery plan.