Data Engineer II - Digital Commerce at Capitec Bank

Purpose Statement

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

The job holder has no direct or indirect reports.

• Development and Design.
• Testing.
• Projects.
• Research and continuous improvement.

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 Capitec Bank 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.)

Levels

• 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 Descriptors:

Job Title
Data Engineer III

Stakeholder Engagement

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

Quality Assurance

• Contribute to the organisation through technical expertise, knowledge, and skills.

Level of Complexity

• Complexity level is higher and scope is greater. A proactive, initiating approach is required. 
• Provide input to the overall strategy of the function and translate functional strategy into business plans. 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.

Autonomy

• Operate autonomously and independently of Architect and BIBA (standalone). 
• Perform as the technical lead on projects.
• Provide technical expertise and input, support, guidance and training to other Data Engineers on D&A function and during projects.

Knowledge:

Minimum:

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

Ideal:
Knowledge of:

• Data analysis and design
• Data architecture (technical design and implementation processes)

DPLC
Solid understanding of:

• Banking systems environment
• Banking business model
• Best practices for Quality Assurance (QA)

Experience:

Minimum:

• 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

Proven experience in:

• SQL Server and / or business intelligence tools (SSIS, SSRS, SSAS)
• Data Warehousing
• Data Management Lifecycle 

Ideal:

Proven experience in:

• Python and/or Open Source development tools 
• Visualisation Technologies: MS PowerBI, AWS QuickSight
• 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. Data Engineering, BI Business Analysis, Data Modelling

Education (Minimum)

• Care and passion for our people (Departmental Contributor)
• Earn and extend trust (Departmental Contributor)
• Simplify and make it easy (Departmental Contributor)
• Drive innovation mindset (Departmental Contributor)
• Lead with the "Why" (Departmental Contributor)
• Attract and relentlessly develop people (Departmental Contributor)
• Make decisions - faster and smarter (Departmental Contributor)
• Inspire optimism and persistence (Departmental Contributor)
• A relevant tertiary qualification in Information Technology or Data Analysis
• A relevant tertiary qualification in Information Technology or Data Analysis
• Clear criminal and credit record
• Analytical Skills
• Communications Skills
• Computer Literacy (MS Word, MS Excel, MS Outlook)
• Interpersonal & Relationship management Skills
• Problem solving skills

Education (Ideal or Preferred)

• Care and passion for our people (Departmental Contributor)
• Earn and extend trust (Departmental Contributor)
• Simplify and make it easy (Departmental Contributor)
• Drive innovation mindset (Departmental Contributor)
• Lead with the "Why" (Departmental Contributor)
• Attract and relentlessly develop people (Departmental Contributor)
• Make decisions - faster and smarter (Departmental Contributor)
• Inspire optimism and persistence (Departmental Contributor)
• A relevant tertiary qualification in Information Technology or Data Analysis
• A relevant tertiary qualification in Information Technology or Data Analysis
• Clear criminal and credit record
• Analytical Skills
• Communications Skills
• Computer Literacy (MS Word, MS Excel, MS Outlook)
• Interpersonal & Relationship management Skills
• Problem solving skills