Data Analytics Engineer at Rainforest Alliance
3 months ago
The Rainforest Alliance is a growing network of people who are inspired and committed to working together to achieve our mission of conserving biodiversity and ensuring sustainable livelihoods. Through creative, pragmatic collaboration, we aim to rebalance the planet by building strong forests and healthy communities around the world
Position summary:
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
REQUIREMENTS
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
-
Data Analytics Engineer at
3 months ago
Nairobi, Nairobi Area, Kenya Rainforest Alliance Full timeThe Rainforest Alliance is a growing network of people who are inspired and committed to working together to achieve our mission of conserving biodiversity and ensuring sustainable livelihoods. Through creative, pragmatic collaboration, we aim to rebalance the planet by building strong forests and healthy communities around the worldPosition summary:At...
-
Program Manager at Rainforest Alliance
2 months ago
Nairobi, Kenya Rainforest Alliance Full timeThe Rainforest Alliance is a growing network of people who are inspired and committed to working together to achieve our mission of conserving biodiversity and ensuring sustainable livelihoods. Through creative, pragmatic collaboration, we aim to rebalance the planet by building strong forests and healthy communities around the world. Position...
-
Project Data Manager at Rainforest Alliance
3 weeks ago
Nairobi, Kenya Rainforest Alliance Full timeThe Rainforest Alliance is a growing network of people who are inspired and committed to working together to achieve our mission of conserving biodiversity and ensuring sustainable livelihoods. POSITION SUMMARY: At Rainforest Alliance, we believe in the value of data. The Data Management and Intelligence department is paving the way for enabling...
-
Senior Product Owner at Rainforest Alliance
2 months ago
Nairobi, Kenya Rainforest Alliance Full timeThe Rainforest Alliance is a growing network of people who are inspired and committed to working together to achieve our mission of conserving biodiversity and ensuring sustainable livelihoods. Through creative, pragmatic collaboration, we aim to rebalance the planet by building strong forests and healthy communities around the world. Position summary: The...
-
Data Partnerships Manager at Rainforest Alliance
4 weeks ago
Nairobi, Kenya Rainforest Alliance Full timeThe Rainforest Alliance is a growing network of people who are inspired and committed to working together to achieve our mission of conserving biodiversity and ensuring sustainable livelihoods. Through creative, pragmatic collaboration, we aim to rebalance the planet by building strong forests and healthy communities around the world Position summary: At...
-
Nairobi, Kenya Rainforest Alliance Full timeThe Rainforest Alliance is a growing network of people who are inspired and committed to working together to achieve our mission of conserving biodiversity and ensuring sustainable livelihoods. Through creative, pragmatic collaboration, we aim to rebalance the planet by building strong forests and healthy communities around the...
-
Internal Compliance Manager
3 months ago
Nairobi, Kenya Rainforest Alliance Full timeThe Rainforest Alliance is a growing network of people who are inspired and committed to working together to achieve our mission of conserving biodiversity and ensuring sustainable livelihoods. Through creative, pragmatic collaboration, we aim to rebalance the planet by building strong forests and healthy communities around the world Position...
-
Nairobi, Kenya Rainforest Alliance Full timeThe Rainforest Alliance is a growing network of people who are inspired and committed to working together to achieve our mission of conserving biodiversity and ensuring sustainable livelihoods. Through creative, pragmatic collaboration, we aim to rebalance the planet by building strong forests and healthy communities around the...
-
Senior Associate, Monitoring, Evaluation
2 months ago
Nairobi, Kenya Rainforest Alliance Full timeThe Rainforest Alliance is a growing network of people who are inspired and committed to working together to achieve our mission of conserving biodiversity and ensuring sustainable livelihoods. Through creative, pragmatic collaboration, we aim to rebalance the planet by building strong forests and healthy communities around the world. Position...
-
Nairobi, Kenya Rainforest Alliance Full timeThe Rainforest Alliance is a growing network of people who are inspired and committed to working together to achieve our mission of conserving biodiversity and ensuring sustainable livelihoods. Through creative, pragmatic collaboration, we aim to rebalance the planet by building strong forests and healthy communities around the world. Position summary: ...
-
Nairobi, Kenya Rainforest Alliance Full timeThe Rainforest Alliance is a growing network of people who are inspired and committed to working together to achieve our mission of conserving biodiversity and ensuring sustainable livelihoods. Through creative, pragmatic collaboration, we aim to rebalance the planet by building strong forests and healthy communities around the world Position Summary Are...
-
Nairobi, Kenya Rainforest Alliance Full timeThe Rainforest Alliance is a growing network of people who are inspired and committed to working together to achieve our mission of conserving biodiversity and ensuring sustainable livelihoods. Through creative, pragmatic collaboration, we aim to rebalance the planet by building strong forests and healthy communities around the world. Position...
-
Senior Associate, Monitoring, Evaluation
3 weeks ago
Nairobi, Kenya Rainforest Alliance Full timeThe Rainforest Alliance is a growing network of people who are inspired and committed to working together to achieve our mission of conserving biodiversity and ensuring sustainable livelihoods. Responsibilities: The Rainforest Alliance’s Core Values are Impact, Change, Collaboration, Openness and Trust and as such they form the basis of the...
-
Human Resources Generalist
3 months ago
Nairobi, Kenya Rainforest Alliance Full timeThe Rainforest Alliance is a growing network of people who are inspired and committed to working together to achieve our mission of conserving biodiversity and ensuring sustainable livelihoods. Through creative, pragmatic collaboration, we aim to rebalance the planet by building strong forests and healthy communities around the world. Position...
-
Senior GIS Officer at Rainforest Alliance
4 weeks ago
Nairobi, Kenya Rainforest Alliance Full timeThe Rainforest Alliance is a growing network of people who are inspired and committed to working together to achieve our mission of conserving biodiversity and ensuring sustainable livelihoods. Through creative, pragmatic collaboration, we aim to rebalance the planet by building strong forests and healthy communities around the world Position Summary: To...
-
Nairobi, Kenya Rainforest Alliance Full timeThe Rainforest Alliance is a growing network of people who are inspired and committed to working together to achieve our mission of conserving biodiversity and ensuring sustainable livelihoods. Through creative, pragmatic collaboration, we aim to rebalance the planet by building strong forests and healthy communities around the world. POSITION...
-
Senior Training Officer
3 months ago
Nairobi, Kenya Rainforest Alliance Full timeThe Rainforest Alliance is a growing network of people who are inspired and committed to working together to achieve our mission of conserving biodiversity and ensuring sustainable livelihoods. Through creative, pragmatic collaboration, we aim to rebalance the planet by building strong forests and healthy communities around the world POSITION...
-
Manager, Coffee Supply Chain and Project Monitoring
2 months ago
Nairobi, Kenya Rainforest Alliance Full timeThe Rainforest Alliance is a growing network of people who are inspired and committed to working together to achieve our mission of conserving biodiversity and ensuring sustainable livelihoods. Through creative, pragmatic collaboration, we aim to rebalance the planet by building strong forests and healthy communities around the world. Position...
-
Senior GIS Solution Manager at Rainforest Alliance
2 months ago
Nairobi, Kenya Rainforest Alliance Full timeThe Rainforest Alliance is a growing network of people who are inspired and committed to working together to achieve our mission of conserving biodiversity and ensuring sustainable livelihoods. Through creative, pragmatic collaboration, we aim to rebalance the planet by building strong forests and healthy communities around the world. Position...
-
Manager, Coffee Supply Chain and Project Monitoring
3 months ago
Nairobi, Kenya Rainforest Alliance Full timeThe Rainforest Alliance is a growing network of people who are inspired and committed to working together to achieve our mission of conserving biodiversity and ensuring sustainable livelihoods. Through creative, pragmatic collaboration, we aim to rebalance the planet by building strong forests and healthy communities around the world. Summary As a...