At Redcare Pharmacy, we are continuously strengthening our data-driven approach to Strategic Procurement across our European markets.
In this role, you will take ownership of the technical foundation behind our Procurement reporting and performance analytics.
Build and maintain Power BI dashboards tracking Procurement performance across European markets
Extract and transform large datasets from multiple systems using SQL and dbt
Automate recurring reporting and replace manual Excel-based workflows
Analyze supplier performance, bonuses and profitability to support commercial decisions
Identify and resolve data inconsistencies and standardize KPI definitions
From the employer’s posting
At Redcare Pharmacy, we are continuously strengthening our data-driven approach to Strategic Procurement across our European markets. To support this ambition, we are looking for a technically strong Data Analyst - Procurement who enjoys turning complex data into reliable, scalable and actionable analytics solutions.
In this role, you will take ownership of the technical foundation behind our Procurement reporting and performance analytics. You will work with large datasets, develop automated data pipelines and reporting solutions, and ensure that our Procurement teams have access to accurate, consistent and meaningful information.
Design, build and continuously improve interactive Power BI dashboards and reporting solutions to monitor Procurement performance across our European markets
Extract, transform and analyze large datasets from different systems and sources using SQL, dbt and other relevant technologies
automate recurring reporting processes and reduce manual, Excel-based workflows
Develop analytical solutions to monitor supplier performance, identify deviations and support bonus forecasting, profitability analyses and commercial decision-making
Identify and resolve data inconsistencies, improve data quality and establish reliable, standardized KPI definitions
Add your resume and we’ll mark which of these tools you already use, and point out anything in the posting that could rule you out.
SQL
Databricks
dbt
Power BI
Where the posting names them
About Your Tasks:
- Data Analytics & Engineering: Extract, transform and analyze large datasets from different systems and sources using SQL, dbt and other relevant technologies.
- BI & Dashboard Development: Design, build and continuously improve interactive Power BI dashboards and reporting solutions to monitor Procurement performance across our European markets.
- A degree in Data Science, Business Analytics, Computer Science, Business Informatics, Economics or a comparable field.
- Strong hands-on experience with SQL and Power BI, including data modeling, data transformation and dashboard development.
- Experience with dbt or comparable data transformation frameworks; knowledge of Databricks or similar modern data platforms is a plus.
- Strong hands-on experience with SQL and Power BI, including data modeling, data transformation and dashboard development.
- Experience with dbt or comparable data transformation frameworks; knowledge of Databricks or similar modern data platforms is a plus.
- Solid understanding of data structures, ETL/ELT processes, data quality and reporting architecture.
- Data Analytics & Engineering: Extract, transform and analyze large datasets from different systems and sources using SQL, dbt and other relevant technologies.
- BI & Dashboard Development: Design, build and continuously improve interactive Power BI dashboards and reporting solutions to monitor Procurement performance across our European markets.
- Data Modeling & Automation: Develop scalable data models, automate recurring reporting processes and reduce manual, Excel-based workflows.
Data Analytics & Engineering: Extract, transform and analyze large datasets from different systems and sources using SQL, dbt and other relevant technologies.
BI & Dashboard Development: Design, build and continuously improve interactive Power BI dashboards and reporting solutions to monitor Procurement performance across our European markets.
Data Modeling & Automation: Develop scalable data models, automate recurring reporting processes and reduce manual, Excel-based workflows.
Data Quality & Governance: Identify and resolve data inconsistencies, improve data quality and establish reliable, standardized KPI definitions and reporting structures.
Procurement Performance Reporting: Build analytical solutions covering key Procurement KPIs such as supplier bonuses, purchasing conditions, payment terms, purchasing volumes, direct supply share and supplier profitability.
Advanced Analytics: Develop analytical solutions to monitor supplier performance, identify deviations and support bonus forecasting, profitability analyses and commercial decision-making.
Cross-functional Collaboration: Partner with Strategic Procurement, Data/BI and Finance/Controlling to understand business requirements and translate them into effective technical solutions.
Continuous Improvement: Proactively identify opportunities to improve our data infrastructure, reporting capabilities and analytical processes, leveraging modern technologies and automation.
Qualifications
About You:
A degree in Data Science, Business Analytics, Computer Science, Business Informatics, Economics or a comparable field.
Strong hands-on experience with SQL and Power BI, including data modeling, data transformation and dashboard development.
Experience with dbt or comparable data transformation frameworks; knowledge of Databricks or similar modern data platforms is a plus.
Solid understanding of data structures, ETL/ELT processes, data quality and reporting architecture.
Strong analytical and problem-solving skills, with the ability to work independently with complex datasets.
Experience in developing automated and scalable reporting solutions, ideally in a commercial, retail, e-commerce or Procurement environment.
Ability to understand business requirements and translate them into reliable technical solutions.
A proactive, structured and detail-oriented working style, combined with curiosity and a continuous improvement mindset.
Very good English communication skills; German is an advantage.
Additional Information
About your Benefits:
In order to provide our employees with the best possible support for their individual needs, we offer a wide range of 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.
Redcare events: We promote teambuilding through creative team events, and celebrate our successes together at regularly scheduled parties.
Kindergarten Grant: We offer our employees who pay for childcare in kindergarten 100,00 € (total) per month.
Mental health: Get quick professional help from psychologists from nilo if you feel overwhelmed in your personal or professional life. Anonymously and free of charge.
Personal Development: We are all constantly learning. That's why we support and foster your career development through internal & external training and help you grow.
Mobility: Your commute matters to us. We provide our employees with a fully costed Deutschland Ticket which can be used at any time.
Sports & Health: Your well-being is our top priority. Therefore, we offer you a range of opportunities to improve your health. Profit from a membership (M) package at Urban Sports Club, providing a variety of sports offers tailored to your interests.
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:
At Redcare Pharmacy, we are continuously strengthening our data-driven approach to Strategic Procurement across our European markets. To support this ambition, we are looking for a technically strong Data Analyst - Procurement who enjoys turning complex data into reliable, scalable and actionable analytics solutions.
In this role, you will take ownership of the technical foundation behind our Procurement reporting and performance analytics. You will work with large datasets, develop automated data pipelines and reporting solutions, and ensure that our Procurement teams have access to accurate, consistent and meaningful information.
Working closely with Strategic Procurement, Data/BI and Finance, you will help us move away from manual reporting towards a scalable, automated and data-driven Procurement environment.
Demand for Analyst roles
New Analyst postings at the employers we follow are up 25% over the last 6 weeks compared with the 6 before.
August 17Last week
Each bar is one week of new postings. The darkest bars are the last 6 weeks.
Counted from the hiring pages we’ve followed for at least five weeks, so employers we add don’t look like growth. Updated weekly.
About the role
We file this job under Analyst, by the work the posting describes.
Analysts answer business questions with data. They pull numbers with SQL, build reports and dashboards, and explain what changed and why to the people making decisions.
Most postings ask for SQL, spreadsheets, a dashboard tool such as Tableau or Power BI, and clear writing.
Unlike a data scientist, an analyst mostly explains what happened rather than building models that predict what will.