Analytics Engineer: Data Pipelines & Modeling

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

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.