(Senior) Technical Analyst

At **Nailscamp**, our mission we strive everyday to achieve our mission: _to make the world more beautiful, one stroke at a time._ As one of the leading companies for high-quality, long-lasting nail polish, we are a fast-moving consumer brand operating right from the vibrant heart of Berlin. We combine beauty, innovation, and data-driven insights to deliver products our community loves.

Tasks

Joining us, you will:

• **Shape our Data Architecture:** Design, build, and maintain scalable data models using **dbt** and robust **SQL** within our **Google BigQuery** data warehouse, with a focus on high-performing data marts and a clean semantic layer.
• **Own the BI Layer End-to-End:** Lead the development of our self-service BI capabilities, creating intuitive data explores and dashboards that give the entire company a single, unified source of truth.
• **Harmonize the E-Com Ecosystem:** Unify and blend data across the **Shopify ecosystem**, Google Analytics, performance marketing channels (Meta, Google Ads, TikTok), ERP/fulfillment tools, and internal booking or factoring systems.
• **Deliver Strategic Insights:** Develop end-to-end reporting solutions—from gathering stakeholder requirements and validating data to building polished dashboards and leadership-ready reports.

Requirements

**Data Modeling Expertise:** Strong hands-on experience with SQL, modular query design, and dimensional data modeling (star schemas, fact/dimension design).

**The Modern Data Stack:** Production experience designing and maintaining data models using **dbt** (or similar transformation tools), including testing and documentation, ideally layered on top of **Google BigQuery**.

**E-Commerce Native:** A solid understanding of D2C/e-commerce metrics (AOV, LTV, CAC, retention rates, repeat purchase behavior, and cohort logic).

**A Proactive & Curious Mindset:** You don't just report numbers—you question definitions, challenge inconsistencies, and proactively optimize data processes.

**Stakeholder Management:** Exceptional communication skills to translate ambiguous business questions into structured analytical frameworks.

**Language Skills:** Professional proficiency in English; German is a major plus.

Benefits

The opportunity to leave your mark on a fast-growing, loved consumer brand.

A dynamic, creative, and data-driven team right in the center of Berlin.

Plenty of ownership, beautiful data challenges, and, of course, the best nail polish in town!

At **Nailscamp**, our mission we strive everyday to achieve our mission: _to make the world more beautiful, one stroke at a time._ As one of the leading companies for high-quality, long-lasting nail polish, we are a fast-moving consumer brand operating right from the vibrant heart of Berlin. We combine beauty, innovation, and data-driven insights to deliver products our community loves.

Aufgaben

Joining us, you will:

• **Shape our Data Architecture:** Design, build, and maintain scalable data models using **dbt** and robust **SQL** within our **Google BigQuery** data warehouse, with a focus on high-performing data marts and a clean semantic layer.
• **Own the BI Layer End-to-End:** Lead the development of our self-service BI capabilities, creating intuitive data explores and dashboards that give the entire company a single, unified source of truth.
• **Harmonize the E-Com Ecosystem:** Unify and blend data across the **Shopify ecosystem**, Google Analytics, performance marketing channels (Meta, Google Ads, TikTok), ERP/fulfillment tools, and internal booking or factoring systems.
• **Deliver Strategic Insights:** Develop end-to-end reporting solutions—from gathering stakeholder requirements and validating data to building polished dashboards and leadership-ready reports.

Qualifikation

**Data Modeling Expertise:** Strong hands-on experience with SQL, modular query design, and dimensional data modeling (star schemas, fact/dimension design).

**The Modern Data Stack:** Production experience designing and maintaining data models using **dbt** (or similar transformation tools), including testing and documentation, ideally layered on top of **Google BigQuery**.

**E-Commerce Native:** A solid understanding of D2C/e-commerce metrics (AOV, LTV, CAC, retention rates, repeat purchase behavior, and cohort logic).

**A Proactive & Curious Mindset:** You don't just report numbers—you question definitions, challenge inconsistencies, and proactively optimize data processes.

**Stakeholder Management:** Exceptional communication skills to translate ambiguous business questions into structured analytical frameworks.

**Language Skills:** Professional proficiency in English; German is a major plus.

Benefits

The opportunity to leave your mark on a fast-growing, loved consumer brand.

A dynamic, creative, and data-driven team right in the center of Berlin.

Plenty of ownership, beautiful data challenges, and, of course, the best nail polish in town!