Sql data analyst Offres d'emploi - Delta, BC

Requisition ID: 949009
Position:Transportation Analyst
Total Rewards: Benefits/Incentive Information

Founded in 2000, Clearly is on a mission is to eradicate poor vision in the world by 2050 - the world’s largest unaddressed disability. Clearly serves this mission and the community every day by providing the most accessible, affordable, and stylish optical products on the market. Vancouver born and bred, Clearly was the first Canadian retailer to offer eyewear online. We are proud of our dynamic team members who work every day to fulfill our mission, and we celebrate their diverse backgrounds, skills, and perspectives.

Clearly is part of EssilorLuxottica, a global leader in the design, manufacture and distribution of world-class vision care products, including iconic eyewear, advanced lens technology and cutting-edge digital solutions. Join our global community of over 200,000 dedicated employees around the world in driving the transformation of the eyewear and eyecare industry. Discover more by following us on LinkedIn!

JOB DESCRIPTION

GENERAL FUNCTION

• Passion for operations, with the ability to manage day-to-day processes, spot bottlenecks, and implement practical improvements.
• Leverage data and analytical thinking to identify, develop, and implement continuous improvement initiatives that optimize cost and service performance
• Establish clear performance measures, track results, and effectively communicate insights, progress, and business impact to key stakeholders.

MAJOR DUTIES AND RESPONSIBILITIES

• Managing Transportation flows including:
  • Carrier Service Performance
    • Tracking of shipments and monitoring service performance
    • daily/weekly reports to Essilor Canada entities and NA transportation
    • Working with the BI Team to provide the relevant sources of Transportation data for weekly KPI reporting
    • Challenging our freight vendors if the OTP is below target
    • Attending weekly operations meeting with each of our freight vendors to review service performance and highlight any areas of concern
    • Ability to identify and implement service performance opportunities
  • Transportation Key Contact for Operations
    • Subject matter expert, able to identify and resolve any issues across all Transportation flows
    • Provides reporting and troubleshooting support to Operations team as required
    • Supervision of Inbound shipments (Parts and consumable, contact lenses, ophthalmic lenses imported from overseas) and outbound shipments (Ophthalmic lenses and contact lenses distribution to stores and customers)
  • Responsible for month end financial processes
    • Obtaining all the vendor invoice statements
    • Approves transportation invoices
    • Working directly with our finance BA and logistics analyst to validate the Transportation spend
  • Liaise with AP to ensure Transportation vendors are paid on time
  • Coordinate with customer service and sales
• Assists the transportation manager :
  • Identify anomalies and unique trends in complex data to support timely and dynamic approaches to delivering enhanced service levels as well as freight reductions within the Essilor Canada network
  • Tracking savings in transportation projects
  • Support in annual budget process
  • Providing support to Sourcing team for RFPs, new Freight Forwarders implementations, vendor files maintenance and vendor evaluations (QBRs, etc.)
  • Customs compliance
    • Ensure full compliance with customs and government agency requirements
    • H.S Code classification,
    • Audit Shipping documents
• Performs all of the above with a high level of confidentiality, experience, professionalism, detail orientation, thoroughness, and accuracy

Physical Demands:

• Passion for operations, with the ability to manage day-to-day processes, spot bottlenecks, and implement practical improvements.
• Strong analytical and problem-solving skills
• Ability to use data and analytics to drive operational decisions
• Strong Data analysis. Extensive experience in Microsoft Applications (eg Excel and Powerpoint)
• Experience in Supply Chain Logistics, preferred
• Strong communication and relationship skills
• Lean/Six Sigma experience preferred
• Bilingualism (French, English), an asset

Pay Range: 77,907.50 - 85,580.00

This posting is for an existing vacancy within our business. Employee pay is determined by multiple factors, including geography, experience, qualifications, skills and local minimum wage requirements. In addition, you may also be offered a competitive bonus and/or commission plan, which complements a first-class total rewards package. Benefits may include health care, retirement savings, paid time off/vacation, and various employee discounts.

EssilorLuxottica complies with all applicable laws related to the application and hiring process. If you would like to provide feedback regarding an active job posting, or if you are an individual with a disability who would like to request a reasonable accommodation, please call the EssilorLuxottica SpeakUp Hotline at 844-303-0229 (be sure to provide your name, job id number, and contact information so that we may follow up in a timely manner) or email EmployeeRelations@luxotticaretail.com

We are an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, gender, national origin, social origin, social condition, being perceived as a victim of domestic violence, sexual aggression or stalking, religion, age, disability, sexual orientation, gender identity or expression, citizenship, ancestry, 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. Native Americans in the US receive preference in accordance with Tribal Law.