Sr Analyst- Business Data

EssilorLuxottica Group•Farmers Branch, TX

5d•Onsite

About The Position

Overall mission is to provide analytical tools, metrics, and analysis that measures Supply Chain and Manufacturing progress toward its productivity, brand services and cost commitments. To perform analyses and reporting on opportunities to improve its performance. This includes advanced query, design, database, and systems expertise across multiple operational and analytical systems.

Requirements

Bachelor’s degree in Information Systems or equivalent experience
Minimum 5 years’ experience in a similar role.
Expertise in database query tools. (SQL, APEX, SAP BW/BI, LMS/CLNR)
Expertise in data analysis and presentation tools such as Microsoft Access and Excel.
Statistical Process / Quality Control experience.
Reporting tool (Power BI/Spotfire/Tableau) and ETL expertise
Basic Linux navigation/admin

Nice To Haves

Comfortable with multi-tasking on a broad range of assignments.
Sense of urgency for results - able to get a fairly accurate result quickly without getting bogged down in a “perfect”
Good communication skills and ability to work with business users to further initiatives and use tools.
Programing experience in Python/Perl
Optical industry knowledge

Responsibilities

Lead initiatives with business users and analysts to develop reporting on manufacturing, service, and efficiency metrics
Design and execute database queries into various systems (LMS/SAP/Kronos/BO)
Summarize the results of queries in a common format
Maintain accuracy and frequency of the reports with Supply Chain and Manufacturing leaders
Establish processes for ongoing distribution of reports
Publish the reports regularly
Build/Maintain metrics databases allowing for trend reporting
Monitor the effectiveness of the reports and coordinate improvements as required
Analyze operations for improvement opportunities
Contact and establish effective relationships with various sources of data
Analyze results for trends and opportunities using appropriate tools
Dig deeper as required to get actionable data
Develop root cause reporting based on anomalies
Track trends in root causes and tie to improvement in results
Provide brand-specific and sub-brand specific reporting
Store - level remake reports
Store - caused delays in sending in frames or transmitting orders