Analytical Engineer

Nedbank

Johannesburg

On-site

ZAR 700,000 - 1,100,000

Full time

5 days ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

Nedbank is seeking an Analytics Engineer to design, build and maintain scalable data models, pipelines and metadata within Nedbank's Data Ecosystem. You will translate business requirements into data flows, implement tests, observability and ensure data quality across domains.

You will mentor junior analysts, collaborate with data architects and engineers, and help optimise self-service analytics for Nedbank users. A strong foundation in SQL, Python and data modeling is essential.

Qualifications

  • Undergraduate degree required.
  • Advanced SQL with window functions.
  • Basic Python knowledge.
  • Understanding Data Vault, dimensional or relational models.
  • Strong communication and assertive personality.

Responsibilities

  • Design, build, and maintain data models and pipelines for Nedbank's data domain.
  • Mentor junior Analytics Engineers and guide data governance.
  • Translate requirements into data-product backlogs with data contracts and acceptance criteria.
  • Collaborate with Data Modelers, Data Engineers, Data Architects and Data Governance.

Skills

Advanced SQL
Python basics
PySpark
Data warehouse
Communication

Education

Undergraduate Degree

Tools

Databricks
Fabric certification
Delta tables
Parquet files

Job description

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.

Job Responsibilities
  • 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.
  • 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.
Job Responsibilities Continue
  • 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.
  • 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.
Beneficial Experience
  • 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).
  • Understanding parquet files and delta tables in cloud.
Technical Expertise
  • Enabling Self-Service Insights: Works with full competence to create intuitive, governed data models and metrics, document them and empower stakeholders to self-serve insights. Typically works without supervision and may provide technical guidance.
  • Build Data Products: Works with full competence to create reliable datasets/metrics/APIs, document and permission them, deploy to users, monitor and improve. Typically works without supervision and may provide technical guidance.
  • Design Data Products: Works at an advanced level to discover user needs, define value and outcomes, specify data contracts, success metrics and plan the roadmap. Typically works independently and provides guidance.
  • Data Visualisation: Works at an advanced level to select the best data visualising tools to create accessible and accurate visuals and to turn these into a clear narrative, highlighting what matters and guide decisions. Typically works independently and provides guidance.

Data Governance Principles: Works with full competence to manage data in accordance with the organisation's data governance protocols, including sourcing, handling, classifying, storing, monitoring, extracting, loading, transporting and securing relevant data, while understanding and applying data quality principles to enhance the accuracy, consistency, and reliability of organisational data. Typically works without supervision and may provide technical guidance.

  • Business Data Modelling: Works with full competence to conduct activities to collect, analyse, diagram (model) and report information and data flow, including state changes, to help make strategic decisions, achieve major goals, and solve complex problems. Typically works without supervision and may provide technical guidance.

---------------------------------------------------------------------------------------

Nedbank Ltd Reg No 1951/000009/06.
Authorised financial services and registered credit provider (NCRCP16).

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Senior Analytics Engineer
Senior Analytics Engineer

Nedbank • Gauteng

On-site
ZAR 600,000 - 800,000
Professional development opportunities
Flexible work hours
Performance bonuses
Data Engineer
Data Engineer

Nedbank • Johannesburg

On-site
ZAR 900,000 - 1,200,000
Senior Data Scientist
Senior Data Scientist

Nedbank • Johannesburg

On-site
ZAR 700,000 - 900,000
Quantitative Data Analyst
Quantitative Data Analyst

Nedbank • Johannesburg

On-site
ZAR 600,000 - 900,000
Senior Data Scientist
Senior Data Scientist

Nedbank • Johannesburg

On-site
ZAR 800,000 - 1,200,000
Analytics Engineer: Data Products & Self-Service
Analytics Engineer: Data Products & Self-Service

Nedbank • Johannesburg

On-site
ZAR 700,000 - 1,100,000
BI Data Analyst
BI Data Analyst

Nedbank • Johannesburg

On-site
ZAR 300,000 - 600,000
Data Engineer Jhb - Northern Suburbs
Data Engineer Jhb - Northern Suburbs

Psybergate • Johannesburg

On-site
ZAR 1,000,000 - 1,500,000
AI Engineer
AI Engineer

Nedbank • Johannesburg

On-site
ZAR 1,200,000 - 1,800,000
Systems Risk Specialist
Systems Risk Specialist

Nedbank • Sandton

On-site
ZAR 600,000 - 800,000