Data Analyst

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

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

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:

• Bachelors 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 companys best interests in mind at all times.
• Maintains ethical standards at all times.
• Maintains a professional personal appearance.