Data architecture - Internship - Curious Talent
发布于 大约 2 个月前实习/见习
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.
职位点评
Paid internship at Merck R&D in Barcelona, strong learning curve with modern data tech, moderate lifestyle flexibility, high purpose.
从学习成长、工作节奏、岗位方向和实习待遇综合评估，方便比较实习机会。
薪资福利
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.
成长发展
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.
工作生活
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.
使命价值
Working in pharmaceutical R&D to improve patients' lives provides a strong sense of purpose. The company emphasizes innovation and global impact.