Data Analytics Architect (m/f/d) at Redcare Pharmacy

Cologne, North Rhine-Westphalia, Germany -

Full Time

Start Date

Immediate

Expiry Date

12 Aug, 26

Salary

0.0

Posted On

14 May, 26

Experience

5 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

Microsoft Fabric, Databricks, Power BI Premium, SparkSQL, Unity Catalog, DBT, Azure AD, Semantic Modeling, Data Governance, Performance Diagnostics, DAX, RBAC, RLS/OLS, Data Architecture, Capacity Strategy, Incremental Refresh

Industry

Retail Pharmacies

Description

Company Description 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). Job Description 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. Qualifications 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. Additional Information 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. Remote Type: Data & AI

Responsibilities

Define and evolve the enterprise analytics architecture across Microsoft Fabric and Databricks to support over 500 users. Design scalable semantic models, a governed metrics layer, and enforce data governance and access controls.