(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.

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!

Find more English Speaking Jobs in Germany on Arbeitnow