Data Analyst

Johnstone Supply; Orleans (IN); On-site; USD 26,174 - 30,307; Full time

Job summary

Johnstone Supply, North America's leading HVACR distributor, seeks a data analyst to turn data into actionable insights. You will work with Excel to analyze performance, pricing impact, and reporting for senior management.

The role requires strong Excel skills, experience with POS/ERP systems, and the ability to present data clearly to support business decisions. This is a full-time, on-site position in Indiana with opportunities to influence market strategies.

Qualifications

• Two-year college degree or equivalent; three to five years in data analysis suggested.
• High level of computer literacy and strong Excel proficiency.
• Experience with POS/ERP database and reporting functionality.
• Proficiency with pivot tables, charts and graphs in Excel.

Responsibilities

• Identify data required to analyze company performance and price impact.
• Aggregate and organize data using Excel functions.
• Create clear Excel reports for senior management to aid decision making.
• Present data insights to support go-to-market decisions.
• Produce daily, monthly, and quarterly reports to improve staff efficiency and productivity.

Skills

Excel

Pivot tables

Data analysis

Statistical analysis

Reporting

Education

Two-year college degree

Bachelor’s degree

Tools

POS/ERP database

Microsoft Office

Job description

Johnstone Supply, North America's leading wholesale distributor of HVACR equipment, parts, and supplies, has a great opportunity to join our team. Over the last seven decades, Johnstone has grown into a multi-billion-dollar industry leader with over 470 distributor branches and 6 distribution centers throughout North America. We work with some of the largest companies in the world, including Daikin/Goodman, Bosch, Copeland, Honeywell, Johnson Controls, and Fujitsu, to provide contractors with world-class products, technical expertise, and quality service.

Now is the best time to join Johnstone Supply

Relationship-building is the key to our success, and it shows in everything we do. The Power of Johnstone is everyone who works with us. Our customers, our partners, and our people. Johnstone is growing, and so can you.

Responsibilities

• Identify relevant data required to effectively analyze and measure company performance.
• Identify relevant data required to effectively analyze and impact product sell pricing.
• Aggregate and organize data using Microsoft Excel functions.
• Create reports in Excel that are easily understandable by the senior management team, and provide relevant information needed for business decision making.
• Present objective information and data mining to make better decisions concerning the business and how the company will go to market.
• Serve a vital role in providing information in a way that allows us to make better decisions about the performance of our business.
• Formulate daily, monthly, and quarterly reporting to enhance the decision making of the average staff member to do his or her job with greater efficiency and productivity.

General Results And Responsibilities

• Adheres to all company policies, procedures, standards, and business ethics codes.
• Maintains a helpful, courteous attitude, and professional communication when interacting with customers, coworkers, and outside agencies.
• Role models the Johnstone Supply organizational culture on daily a basis.
• Committed to the Two Pillars of Lean: Continuous Improvement, and Respect for People

Qualifications

To perform this job successfully, an individual must be able to perform each essential job function satisfactorily. The requirements listed below are representative of the knowledge, skills, and/or abilities required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

Required

Education and/or Experience:

• Two-year college degree.
• Three to five years related experience in a data analysis role.
• High level of computer literacy, and highly proficient in Excel.
• Experience with a POS or ERP database, with reporting functionality.
• Proficiency with pivot tables, charts and graphs in Excel.

Preferred

• Bachelor’s degree or advanced degree.

Technical

• Ability to add, subtract, multiply and divide using whole numbers, common fractions, and decimals.
• Strong statistical analysis skills.
• Ability to evaluate multiple levels of data and identify patterns.
• Ability to develop impactful charts and graphs to present findings.
• Highly proficient in all Microsoft Office Excel and related Office products.

Process

• Skill in using critical thought to identify the strengths and weaknesses of alternative solutions.
• Ability to follow instructions and procedures.
• Ability to organize and prioritize work.
• Ability to attend to details.

Communication

• Strong written and verbal communication skills.
• Strong presentation skills.
• Ability to network internally to accomplish business goals and projects

Person-Organization Fit

• Skill in following through on commitments.
• Ability to work independently with some direction.
• Strong ability to multitask and skill in prioritizing work.
• Skill in using critical thought to identify the strengths and weaknesses of alternative solutions.
• Ability to complete routine paperwork.
• Ability to maintain a positive and friendly demeanor in a stressful and fast paced environment.
• Ability to follow instructions and procedures
• Ability to work efficiently and with a sense of urgency.
• Ability to work with others in a team-based environment.
• Ability to manage time in a deadline driven environment.
• Keeps the company’s best interests in mind at all times.
• Maintains ethical standards at all times.
• Maintains a professional personal appearance.

Physical Demand

While performing the duties of this job, the employee is regularly required to stand; walk; use hands to finger, handle, or feel; reach with hands and arms; climb or balance; stoop, kneel, crouch, or crawl. The employee is occasionally required to talk or hear. Specific vision requirements are close vision, distance vision, peripheral vision, and depth perception. All full-time employees are expected to work 40 hours in a week and overtime as workload dictates.

Company Values

• Safety: Always prioritizes safety, both at work and at home, while ensuring those who work for you work safely.
• Customer Focused: Take the perspective of those we serve, anticipate their needs, and responding quickly.
• One Team: We win together by collaborating with each other, focusing on the common goal, and leveraging the strengths of the team.
• Own It: Take the initiative, act with a sense of urgency and pride, do things right the first time, and always act with integrity.
• Innovate: Embrace and create change that drives continuous improvement and customer-valued solutions.

Benefit Overview

At Johnstone Supply, we recognize that our employees’ growth, well‑being, and success drives the company’s success. We offer a competitive wage, in addition to health and wellness benefits including medical, dental, vision coverage, and options for supplemental care. We provide the resources you need to take charge of your well‑being, including:

• Competitive Paid Time Off (PTO)
• Safe Harbor 401(k) – 100% employer match up to 5% of base pay and immediate vesting
• Holiday pay – we recognize and pay our employees for 7.5 holidays per year
• Paid Parental Bonding Time
• Employer subsidized medical, dental, and vision plans
• Employer paid life insurance and short‑term disability
• Voluntary long‑term disability, accident, critical illness, and hospital indemnity insurance
• 24/7 Access to virtual care/telehealth options
• Health Savings Account (HSA) with employer contribution; Flexible spending accounts (FSA)
• Wellbeing program with opportunity to earn reduced medical costs
• Employee Assistance Program (EAP) for you, and your family
• Tuition reimbursement
• Employee referral bonus program
• Employee service milestone recognition program

We understand that our employees are the cornerstone of our success. Our commitment to continuous improvement & investment in our people is only matched by our commitment to superior customer experience.

EOE & E-Verify Participating Employer.

Compensation

$19-$22 Hour