Sr Analyst - Business Intelligence, SalonCentric

L'oreal Usa; Clearwater (FL); Hybrid; USD 95,000 - 130,000; Full time

Benefits offered by this job

Hybrid work (3 days in office, 2 days"

Flexible time off

Company perks

Learning & development

Employee resource groups

Wellness programs

Job summary

L’Oréal USA is seeking a Senior Analyst, Business Intelligence to contribute to analytical model development, strategic reporting, and incentive simulations. You will collaborate with Finance, HR, and Field Operations to translate data into actionable insights that optimize resources and control costs.

You will build and enhance Power BI dashboards, automate processes, and ensure accuracy of performance incentives and bonus structures.

Qualifications

• BA/BS in a business or related field is preferred.
• 3–5 years of analytics experience or related field.
• Advanced Excel, Access, Power BI, Power Query and Power Pivot proficiency.
• Experience with SQL, BigQuery, DAX, and MDX is preferred.
• Proven model-building experience and production deployment.

Responsibilities

• Model incentives, bonuses, and campaign structures and run simulations.
• Serve as primary contact for incentive inquiries with a professional approach.
• Develop and enhance interactive dashboards in Power BI and Excel.
• Create reports/presentations for business needs (e.g., Shade Trade).
• Automate reporting workflows to improve efficiency.
• Maintain store rosters and data attributes; support data governance.

Skills

Excel

Power BI

SQL

BigQuery

DAX

MDX

Data modelling

Communication

Problem solving

Organization

Project management

Education

Business Degree in related field

Tools

Power BI

Power Query

Power Pivot

Access

Job description

Division: OneData L’Oreal

Supervisor Title: AVP, Analytics Lead

Location: Clearwater, FL (NOC)

FLSA: Exempt

Summary

The Senior Analyst, Business Intelligence is responsible for contributing to the development of analytical models, providing strategic reporting, and supporting performance and business decision-making by recommending system and/or process improvement solutions. This role focuses on the development, calculation, and validation of performance incentives, bonus simulations, and standard sales compensation structures, ensuring financial accuracy and alignment. Collaborating closely with cross-functional partners in Finance, HR, and Field Operations, the Senior Analyst identifies opportunities to automate data processes, streamline workflows, and eliminate manual tasks to save time for both the analyst team and business partners. Through these efforts, they translate operational data into actionable insights to optimize resources, control costs, and support overall team agility and business continuity. This is a unique opportunity for an individual with the technical skillsets and desire to analyze, transform, and build accessible, high-impact reporting for a highly driven organization.

Job Responsibilities

• Incentive & Compensation Modeling: Execute, model, and validate incentives, bonus programs, or campaign structures; conduct simulation analyses to support financial forecasting and evaluate program ROI.
• Inquiry & Program Support: Serve as the primary point of contact for contest or incentive inquiries, resolving field questions with a professional, diplomatic, and helpful approach.
• Analytics & KPI Dashboarding: Develop, maintain, and continuously enhance interactive dashboards and analytical tools in Microsoft Power BI and Excel to track critical business performance metrics.
• Reporting: Create reports and presentations based on business needs (such as Shade Trade performance).
• Process Automation & Efficiency: Identify and implement automated solutions to streamline reporting workflows, reduce manual efforts, accelerate delivery times, and improve productivity for the team and end-users.
• Data Governance: Maintain store rosters, operational personnel databases, and data attributes.
• Cross-Functional Analytical Partnering: Partner with cross-functional teams (such as Finance, HR, and Field/Operations) to provide analytical support, trend analysis, and data inputs for budget planning (such as labor hours), business reviews, and strategic initiatives.
• Operational & Process Documentation: Assist in standardizing data processes; maintain and update standard operating procedures (SOPs) for core analytics workflows when necessary.
• Cross-Functional Backup: Serve as a designated back-up for other core Business Intelligence activities and ad-hoc reporting needs to support overall team agility and operational continuity.

Required Experience & Competencies

• Business Degree in related field preferred
• At least 3-5 years experience working in analytics or related field
• Advanced proficiency in Microsoft Office Suite applications with an emphasis on Excel, Access, Power BI, Power Query, and Power Pivot; Proficient and comfort with technology and addressing troubleshooting routine technological issues
• Experience in SQL, Big Query, DAX, and MDX preferred
• Proven experience building models and placing models into production
• Excellent problem-solving ability
• High attention to detail; ability to produce highly accurate documents and work products in a demanding environment
• Exceptional organization skills. Ability to prioritize and manage time efficiently
• Flexible to accommodate last minute changes and demands from multiple sources
• Excellent communication skills; listening, speaking, and written
• Strong verbal/communication skills; Ability to communicate/translate data or system information to client/appropriate user/audience
• Experience presenting to Leadership
• Extremely well organized. Able to effectively multitask in a fast-paced environment while maintaining professionalism and composure
• High level of professionalism and sound judgment in dealing with senior managers; effectively builds relationships and resources at all levels of the organization
• Highly proactive; takes initiative to begin and complete projects; masterful at follow-up and tracking work projects; anticipates and executes tasks before being asked
• Strong interpersonal and project management skills. Strong administrative and leadership skills to maintain high standards and coordinate staff effectively
• Self-starter with demonstrated initiative, judgment, decisiveness, confidence and discretion

Diplomatic style with professional, positive, friendly manner; practical, “roll up your sleeves” team player work style and positive “can do” attitude.

What’s In It For You:

• 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’Oréal’s Internal Shop for Discounted Products, Monthly Mobile Allowance)
• Learning & Development Opportunities for Career Progression (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

We are an Equal Opportunity Employer and take pride in a diverse environment. We 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.

Authorization to work in the United States on a full-time, permanent, ongoing basis is required. No immigration support/sponsorship is offered for this role.

Being present in the office three days a week is considered an essential function of all office-based roles for eligible full-time employees.