Soc analyst Jobs in Köln

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.

Job Description

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.

• 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.