HAYS is partnering with a Top global pharmaceutical company operating across multiple countries and leading innovation in human healthcare.
The company has established a Digital & Data Hub in Barcelona to support international, insight-driven initiatives across marketing, medical affairs, and customer intelligence.
We are looking for a Business Intelligence (BI) Engineer to bring strong expertise in Snowflake, AWS, and data visualization within a dynamic and fast-paced environment.
Key Responsibilities
• Design, develop, and maintain analytical tables in Snowflake, ensuring scalability and performance.
• Optimize data storage and retrieval processes to improve query efficiency.
• Implement robust data models aligned with business and reporting needs.
• Manage and deploy solutions across development, testing, and production environments, ensuring stability and accuracy.
• Perform data validation and testing to guarantee data integrity.
• Work with AWS services (S3, Redshift, Lambda, etc.) to support data storage, processing, and analytics.
• Develop and manage ETL processes within the cloud environment.
• Collaborate with cross-functional teams (data analysts, data scientists, business stakeholders) to deliver data solutions.
• Manage tasks, issues, and workflows using Jira.
• Maintain version control and code repositories using GitHub / Bitbucket.
• Build and maintain interactive dashboards and reports using Tableau.
• Translate complex datasets into clear, actionable insights.
• Provide ad-hoc reporting and analytical support to business teams.
• Document data models, processes, and workflows to ensure knowledge sharing and scalability.
• Ensure data governance, quality, and compliance standards are met.
Required Qualifications
• Previous experience in Business Intelligence, Data Engineering, or related roles.
• Strong experience with Snowflake, including schema design, SQL development, and performance optimization.
• Advanced proficiency in SQL and experience with ETL processes and tools.
• Solid understanding of data warehousing concepts and best practices.
• Hands-on experience with AWS cloud services (S3, Redshift, Lambda, etc.).
• Experience working with Jira for project and issue management.
• Proficiency with GitHub or Bitbucket for version control.
• Advanced skills in Tableau for data visualization and reporting.
• Strong analytical and problem-solving skills with attention to detail.
• Ability to work both independently and collaboratively in fast-paced environments.
• Excellent communication skills, with the ability to explain technical concepts to non-technical stakeholders.
Desired Skills
• Experience with additional BI tools such as Power BI or Looker.
• Knowledge of Python or other scripting languages for data manipulation or automation.
• Relevant certifications in Snowflake, AWS, Tableau, or similar technologies.
• Strong collaboration skills with the ability to work across international teams.
What do we offer?
• Permanent contract through Hays for a full-time, long-term project.
• Opportunity to work with a Top global pharmaceutical company.
• Versátil working model with only one office day per month in Sant Cugat del Vallès (transit included – buffet onsite).
• Exposure to modern data stack and cloud technologies.
• Collaborative, international environment with cross-functional teams.