Data Analyst I

Johnstone Supply, North Americas 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 the 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, Honeywell, Emerson, Johnson Controls, Google 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.

Data Analyst Duties

• 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.

Education and/or Experience: 

      Required: 

• 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 Demands & Work Environment:

The physical demands and work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

Physical: 

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.

Work Environment:  

While performing the duties of this job, the employee is occasionally exposed to wet or humid conditions; moving mechanical parts; high, precarious places; fumes or airborne particles; toxic or caustic conditions; and vibration.  The noise level in this environment is usually moderate, occasionally loud.

We’re also interested in hiring a great candidate that holds these values so we can further build a strong company culture: 

• 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.

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.