Data Warehouse Engineer – Senior // ViaEurope at ViaEurope

Posted on: 02/23/2021

Location: Berlin, Germany (ON-SITE)

full time

Crunchbase | Original Source

Tags: ruby etl elixir python sql rails redis postgresql

ViaEurope means: smart Web-Apps & APIs combined with real warehouses, clearing thousands of parcels each day - bringing products from all over the world to Europe. We are growing fast and are looking for a Data Warehouse Engineer who can support the development of the ViaEurope applications - work remotely or join us in Berlin. Come and join our international dream team to make e-commerce to Europe easy. As a Data Warehouse Engineer with extensive experience building, scaling and maintaining relational databases and data warehouses and the ability to understand and manipulate our large datasets, you‚Äôll work closely with our newly formed Business Intelligence team and provide them with the infrastructure and raw data that allows them to generate insightful information to help them monitor and manage their daily operations in the most efficient way. ‚ÄčAs a member of the tech team you will also get the chance to optimize our existing operational databases, helping us to ensure that queries run fast and data is consistent. We will rely on your expertise when evaluating our data architecture or debugging gnarly queries. ‚ÄčYou will be joining our tech team in Berlin, but you will also be working closely with our operations and business intelligence teams in the Netherlands and Belgium as well as our sales and support team in China. **What we are looking for:** * In-depth discussions with colleagues to understand their data requirements.‚Äč * Planning, designing, deploying and maintaining data warehouse systems to power our BI solutions. * ‚ÄčDeveloping data architectures, data modelling solutions within the DWH and our production databases. * ‚ÄčDeveloping and maintaining ETL pipelines from various data sources into the DWH. * ‚ÄčSupport the development and validation required through the lifecycle of the DWH and Business Intelligence systems, maintain user connectivity. * ‚ÄčEnsure the security of the DWH. * ‚ÄčMonitor the DWH and BI systems performance and integrity provide corrective and preventative maintenance as required. * ‚ÄčAnalyze and optimize usage of the existing production PostgreSQL systems. * ‚ÄčWriting and maintaining documentation describing our DWH infrastructure, ideally in a structured, executable form (infrastructure-as-code). * ‚ÄčProvide training and coaching to your peers regarding efficient database querying, etc. **Your skills and experience:** * Extensive experience with SQL coding and relational database software administration. * Experience with PostgreSQL is appreciated (we are currently using PostgreSQL and Redis exclusively). * Extensive experience with at least one general purpose programming language, for example, Ruby, Python, Go, Elixir, Crystal, Java, Shell Script, etc. ‚ÄĒ our software stack is mainly based on Ruby / Ruby on Rails. * Experience with common data warehousing/OLAP systems to build a multidimensional data warehouse. * Familiarity with cubes and data models. * Experience with designing, developing and implementing cloud-based ETL pipelines and monitoring their health. * Good presentation and communication skills * Strong capabilities in identifying data and process relations and high capacity to quickly adapt to changes. * Verbal and written English skills are a must. * Willingness to work independently. You‚Äôll be given the freedom and responsibility to fulfil your own tasks, managing your time the way you see fit but always delivering quality work and being respectful of deadlines. **At ViaEurope you will enjoy** * Casual Dress: ViaEurope cultivates a start-up mindset and therefore promotes a casual work environment. * Involvement: Ability to participate in meetings, team building events, celebrations, and much more. * ‚ÄčSelf-empowerment: We believe in people and therefore give space for own initiatives and self-development.