Share this Job

Workforce Labor Forecasting and Reporting Analyst

Date: Jul 13, 2019

Location: Mason, OH, US, 45040

Company: Luxottica Group

Requisition ID: 100094 
Store #130103 LC Field Finance 


At LensCrafters, we love eyes and we care about the people behind them.

LensCrafters is the largest optical retailer in North America with 900+ stores and as part of an eyewear industry leader, Luxottica, our love of eyes and higher standard of quality have made LensCrafters a leader in vision care for over 30 years.

With a career at LensCrafters, you’ll find yourself learning, growing, and interacting with some of the most passionate and talented people in the business. At the same time, you’ll be helping people look and see their best.



The Financial Analyst plays a key support role in the LensCrafters Sales and Labor Team, with responsibility for labor planning, weekly/monthly business reporting (including report writing/maintenance and distribution), trend analysis, forecasting and process improvement recommendations and other ad hoc reporting and analyses.



  • Understand retail staffing and scheduling processes, identify gaps and root causes; propose and implement new solution
  • Assists team with development of complex spreadsheets and query tools, automation formulas, and custom formatting of reports. Manipulates data (merging or importing/exporting) to provide more useful information.
  • Investigates/validates/analyzes/updates labor forecasts accordingly.
    • Hour/Shift guidance, Commissions
    • Use of forecasting and statistical models
  • Develops methodology and functionality to automate and streamline reporting with Kronos Workforce Analytics and business objects.
  • Updates labor forecasting processes and shift guidance to incorporate logic with all database views, reports and interfaces.
  • Collaborate in team environment and independently with vendors, business partners and technology teams on projects, support activities to drive key initiatives
  • Identifies opportunities for process improvement via SQL, Macro automation or business objects.
  • Ensures integrity of data and assists in auditing accuracy
  • Participates in user acceptance testing, regression testing for key workforce projects
  • Participates in special projects.
  • Support scheduling a delivering daily and weekly operational reports
  • Communicates to field team and leadership.



  • Bachelor’s degree Finance/Accounting/Math/ Computer Science/Data Science
  • 1+ year(s) Retail workforce systems (Kronos, JDA, etc) or Financial Planning and Analysis experience
  • Proficiency with Microsoft Excel Macros - ability to troubleshoot and create new Macros
  • Proficiency with Microsoft Access
  • Proficiency with Business Objects
  • Proficiency with standard SQL
  • Motivated self-starter who is willing to accept new responsibilities as processes change/improve
  • Strong Systems experience and aptitude
  • Ability to learn new systems quickly
  • Exceptional analytical and mathematical skills
  • Ability to communicate complex processes to Senior Management
  • Excellent oral and written communication skills
  • Curiosity to research issues and willingness to expand breadth of knowledge
  • Ability to prioritize and manage multiple tasks
  • Innovative and proactive to drive improvement and change
  • 2-5+ years related retail experience
  • 2-5+ years labor system, retail systems



  • Retail Time Keeping systems experience
  • Experience in working with R, Python or applying IBM analytics software to business problems, SPSS statistics, forecasting and SPSS Modeler

Upon request and consistent with applicable laws, Luxottica will provide reasonable accommodations to individuals with disabilities who need assistance in the application and hiring process. To request a reasonable accommodation, please contact Talent Luxottica at  877-589-8253 (513-765-2256 outside of US) or email

We are an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, gender, national origin, religion, age, disability, sexual orientation, gender identity or expression, citizenship, veteran or military status, marital status, pregnancy (including unlawful discrimination on the basis of a legally protected pregnancy or maternity leave), genetic information or any other characteristics protected by law.


Analyst   Analyst 

Nearest Major Market: Cincinnati

Job Segment: Retail Sales, Business Process, Retail, Management