Job
Title: Data Analytics Engineer
Hiring Organization: Rainforest
Alliance
Location – Locality: Nairobi
Location – Region: Kenya
Industry: Non Profit
Job Type: Full Time
Salary: KES
Date Posted: 06/10/2024
At Rainforest Alliance,
we utilize data to make informed decisions. Through our Data Analytics Platform
(DAP), we provide access to crucial data. The data engineering team is a team
with a primary focus on development of data pipelines, and technical components
of the DAP. This role focuses on ETL data pipeline development. But as a
successful data team we also need data and business analysis skills.
This means there is also space for people who are more focused on data analysis and design or testing, but we expect some technical background as well.
The candidate should
possess most of the technical skills to
Analyse and clarify
requirements with data owners and users
Understand relational
and conceptual information modelling techniques, especially Data Vault and
dimensional modelling.
Build data pipelines
using SQL and scripting languages
Deliver and test data
sets and reports to agreed levels of accuracy and completeness
Design and build data
warehouse components and quality monitoring solutions
Maintain code bases and
tools that make up the data analytics environment
Understand processes
that ensure structured and quality delivery
Responsibilities:
Understand the business
requirements and data models from the source systems that feed the DAP
Develop, maintain and
improve the pipelines into the data analytics platform using procedural SQL,
ETL, data virtualization, and databases
Develop, maintain and
improve the data connections between data sources and the data analytics
platform, using Terraform and Azure tools, together with the data platform
engineer
Follow processes and
maintain version control over the code assets within the data analytics
platform
Be an active participant
in the sprint planning and goal definition activities within the Data
Excellence team
Review process,
architectural, information and data models in collaboration with the Data
Architect, Data Engineers, and the rest of the Data Excellence team
Qualifications:
5 years of relevant data
engineering work experience.
Ability to program in
procedural SQL, and automation using scripting languages
Working experience with
business intelligence platforms, data models, and test case design
Working experience with
Azure server infrastructure and Microsoft databases
Working experience with
Data Vault and dimensional modelling
Experience with
Scrum/Agile methodologies and working independently as a member of a virtual
team
Good communication
skills with the ability to work with both technical and business minded
colleagues.
Pro-active attitude and
an ability to remain organized under deadlines and see projects to completion.
Experience of
environments where improvements led to increased data flow and a reduction of
lead times and errors
English fluency
Nice To Have:
Familiarity with topics
relevant to the work of Rainforest Alliance and certification is a strong plus
Experience with Data
Virtuality software and ANSI SQL
Experience with Azure
SQL Data Warehouse (Synapse)
Experience with Azure
Data Factory
Ability to build reports
and datasets using Power BI, Power Query and DAX
Experience with
designing and consuming Rest API’s for loading data changes from source systems
Ability to program in
.net or Java and work with JSON and REST api’s
Working experience of
source code repositories such as GIT