Data Analyst

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

Benefits offered by this job

Health insurance

Dental insurance

Vision insurance

Paid Time Off

401(k) with employer match

Holiday pay

Parental bonding time

Life insurance

Short-term disability

Long-term disability

Telehealth

HSA

FSA

Wellbeing program

Employee Assistance Program

Tuition reimbursement

Employee referral program

Service milestone recognition

Job summary

Johnstone Supply LLC in New Orleans is seeking a Data Analyst to identify and organize essential data, and to create clear Excel reports for executive decision-making. You will help quantify performance, pricing impacts, and market outcomes across the organization.

The role requires 3–5 years of data analysis experience, advanced Excel skills, and familiarity with POS/ERP reporting. This on-site position offers growth and exposure to a leading HVACR distribution network.

Qualifications

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

Responsibilities

• Identify relevant data required to analyze and measure company performance.
• Identify data to analyze and impact product sell pricing.
• Aggregate and organize data using Microsoft Excel functions.
• Create Excel reports easily understood by senior management for business decisions.
• Present objective information and data mining to inform market strategy and decisions.
• Provide information to improve decision making about business performance.
• Prepare daily, monthly, and quarterly reporting to boost staff productivity.

Skills

Advanced Excel

Pivot tables

Data analysis

Reporting

Education

Two-year college degree

Bachelor’s degree or advanced degree (preferred)

Tools

POS/ERP database

Job description

Overview

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 peopleJohnstone is growing, and so can you.

Responsibilities

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 Demand

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.

Company Values

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.

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