Data Analyst

Data Analyst
Department: ARC Mechanical
Employment Type: Full Time
Location: Wilmington, MA
Description
Kelvin Group is a leader in the field of industrial and commercial mission-critical mechanical services, process safety management and environmental compliance. Our turnkey solutions provide Design/Installation and Ongoing Service and Preventative Maintenance of world-class mechanical systems for leaders in the Food and Beverage, Cold Storage, Pharmaceutical, Educational, Health Care, and Process industries.
We are seeking a Data Analyst to join our team and support our 150 field technicians in our HVAC/R service business as well as work with our corporate team to build a comprehensive automated reporting package. The Data Analyst will play a critical role in gathering, analyzing, and interpreting data to optimize our operations, improve field service efficiency, and enhance overall business processes.
Key Responsibilities

• Data Collection and Analysis:
  • Gather and compile data from various sources, including service reports, work orders, and back-end ERP systems.
  • Analyze and interpret data to identify trends, performance indicators, and areas for improvement.
  • Develop data collection protocols and ensure data accuracy and completeness.
• Performance Tracking:
  • Monitor field technician performance and productivity.
  • Develop and maintain KPIs to measure service quality, response times, and customer satisfaction.
  • Generate regular reports and dashboards for management.
• Operational Efficiency:
  • Work with the field service team to optimize technician routes and schedules.
  • Identify opportunities to reduce operational costs and improve resource allocation.
  • Assist in inventory management to ensure timely availability of spare parts.
• Customer Satisfaction:
  • Analyze billing team feedback and service quality data to enhance the days to bill process.
  • Identify areas for service improvement and recommend action plans.
  • Collaborate with customer service teams to address customer concerns.
• Technology Integration:
  • Assist in the integration of new technologies and validation of the data.
  • Ensure seamless data flow between field technicians and central databases.
• Continuous Improvement:
  • Stay up to date with industry best practices and data analysis tools.
  • Propose process improvements and innovations to enhance field service operations.

Skills, Knowledge and Expertise

• Bachelor's degree in a relevant field (e.g., Data Science, Business, Engineering, Finance).
• Proven experience in data analysis and data management.
• Proficiency in data analysis tools, such as Microsoft Excel, SQL, and data visualization tools.
• Strong analytical and problem-solving skills.
• Excellent communication and teamwork skills.
• Knowledge of HVAC/R systems and field service operations (preferred but not mandatory).
• Power BI or Tableau experience a plus.

Benefits
Check out these industry leading benefits:

• Healthcare (medical, dental, vision, prescription drugs)
• Health Reimbursement Arrangement (shared cost deductible)
• Flexible Spending Account
• Dependent Care Account
• Accident Insurance
• Life Insurance
• AD&D Insurance
• Short/Long Term Disability
• Employer matched 401(k) savings plan
• Paid vacation time
• Paid sick time
• Generous paid holiday schedule