Careers at Rainforest Alliance

THE ROLE:

You will work with diverse business and development teams to gather, refine, and analyze data requirements. Through data analysis and understanding of the problem domain, you will present solutions to the business, then refine them into technical requirements for delivery by the DAP team.

The ideal candidate should be able to:

• Communicate with data stakeholders, capturing and documenting business requirements.
• Model data using third normal form, Data Vault, and dimensional techniques.
• Refine business requirements into technical, value focused stories.
• Mentor junior engineers.
• Design, build, and test data pipelines using SQL
• Monitor and maintain the data pipelines and data mart health, helping solve inconsistencies and issues efficiently.
• Help to build best practices to improve the quality, structure, and testing of ETL pipelines
• Design and build data warehouse components and quality monitoring solutions
• Participate in sprint planning and data model review sessions with the engineering team.

QUALIFICATIONS:

• Demonstrated ability (7 years) of data engineering experience.
• Strong proficiency in SQL.
• Strong business analysis and requirement analysis skills.
• 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, and being able to explain the possibilities and restrictions.
• 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.

go to method of application »

POSITION SUMMARY:

• Are you the data detective in our data engineering team? Do you want to be the person-to-go for understanding the data structures of our systems, the second-line support for data analysis? Are you not afraid of data challenges? Do you have eye for detail?
• 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. Most of our data engineers focus on ETL data pipeline development. But as a successful data team we also need data and business analysis skills.
• Your work will be focused on data analysis, business analysis, troubleshooting, data quality analysis, testing. We will also consider your application if you don't meet all the criteria below but has a strong knowledge of SQL.

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 or other experience managing and structuring large datasets.
• 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.

go to method of application »

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.

go to method of application »

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. You will maintain, extend and scale the platform, while keeping it recoverable, secure, available and performant. Automation will be an important part of the job as well as uncovering ways to improve the platform. You will work close together with the data engineers in the data excellence team as well as the platform ops team. Another aspect is to adapt it as needed for new products (open data, ingestion of external sources, unstructured data, etc.).
• We are looking for someone on the crossroads of platform ops and data engineering. If you have most of the skills but not all of them, you are also invited to apply.

The candidate should possess the technical skills to:

• Maintain the technical infrastructure of a cloud-based data platform and ensure its security
• Understand the specifics of a data platform and the way of working in a data team
• Build and/or assist in automated solutions for data pipelines and other supporting tools to increase speed of delivery
• Assist with the design of data warehouse components and quality monitoring solutions
• Maintain tools that make up the data analytics environment

RESPONSIBILITIES:

• Implements, maintains and actively monitors the servers, virtual machines, applications and software of the Azure data platform
• Develop, maintain and improve the data connections between data sources and the data analytics platform, using Terraform and Azure tools
• Maintain the high level of security and confidentiality of the data platform
• Develop, maintain and improve automation of data pipelines and other supporting processes for the data platform
• Performance tuning of the environment
• 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 (5 years) managing databases, database servers and their infrastructure
• Ability to coding in procedural SQL, and automation using scripting languages
• Working experience with technical infrastructure of business intelligence platforms
• Working experience as (SQL Server) DBA for a data (warehouse) environment
• Working experience with Azure cloud services
• English fluency
• Good communication skills with the ability to work with both technical and business minded colleagues
• Excellent analytical problem-solving skills, diagnostic skills and ability to prioritize own work.
• Pro-active demeanour and an ability to remain organised under pressure and see projects to completion.
• Working experience of source code repositories such as GIT

PLUS IF YOU 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 Scrum/Agile methodologies and working independently as a member of a virtual team
• Experience with infrastructure as code, especially Terraform
• Ability to program in languages like Java/Python/Scala and work with JSON and REST API's
• Experience with designing and consuming REST API's for loading data changes from source systems
• Experience with automated Business Intelligence tools