ETL Designer

  • GeoPhy
  • Delft, Netherlands
  • Jul 22, 2017
Full time Data Developer

Job Description

As an ETL Designer at GeoPhy you will be the front and center in an amazing transformation within the real estate market.The ETL Designer specialises in the design and development of the ETL environment, processes, programs, and scripts to acquire data from source systems and apply the data to the tables in the database. You will be enabling GeoPhy to become more sophisticated in its approach to managing large incoming data streams, while at the same time enjoying a flat company structure within a start-up setting where freedom, responsibility and above all growth is celebrated! We are a lean team, so your impact will be felt immediately! Up for the challenge? Come work with us!

Responsibilities

  • Capture and understand ETL requirements and translate into technical specifications
  • Ensure accuracy and integrity of data through analysis, coding and problem resolution
  • Design, develop, and test processes for extracting data from legacy systems or production databases
  • Design, develop, and test processes for validating and conditioning data prior to loading into a data warehouse
  • Design, develop, and test processes for loading staging data into a data warehouse (RDF, Ontology, Linked Data)
  • Experience with Dimensional Data modelling
  • Translate business needs into end product applications
  • Partner up with several cross-functional team members (DBA’s, Data Quality Managers, BI) to identify new opportunities, bottlenecks and efficiency issues
  • Contribute in a positive way to the atmosphere within the team

Requirements

  • Working experience and deep understanding of ETL tools 
  • Strong SQL and database tuning skills
  • Knowledge of Sparql, RDF, Ontologies, Owl, inference.
  • Knowledge of python, ruby or shell scripting.
  • Problem solving mentality leveraging internal and/or external resources
  • Highly adaptive and flexible in order to keep up in a fast changing environment
  • Full working proficiency in English
  • Desire and eagerness to contribute to the overall success of the company and grow along with it
  • Highly organized, at least a semi-perfectionist
  • Sense of humor
  • Trustworthy and responsible
  • International mind set

Bonus Points

  • University degree with a background in computer science, management information systems, mathematics or a similar technical field
  • Previous startup experience
  • An understanding of the (global) real estate market
  • Additional language(s)