Data Warehouse Engineer

Number of employees

50

Copenhagen, Denmark, Denmark

Posted on: 2022-11-30

Category: agritech

Apply now

Please let Agreena know you found this job on Work in Green. This will help us grow!

Expired

Employment type:

Full time

Experience required:

Intermediate

Salary

Salary not provided

About the company:

We are developing our online commodity marketplace which allows farmers to find more sellers and buyers and to identify the best possible deals out there. We are looking forward to giving you access to the Agreena platform, from which we will enable farmers to easily access and identify the best prices on agricultural commodities delivered by both local and international market players. Both farmers and trading houses will be able to post offers in this open cross-border online market place. We hope you will join us on this journey towards a more open market. 

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 200 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 17 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.

About the role:
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 near to Copenhagen or London and are comfortable making the journey to spend time in the office regularly. However, please enquire as other remote working options can be accommodated

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?
We encourage you to follow our Agreena LinkedIn page to keep updated on content, articles as well as new opportunities opening. You can also subscribe to our job alerts talent pool to stay in the loop for the departments you're interested in exploring further at Agreena.


🌍 Be your best self every day at Agreena
At Agreena we are devoted to building an environment that promotes equality, inclusion, and diversity. We are on the path towards expansion and growth so with that, we believe everyone’s uniqueness should be celebrated and embraced to help us achieve this exciting journey. This is critical to our success and innovation. We want 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 are working to ensure Agreena remains a diverse and inclusive environment for everyone.  

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.

  • Similar climate jobs

    These are some of our top picks for great climate jobs on Work in Green.

    View all jobs
    Pivot Bio logo
    United States
    Number of employees

    400

    Full time
    Agritech
    Pivot Bio logo
    United States
    Number of employees

    400

    Full time
    Agritech
    Agreena logo
    Denmark
    Prolific Machines logo
    United States
    Climate Robotics logo
    United States
    Number of employees

    10

    Full time
    Agritech

    69 Agritech jobs at Agreena

    Agreena is hiring Head of Accounting & Controlling,Business Solutions Specialist (Program),Android Developer (Remote), and more.

    View all jobs at Agreena
    Agreena logo
    Denmark
    Agreena logo
    United Kingdom
    Agreena logo
    United Kingdom
    Number of employees

    50

    Full time
    Agritech
    Agreena logo
    United Kingdom
    Number of employees

    50

    Full time
    Agritech
    Agreena logo
    Denmark
    Number of employees

    50

    Full time
    Agritech