Job Description
PGW Auto Glass has an immediate opening for a Senior Pricing Analyst. PGW AG is part of LKQ Corporation, the largest provider of aftermarket collision replacement products, recycled OEM products and refurbished OEM collision replacement products. LKQ is also a leading distributor of paint and body shop supplies.
This position is part of the Corporate Pricing Team and plays a critical role in executing and implementing business strategies related to product pricing and product coverage and has a significant impact on the performance of the business. This position influences all facets of the team's strategic Pricing efforts to support profitable sales of over 8,000 parts to over 5,000 customers. This role interacts and collaborates regularly with sales, finance and supply chain functions.
1\. Support the sales team by providing pricing, financial modeling, data mining and analysis, project management, and reporting.
2\. Manage a database of industry, internal, and third-party datasets to analyze and make recommendations supporting pricing actions for the division.
3\. Lead the development, refinement, and adoption of tools, policies, and procedures that enhance existing performance.
4\. Document and maintain the departments processes and procedures.
5\. Create and run reports tracking industry pricing trends as well as project results and communicate findings appropriately.
6\. Perform ad-hoc analysis and prepare reports of findings
7\. Perform other duties as assigned
Requirements
A Bachelors degree in business, finance, economics, engineering, information technology, computer science or a related field is required, along with a minimum of 5 years relevant business experience. The incumbent must have a demonstrated track record of success performing the required responsibilities. A Master's degree and experience in the automotive replacement glass market is preferred but not required.
The incumbent must have possess excellent analytic abilities, must be proficient in both written and oral communication, and must be adept in advanced query writing and relational database management. Proficiency in the SQL computer language (T-SQL, ANSI, or PLSQL), manipulating data structures, maintaining and validating data tables, schemas, simple programs, DMLs and DDLs. He/she must be able to effectively interface with multiple lines of business including sales, finance, supply chain, and manufacturing and be able to build partnerships both internally and externally. A high degree of creative ability, analytical business skills, and independent judgment are continually utilized in this role. The incumbent must also demonstrate exceptional prioritization and organizational skills in managing the multiple projects and responsibilities. Proficiency in Microsoft Office applications such as Outlook, Word, Excel and Power Point are also required.
Position Type
Full-time
Chicago, IL
LKQ Corporation is an American provider of alternative and specialty parts to repair and accessorize automobiles and other vehicles. LKQ has operations in North America, Europe and Taiwan. LKQ offers its customers a broad range of replacement systems, components, equipment and parts to repair and accessorize automobiles, trucks, and recreational and performance vehicles. As of 2018, it was #300 on the Fortune 500 list. In March of 2017, Dominick P. Zarcone was selected to become the new President and Chief Executive Office.
LKQ was initially formed in 1998 through the combination of a number of wholesale recycled products businesses located in Florida, Michigan, Ohio and Wisconsin. We subsequently expanded through internal development and over 220 acquisitions of aftermarket, recycled, refurbished, and remanufactured product suppliers and manufacturers; self service retail businesses; and specialty vehicle aftermarket equipment and accessories suppliers. Our most significant acquisitions include:
• 2007 acquisition of Keystone Automotive Industries, Inc., which, at the time of acquisition, was the leading domestic distributor of aftermarket products, including collision replacement products, paint products, refurbished steel bumpers, bumper covers and alloy wheels.
• 2011 acquisition of Euro Car Parts Holdings Limited ("ECP"), a vehicle mechanical aftermarket parts distribution company operating in the United Kingdom. This acquisition allowed us to expand our operations into the European automotive aftermarket business.
• 2013 acquisition of Sator Beheer B.V. ("Sator"), a vehicle mechanical aftermarket parts distribution company based in the Netherlands, with operations in the Netherlands, Belgium and Northern France. This acquisition allowed us to further expand our geographic presence into continental Europe.
• 2014 acquisition of Keystone Specialty, which expanded our product offering and increased our addressable market to include specialty vehicle aftermarket equipment and accessories.
• On December 22, 2015, LKQ announced that it has signed a definitive agreement to acquire the holding company of Rhiag-Inter Auto Parts Italia
• S.p.A (“Rhiag”), a leading pan-European business-to-business distributor of aftermarket spare parts for passenger cars and commercial vehicles. Rhiag has operations in Italy, Czech Republic, Switzerland, Hungary, Romania, Ukraine, Bulgaria, Slovakia, Poland and Spain. The transaction is expected to be completed in the first half of 2016 and is subject to customary closing conditions and necessary regulatory approvals.