onsite
Data Analyst - Johnstone Supply
Data Analyst
Data Analyst focused on HVACR supply chain insights, leveraging SQL, Python, Excel, Tableau, and Power BI to transform data into actionable business intelligence for a leading wholesale distributor.
About the role
Key Responsibilities
- Collect, clean, and analyze large datasets from distribution centers and sales channels to identify trends and opportunities.
- Develop and maintain interactive dashboards in Tableau and Power BI to provide real‑time visibility to sales, operations, and executive teams.
- Write complex SQL queries to extract, join, and aggregate data across multiple source systems.
- Use Python for data manipulation, statistical analysis, and automation of repetitive reporting tasks.
- Collaborate with cross‑functional stakeholders to define KPIs, report requirements, and data governance standards.
Requirements
- Bachelor’s degree in Data Science, Statistics, Computer Science, or related field.
- 3+ years of experience in a data analyst role within a distribution or supply‑chain environment.
- Proficiency in SQL, Python (pandas, numpy), and advanced Excel functions.
- Hands‑on experience building dashboards in Tableau or Power BI.
- Strong analytical mindset, excellent communication skills, and ability to translate business questions into data solutions.
Skills
sqlpythonexceltableaupower bi