Junior Analytics Engineer
Junior Analytics Engineer
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
Job Description
We are Gemma Analytics: a Berlinbased company specializing in generating insights in highperformance data infrastructure. Gemma was founded in early 2020 by two data enthusiasts. Ever since we have helped over 70 companies to become more datadriven and successful. We have a fun honest and inclusive work environment. We are always looking for dataminded people we can learn from.
Tasks
Gemma Analytics is datadriven and helps clients to become more datadriven.
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 youre a Data Magician. While manipulating data you bring out the detailed information and quirky insights. You find what others cant 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 wellinformed decisions based on data.
Responsibilities:
- As we are toolingagnostic you will touch multiple technologies and understand the ins & outs 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
Technologies youll use
Working with multiple clients we are in touch with many technologies which is truly exciting. We use stateoftheart technologies while being fully pragmatic (we do not 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 our clients we either use a scheduler (e.g. Apache Airflow or Prefect) and run Python DAGs with it we also like to work with dlt as a framework
- For standard connectors we work with Fivetran or Airbyte Cloud preferably
Data Warehousing
- For smaller data loads we mostly use PostgreSQL databases
- For larger datasets we mostly work with Snowflake or BigQuery
Data Transformation
- We love to use dbt (data build tool) since 2018 we can also work without it yet we are fans to be honest
- It is important to us that we work versioncontrolled peerreviewed with data testing and other engineering best practices
Data Visualization
- For smaller businesses with < 100 FTE we mostly recommend Metabase or Superset as a powerful opensource reporting tool
- For specified needs and a centralized BI we recommend PowerBI or Tableau
- For a decentralized selfservice BI with more than 50 users we recommend Looker Holistics or ThoughtSpot
- We are always on the lookout for new tools at the moment we are excited about Lightdash Omni dlt and other tools
Requirements
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 Kimballs Dimensional Modelling) and data warehousing in general
Benefits
We are located in Berlin close to Nordbahnhof. We are currently 20 colleagues and will grow to 22 colleagues this year. Other perks include:
- We are a hybrid company that meets in the office twice a week one common office day and one flexible day
- We allow for intraEU workcations for up to 3 months a year (extraEU workcations also if this is allowed)
- We have an honest inclusive work environment and want to nurture this environment
- We dont 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 to further initiatives
- We pay a marketfriendly salary and we additionally distribute at least 20 of profits to our employees
- We are fastgrowing and 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 and having a good time 2021: Austria 2022: Czech Republic: Germany 2025: Spain)
How youll get here
- CV Screening
- Phone/Coffee/Tea Initial Conversation
- Hiring Test @home
- Interviews with 23 future colleagues
- Reference calls
- Offer Hired
Looking forward to your application :
Employment Type
Full Time
