Apply now

Quick facts:

  • Experienced Professional
  • Business Intelligence
  •  Berlin

Senior Data Warehouse Engineer (m/f)

Become a part of the smava-story now as a:

Senior Data Warehouse Engineer (m/f)

As Data Warehouse Engineers we work collaboratively with our Business Analytics and IT Teams to implement new ideas and initiatives according to our stakeholder requirements. We provide data-driven solutions and easy implementation with the latest technology. Our major task is to build and maintain our Enterprise Data Warehouse using Data Vault 2.0 methodology. Our challenges are maintaining, extending and optimizing our data warehouse so that business analytics and stakeholders can make correct decisions. Our team is growing and looking for a talented colleague to improve and maintain our DWH structure. If you think you can handle this challenge – HERE YOU GO!

Your tasks

  • Gain a deep understanding of our business model, processes and DWH infrastructure
  • Work collaboratively with our Analytic sub-teams to create and implement new initiatives according to our stakeholder requirements
  • Maintain, optimize and extend our Data Warehouse infrastructure on PostgreSQL
  • Design, implement, improve and maintain ETL processes as well as the data warehouse architecture
  • Provide support in the application and collection of data from company-wide sources (AWS, RDBMS, API’s and others)
  • Collect additional data from external companies using Python
  • Transfer and apply business logic into data-marts for analytical use by our Tableau reporting tool and Data Science Team
  • Provide ad-hoc support and mentoring analysts which interacts with the database

Your profile

  • You have already gained at least 3-5 years of relevant working experience as a Data Warehouse Engineer
  • You have worked with SQL and procedural SQL (ideally PostgreSQL) for at least 3-5 years
  • You are an expert of ETL processes, knowing the most important tricks and stunts also in using Tools like Pentaho Data Integration (Kettle)
  • You have experience with Cloud infrastructure, especially AWS
  • You have a solid knowledge of Data Warehouse methodologies and modeling, especially Star Schema, Snowflake and Data Vault 2.0
  • You are familiar with programming languages such as Python and Shell, ideally Python packages like requests, boto3, pandas etc.
  • You have an analytical and conceptual mode of thinking and a high affinity for numbers and data
  • You are highly flexible and can cope up with a fast-changing environment
  • You have a proactive and communicative attitude and consider yourself as a person who can work independently
  • Your English is fluent and you are willing to learn German as well

Nice to have

  • You have some experience with database administration (DBA) and the performance tuning
  • You are familiar with Java or/and JavaScript languages
  • Experience with Real Time and Big Data technologies like Apache Kafka, AWS EMR, Spark or Snowflake 

What we offer

  • Signing bonus, because every great decision should be rewarded
  • Relocation bonus (in case you are relocating to Berlin)
  • Onboarding support (e.g. visa sponsorship & accommodation)
  • An exciting opportunity in an innovative and fast-growing Fintech company
  • Paid education (e. g. trainings, workshops, conferences)
  • Employer-funded pension
  • Subsidized Lunch offer ( and subsidized public transport ticket (VBB Umweltkarte)
  • Discounted fitness offers close to the office
  • Flexible working hours
  • Language courses
  • Brown Bag Lunches, Hackathons, Beer Friday, Cookie Friday, Mystery Lunch, Breakfast Club and team events
  • Open communication, flat hierarchy and fast execution
  • Smart colleagues from all around the world (35+ nationalities)

Did we get your attention? Then we are looking forward to receiving your application including:

  • CV, salary expectations and earliest starting date addressed to Natalia Nehring
  • In case you are not an EU citizen, we also need a copy of your academic degree & valid passport
  • If you already have a Blue Card, Visa or Work Permit, please let us know

Note that it will be difficult to proceed with your application without the documents mentioned above.

About us

We are smava, the online loan comparison platform.  We are one of the three largest Fintech-employers in Germany. Our mission is to revolutionize the loans market by making it fair and transparent. smava finds the best loans for everyone: fast, convenient and cost-effective. We are in the third stage of innovation in the finance industry: first ATM’s, then online-banking, now digital loans by smava! This is also why we were awarded as Innovator 2018. All of this was achieved thanks to almost 500 employees.

Further information

Select files
Please upload additional files such as your CV in the PDF Format. Please note that files must not be bigger than 10MB.