Luxottica Workforce Planning Analyst in Mason, Ohio

Requisition ID: 39403

Store # : 130103 LC Field Finance

Position: Full-Time

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 sales planning, labor planning, weekly/monthly business reporting (including report writing/maintenance and distribution), trend analysis and process improvement recommendations and other ad hoc reporting and analyses.


  • Assists team with development of complex excel spreadsheets and query tools, automation formulas, and custom formatting of reports. Manipulates data (merging or importing/exporting) to provide more useful information.

  • Investigates/analyzes/updates Monthly Sales and Labor forecasts accordingly.

  • Develops methodologies/functionality to automate and streamline reporting tools and databases.

  • Identifies opportunities for process improvement via SQL, Macro automation.

  • Develops processes that maximize the efficiency of financial reporting tools.

  • Establishes proactive working relationships with business partners.

  • Ensures integrity of report data.

  • Participates in special projects and creates ad hoc analyses.

  • Supports financial managers/analysts as they partner on key projects.


  • Bachelor’s degree Finance/Accounting or MIS

  • 1+ year(s) retail systems or Financial Planning and Analysis experience

  • Proficiency with Microsoft Excel Macros - both the ability to troubleshoot and create new Macros

  • Proficiency with Microsoft Access

  • Proficiency with standard SQL

  • Strong interpersonal and communications skills

  • 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

  • Able 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


  • Retail Time Keeping systems experience

  • Experience with SAP, Hyperion, Essbase & Business Objects

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 the Luxottica HR Solutions Group at 1-866-431-8484.

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 AND Finance Analyst