默克药厂
Data architecture - Internship - Curious Talent
Data architecture - Internship - Curious Talent
发布于 4 天前实习/见习
Mollet del Valles, Barcelona, Spain
无经验要求
兼职员工
仅现场办公
学历未注明
信息技术与基础设施
SQL
CI/CD
Azure DevOps
ETL/ELT
DBT
AI 估算 · 6k–9k
实习岗位，默克为跨国药企，巴塞罗那实习薪资中等，按12个月估算月薪约6000-9000元人民币。
职位详情
关于这个职位
This internship at Merck Healthcare R&D in Barcelona offers hands-on experience in data architecture and pipeline design. You will support building scalable data solutions using Snowflake, AWS, and ETL tools, collaborating with global teams to enable analytics and AI. Ideal for students pursuing data engineering or architecture careers.
最低要求
Familiarity or exposure to Snowflake and AWS data services (Glue, Lambda, DMS); understanding of ETL/ELT concepts; knowledge of data modeling patterns; good SQL skills; basic Python experience; understanding of CI/CD concepts; fluent English; ability to work in virtual cross-functional agile teams.
工作职责
Support design and implementation of data models, data pipelines and ETL/ELT flows that feed reporting, analytics and AI solutions. Assist in building and operating data repositories (e.g., Snowflake) and cloud-based data processing (AWS services) together with senior architects and engineers. Collaborate with product owners, data engineers, business analysts and domain users to translate requirements and ensure correct solution delivery. Help create and maintain architecture blueprints, standards, data dictionaries and best practices for the team. Support automated CI/CD for data pipelines and integration tests (Azure DevOps / Git / warehouse automation tools). Assist in data quality checks, basic troubleshooting and third-level support tasks for R&D data systems. Contribute to documentation, knowledge sharing and operational run-books.
AI 洞察
优缺点分析
优点
- Hands-on experience with modern data stack (Snowflake, AWS, dbt) in a pharmaceutical R&D environment.
- Work in a global, agile team with mentorship from senior architects and engineers.
- Exposure to the full data value chain from ingestion to AI/analytics.
- Part-time structure allows balance with studies.
- Requires self-driven learning
- formal training may be limited.
- Part-time role may extend project timelines
- need to manage multiple stakeholders.
- Competitive internship
- may require prior coursework or projects.
- Students pursuing degrees in data science, computer science, or related fields who want practical experience in data architecture and cloud technologies.
缺点 / 挑战
暂无明显挑战项
角色解读
- Progress to Data Engineer or Data Architect roles after internship.
- Gain expertise in cloud data platforms and advanced analytics.
- Opportunity to move into full-time positions within Merck's global R&D teams.
- Design and implement data models, pipelines, and ETL/ELT flows for reporting and AI solutions.
- Work with Snowflake, AWS, and cloud-based data processing tools alongside senior engineers.
- Collaborate with cross-functional teams to translate requirements into technical solutions.
- Contribute to data architecture documentation, standards, and CI/CD pipelines.
- Familiarity with Snowflake and AWS services (Glue, Lambda, DMS).
- Solid SQL skills and basic Python programming.
- Understanding of ETL/ELT concepts and data modeling patterns.
- Basic knowledge of CI/CD and version control (Azure DevOps, Git).
申请策略
- Tailor your resume to reflect the specific tools mentioned (Snowflake, AWS, Informatica).
- Express curiosity about pharma R&D and how data enables innovation.
- Emphasize any hands-on projects using Snowflake, AWS, or ETL tools (e.g., dbt, Informatica).
- Show SQL and Python proficiency with specific examples (queries, scripts, automation).
- Highlight coursework or projects related to data modeling, pipelines, or CI/CD.
- Demonstrate ability to work in agile teams and communicate in English.
- Complete online courses on Snowflake, AWS Data Services, or dbt.
- Practice building a small ETL pipeline using publicly available datasets.
面试指南
- Use the STAR method for behavioral questions: Situation, Task, Action, Result.
- For technical questions, explain concepts clearly and relate to the role's context (pharma R&D).
- Show enthusiasm for learning
- if unfamiliar, describe how you would approach learning.
- Explain the differences between ETL and ELT. When would you choose one over the other?
- Describe a data pipeline you designed or worked on. What were the challenges?
- How would you model a star schema for a sales dataset?
- What is your experience with Snowflake? Explain how clustering or partitioning works.
匹配度报告
66
综合匹配度
Paid internship at Merck R&D in Barcelona, strong learning curve with modern data tech, moderate lifestyle flexibility, high purpose.
适合人群
Students who prioritize skill growth and purpose over immediate financial compensation.
最强匹配
成长发展匹配
最弱匹配
薪资福利匹配
薪资福利40
成长发展85
工作生活60
使命价值80
薪资福利匹配
40较低
Internship salary is typically modest, and no explicit benefits are mentioned in the JD. The part-time nature may limit financial compensation but provides flexible hours.
薪资信号未披露（AI估算：6K-9K/月）
成长发展匹配
85较高
The role offers strong skill development with modern cloud data tools, mentorship, and exposure to R&D data value chain. It explicitly mentions opportunities for personal and professional growth.
技术前沿主流现代技术
技术栈Snowflake、AWS、dbt、Informatica、Python、SQL、Azure DevOps
成长机会opportunities for personal and professional development worldwide
业务类型cost_center
工作生活匹配
60中等
The JD mentions a flexible work culture, but work mode is not specified. As an on-site part-time role, it offers some flexibility but likely requires presence in Barcelona.
工作模式仅现场办公
办公地点未明确
加班情况未提及（无法判断）
工作生活平衡flexible work culture
使命价值匹配
80较高
Working in pharmaceutical R&D to improve patients' lives provides a strong sense of purpose. The company emphasizes innovation and global impact.
行业发展稳定成熟行业
社会影响正向社会影响力较高
使命信号enrich people's lives、help create, improve, and extend lives
创新程度积极采用新技术
Watch Jobs