Senior Data Analyst

Responsibilities

• Design, build, and maintain scalable data models using dbt and strong SQL, with a focus on robust data marts and a clean semantic layer.

• Own the BI layer (Looker/LookML) end-to-end, creating self-service explores that give the entire company a single source of truth for analysis.

• Translate complex business logic into structured data models, including topics such as Customer Health Scores, NRR (cohort-based), CAC Payback, product unit economics, churn, provisions, and commercial KPIs.

• Unify and harmonize data across systems such as Salesforce, Product Data, HubSpot, Jira, Intercom, Personio, and internal booking/factoring systems.

• Develop end-to-end reporting solutions from requirement gathering and data validation to Looker dashboards and stakeholder-ready reports.

• Build advanced analyses such as:

• Sales funnel and GTM performance tracking.

• Commercial KPI automation.

• Cohort-based NRR, CAC payback and churn analytics.

• Revenue reconciliation (Signed vs. Actual Revenue).

• Customer and usage benchmarks (including regional usage/booking patterns).

• Ensure data quality and cross-functional alignment:

• Identify gaps in data collection and instrumentation before modeling begins, ensuring quality, consistency, and long-term scalability.

• Establish tests and validation logic in dbt to guarantee reliability and transparency across data models.

• Collaborate closely with Product, Commercial and Finance to deeply understand the processes generating the data.

• Support system alignment between tools to ensure consistent reporting logic across the organization.

Requirements

• Strong hands-on experience with SQL, modular query design and dimensional data modeling (star schemas, fact/dimension design).

• Production experience designing and maintaining scalable data models using modern transformation tools (e.g. dbt, SQLMesh, Metabase), including testing and documentation.

• Experience developing SQL-based data marts and self-service explores BI tool with modeling capabilities (e.g. Looker).

• Solid understanding of revenue metrics (MRR, NRR, churn, cohort logic), SaaS KPIs, and GTM performance metrics.

• Experience integrating and modeling data from tools such as Salesforce, HubSpot, CRM systems, and financial systems.

• Strong stakeholder management skills and the ability to translate ambiguous business questions into structured analytical frameworks.

• A proactive mindset—you question definitions, challenge inconsistencies, and improve processes instead of just reporting on them.

• Fluency in SQL; experience in dbt and Looker/LookML is a plus.

• Professional proficiency in English; German is a plus.