DHW Engineer

About Vimcar

As one of Berlin's most successful SaaS companies, Vimcar is redefining business mobility. By combining live car data and a set of cloud-based applications, we offer real-time insight into vehicle activity to help our customers reduce the operational costs for their fleets.

By serving freelancers, small and medium-sized companies, Vimcar already has connected more than 100,000+ cars and we are incredibly proud to serve the companies who are the backbone of our economy: the electricians, the doctors, the plumbers, the retailers, the construction workers - everyone whose business is on the road.

Headquartered in Berlin, more than 200 employees from 30+ countries are working towards our mission to build Europe's leading fleet tech company. We do not believe in hyper-growth at any cost and burning loads of Venture Capital but in sustainable growth driven by smart people and innovative ideas. If you are not celebrating funding rounds, but value a great customer experience and passionate colleagues: Vimcar might be the right place for you!

Important information regarding COVID-19: the safety of our employees is crucial to us. Therefore, you can expect the application process and the start of your employment with us to be remote until further notice.

Position

Analytics and Business Intelligence support Vimcar with organising internal and external data in one place - the Data Warehouse - so it can be used for analyses and reporting. Over the years we have accumulated 2,7 billion rows / 1,7 TB worth of data. This Business critical team covers two core areas - BI development and BI Analysis.

The Role

• You set up, maintain, monitor, and support BI-related infrastructure, mainly BI application and database servers
• You design and deploy ETL pipelines with Python and Pentaho Data Integration on our AWS-based application server in a Linux environment
• You will model data structures to hold data from various sources and enable efficient reporting and analysis
• You perform code reviews
• You provide documentation and know-how transfer
• You maintain and support our reporting platforms, and continuously evaluate and improve our existing BI systems.

The Tech Stack

• AWS-based server infrastructure running on Amazon Linux 2
• Ansible for server provisioning
• Postgres v12.8 databases
• Airflow v2.3.4 in a Docker container for ETL task orchestration
• Python v3.9 for external data retrieval and API wrappers
• Pentaho Data Integration v9.1 for data transformation
• Tableau Server v2022.1

Your qualification

• You have gained at least in-depth practical experience as a BI Developer
• Advanced Python programming skills
• You enjoy researching and developing the use of new technologies that might improve the current BI tech stack
• You have a working proficiency with Linux (ideally Amazon Linux 2 or CentOS 6)
• You have good SQL skills to be able to transform data into desired structures especially DDL

What we offer

Working in a complex environment with tons of data — you’ll get hands-on experience in working on various projects, tools, and datasets.

• You join a highly automatised, well designed and documented BI system
• You will collaborate closely with your Team Lead who is a highly experienced BI developer including other BI and product Analysts across the company
• You will work closely with Dev Ops who support us in automating our AWS infrastructure
• You will be mentored and coached by a Senior with 15 years of experience as a BI Developer, who will support you with your professional and personal development
• You will have the time you need to learn new skills and explore & research new technologies
• A permanent full-time position at a successful and established scaleup with an international team
• Flexible working hours and attractive salary
• Mental Health support: Premium access to Headspace for day to day care, and Nilo.health for more difficult times
• The choice of a range of Company Benefits, such as an Urban Sports Club membership, Plants club, JobRad, or a BVG ticket grant
• Personal learning budget to support your professional growth, as well as free in-house language courses
• Access to company car sharing
• Regular company events (post-covid)
• Hybrid setup: Though have a beautiful office in the heart of Berlin, however, how much time you’d like to work remotely vs. onsite depends on you and your team