Data Warehouse Engineer

Copenhagen, Denmark / London, United Kingdom / Berlin, Germany

Technology – Software Engineering /

Full-time /

Remote

Apply for this job

About Agreena

Agreena is an exciting, dynamic, and purpose-oriented organisation united in a mission to mobilise farmers and corporations to unlock the value of nature and help restore the planet. While we’re rooted in agriculture, finance, and technology, our team of experts range from soil carbon scientists and software developers to market strategists and regulatory affairs experts. Over 230 employees across more than 40 nationalities are gathered under the common Agreena flag – either working from our headquarters in Copenhagen, offices in London, or remotely across Europe.

As a rapidly scaling climate agtech, Agreena provides solutions that drive both environmental and financial sustainability in farming. We have helped farmers across 18 countries in their conversion journey from conventional agriculture to regenerative farming practices to reduce greenhouse gas emissions and remove CO2 from the atmosphere, storing it in soil. Our company offers a supportive and positive work environment with opportunities for learning, leading and growth no matter where you are in your professional journey. We believe in giving our employees a lot of responsibility, and we encourage new thinking, innovation and fun.

And this is where you come in:

We are looking for an experienced Engineer who will be in charge of our data warehouse maintenance and development and will also work closely with stakeholders to help them make the right data-driven business decisions by utilising our BI platform.

Our Data Stack is PostgreSQL (+PostGIS), S3, AWS Glue (including Workflows), AWS Lambda, AWS Athena and AWS QuickSight, and we have ambitions to expand it towards a Geographic/Spatial Data Lake. Supported by our DevOps team, we use Terraform and Git to manage the infrastructure (as a Code) and ETL processes.

Ideally you will be located in the UK, Denmark or Germany for this position.

Your responsibilities:

• Keeping DWH data models up to date, documented, and easy to use for not technical users.
• ETL processes and Data warehouse maintenance and development.
• Data governance and access management.
• Development and maintenance of data sources on our BI platform (we use AWS QuickSight).
• Business Intelligence platform administration.
• Assisting colleagues in gaining access to the right data and building their reporting tools.
• Ad hoc reporting and data-related tasks in collaboration with internal stakeholders.
• Working with programmers, engineers, and management to identify process improvement opportunities and data governance strategies.

Requirements to succeed in the role:

• 3+ years of hands-on experience working with DWH development / maintenance, data architecture or data setup & structure.
• Experience with development of analytical tools and dashboards with any BI platform.
• Advance knowledge and experience working with SQL.
• Experience with data modelling and ETL processes.
• Hands-on experience in coding and analytics, Python, SQL.
• Deep understanding of data architecture on AWS and its services.
• Experience with AWS data technologies for data processing (S3, Athena, Glue, Lambda).
• Apache Spark (AWS Glue) - basic knowledge.
• A "service gene" shown by a can-do attitude to helping both data owners and data users.
• A commercial mindset where efforts are made into helping to get maximal insights from the data available.

Bonus points if you have:

• Experience with Terraform, Ansible or Puppet.
• Portfolio showcasing strong data visualisations and data processing skills.
• Understanding and showcasing how data insights have driven business results.
• Experience in agriculture-related data processing tasks.
• Experience in Geospatial Data Lakes development and maintenance on the AWS platform.
• Experience with Fivetran.

What's in it for you:

• A truly global environment where you can collaborate and socialise with diverse and passionate colleagues.
• Competitive salary.
• Remote work policy.

Want to become a fellow Agreenian?

If you read until this point, we'll assume that you would like to join us. If that's the case, please send your CV which includes 3-4 sentences on why you would like to work at Agreena.

For any additional questions regarding this job position, please contact Jolanta, our Talent Attraction Partner, at [email protected].

🌱 Not quite what you're looking for?

Stay connected with us by following our Agreena LinkedIn page. It's the best way to stay updated on our latest content, articles, and exciting new opportunities.

Plus, if you want to be the first to know about job openings in the departments you're interested in, you can subscribe to our job alerts talent pool.

🌍 Be your best self every day at Agreena

At Agreena, we are devoted to building an environment that promotes equality, inclusion, and diversity. As we embark on our journey of expansion and growth, we recognise the value of celebrating and embracing everyone's uniqueness. This diversity is crucial to our success and innovation. We aspire to build a product that is loved by our customers and we want the same to be reflected in our teams.

With this in mind, we're dedicated to ensuring that Agreena remains a welcoming and diverse environment for all.