Workforce Planning Analyst


Luxottica Group

Type

Corporate / junior

Location

North America

Mason

United States

Location

United States

Mason

Type

Corporate / junior


GENERAL FUNCTION 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. MAJOR DUTIES AND RESPONSIBILITIES 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. BASIC QUALIFICATIONS 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 PREFERRED QUALIFICATIONS Retail Time Keeping systems experience Experience with SAP, Hyperion, Essbase & Business Objects