Business Intelligence Officer - Optical

Utilize the company’s approved business intelligence software for campaign management, including initiating, planning, executing and reporting on same, to ensure that all campaign deliverables are implemented.

POSITION: BUSINESS INTELLIGENCE MANAGER

REPORTS TO: REGIONAL BUYING MANAGER - OPTICAL

PRINCIPAL ACCOUNTABILITIES:

• Updating of the Regional merchandise dashboard – in terms of overall product sales; premium and regular frames, contact lenses, sunglasses, lenses and specialist treatments by country and for the region.
• Present business performance slides with analysis and recommendation
• Conducting the Regional Frames Analysis – measuring sales by units and supplier and by class (regular or premium)
• Optical Aged stock report – monitoring aged stocks by product type by country versus target to also include Lens currently unavailable in RP3
• Conducting the Regional Lens analysis – determining sales, margins and % contribution to overall sales as well as sales by lens types (single vision, progressive, bifocals) and treatments (AR, BB, Transitions).
• Conducting an Optical Health Check – measuring country/store performance weekly tracking all key metrics including appointments, exams and RX written
• Generating the Regional Optical Sales report - Measuring overall P&L Optical performance for the Region, reports by Country and Store, and tracking performance V budget and by SSS
• Generating reports on Optical Marketing spend by supplier to ensure maximum support from co-op promotions and also to gather ROI
• Generating reports on the effectiveness of Optical Marketing promotions, analysing units, retail sales, rotations and gross margins
• Ensuring Lab productivity – tracking performance of country edging labs to measure performance and present recommendations
• Generating and compiling commercial slides for effective Regional Commercial Meetings
• Ensuring data integrity throughout the merchandise hierarchy across the region
• Ad Hoc duties – producing and formatting charts, tables and graphs to support management presentations and facilitate business decisions. Reporting on supplier and products types performance by brand to assist with supplier meetings. Tracking turnaround time for various lens type by country to ensure optimum performance

QUALIFICATION/EDUCATION AND EXPERIENCE:

• Degree in Business, Information Systems, Finance or related discipline
• Minimum of three (3) years’ experience in producing high-level reports and presentations to senior management, working with large spreadsheets and summarizing information for concise reports.
• Proficiency in Microsoft Office Suite with advanced proficiency.

KNOWLEDGE, SKILLS AND ABILITIES:

• Strong analytical skills to collect, organize and interpret data to draw meaningful conclusions.
• Strong interpersonal and communication skills
• Strong written and oral communication skills to effectively and efficiently articulate strategy and results.
• The ability to work in a fast-paced environment, manage time and achieve targets