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.