Join our cross-divisional Data Team at the forefront of the company’s data transformation. The Data Processing Team is part of Data Poland & Baltics team, we are responsible for transforming raw, sometimes unstructured information from external providers into high-quality, ready-to-use data products. We operate at the intersection of GCP (BigQuery), Python automation, and Power BI visualization, delivering data that empowers key business decisions.

Your Responsibilities:

• Data Wrangling & Quality Control: Extract data from various sources (flat files like XLS/CSV, APIs, and direct database connections), followed by rigorous cleaning and quality verification.
• Schema Alignment: Map and reconcile external data schemas with our internal corporate standards.
• ETL/ELT Process Development: Build and maintain robust data pipelines using SQL (BigQuery) and Python scripts.
• Master Data Management: Integrate datasets with master dictionaries and mappings to ensure logical consistency across all processed information.
• Product Delivery: Provide processed datasets as optimized tables in BigQuery or as final reporting files (CSV) or PBI data flows.

Requirements: Must Have

• Hands-on Data Wrangling Experience: Proven track record in data cleaning, handling missing values (nulls), and resolving inconsistent formats.
• Analytical Mindset: Ability to grasp business logic (understanding the "why" behind mappings) and proactively identify logical errors in data.
• Process Automation: Experience building repeatable data pipelines that minimize manual intervention.
• SQL Proficiency: Ability to write complex queries, perform multi-table joins, and work with datasets (preferably in a cloud environment like BigQuery).
• Excel / CSV Expertise: Advanced manipulation of flat files, understanding different encoding formats, delimiters, and common file-based data issues.
• Python Fundamentals: Practical ability to write scripts for data transformation and data extraction.
• English Proficiency: Ability to work with technical documentation and collaborate in an international environment.

Requirements: Nice to Have

•    Google Cloud Platform (GCP) knowledge: Experience with BigQuery, Cloud Storage, or orchestration tools (e.g., Airflow).

•    Power BI (Data Prep): Experience creating Power BI Dataflows or working with Power Query.

•    Market Research Data Expertise: Familiarity with panellist data structures (e.g., Nielsen, IQVIA, Kantar) is an advantage.

We Offer:

•    Friendly and dynamic work atmosphere in the diverse environment of a market beauty leader.

•    Plenty of opportunities to grow – both cross-divisionally and functionally.

•    Rich e-Learning package (including access to DataCamp, Coursera, and internal platforms).

•    Modern, sustainable office with hybrid work week (3 days in the office, 2 days Home Office) in the heart of the city.

•    Dedicated Buddy from day one to support your integration.

•    Attractive benefit package: sports card, private health care, life insurance, pension package, and an internal boutique with employee discounts & product allocations.

•    Share in profit and a community engaged in Sports and CSR activities.

We are open for candidates with disabilities.

RODO/GDPR

Information clause

The controller of  personal data is L’Oréal Polska Sp. z o.o with its registered office in Warsaw (00-844) at Grzybowska 62. Contact with the Data Protection Officer and additional information about the personal data processing carried out by the Company is possible via e-mail address: [email protected].

The processing of personal data is carried out for the purpose of the recruitment process in accordance with Article 6(1)(c) of the General Regulation on Personal Data of 27 April 2016, (hereinafter GDPR). Data processing to a wider extent than resulting from the provisions of labor law, for the purposes of the future recruitment processes will be carried out on the basis of the given consent in accordance with Article 6(1)(a) of the GDPR.

Your personal data will not be disclosed to other entities without your prior consent. Your personal data may be made available at the request of entities authorized to do so under the law. The controller may, by means of a written contract, entrust to another entity the processing of your personal data to the extent and for the purpose necessary to perform the service. Your personal data will not be transferred to a third country/international organization.

Your personal data will be kept for a period of 2 years from the end of the recruitment process – in which case these data will be processed until the consent is withdrawn.

You have the right to access their data, rectify, delete, object, limit processing, and transfer. Your consent may be withdrawn at any time. Withdrawal of the consent will not affect the lawfulness of the processing of your personal data that was made on the basis of your given consent before its withdrawal. A declaration of withdrawal of the consent to the processing of your personal data should be sent to the e-mail or postal address indicated above.

You have the right to lodge a complaint to the President of the Personal Data Protection Office if you feel that the processing of your personal data violates the provisions of the GDPR.

The provision of personal data is voluntary but necessary for the participation in recruitment process. Failure to provide personal data will result in the inability to participate in the recruitment process.