Customer Data Analyst Intern (Summer 2025)
L'Occitane En Provence
Internship
On-site
New York, New York, United States
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
- 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:
FMLA Special Rules for Returning Military Members (USERRA)