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:
- Experience with SQL and relational databases
- Experience with one or more data visualization tools
- Business Fluency (C2 or native) in German
- Optional: Experience with managing stakeholder and/or clients
- Optional: 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 19 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 solving complex data-related tasks
About us
We are Gemma Analytics: a Berlin-based company specialized in generating insights in a high-performance data infrastructure. Gemma was founded in early 2020 by two data enthusiasts. Ever since we have helped over 50 companies becoming more data-driven and successful. We have a fun, honest, and inclusive work environment. We are always looking for data-minded people we can learn from.
