Data Analytics Architect (m/f/d)
Redcare Pharmacy Open · verified Oct 24, 2026 At a glance
Mid-level Data Analysis & BI role at Redcare Pharmacy. Köln · full-time · no salary stated · we estimate €65,000–€82,850 across Germany.
Redcare Pharmacy has not published a salary for this role. The figure below is our estimate, not theirs.
dataroles summary, based on the employer's posting.
What you'll do
- Set the analytics platform blueprint across Fabric and Databricks, keeping it aligned with business scale and longer-term data plans
- Shape semantic and data models for scale, using refresh patterns, partitions, aggregations and composite models
- Build a governed DBT metrics layer with defined measures, tracked transformation versions and a clear split from consumption
- Set access rules across Unity Catalog, RBAC, RLS/OLS and workspace boundaries
- Trace platform slowdowns across modeling, DAX, Spark, capacity and governance to find their source
What you bring
- You have substantial production experience with Fabric and Power BI Premium capacity, including behavior under heavy concurrent use
- You can optimize Databricks and SparkSQL workloads and manage data access through Unity Catalog
- You know how to design and grow an enterprise metrics layer, with DBT as the preferred framework
- You can diagnose performance problems across data models, compute and platform capacity
Who this fits
This mid-level role suits an analytics architect who works across platform design and system performance, rather than focusing on individual dashboards. The role is based in Köln and hybrid. The stated home-working benefit allows up to twenty days a year from anywhere in the EU.
From the employer
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.
Data Analysis & BI work from LinkedIn, X, Reddit and Upwork, in one list.
Each morning you get everything that fits, strongest first.
Data Analysis & BI
Find me workBy the team behind dataroles.