Apply on Employer Site

Pronghorn · 1 day ago

Supplier Insights Coordinator

United States

Part-time

Remote

Entry, Mid Level

$25/hr - $30/hr

Pronghorn is building a movement focused on culture, innovation, and equity in the Spirits industry. The Supplier Insights Coordinator will support the Commercial Director by leading insights and analysis of supplier data, developing actionable insights, and owning reporting dashboards.

ManufacturingWine And Spirits

No H1B

Responsibilities

Automate Report Generation: Build, maintain, and continually improve code to aggregate and standardize supplier data from multiple data sources. Use this data and code to generate dashboards, customer order reports, state-of-business reports, and other ad-hoc actionable insights

Dashboard Ownership: Own, maintain, and update the supplier dashboard to provide insights on KPIs such as depletions, shipments, re-order rates, rate of sale, commitment status and more

Data SME/Data Strategy: Build understanding of underlying data sources to become SME on all supplier data sources. Build capability to pull ad-hoc reports and analysis as needed from any of these data sources

Qualification

ExcelPythonData visualizationData miningPowerPoint

Required

Advanced in Excel and/or Google Sheets (including strong proficiency in pivots, lookups, and advanced formulas as well as Excel/Google Sheets data visualization)

Experience in coding (Python or other) to clean, merge, and map datasets

Experience in data mining/manipulation and proficiency in managing datasets