Data Engineer: Analytics

Talentsafari

Nairobi, Kenya

On-siteCareer-pivot friendly

Who this role is best for

Geared toward candidates comfortable with end-to-end data modeling and client-facing analytics delivery, with a focus on cloud technologies and East African geography.

Best fit for

Candidates with 3+ years of production data pipeline experience and a track record of client-facing reporting.
— “Minimum 3 years building and maintaining production data pipelines that other teams relied on.”
Individuals who have designed and justified data models with clear reasoning and exclusion criteria.
— “At least one data model you designed: its grain, why you selected that grain, and what you deliberately excluded.”
Professionals who can independently clean and reconcile source data with a system of record.
— “Profile, clean, and reconcile source data before it reaches the reporting layer.”

Things to consider

Certification in data, analytics, or machine learning is mandatory, not optional.
— “Certification required: a current cloud certification within the data, analytics, or machine learning track.”
Candidates must demonstrate experience with dbt in a production environment, not just theoretical knowledge.
— “dbt in a production setting: incremental models, snapshots, tests, and a project structure you designed rather than inherited.”

How to stand out

Showcase a case where you cleaned and reconciled incomplete or inconsistent source data.
— “One instance where source data arrived incomplete, duplicated, or inconsistent, and what you did to make it reliable enough to report on.”
Emphasize your ability to present analytics findings to non-technical stakeholders clearly.
— “Presentation of data: turning a result into a clear chart, a written finding, and a recommendation that a non-technical audience can act on.”
Demonstrate your advanced SQL skills with concrete examples, not just proficiency statements.
— “Advanced SQL: window functions, CTEs, set logic and aggregation at the correct grain, with the ability to read a query plan and explain a performance problem.”
Include specific analytics or reporting projects you delivered and their business impact.
— “Analytics or reporting you delivered, the question it answered, and how the business used it.”

Pace · SteadyCollaboration · MediumAutonomy · MediumDecision Impact · Team

Derived from job-description analysis by Serendipath's career intelligence engine.

What success looks like

successful design and implementation of data models
high-quality data presentation to clients

Typical background

data engineeringdata sciencesoftware engineering

Skills & requirements

Required

Data ModelingSQLPythonData CleaningData TransformationData VisualizationCommunicationPresentation

Preferred

SnowflakedbtMachine LearningCloud Certifications

Stack & domain

Data PipelinesProduction Data PipelinesSQLWindow FunctionsCtesSet LogicAggregationQuery PlanPerformance ProblemRelational DatabaseModellingNormalisationGrainKey RelationshipsSlowly Changing DimensionsDenormalisePythonData CleaningStatisticsPresentationAI ToolsCommunicationCloud CertificationsCloudDataMachine Learning

About the role

Original posting from Talentsafari via Ashby

ABOUT THE COMPANY
Kitsilano Technologies is a leading technology consulting firm based in Kenya, focused on helping organizations accelerate digital transformation through cloud, data, and modern IT solutions.
Kitsilano Technologies designs and delivers data platforms, analytics, and reporting for banks, insurers, manufacturers, and hospitality groups across East Africa. We partner with global technology providers such as AWS and Google Cloud to deliver scalable, secure, and cost-effective solutions that drive real business impact.
ABOUT THE ROLE
We are hiring a data engineer to design the models behind client reporting and to present the results to the client directly. Source systems are rarely clean, and requirements rarely arrive complete.
WHAT YOU WILL DO
Design and build the ingestion, transformation, and modelling layers that client reporting depends on.
Own data models end to end: grain, keys, relationships, history, and testing, with the reasoning documented.
Profile, clean, and reconcile source data before it reaches the reporting layer.
Build the analytics layer that answers the client's questions, and interpret what the results indicate for their business.
Present designs, findings, and recommendations directly to client stakeholders, including non-technical audiences, and contribute to scoping at the pre-sales stage.
Excellent communication and presentation skills
Self-Starter – Motivated – Customer-focused
WHAT YOU HAVE
Minimum 3 years building and maintaining production data pipelines that other teams relied on.
Undergraduate coursework, university and personal projects do not count toward this.
Certification required: a current cloud certification within the data, analytics, or machine learning track.
Certifications outside that track do not satisfy this requirement.
Snowflake SnowPro Core, production Snowflake experience, and machine learning deployed to production are each an advantage.
Advanced SQL: window functions, CTEs, set logic and aggregation at the correct grain, with the ability to read a query plan and explain a performance problem.
Relational database and modelling depth: normalisation, grain, key relationships, slowly changing dimensions, and judgement on when to denormalise.
dbt in a production setting: incremental models, snapshots, tests, and a project structure you designed rather than inherited.
Python for data work: analysis, automation, and acquiring data from databases, APIs, and files, including scraping where no interface is provided.
Data cleaning as an engineering discipline rather than a one-off task: profiling a source, reconciling it against a system of record, and holding it to that standard as it changes.
Quantitative and logical reasoning: statistics sufficient to validate a result, and the discipline to justify a design decision under questioning.
Presentation of data: turning a result into a clear chart, a written finding, and a recommendation that a non-technical audience can act on.
Where AI tools form part of how you work, you are expected to explain and defend every line of output you deliver. We regard them as an accelerator, not a substitute for understanding.
WHAT WE WANT TO SEE IN YOUR CV
The databases, platforms, and tools you worked on directly, the scale of the data, and your own contribution rather than the team's.
At least one data model you designed: its grain, why you selected that grain, and what you deliberately excluded.
One instance where source data arrived incomplete, duplicated, or inconsistent, and what you did to make it reliable enough to report on.
Analytics or reporting you delivered, the question it answered, and how the business used it.
The hardest query or performance problem you have solved, rather than a stated proficiency level.
Certifications held, with the awarding body and current status.
WHAT WE OFFER
The opportunity to work with the leading global OEMs and their technologies.
Ongoing professional development, with certifications supported and funded.
Career growth within a rapidly expanding technology consulting firm.

Source: Talentsafari careers (Ashby)