Analytics Engineer (OVA5693)

Ovations Talent Sourcing; Johannesburg; Hybrid; ZAR 600,000 - 900,000; Full time

Job summary

Ovations Talent Sourcing is seeking an experienced Analytics Engineer to design, build and maintain data models and orchestrated pipelines in a complex enterprise data environment.

You will translate business requirements into data flows, implement testing and observability, optimize cost and performance, and mentor junior engineers while collaborating with Data Engineers, Architects and Governance teams.

Qualifications

• Translate business requirements into data models and data contracts.
• Design scalable data models, schemas and pipelines.
• Mentor junior Analytics Engineers and collaborate with teams.
• Ensure data governance and regulatory compliance across data assets.
• Develop observable, testable data products with quality checks.

Responsibilities

• Design, build and maintain scalable data models, schemas, metadata and data pipelines.
• Translate business requirements into data-product backlogs, data contracts and acceptance criteria.
• Partner with stakeholders to understand data requirements, user interactions and business outcomes.
• Provide Data Management guidance aligned to organisational frameworks, standards and data strategy.
• Collaborate with Data Modelers, Data Engineers, Data Architects and Data Governance teams.
• Apply Data Vault, Relational, Dimensional and Object-Oriented modelling concepts.
• Design and maintain data architecture supporting efficient storage, retrieval and analysis.
• Perform data profiling, testing, validation and reconciliation throughout the data lifecycle.
• Identify and resolve data quality issues and contribute to data standards.
• Build and maintain APIs in collaboration with Data and Software Engineers.
• Build and maintain data pipelines that extract, transform and load data from multiple sources and formats.
• Automate, monitor and optimise pipeline performance.
• Implement data lineage within the metadata environment.
• Ensure validation and reconciliation checks are incorporated into data pipelines.
• Support cloud technology adoption within database and data environments.
• Ensure compliance with data protection, privacy, regulatory and data governance requirements.
• Enable stakeholders to access and use governed data for self-service insights.
• Develop reliable datasets, metrics and APIs and ensure they are documented, secured and monitored.
• Provide technical guidance and mentorship to junior Analytics Engineers.

Skills

Data modelling

Data architecture

Data Vault modelling

Relational modelling

Dimensional modelling

ETL / Data pipelines

Data quality and validation

Data governance

Metadata & data lineage

API design & data contracts

Cloud data platforms

Database design & management

Education

Undergraduate Degree

Job description

Hiring: Analytics Engineer

Location: Johannesburg-Hybrid

Employment Type: 12 Months Independent Contract

Industry: Banking / Financial Services

We are looking for an experienced Analytics Engineer to design, build and maintain data models and orchestrated data pipelines within a complex enterprise data environment.

The successful candidate will translate business and data requirements into documented data flows and reusable data models, implement testing and observability, optimise cost and performance, and ensure datasets remain timely, accurate and well documented.

You will also mentor and guide junior Analytics Engineers while working closely with Data Engineers, Data Architects, Data Modelers and Data Governance teams.

Key Responsibilities

• Design, build and maintain scalable data models, schemas, metadata and data pipelines.
• Translate business requirements into data-product backlogs, data contracts and acceptance criteria.
• Partner with stakeholders to understand data requirements, user interactions and business outcomes.
• Provide Data Management guidance aligned to organisational frameworks, standards and data strategy.
• Collaborate with Data Modelers, Data Engineers, Data Architects and Data Governance teams.
• Apply Data Vault, Relational, Dimensional and Object-Oriented modelling concepts.
• Design and maintain data architecture supporting efficient storage, retrieval and analysis.
• Perform data profiling, testing, validation and reconciliation throughout the data lifecycle.
• Identify and resolve data quality issues and contribute to data standards.
• Build and maintain APIs in collaboration with Data and Software Engineers.
• Build and maintain data pipelines that extract, transform and load data from multiple sources and formats.
• Automate, monitor and optimise pipeline performance.
• Implement data lineage within the metadata environment.
• Ensure validation and reconciliation checks are incorporated into data pipelines.
• Support cloud technology adoption within database and data environments.
• Ensure compliance with data protection, privacy, regulatory and data governance requirements.
• Enable stakeholders to access and use governed data for self-service insights.
• Develop reliable datasets, metrics and APIs and ensure they are documented, secured and monitored.
• Provide technical guidance and mentorship to junior Analytics Engineers.

Technical Expertise

• Data Products & Self-Service Insights
• Data Modelling & Data Architecture
• Data Vault, Relational & Dimensional Modelling
• Data Pipelines / ETL
• Data Quality & Validation
• Data Governance
• Data Visualisation
• Data Contracts & APIs
• Metadata & Data Lineage
• Cloud Data Platforms
• Database Design & Management

Essential Requirements:

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

Behavioural Competencies

We are looking for someone who:

• Collaborates effectively with stakeholders and technical teams.
• Ensures Accountability and consistently delivers on commitments.
• Optimises Work Processes and continuously looks for ways to improve efficiency.
• Demonstrates strong Decision Quality and sound judgement.
• Manages Complexity and can analyse complex data and business requirements.
• Communicates clearly and works effectively across multidisciplinary teams.