(Senior) Technical Analyst

<p>At <strong>Nailscamp</strong>, our mission we strive everyday to achieve our mission: <em>to make the world more beautiful, one stroke at a time.</em> 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.</p> <h2>Aufgaben</h2> <p>Joining us, you will:</p> <ul> <li><strong>Shape our Data Architecture:</strong> Design, build, and maintain scalable data models using <strong>dbt</strong> and robust <strong>SQL</strong> within our <strong>Google BigQuery</strong> data warehouse, with a focus on high-performing data marts and a clean semantic layer.</li> <li><strong>Own the BI Layer End-to-End:</strong> 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.</li> <li><strong>Harmonize the E-Com Ecosystem:</strong> Unify and blend data across the <strong>Shopify ecosystem</strong>, Google Analytics, performance marketing channels (Meta, Google Ads, TikTok), ERP/fulfillment tools, and internal booking or factoring systems.</li> <li><strong>Deliver Strategic Insights:</strong> Develop end-to-end reporting solutions—from gathering stakeholder requirements and validating data to building polished dashboards and leadership-ready reports.</li> </ul> <h2>Qualifikation</h2> <p><strong>Data Modeling Expertise:</strong> Strong hands-on experience with SQL, modular query design, and dimensional data modeling (star schemas, fact/dimension design).</p> <p><strong>The Modern Data Stack:</strong> Production experience designing and maintaining data models using <strong>dbt</strong> (or similar transformation tools), including testing and documentation, ideally layered on top of <strong>Google BigQuery</strong>.</p> <p><strong>E-Commerce Native:</strong> A solid understanding of D2C/e-commerce metrics (AOV, LTV, CAC, retention rates, repeat purchase behavior, and cohort logic).</p> <p><strong>A Proactive &#x26; Curious Mindset:</strong> You don't just report numbers—you question definitions, challenge inconsistencies, and proactively optimize data processes.</p> <p><strong>Stakeholder Management:</strong> Exceptional communication skills to translate ambiguous business questions into structured analytical frameworks.</p> <p><strong>Language Skills:</strong> Professional proficiency in English; German is a major plus.</p> <h2>Benefits</h2> <p>The opportunity to leave your mark on a fast-growing, loved consumer brand.</p> <p>A dynamic, creative, and data-driven team right in the center of Berlin.</p> <p>Plenty of ownership, beautiful data challenges, and, of course, the best nail polish in town!</p> <p>Find more <a href="https://www.arbeitnow.com/english-speaking-jobs">English Speaking Jobs in Germany</a> on Arbeitnow</a>