Senior ETL Developer

Bedrijfsprofiel

How does building an entirely cloud based, open source data warehouse sound to you? As ETL developer this is exactly what you will be doing.

As the world’s largest HR service provider, the amount of information that passes through our systems every day is vast. Using accurate data to inform our decision making processes and to guide us is therefore an integral part of our strategy. Our Data Insights team are helping us build an entirely new environment between our AWS datalake and Tableau reporting, drastically reducing the number of reports we need.

Where our datahub team connects all of our various data sources, our data insights team focuses on the transformation aspect of the ETL proces, integrating data sources into a multi-dimensional data model we can use to build analyses across a multitude of sources.

In doing so, we are saying goodbye to our existing Redshift Data Warehouse and focusing on a new greenfield build based on the DBT open source data transformation tool, Airflow scheduling and Snowflake.

Functie omschrijving

As ETL developer your main focus is the design and creation of new data flows.

You will:
Define how we can connect the different sources based on each use case

  • Define which transformations are necessary
  • Build the necessary ETL processes using DTP
  • Ensure data quality and security while doing so, working with highly sensitive data

In addition to this, you are welcome to contribute as widely as you are keen. For example:

  • Contribute to the data modelling stages
  • Develop solutions to new use cases, further defining requirements and consulting on available data sources
  • Consult with internal customers on their data requirements
  • Contribute to or develop optimization initiatives
  • Give advice on managing and preventing unwanted data sprawl

Functie eisen

Your background

We don't expect you to have worked with every technology we use, but to be able to adapt to our environment we expect you to have:

  • A minimum of 5 years experience within data integration or data warehousing
  • Experience working with cloud based data warehouse solutions (Snowflake and Databricks appreciated but not required)
  • Strong knowledge of ETL techniques (open source experience appreciated but not required)
  • Strong knowledge of SQL
  • Experience with CI/CD (DevOps, Git, Jenkins, Yaml)
  • Experience with dimensional data modeling
  • Further experience with Tableau, modern scheduling and orchestration tools such as Airflow and data structures and formats such as JSON, CSV, Parquet are not required but are valuable.

Arbeidsvoorwaarden

What we offer

  • A completely new, state of the art project you can build from scratch;
  • Extensive learning and development opportunities through our partners;
  • A gross monthly salary between €3.207 - €5.879;
  • A benefit budget of 12,347% (incl. 8,5% holiday pay), to spend on net benefits, extra leave or simply more income;
  • A generous bonus scheme tied to company performance;
  • 25 holidays (with the possibility to buy 26 more);
  • A company car or generous mobility budget;
  • A generous share purchase plan that doubles any shares purchased;
  • Possibility to go on a sabbatical, or to participate in international volunteer projects.

Publicatie datum

01.12.2022

Contactpersoon

C.P.A. Hrkac

Deel deze vacature:
www.werkenbijecht.nl gebruikt cookies om bepaalde voorkeuren te onthouden en vacatures af te stemmen op je interesses.