Job Information
About the Position
Introduction
Werfen is a growing, family-owned, innovative company founded in 1966 in Barcelona, Spain. We are a worldwide leader in specialized diagnostics in the areas of Hemostasis, Acute Care Diagnostics, Transfusion, Autoimmunity, and Transplant. Through our Original Equipment Manufacturing (OEM) business line, we research, develop, and manufacture customized assays and biomaterials. We operate directly in 30 countries, and in more than 100 territories through distributors. Our Headquarters and Technology Centers are located in the US and Europe, and our workforce is more than 7,000 strong.
Overview
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.
Responsibilities
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.
Qualifications
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
If you are interested in constantly learning and being challenged on a daily basis, we encourage you to submit your resume or CV.
Werfen appreciates and values diversity. We are an Equal Opportunity/Affirmative Action Employer M/F/D/V.
www.werfen.com
