Its 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. Petersons 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 dont 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.Its 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 Petersons 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 managements 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

Bachelors 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: $83000 - $100000 (Starting wage will depend on experience and education. We also offer a total compensation package in addition to base salary.)