Data Analytics Engineer

POSITION SUMMARY:

At the Rainforest Alliance, we use 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 main 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
• Design, build, and test data pipelines using SQL
• Deliver and validate datasets and reports to agreed levels of accuracy and completeness.
• Monitor and maintain the data pipelines and data mart health, helping solve inconsistencies and issues efficiently.
• 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 Engineering team

QUALIFICATIONS:

• Demonstrated ability (3 years) of data engineering experience.
• Strong proficiency in SQL and data analysis.
• Experience with cloud infrastructure and data services, preferably Azure but not limited it.
• Expertise in BI platforms and test design.
• Familiarity with Data Vault and dimensional modelling.
• Proficiency in Agile methodologies.
• Superb communication skills, both technical and business oriented.
• Proactive and organized approach.
• Fluent in English.

NICE TO HAVE:

• Affinity or exposure to Rainforest Alliance's sustainability objectives.
• Familiarity with Azure platform and Data Virtuality software.
• Familiarity with other data platforms and tools,
• Ability to build reports and datasets using Power BI.
• Experience with designing and consuming REST API's for loading data changes from source systems.
• Working experience of source code repositories such as GIT.

Level: 4

Deadline: 25 April 2025

Salary: Commensurate with experience

Notes: Only candidates legally authorized to work in Kenya will be considered. 

If you have any questions about the job vacancy, please contact the HR department: recruitment@ra.org

The Rainforest Alliance encourages diversity and inclusion across the global organization. With this commitment to diversity, we are proud to be an equal opportunity employer and do not discriminate on the basis of gender, race, color, ethnicity, religion, sexual orientation, gender identity, ages, disability and any other protected group.