Data Scientist Jr

Mexico City - Mexico

Monthly Salary: Not Disclosed

Posted on: 10 hours ago

Vacancies: 1 Vacancy

Job Summary

Job Description

Role summary Support the organizations data governance and data quality foundations by working with SQL Python and R to cleanse standardize and prepare data for BI tools (Qlik Sense and Power BI). This role offers hands-on experience with ETL processes data mapping and cross-system validation with mentoring from senior team members.

Key responsibilities

Data engineering (entry-level)
- Assist in structuring and normalizing source data for ingestion and analytical use.
- Support the design and maintenance of basic ETL/ELT processes and data pipelines.
- Implement Star Schema elements under guidance (dimensions and fact tables).
Data mapping and cataloging
- Scan and document databases to map and harmonize information (contribute to data dictionaries and lineage).
- Help identify inconsistencies duplicates and basic data quality issues.
Standardization and cleansing
- Apply established methodologies to standardize and cleanse datasets.
- Perform data cleanup deduplication and reconciliation tasks.
Development and automation
- Develop and maintain scripts to cross-reference and consolidate data between systems (SQL Python R).
- Contribute to simple applications or interfaces that enable controlled data access.
Validation and quality control
- Validate datasets against other systems or sources and report discrepancies.
- Perform exploratory analysis and prepare concise quality reports for key databases.
Analytical front-end preparation
- Create basic master measures and prepare datasets for Qlik Sense and Power BI.
- Work with BI to ensure datasets are ready for visualization and end-user consumption.

Typical systems and data sources

Veeva (Approved Email Visits Events etc.)
Salesforce Marketing Cloud (SFMC)
Flash for WhatsApp
Relational databases and internal data warehouses
Qlik Sense and Power BI for visualization and reporting

Required skills and experience

Basic to intermediate experience in SQL (writing queries joins aggregations).
Programming experience in Python and R for data manipulation and scripting.
Practical experience developing dashboards and datasets in Qlik Sense and Power BI.
Familiarity with data cleaning deduplication and standardization techniques.
Understanding of ETL/ELT concepts and dimensional modeling (Star Schema) is a plus.
Good analytical skills attention to detail and ability to work in a team with mentoring.
Effective communication skills in English (or local language as required).

Preferred (not required)

Experience with data cataloging or lineage tools.
Familiarity with marketing/CRM platforms such as Veeva and SFMC.
Basic knowledge of APIs and data access mechanisms.

#LI-DNI

Required Skills:

3D Model Making Building Architecture Business Analysis Business Data Analytics Business Expansion Communication Methods Data Analysis Data Analytics Databasing Data Measurement Data Science Machine Learning (ML) Market Segmentation Model Building Qlik Sense Sketch Modelling Statistics Web-Based Communications

Preferred Skills:

Business Embedded Programming Languages

Current Employees apply HERE

Current Contingent Workers apply HERE

Search Firm Representatives Please Read Carefully
Merck & Co. Inc. Rahway NJ USA also known as Merck Sharp & Dohme LLC Rahway NJ USA does not accept unsolicited assistance from search firms for employment opportunities. All CVs / resumes submitted by search firms to any employee at our company 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 a candidate is hired by our company as a result of an agency referral where no pre-existing agreement is in place. Where agency agreements are in place introductions are position specific. Please no phone calls or emails.

Employee Status:

Temporary (Fixed Term)

Relocation:

No relocation

VISA Sponsorship:

Travel Requirements:

No Travel Required

Flexible Work Arrangements:

Hybrid

Shift:

Not Indicated

Valid Driving License:

Hazardous Material(s):

n/a

Job Posting End Date:

12/4/2025

*A job posting is effective until 11:59:59PM on the day BEFOREthe listed job posting end date. Please ensure you apply to a job posting no later than the day BEFORE the job posting end date.

Required Experience:

Junior IC

Job DescriptionRole summary Support the organizations data governance and data quality foundations by working with SQL Python and R to cleanse standardize and prepare data for BI tools (Qlik Sense and Power BI). This role offers hands-on experience with ETL processes data mapping and cross-system va...