Junior Analytics Platform Engineer - Part time for a student

We're looking for students of Czech Universities, who are interested in a long-term collaboration with MSD. 

Did you always want to work in a company where your work can have a real impact? Do you enjoy working in an international environment with lots of room for personal development? Are you ready to join a company where we cherish Diversity and Inclusion and the wellbeing of our employees?

Our IT team operates as a business partner proposing ideas and innovative solutions that enable new organizational capabilities. We collaborate internationally to deliver the services and solutions that help everyone to be more productive and enable innovation.

As a Junior Analytics Platform Engineer intern, in this internship you will particularly focus on:

Perform ad-hoc data analysis

• Answer metric-related questions from product teams, investigate anomalies, and create trend reports.

Manage source data requests

• Triage incoming requests, clarify requirements, track status, and coordinate with engineering teams.

Shepherd product metrics definitions

• Guide product teams through Product Metrics Definition (PMD) creation, review pull requests and validate schemas.

Contribute to documentation & testing

• Write and improve documentation, create and maintain dbt tests, and help keep metric catalogs and onboarding guides up to date.

Develop exploratory insights

• Identify usage patterns, benchmark products, and explore metric correlations to uncover opportunities and risks.

What you should know / have:

SQL proficiency

• Comfortable with JOINs, aggregations, window functions, and CTEs to query a data warehouse.

Analytical thinking

• Ability to understand metrics, spot anomalies, validate results, and challenge assumptions.

Python (basic, data-focused)

• Experience using Python for simple data manipulation, analysis, or automation tasks.

Stakeholder communication

• Able to clarify requirements, manage expectations, provide clear updates, and translate technical concepts for non-technical audiences.

Attention to detail

• Careful with data validation, schema accuracy, and documentation completeness.

Basic technical foundation

• Familiarity with Git, YAML/JSON, and the command line, plus a willingness to learn dbt and other analytics engineering tools.

What you will do / learn:

During this internship, you will:

Work with a modern data stack

• Get hands-on experience with data warehouses, dbt, analytics engineering workflows, and metric layer concepts.

Learn how product analytics works in practice

• See how metrics are defined, governed, and used in decision-making across product teams.

Improve your SQL and data skills

• Write production-grade queries, optimize them for performance, and apply best practices for data quality and validation.

Contribute to real products and decisions

• Support product teams with analysis and insights that inform roadmaps, experiments, and feature improvements.

Develop as an analytics engineer

• Learn how to structure data models, define metrics consistently, and think in terms of reusable, scalable data solutions.

Build professional skills

• Practice working in an agile, collaborative environment, managing your own tasks, and communicating with technical and non-technical stakeholders.

Besides a great atmosphere and flexible working environment, we also offer:

• Hourly wage
• Multinational environment in the leading pharma corporation
• Meal vouchers and Multisport card
• Development program (every month trainings, workshops, networking events, etc.)
• Flexible working hours
• Friendly working environment
• Possibility of challenging career

Who we are ... 

We are known as Merck & Co., Inc., Rahway, New Jersey, USA in the United States and Canada and MSD everywhere else. For more than a century, we have been inventing for life, bringing forward medicines and vaccines for many of the world's most challenging diseases. Today, our company continues to be at the forefront of research to deliver innovative health solutions and advance the prevention and treatment of diseases that threaten people and animals around the world.

What we look for ... 

In a world of rapid innovation, we seek brave Inventors who want to make an Impact in all aspects of our business, enabling breakthroughs that will affect generations to come. We encourage you to bring your disruptive thinking, collaborative spirit and diverse perspective to our organization. Together we will continue Inventing For Life, Impacting Lives while Inspiring Your Career Growth. 

Invent. Impact. Inspire. 

We are proud to be a company that embraces the value of bringing diverse, talented, and committed people together. The fastest way to breakthrough innovation is when diverse ideas come together in an inclusive environment. We encourage our colleagues to respectfully challenge one another's thinking and approach problems collectively. We are an equal opportunity employer, committed to fostering an inclusive and diverse workplace.

Please note our third party recruitment partner, will retain and employ successful applicants for this program. 

Search Firm Representatives Please Read Carefully:  

Our company does not accept unsolicited assistance from search firms or recruitment agencies for this employment opportunity. Please, no phone calls or emails. All resumes submitted by search firms to any of our employees via email, the Internet or in any form without a valid written search agreement in place for this position will be deemed the sole property of our Company. No fee will be paid in the event the candidate is hired by our Company as a result of the referral or through other means.)

#PragueInterns