Customer Data Analyst Intern (Summer 2025)

Job Summary

As an Intern with L’Occitane en Provence North America you will undertake work on our different Data projects. L'Occitane group has built an ambitious Datahub program with the set up of a Datalake (Snowflake solution) to cover the analytical needs and different Master data platforms for operational needs around referential data (customers, products, stores). To drive the development of our data, the Data Intern will have the role to develop diversified projects on different business domains : Customers, Supply, and Finance. The Data Intern will work on projects such as data information capture and extraction using ETL, data quality and monitoring and/or build Finance/Supply reporting.

Job Responsibilities

• The candidate will work on the Snowflake platform to monitor and improve the Data Quality in our different channels (Retail, Clienteling, E-commerce, CRM) on customer, finance and supply domains
• Build and maintain Data flow to capture and propagate data in Customers, Finance and Supply domains using SQL language, ETL solution such as DBT, SSIS or Knime
• Build and maintain Datamart using SQL language and DBT
• Analyze data sets using SQL language
• Build reports using PowerBI
• In Data Science, if the candidate is skilled and autonomous, she/he can propose use cases using Machine learning scores and Large Language Model to improve our customer knowledge and KPI, create actionable data and automate process using Python, PowerBI report, Knime or OpenAI. For this expertise area, we are expecting the candidate to be autonomous and bring his/her expertise to the company
  
  

Key Performance Indicators

• Data accuracy
• Project completion in timely manner
• Project deliverables
• Fast learning curve
• Accuracy of data
• Autonomy
• Curious
  
  

Requirements

EDUCATION:

• Currently pursuing a bachelor's / master's degree in Computer Science
  
  

EXPERIENCE:

• Prior internship experience or students projects with data projects and development
  
  

Skills

• SQL (good knowledge and experience)
• Data Modelization
• Data flows (ETL, API)
• Data Science
• Python
• Reporting
  
  

Physical & Travel Requirements

• Hybrid or on site at NY office
  
  

Benefits Include

• Competitive Compensation at $19/hour
• School Credit Offered
• A warm, open, fun, and friendly work environment
• Generous L’Occitane employee discounts
  
  

All Applicants

L'Occitane's Privacy Statement

United States Applicants Only

Employee Rights

FMLA: Posters

FMLA Special Rules for Returning Military Members (USERRA)