PHAYS is collaborating with the leading company in the pharmaceutical sector, TOP 10 pharma. They create innovative medicines for people and animals, adding value through innovation for all three business areas: human pharmaceuticals, animal health, and contract manufacturing of biopharmaceuticals. Now they are growing in animal area too, it was created 3 years ago. Our client is forming a technological hub that will serve the entire group internationally. It is growing and has more than 500 specialists. This hub is located in San Cugat del Vallés. /ppbr/ppWe are looking for a b Data Transformation Engineer /bto join the team. /ppbr/ppbWhat will your duties be? /b /pulliDesign, develop, and maintain scalable data transformation workflows using dbt. /liliNavigate Snowflake to ensure accuracy, performance, and compliance. /liliOrchestrate data pipelines and scheduling using Airflow. /liliImplement version control and collaborative development practices with Bitbucket. /liliWrite and optimize SQL queries for data extraction, transformation, and loading. /liliCollaborate with data engineers and analysts to deliver high-quality data solutions. /liliMonitor and troubleshoot data workflows to ensure reliability and efficiency. /li /ulpbr/ppbWhich are the requirements? /b /pulliDBT for data modeling and transformation. /liliSnowflake or similar cloud data warehouse platforms. /liliAirflow for workflow orchestration. /liliBitbucket/GitHub for source control. /liliStrong SQL skills for complex queries and performance tuning. /liliSolid understanding of data modeling principles and best practices. /li /ulpbr/ppbWhat we offer? /b /pulliLong term contract with Hays. /liliParticipate in international projects. /liliFlexible remote work model (1 office day per month). Location: Barcelona. /liliFlexible Schedule: Monday to Friday from 8-9 to 5-6. /li /ul