Junior Data Engineer

  • Climate KIC
  • Germany
  • 11/07/2022
Full time Data Engineering Big Data Software Engineering Data Governance

Job Description

Job Description

employment type
Temporary contract

Full job description

LEVEL
Foundation
CONTRACT
Fixed-term
APPLY BY
27 Jul 2022
SALARY
Competitive for not-for-profit organization
START DATE
ASAP
LOCATION
Germany, UK, Poland, Spain

ABOUT US

EIT Climate-KIC (Knowledge and Innovation Community) is Europe's foremost climate innovation initiative. We understand that keeping global temperature rise below 1.5˚C demands unprecedented change. It requires new social dynamics, ways of doing business, capital flows, policymaking, economic models, and new ways of living. That is why our mission is to leverage the power of systems innovation to transform whole places, industries and value chains by 2030, working across sectors to develop and scale ambitious, mission-led programmes.

Established in 2010 and headquartered in Amsterdam, we orchestrate a community of more than 400 organizations including large corporations and SMEs, municipal and regional governments, universities and research institutes, as well as non-governmental organizations and uncommon actors. Historically, we have been funded by our founder and core funder, the European Institute for Innovation and Technology (EIT), but we are currently transitioning to a multi-funder model.

EIT Climate-KIC colleagues are based in one of our local offices across Europe, or work remotely from home based in one of the countries we have a branch in. We meet at our local offices to exchange and connect, and use online collaboration tools work with each other and with our community. On occasion, we meet in person as teams, and once a year as an organization.

As a mission-driven organization dedicated to climate transformation, we consider the climate impact of our own actions, for example travel, catering or IT equipment.

ABOUT THE ROLE

As a junior Data Engineer in Climate-KIC, you will develop and manage systems integration and the data warehouse. You will contribute to the development of the organization's data landscape while receiving guidance that supports your own development.

key responsibilities

Systems integration: develop and manage ETL to populate our data warehouse from APIs. EIT Climate-KIC uses a range of IT tools in its business processes. These generate data that are ingested, curated and consumed in a data warehouse, developed in Snowflake. Some of the curated data are then processed and moved into other business tools. Your most important responsibilities are 1) to develop and maintain ETL processes and 2) maintain and further develop the Data Warehouse.

Data Architecture: Support improving and maintaining a data architecture that ties together EIT Climate-KIC's application landscape. We are building and improving our data landscape to deliver the right solutions to the business, and you will play a role in this effort. You want support with data catalog and data model definitions.

Dataset building: Drawing on the Data Warehouse, build datasets that will be used by internal or external stakeholders. These can either be tables to be directly consumed by users or datasets that will be a basis for BI development or sense making activities in EIT Climate-KIC.

Data security and compliance: Ensure that the data tools and integrations meet security requirements and are GDPR compliant.

Interface with internal and external stakeholders to ensure business requirements are understood and delivered. Keeping up to date with the data landscape and the market, to identify synergies with our internal environment.

ABOUT YOU

You are passionate about making a critical contribution with your skills to EIT Climate-KIC's mission of making a positive impact on climate change through systemic innovation. You are able and willing to thrive in a start-up-like environment. As a data engineer, you are part of a lean data team with real responsibilities and autonomy for everyone.

experience

  • 1+ years of experience with data engineering or a data engineering portfolio.

skills

  • Experience developing ETL, as well as experience developing integrations between systems. ETL with Python is a must, experience with Talend (ETL tool) is an important advantage.
  • Experience developing and maintaining data warehouse. Solid understanding of layered data warehouse architecture with ingestion, curation and consumption layers. Experience with Snowflake is not a must, but of great advantage.
  • A solid background in developing and maintaining relational databases, adept with complex SQL and implementing logical data models. Understanding of data architecture principles and implementation, as well as the broad data landscape and the data market.
  • You understand GDPR requirements and can design and implement solutions that are both secure and compliant, as well as manage security incidents in our data tools suite.
  • Must-have hard skills: Understand and write complex SQL queries; solid understanding of data models; experience working with APIs; command of Python and data-related packages, like Pandas, Requests, Numpy.
  • Desirable: some experience with Talend; basic Java; Experience with Snowflake, solid command of Ms Excel, especially the Power Query suite.
  • Experience and willingness to work with collaborative IT applications (we use Office365 and Microsoft Teams, as well as Miro, Zoom, Mentimeter etc.)

Qualities, Personal Style, and Approach

  • Curious with a learning mindset
  • Pro-active with a drive for problem-solving
  • Resilient to uncertainty in an evolving internal and external landscape
  • Communication within the team and other stakeholders is crucial. Our internal data and technology landscape is undergoing relevant change, which requires a positive, proactive attitude. You must be fluent in English, both speaking and writing.

Location

Candidates must have the right to work in the EU (or the UK) prior to applying for the position. Ideally, the successful candidate will be based close to an EIT Climate-KIC office, but we support full remote or hybrid forms of working and offer a high degree of flexibility.

Our presence includes: Netherlands (Amsterdam), Belgium (Brussels), France (Paris), United Kingdom (London), Germany (Berlin), Denmark (Copenhagen), Poland (Warsaw), Hungary (Budapest), Italy (Bologna), Spain (Valencia), Slovenia (Lubjiliana), Republic of Ireland (Dublin).

At EIT Climate-KIC we are wholeheartedly committed to building a diverse and representative team and an inclusive workplace that values ​​different life experiences and perspectives, and encourages personal development, learning and growth.

When recruiting we look to achieve diversity in the candidate pool. We actively encourage applications from underrepresented groups and are happy to consider reasonable adjustments to that will foster success in potential employees from diverse backgrounds and life situations. And because our team has differing needs and personal circumstances, we offer a high degree of flexibility to accommodate all working patterns.

Our application and recruitment process

Climate-KIC values ​​diversity and welcomes applications from all suitably qualified candidates regardless of age, gender, race, disability, sexual orientation, religion or ethnic background.

Your application should be written in English and consist of:

  • a full curriculum vitae
  • a covering letter describing briefly how your profile, skills and experience meet the criteria outlined in the person specification, and outlining your interest in and vision for the role.
  • your current salary
  • where you saw this role advertised.

Please send your full application You should state your full name, followed by the role for which you are applying for in the subject line of the email. The deadline for receipt of applications is 23.59 GMT on the date published on the job advert.

Receipt of your application will be acknowledged by email.

Your application will be reviewed on or around the closing date for the vacancy for which you have applied. If your application is shortlisted for interview, you will be contacted directly by Climate-KIC.

Candidates invited to a first interview will be notified of the outcome and informed about next stages if they are successful.

NB/ This advertisement will be taken down from the website after the closing date so it is a good idea to copy and keep the text for reference to use should you be invited to interview