Service: Data Apps & Infrastructure

Data Apps & Infrastructure: a data engineering foundation that scales

Our data engineering consulting is for companies that want their data on a platform that grows with the business. We build the infrastructure, pipelines and integrations that analytics and AI workloads can run reliably on. We have built platforms from scratch and moved teams off Y42, a home-grown warehouse or a legacy ERP onto a modern data stack.

DWH & data modelingPipelines & integrationsCustom data apps (bespoke tooling)Cloud infrastructure (DevOps & IaC)
“In a migration I don't just rebuild every connector one to one. I first look at what the old logic actually does. In the end your team should be able to change the pipelines itself.”
Lui, Lead Data & AI Engineering at Gemma Analytics
Pipeline architect
Your expert

Lui

Lead Data & AI Engineering
What we do

What we deliver

Every data product is only as good as the platform under it. Four building blocks make up a Modern Data Stack that holds up.

01

DWH & data modeling

We build your cloud data warehouse, for example in Snowflake or Google BigQuery. With dbt we model, test and document the data, so one single source of truth emerges for reporting and analysis. You get a warehouse with dbt models in staging, intermediate and mart layers, with tests and documentation.

02

Pipelines & integrations

In data integration, data from your shop, marketing, CRM and support tools flows into the warehouse automatically and on schedule. Standard sources such as your shop and ad platforms come in through Fivetran. For sources without a ready-made connector we write our own pipelines with dlt and Airflow, including SOAP interfaces or an ERP database reached over VPN. Failed runs report to a dedicated alerting channel.

03

Custom data apps (bespoke tooling)

When standard tools do not fit, we build custom data apps and internal tools (sometimes called a Company OS) that your whole organisation keeps coming back to. Sometimes the warehouse needs to produce a finished output. For Tasty Urban the pipeline generates the credit notes for partner restaurants and creates them as drafts in the invoicing tool. For another client, Claude queries the data directly through a semantic layer.

04

Cloud infrastructure (DevOps & IaC)

We set up the cloud infrastructure under your data platform. Servers, network and access are described as code with OpenTofu or Terraform and Ansible, so the setup is versioned like code and can be rebuilt on demand. Secrets live in a password manager, never in the repository.

Everything is yours from day one

Code and accounts belong to you from the start.

Repos in your GitHub organisationWarehouse in your accountInfrastructure as codeSecrets in a password manager
Typical problems

Typical problems we solve

Does any of this sound familiar? Then your data platform is ready for a closer look.

Your data is scattered across tools

Shop, marketing, CRM and support each deliver their own numbers, and fragmented, manual processes make it hard to track key metrics.

Your platform limits your growth

The setup stopped scaling as the business and its data volumes grew. Every new question means another tab. By now a data warehouse modernisation is overdue.

Data refreshes keep breaking

When refreshes fail, trust in the numbers suffers, and the team goes back to checking everything by hand.

Your tool vendor shuts down

Loading, transformation and orchestration all depend on it.

You are switching ERP

Your reporting has to keep working, so the data migration to the new data platform has to happen without a gap.

A warehouse only one person understands

One person built it in-house over years, and only they understand it.

How we work

From discovery call to production

We work hands-on and results-driven, in four steps.

01

Discovery call

We spend 30 to 60 minutes on your challenges, your current setup and where your data lives today.

02

Inventory & architecture

We clarify which sources and systems to connect, design the target architecture for your warehouse and write down for each building block when it is done.

03

Build

We build pipelines, warehouse and data models step by step: loaded automatically, tested and documented. Every week we show you the current state, and every few weeks we look at budget and next steps together.

04

Production & handover

The platform runs in production. Handover includes documentation and recorded hands-on sessions in which your team changes a connector itself and opens a pull request. Where it helps, we also cover interim roles in your data team.

Tools & technologies

The technologies behind our data engineering

We work with these technologies, among others, from Snowflake consulting to dbt and Airflow. Which ones fit depends on your setup.

dbt logoSnowflake logoGoogle BigQuery logoPostgreSQL logoApache Airflow logoPrefect logoFivetran logoPython logo
Trusted by

70+ successful projects in six years, a senior team of 20 based in Berlin.

Viessmann logoVaillant logoyfood logoFlaschenpost logoglow25 logoheyData logoaudibene logoHomeToGo logoManiko logoWikinger Reisen logoasphaltgold logoPets Deli logoVALUE AG logomotel a mio logoju:it logoInno Nature logoMocMakler logon. logoSmoobu logoTasty Urban logoAUXEUM logohellomed logoNatsana logoSwappie logowholey logoFOND OF logoCleanwatts logoViessmann logoVaillant logoyfood logoFlaschenpost logoglow25 logoheyData logoaudibene logoHomeToGo logoManiko logoWikinger Reisen logoasphaltgold logoPets Deli logoVALUE AG logomotel a mio logoju:it logoInno Nature logoMocMakler logon. logoSmoobu logoTasty Urban logoAUXEUM logohellomed logoNatsana logoSwappie logowholey logoFOND OF logoCleanwatts logo
FAQ

Frequently asked questions about data warehouse consulting

It depends on the scope. The main cost drivers are the number and type of data sources, whether your sources have a ready-made connector or need a custom pipeline, how much of your platform already exists, whether custom data apps are part of the project and how much cloud infrastructure we set up. In a free discovery call we clarify your needs and outline what a project could look like.

A focused migration with a handful of custom connectors takes us about two to three months. A new platform with first dashboards is typically up after three to four months. Large migrations with many legacy models take noticeably longer. We work out how long your project takes in the discovery call.

It pays off once spreadsheets and single tools stop scaling with the business. Our clients have between 30 and 15,000 employees, mostly 50 to 200, and a platform like this fits that range because it grows source by source. Maniko and Glow25 are growing brands that took exactly this step.

Our Modern Data Stack typically includes dbt, Snowflake, Google BigQuery, PostgreSQL, Apache Airflow, Prefect, Fivetran and Python. Which ones fit depends on your setup and your team.

Data engineering builds the foundation: pipelines, the warehouse and the infrastructure. BI and data analytics consulting builds on top of it: dashboards, reporting and deeper analysis. Often you need both, and we cover both in one team.

To BI & Data Analytics

A modern data warehouse runs in the cloud, for example in Snowflake or Google BigQuery, and brings the data from all your systems into one place. Pipelines load the data automatically, dbt models and tests it, and reporting, analysis and AI all work from the same data. Together with the tools around it, this is called a modern data stack.

Mid-sized companies are usually best served by specialised data consultancies that build the data platform themselves and then hand it over to your team. Gemma Analytics works this way: our data engineering services cover the warehouse, the pipelines and the data infrastructure in your own accounts, documented and with hands-on sessions for your team. Most of our clients have 50 to 200 employees.

Possibly, including for platform and infrastructure projects. Gemma Analytics is registered with BAFA as a consulting company. For eligible SMEs, the programme covers up to 50% (up to 80% in the new federal states) of eligible consulting costs as a non-repayable grant, up to a maximum amount. The application has to be approved before the project starts, and we walk you through it at no charge.

More about BAFA funding
Contact

Ready for a data foundation that scales?

Book a free discovery call: 30 to 60 minutes, focused on your challenges.

Bijan, Founder & Managing Director at Gemma Analytics
Your contact

Bijan Soltani

Founder & Managing Director

Bijan and the Gemma team look at your platform and your data sources with you. In the call we also check whether your project qualifies for BAFA funding.