Analytical Engineer

Design, build, and maintain data models and orchestrated pipelines for a defined domain; translate requirements into documented data flows and reusable models, add tests and observability, tune cost and performance and keep datasets timely and well-documented. Mentors and guides junior Analytics Engineers.

Undergraduate Degree

General Experience: Experience enables job holder to deal with the majority of situations and to advise others (Over 3 years to 6 years)

Managerial Experience: Experience of general supervision of more junior colleagues (7 to 12 months)

Advanced SQL skills including understanding of window functions and set operators.

Basic Python.

Understanding DataVault, dimensional or relational models.

Good communications skills and an assertive personality.

Intermediate python skills (object orientated to do automated testing and validation frameworks)

Strong understanding of PY-Spark

Working in a data warehouse.

Databricks or Fabric certification (not introduction but Data Analyst or Data Engineer).

Modelling experience.

Understanding parquet files and delta tables in cloud.

Analytics Engineering Alignment

Drive understanding of the purpose, behaviour and user interactions with the data to optimise self-service offerings and improve Nedbank users' experience in accessing data, provide support to users in understanding and accessing data.

Provide overall Data Management Guidance and alignment to Nedbank's Data Management frameworks and standards.

Support the achievement of the Nedbank data strategy, data architecture roadmap, business strategy, objectives and values.

Design Data and Conceptual Modelling

Displays a deep understanding of business data and information requirements, the related data flow, business processes and systems that generate the data required as well as the properties, profile and behaviour of the data.

Partner with stakeholders to lead discovery and prioritisation, translate requirements into a data-product backlog with data contracts and acceptance criteria, manage trade-offs and ensure delivery aligns to measurable outcomes and SLAs.

Collaborate with various teams including Data Modelers, Data Engineers, Data Architects and Data Governance to align data discovery insights and implement complex data solutions.

Has an intermediate understanding of Data, Object Oriented, Data Vault, Relational and Dimensional modelling concepts and techniques.

Data Architecture

Design, build, and maintain scalable data architecture, including data models, schemas and metadata, to support efficient data storage, retrieval, and analysis.

Oversee data collection mechanisms and how they fit into data architecture, partnering with internal and external stakeholders to ensure quality and accuracy.

Continuously refine data analysis techniques and explore new techniques, be familiar with all the tools and systems within the Nedbank Data Ecosystem, and enhance the quality of work.

Databases Specifications

Approve database specifications, ensuring all agreed standards and protocols are followed and data integrity is preserved.

Perform data testing and validation activities such as error resolution and data quality validation end to end through the data lifecycle.

Provide detailed data specifications for downstream engineering tasks.

Use data profiling techniques, contribute to the definition of data standards, identify potential data quality issues, report on and propose possible solutions.

Databases Installation

Data Pipelines

Build and maintain simple data pipelines to efficiently extract data from multiple sources, in multiple formats and structures, and load target systems, whilst transforming data to a common model or structure, to provide data in a consistent, useable format to Nedbank data stakeholders.

Automate, monitor and improve the performance of data pipelines.

Ensure that data lineage is implemented in the metadata hub for all data pipelines built.

Ensure that data validation and reconciliation checks are implemented in the data pipelines to maintain a high level of data accuracy, consistency and security.

Install and test complex databases and associated products to ensure they are suitable for use and meet customer requirements.

Build and maintain APIs in collaboration with Data and/or Software Engineers.

Has an Intermediate understanding of the utilisation and adoption of Cloud Technologies and platforms in database Installation.

Data Protection

Ensure that all work adheres to regulatory requirements, maintaining compliance with all relevant data policies, privacy standards, and ownership guidelines.