Data Analytics Architect (m/f/d)

About Redcare Pharmacy:

As Europe’s No.1 e-pharmacy Redcare Pharmacy is powered by passionate teams and cutting-edge innovation. We strive to create a healthy collaborative work environment where every employee feels valued and inspired to contribute to our vision “Until every human has their health”. If you’re seeking a career that offers purpose and aligns with your values join us and start your #Redcareer today.

About the role:
As an Analytics Architect, you will define and evolve our enterprise analytics architecture across Microsoft Fabric and Databricks. You operate above individual dashboards or pipelines and instead design the structural foundations — from capacity strategy and governance to scalable semantic modeling and a clean metrics layer.

This role is about architectural clarity at scale: enabling 500+ users to work on trusted, high-performing data products while ensuring governance, observability, and long-term maintainability across domains.

About the tech stack:
Microsoft Fabric (Premium Capacity), Power BI Premium, Databricks, SparkSQL, Unity Catalog, DBT (metrics layer & transformation framework), Azure AD (RBAC & governance).

About your tasks:

• Define and own the enterprise analytics architecture across Fabric and Databricks, aligning platform design with business scale and long-term data strategy.
• Architect and optimize large-scale semantic and data models including incremental refresh, partitioning, aggregation strategies and composite models.
• Establish a governed metrics layer (DBT) ensuring clear metric definitions, versioned transformations and separation between transformation and consumption.
• Design and enforce data governance & access control using Unity Catalog, RBAC, RLS/OLS and workspace isolation strategies.
• Lead performance diagnostics at system level — identifying whether bottlenecks originate from data modeling, DAX logic, Spark processing, capacity strategy or governance setup.

About you:

• You have strong production experience with Fabric / Power BI Premium capacity, including performance behavior under high user concurrency.
• You bring hands-on expertise in Databricks and SparkSQL, including performance optimization and data governance via Unity Catalog.
• You understand how to build and scale a metrics layer architecture (DBT preferred) in an enterprise environment.
• You think in systems, not dashboards — you are comfortable diagnosing complex performance issues across modeling, compute, and capacity layers.

About your benefits:

In order to provide you with the best possible support for your individual needs - whether it‘s living a healthy life, having enough time for your family, or developing your skills - we offer a wide range of different, site-specific benefits:

• Work from Home: If your job does not require you to be present in the office, we can arrange the place you work from individually - even for up to 20 days a year anywhere in the EU.
• Personal development: Grow! We support and encourage your individual development through various in- and external trainings.
• Redcare events: We promote teambuilding through creative team events, and celebrate our successes together at regularly scheduled parties.
• Corporate pension plan: We offer a company pension scheme and have a dedicated external consultant to offer you the best guidance and advice.
• Mental Health: Get quick and professional help from psychologists of nilo if you feel overwhelmed in private or professional life. Anonymous and free of charge.