The Role
Design and maintain scalable data models and semantic layers in BigQuery using dbt and SQL. Lead end-to-end BI and self-service analytics, unify ecommerce and marketing data (Shopify, GA, Meta, Google Ads, TikTok, ERP), gather stakeholder requirements, validate data, and deliver leadership-ready dashboards and reports.
Summary Generated by Built In
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!
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!
Skills Required
- Strong hands-on SQL and dimensional data modeling (star schemas, fact/dimension design)
- Production experience with dbt (transformations, testing, documentation)
- Experience working with Google BigQuery data warehouse
- Experience building self-service BI, data explores, and dashboards
- Knowledge of ecommerce metrics (AOV, LTV, CAC, retention, cohorts)
- Stakeholder management and strong communication to translate business questions into analytics
- Professional proficiency in English
- German language skills
Am I A Good Fit?
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.
Success! Refresh the page to see how your skills align with this role.
The Company
What We Do
Nailscamp GmbH is a leading European e-commerce group dedicated to bringing professional-grade nail artistry into the daily lives of its customers. Through its brands, Proglow and Ongle24, the company provides high-performance gels, nail polishes, and creative tools. Operating as a direct-to-consumer brand for nail care, Nailscamp primarily serves the French and Belgian markets, helping customers express their creativity and self-care.
.png)
