Back to jobs

Senior Data Warehouse Architect

Various locations, Netherlands
Full Time Senior

Position Summary


At Rainforest Alliance, we utilize data to make informed decisions. Through our Data Analytics Platform (DAP), we provide access to crucial data. This role focuses on ETL data pipeline development, emphasizing data analysis, requirements specification, data modelling, and coaching. We currently use Data Virtuality and are transitioning to Azure Data Factory.

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, gathering 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, ensuring accuracy and completeness.

  • Advocate for processes that improve the quality and structure of ETL pipelines.

  • Participate in sprint planning and data model review sessions with the engineering team.



Qualifications

  • 10 years of data engineering experience.

  • Strong proficiency in SQL.

  • Strong business analysis and requirement gathering skills.

  • Expertise in BI platforms and test design.

  • Familiarity with Data Vault and dimensional modelling.

  • Proficiency in Agile methodologies.

  • Excellent 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, Azure Data Factory and Data Virtuality software.

  • 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.


Job Level: 3B

Salary: Commensurate with experience.

Deadline: 10 May 2024

Notes: Only candidates authorized to work in the Netherlands will be considered.

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


Who we are:The Rainforest Alliance is creating a more sustainable world by using social and market forces to protect nature and improve the lives of farmers and forest communities. To achieve our mission, we partner with diverse allies around the world to drive positive change across global supply chains and in many of our most critically important natural landscapes.

Our alliance spans 70 countries and includes farmers and forest communities, companies, governments, civil society, and millions of individuals. Together we work to protect forests  and biodiversity, take action on climate, and promote the rights and improve the livelihoods of rural people.

As an international nonprofit organization with more than 30 years of experience in sustainability transformation, we understand that the social and economic well-being of rural communities is tightly connected to ecosystem health. This knowledge has shaped our rigorous programs to advance sustainable land-use and commodity production.

At the Rainforest Alliance we combat climate change, protect forests and biodiversity, promote human rights, and improve livelihoods. The enormity of the social and environmental challenges we are facing requires working together in a broad alliance. This is why we bring farmers, forest communities, companies, and consumers together to change the way the world produces, sources, and consumes.

WhyTo protect nature and improve lives it’s becoming increasingly urgent that we approach the way we use our land and produce food and other products in more sustainable ways. For this to succeed we need to fundamentally change the way that businesses operate and source, and the choices we all make as consumers.

HowOur growing global alliance aims to transform our relationship with our natural resources and each other, to create a better future for people and nature together.

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.

Please complete all required fields
Please complete all required fields