WERFEN is a global leader in specialized diagnostics in the fields of hemostasis, acute care, autoimmunity, transfusion, and transplant. Our core business revolves around the research and development, manufacturing, and distribution of diagnostic innovative systems for hospitals and clinical laboratories, for the improvement of patient care.We are a family-owned company founded in 1966 in Barcelona, Spain.

In data and digital innovation, we are on a mission to democratize data and to create tangible value through collaborating with business domains on selected data and AI initiatives. We are a diverse team located in Barcelona, Poland and USA and combine technical expertise with customer centricity to develop and support quality data products to our stakeholders.

Job Summary

As a Data Analyst Senior, you will design, develop, and deploy robust analytical solutions to support key business decisions. You will leverage your expertise in SQL, Excel, Python, and Power BI to transform complex data into actionable insights, build scalable data models, and create compelling visualizations that empower business stakeholders.

You will be part of the Global Team responsible for building and maintaining global facts and dimensions that will serve as a standardized foundation for analytics across the organization.

Under the general direction of the Technical Leader and senior personnel, with moderate latitude for self-direction, work closely with data engineers, BI analysts, and product owners to deliver fast, efficient, and scalable data intelligence solutions for Werfen employees.

Key Accountabilities

Among others, you will:

• Work with the team and business stakeholders to identify requirements, define models, and kickstart new analytics initiatives.
• Develop and maintain complex, scalable data models with SQL and Python within our enterprise data platform.
• Have deep knowledge of datasets within the data platform, serving as subject matter expert for data availability, lineage, and quality. Provide guidance to stakeholders regarding data assets and usage.
• Select and apply appropriate dimensional modeling techniques to support business reporting needs
• Champion, promote, and practice data modeling best practices, code quality, and documentation.
• Works with limited oversight of the technical leader.

Networking/Key relationships

It is critical to be able to build relationships based on trust within the organization as the function is to respond to the internal customer needs while taking into consideration the overall corporate strategy.

Minimum Knowledge & Experience required for the position:

• 5 years of relevant work experience in a similar role in a large company, with experience from multiple projects.
• Experience with modern Data Warehouse architecture approaches, including both Inmon's Corporate Information Factory and Kimball's dimensional modeling methodologies.
• Strong proficiency in Python for data analysis, data wrangling, and process automation, using core libraries such as Pandas, NumPy, and visualization tools.
• Advanced SQL including window functions, CTEs, and query optimization.
• Strong proficiency in Microsoft Excel, including pivot tables, power pivot, advanced excel functions, and basic VBA for simple automation.
• Experience in Power BI, Qlik or other dashboarding software.
• Experience developing, testing, and deploying data transformation pipelines using dbt.
• Demonstrated ability to deliver high‑quality, structured documentation that supports clarity, alignment, and long‑term maintainability.

Preferred:

• AWS, Microsoft Azure cloud computing, or similar
• Familiarity with DataOps principles
• Familiar with Agile methodologies
• Git software versioning
• Familiarity with Prefect for workflow orchestration
• Familiarity with SAP SD and FI modules, as well as basic understanding of ABAP
• Familiarity with key finance KPIs to perform data modeling, automation, and analytical workflows

Skills & Capabilities:

We expect you to demonstrate proficiency in data analysis and have a keen interest in understanding various business domains. We will also need you to be able to communicate data concepts to non-technical colleagues.

• You are fluent in English both orally and in writing.
• Strong analytical and problem-solving skills, with keen attention to detail.
• Skilled in extracting insights from complex datasets.
• Excellent time management and prioritization abilities.
• You have good presentation skills.
• You can communicate well within the team and with stakeholders.
• You can analyze business requirements in dialogue with internal stakeholders.
• You can collaborate directly with external consultants and vendors.
• You are a team player willing to share knowledge, ideas, and banter.

Travel requirements:

5% of time