onsite
Data Analyst I - Johnstone Supply
Data Analyst
Entry‑level Data Analyst role focused on extracting, cleaning, and visualizing HVACR supply chain data using SQL, Excel, and Python to support business decisions and improve customer service.
About the role
Key Responsibilities
- Collect, clean, and validate large datasets from internal systems and external partners.
- Develop and maintain SQL queries and stored procedures for reporting and analytics.
- Create interactive dashboards and visualizations in Power BI or Tableau to track key performance indicators.
- Collaborate with cross‑functional teams to define data requirements and deliver actionable insights.
- Document data models, processes, and best practices for future reference.
Requirements
- Bachelor’s degree in Data Science, Statistics, Computer Science, or related field.
- Proficiency in SQL and experience querying relational databases.
- Strong Excel skills, including advanced formulas, pivot tables, and data manipulation.
- Basic programming knowledge in Python (pandas, matplotlib) for data analysis.
- Excellent communication skills and ability to translate technical findings to non‑technical stakeholders.