Product Support Data Analyst - #258396

It’s your time, make it matter.

At Peterson, we partner with our customers to build the future. For over 85 years, our peoples’ work has shaped the communities where we live, where we raise our families, and where we thrive. Peterson’s legacy permeates every aspect of our communities. From roads and bridges, back-up power at hospitals, fire-fighting, concerts and moving goods; we are everywhere you look. At Peterson, you don’t just have a career, you have a purpose.

Our family-oriented environment is built on safety, winning, growth, and professional achievement. Hiring and developing exceptional people is critical to our continued success. We have high standards for a good reason: our people represent Peterson, our family, our brand, and our values.

You have high expectations too. You are exceptionally motivated, have outstanding skills, and want your work to matter. Peterson offers competitive wages, generous benefits, and promotional opportunities at a family-owned and operated business. It’s time to use your skills and passion to do work that matters!

Job Description

Peterson Cat has a need for a Product Support Senior Data Analyst who can be based at either our San Leandro, CA or Hillsboro, OR location.

Summary

The Product Support Senior Data Analyst supports data-driven decision making of Product Support departments within Peterson’s Earthmoving and Power Systems business units by extracting, analyzing, and modeling product support data. This position also develops and maintains reports, dashboards, and predictive analytics; communicates insights and provides actionable recommendations to stakeholders; and maintains internal system documentation and guidelines. As a senior role, this position is also responsible for mentoring and training team members.

Essential Job Functions

The following reflects management’s definition of essential functions for this job but does not restrict the tasks that may be assigned. Management may assign or reassign the functions to this job at any time due to reasonable accommodation or other reasons. Job functions include the following. Other duties may be assigned.

• Extract product support data from Caterpillar and internal systems, performing coding as needed, and collaborating with stakeholders to prepare related analysis and reporting.
• Examine product support data and other relevant information to determine the appropriate method of analysis.
• Clean, validate, cleanse, analyze, model and perform statistical analysis of product support data.
• Contribute to the design, development, and maintenance of reports, analyses, and dashboards, utilizing data visualization software such as Power BI and Tableau as needed.
• Perform and manage ad hoc analyses to help predict, measure, and interpret business trends, frame optimal ways of identifying relevant insights, and enable decision making.
• Manage day-to-day system needs, including system updates, integration requirements, maintenance of data tables, troubleshooting code, and general system maintenance.
• Work closely with various departments to understand the reporting, forecasting, and analytic needs of all end users, from sales representatives to the executive leadership team.
• Update guidelines, manuals, and other reference materials for internal systems including but not limited to Dealer Business System (DBS).
• Use Structured Query Language (SQL) regularly to create and run queries.
• Work to maintain data integrity while performing all job functions.
• Formulate and apply mathematical modeling and other optimizing methods to develop and interpret information that assists management with decision making, policy formulation, and/or other managerial functions.
• Provide predictive and prescriptive analytics and recommendations to stakeholders in a clear, value-focused manner.
• Make recommendations for new metrics to help drive business decisions.
• Launch projects with internal groups to develop in-house productivity/automation tools.
• Mentor, train, and support team members including Product Support Data Analysts.
• Maintain punctual, regular, and predictable attendance.
  
  

Qualifications

Bachelor’s degree from a fully accredited college in Mathematics, Statistics, Data Analytics, or other closely related field; and a minimum of five (5) years of progressive experience in data analytics; or an equivalent combination of education and work experience.

• Experience with DBS and CAT Machines-Engines Equipment database strongly preferred.
• Must display ability to create and run queries using Structured Query Language (SQL)
• Must display advanced skills in data visualization tools including Power BI and/or Tableau
• Must display advanced skills with Microsoft Excel and Microsoft Power Query
• Microsoft Power Automate skills strongly preferred
• Ability to code in Python and/or R preferred
  
  

CERTIFICATES, LICENSES, REGISTRATIONS

• Microsoft Power BI certification preferred
• Tableau certification preferred
  
  

The California pay range for this position is: $83,000 - $100,000 (Starting wage will depend on experience and education. We also offer a total compensation package in addition to base salary.)

Peterson Tractor Co. is committed to equal employment opportunity and affirmative action. Minorities, females, veterans, and individuals with disabilities are encouraged to apply. A drug screen and background check is required.