Director - Retailer Data Excellence

Job Title: Director - Retailer Data Excellence

Division: Consumer Products Division

Location: Clark, New Jersey

Reports To: VP, Customer Supply Chain

Who We Are:

For more than a century, L'Oreal has devoted its energy, innovation, and scientific excellence solely to one business: Beauty. Our goal is to offer each and every person around the world the best of beauty in terms of quality, efficacy, safety, sincerity and responsibility to satisfy all beauty needs and desires in their infinite diversity.

At L'Oreal Operations, we create innovative, inclusive, and sustainable beauty together with our business partners by designing, developing, sourcing, manufacturing, and distributing over 6 billion products globally every year. We support over 36 brands across four L'Oreal divisions. We are consumer-oriented, and we act responsibly all along the value chain.

What You Will Do:

This position supports Supply Chain collaboration initiatives for major retailers. L'Oreal CPD is looking for a passionate and focused business intelligence data engineer to join the Customer Supply Chain team, responsible for enterprise analytics solutions. This role is responsible for managing an analytics workspace to support the broader customer team in providing practical and actionable insights on L'Oreal top retailers, behaviors, and key performance metrics including in store and online availability, phantom inventory, and store tiers. This role will effectively leverage SQL, Power BI, and Excel to build, extract, analyze and visualize data from various customer portals to better understand our performance and our opportunities to drive consumption, maximize productive inventory, and reduce returns.

In order to achieve the above the position will be responsible for:

1. Develop and implement data governance frameworks: Define policies, standards, and procedures for data management across ten large retailers including store and sku level data. Support the evolution of customer analytics with the development of new tools and initiatives.
2. Establish and monitor data quality metrics: Identify key data quality indicators, implement data profiling and monitoring processes, and track progress against defined targets. Support the maintenance of retailer by sku, by store data, regularly monitoring and ensuring accuracy of the data and all data tables, and facilitating any corrections as needed.
3. Drive data quality improvement initiatives: Collaborate with business and technical stakeholders to identify and remediate data quality issues, recommending process changes and implementing automated data quality checks.
4. Foster a data-driven culture: Promote data literacy throughout the organization, providing training and support to business users on data governance principles, data quality practices, and data utilization. Proactively provide analysis and insights that aim to gain a deeper understanding of the L'Oreal customers, shifts in behavior, and opportunities.
5. Recommend and execute new analytical approaches that increase our visibility around store inventory, store tier performance, and phantom inventory. Support the implementation and integration of new tools and solutions with customer data
6. Research and plan implementation of future data sources, building development models for testing, and planning UAT as data sources evolve
7. Partnership with Shared Data Doman leads and other IT teams, leveraging division agnostic databases where possible
8. Stay abreast of industry trends: Keep current with emerging data management technologies, best practices, and regulatory changes.

What We Are Looking For:

Required Qualifications:

• Bachelor's degree required.
• 7-10 years' experience in a strategy & analytics-focused role

• Proven experience in developing and implementing data governance frameworks and data quality management programs.
• Experience working with enterprise cloud databases, data analytics, working with large data sets and ideally writing complex SQL/GBQ queries
• Experience working with data visualization tools and creating data visualization concepts. (Excel, Tableau, Microsoft Power Bi, Looker or similar)
• SAP system experience preferred
• Experience analyzing performance data and summarizing / communicating findings via reports and presentations
• Proactive and results oriented thinker who would flourish in an entrepreneurial environment where new ideas are championed
• Excellent communication, interpersonal, and presentation skills, with the ability to convey technical concepts to both technical and non-technical audiences.
• Strong understanding of data modeling techniques, data integration methodologies, and retailer data complexities.
• Prior experience in Beauty, or CPG industries a plus

As an integral part of our culture at L'Oreal, wellness is at our core. We not only offer a generous Benefits Package (Medical, Dental, Vision, 401K), we also offer flexible time off, work from home days, and a pension plan! Additionally, you will have access to company perks such as Makeup, Skincare, and Fragrance! Employees receive a stipend for L'Oreal products as well as VIP Access to L'Oreal's Internal Shop for Discounted Products, and other perks such as Monthly Mobile Allowance, discounted gym memberships, and ERGs.

Additional Benefits Information As Follows:

• Competitive Benefit Package (Medical, Dental, Vision, 401K, Pension Plan)
• Hybrid Work Policy (3 Days in Office, 2 Days Work from Home)
• Flexible Time Off (Paid Company Holidays, Paid Vacation, Vacation Buy Program, Volunteer Time, Summer Fridays & More!)
• Access to Company Perks (VIP Access to L'Oreal's Internal Shop for Discounted Products, Monthly Mobile Allowance)
• Learning & Development Opportunities (Unlimited Access to E-learnings, Lunch & Learn Sessions, Mentorship Programs, & More!)
• Employee Resource Groups (Think Tanks and Innovation Squads)
• Access to Mental Health & Wellness Programs

Don't meet every single requirement? At L'Oreal, we are dedicated to building a diverse, inclusive, and innovative workplace. If you're excited about this role but your past experience doesn't align perfectly with the qualifications listed in the job description, we encourage you to apply anyways! You may just be the right candidate for this or other roles!

We are an Equal Opportunity Employer and take pride in a diverse environment. We would love to find out more about you as a candidate and do not discriminate in recruitment, hiring, training, promotion, or other employment practices for reasons of race, color, religion, gender, sexual orientation, national origin, age, marital or veteran status, medical condition or disability, or any other legally protected status.

If you are a qualified individual with a disability or a disabled veteran, you may request a reasonable accommodation if you are unable or limited in your ability to access job openings or apply for a job on this site as a result of your disability. You can request reasonable accommodations by contacting [emailprotected]. If you need assistance to accommodate a disability, you may request an accommodation at any time.

Our Safe Together Plan: Your safety is our highest priority. We will proceed with caution and adhere to enhanced protection standards to ensure our sites are safe for all employees. We must all operate with the shared responsibility for each other's health & safety in mind