(Junior) Analytics Engineer

Gemma Analytics; Berlin; Hybrid; EUR 45.000 - 75.000; Vollzeit

Zusammenfassung

Ein innovatives Unternehmen sucht einen Analytics Engineer, der als Datenzauberer fungiert und Unternehmen dabei hilft, aus ihren Daten wertvolle Erkenntnisse zu gewinnen. In dieser spannenden Rolle arbeiten Sie mit verschiedenen Technologien und Kunden, um komplexe Datenprobleme zu lösen und fortschrittliche Datenvisualisierungen zu entwickeln. Sie werden Teil eines dynamischen Teams, das eine inklusive und ehrliche Arbeitsumgebung fördert, in der Lernen und Zusammenarbeit geschätzt werden. Wenn Sie leidenschaftlich an Daten interessiert sind und eine positive Arbeitskultur suchen, ist dies die perfekte Gelegenheit für Sie.

Leistungen

Flexible Arbeitszeiten

Team-Events

Workcations

Hochwertige Arbeitsgeräte

Jährliches Offsite-Event

Marktgerechtes Gehalt

Profitbeteiligung

Lern- und Austausch-Sessions

Qualifikationen

• Erfahrung in SQL und relationalen Datenbanken ist erforderlich.
• Intellektuelle Neugier und strukturiertes Denken sind wichtig.

Aufgaben

• Datenmanipulation und Generierung von Geschäftswerten aus Datensätzen.
• Zusammenarbeit mit Kunden zur Lösung von Datenproblemen.

Kenntnisse

SQL

Datenanalyse

Intellektuelle Neugier

Stakeholder-Management

Datenmodellierung

Ausbildung

Bachelor in Informatik oder verwandten Bereichen

Tools

PostgreSQL

Snowflake

BigQuery

Apache Airflow

dbt

PowerBI

Tableau

Looker

Metabase

Jobbeschreibung

About Gemma Analytics

At Gemma, we help our clients activate data by using state-of-the-art technology. Our clients make better choices and are empowered to make use of their data on their own. We are service-focused, yet also build open-source tools to deliver a more effective and efficient service. You can read more about our data philosophy here.
Our clients range from Series A ventures to SMEs with 30 to 13,000 employees per client. We have an honest, pleasant, and fun work environment. Please make reference calls on us for validation :)

About the job

Gemma Analytics is data-driven and helps clients to become more data-driven.

As one of our analytics engineers, you play a critical role in helping our clients to generate business value out of their existing data sets. There are no two ways about it – you’re a Data Magician. While manipulating data, you bring out the detailed information and quirky insights. You find what others can’t and glean business insights from numbers. By collaborating with clients, you find practical solutions to problems.

You have the opportunity to work on difficult problems while helping startups and SMEs to make well-informed decisions based on data.

Challenges:

• As we are tooling-agnostic, you will touch multiple technologies and understand the in’s & out’s what is currently possible in the data landscape
• Collaborate and connect with domain experts to solve data obstacles in various industries
• Develop advanced data reporting and visualizations
• Apply data modeling methodologies and contribute to a robust data platform for our clients

Who you are

We believe in a good mixture of experience and upside in our team. We are looking for both types of people equally. For this role, we are looking for people with first experience in writing good SQL code in production. In addition to that, we value intellectual curiosity, openness to learn, and a structured mindset.

Besides that, we are looking for the following:

• First experience with SQL and relational databases
• Business Fluency (C2 or native) in German and English
• Optional: Experience with one or more programming languages (Python preferred)
• Optional: Experience with one or more data visualization tools
• Optional: Experience with managing stakeholders and/or clients
• Optional: First understanding of data modeling techniques (e.g. Data Vault or Kimball’s Dimensional Modelling) and data warehousing in general

Technologies you’ll use

Working with multiple clients, we are in touch with many technologies, which is truly exciting. We aim to use state-of-the-art technologies while being fully pragmatic (we do not crack a walnut with a sledgehammer). We follow an ELT philosophy and divide the tasks between Data Engineering and Analytics Engineering accordingly.

The following technologies constitute our preferred data tech stack:

• Data Loading
  • For most clients, we use our own open-source Python library EWAH and Apache Airflow
  • For simple requests, we work with Fivetran or Stitch
• Data Warehousing
  • For smaller data loads, we mostly use PostgreSQL databases
  • For larger datasets, we work with Snowflake or BigQuery
• Data Transformation
  • We love to work with data build tool (dbt)
• Data Visualization
  • For smaller businesses with < 100 FTE, we mostly recommend Metabase as a powerful open-source reporting tool
  • For specified needs and a centralized BI, we recommend PowerBI or Tableau
  • For a decentralized, self-service BI with more than 50 users, we recommend Looker

Gemma Perks

We are located in Berlin, close to Nordbahnhof. We are currently 20 colleagues and will grow to 22 colleagues until the end of the year. Other perks include:

• We have an honest, inclusive work environment and want to nurture this environment
• We have frequent team events in Berlin: our cultural base
• We encourage workcations and even do workcations as a company - it is up to you to come to the office between one and five days a week
• We don’t compromise on equipment - a powerful Laptop, extra screens, and all the tools you need to be effective
• We will surround you with great people who love to solve (mostly data) riddles
• We believe in efficient working hours rather than long working hours - we focus on the output rather than the input
• We learn and share during meetups, lunch & learn sessions and are open for further initiatives
• We pay a market-friendly salary and we additionally distribute at least 20% of profits to our employees
• We are fast-growing, have technology at our core, yet we do not rely on a VC and operate profitably
• We have a great yearly offsite event that brings us all together for a full week, enjoying good food, having a good time, and of course, solving complex data-related tasks

How you'll get here

• CV Screening
• Phone/Coffee/Tea Conversation
• Coding challenge @home
• Interviews with 3 future colleagues
• Reference calls
• Offer + Hired