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
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
Desired Skills
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
How To Apply