Senior Data Analyst

Peterbilt Motors Company; Denton (TX); On-site; USD 95,000 - 125,000; Full time

Benefits offered by this job

401k with company match

Pension plan

Paid time off

Holidays

Tuition reimbursement

Medical, dental, and vision

Job summary

Peterbilt Motors Company, a PACCAR brand, seeks a Senior Data Analyst to manage sales operations analytics across national, regional and vocational teams. You will extract, clean, and model data, develop dashboards in Tableau and Power BI, and collaborate with managers to drive decisions.

The role requires a Bachelor’s degree in a quantitative field, 7+ years in data analysis, and advanced Excel/SQL skills. Travel up to 5% and the ability to work cross-functionally in a fast-paced environment.

Qualifications

• Bachelor’s degree in a quantitative field is required.
• 7+ years of related experience in a data or systems analyst role.
• Advanced knowledge of Excel and Access is required.
• Knowledge of SQL and Snowflake is required.
• Experience with data visualization tools Tableau and/or Power BI is required.

Responsibilities

• Extract, clean, merge, transform and compile data from diverse sources including relational databases, flat files, NoSQL and unstructured data.
• Create and implement data visualization models and dashboards using MS SQL, Snowflake, Tableau and Power BI.
• Develop automated processing using tools like SmartSheet, UIPath, and Microsoft Power Automate.
• Provide actionable ad-hoc analysis to management to support decision-making.
• Deliver technically viable solutions aligned with best practices for implementation.
• Support data architecture design and development for sales and sales operations initiatives.
• Travel up to 5%.

Skills

Excel

Access

SQL

Snowflake

Tableau

Power BI

Education

Bachelor’s Degree in a quantitative field

Bachelor's Degree in Business Administration/Information Systems/Computer Science or related field

Job description

Company Information

PACCAR is a global technology leader in the design, manufacture, and customer support of high-quality light-, medium- and heavy-duty trucks under the Kenworth, Peterbilt and DAF nameplates. PACCAR also designs and manufactures advanced power trains, provides financial services and information technology, and distributes truck parts related to its principal business.

PACCAR is a global technology leader in the design, manufacture, and customer support of high-quality light-, medium- and heavy-duty trucks under the Kenworth, Peterbilt and DAF nameplates. PACCAR also designs and manufactures advanced power trains, provides financial services and information technology, and distributes truck parts related to its principal business.
Peterbilt Motors Company
On highways, construction sites, city streets, logging roads - everywhere our customers earn their living - Peterbilt's red oval is a familiar symbol of performance, reliability, and pride. Peterbilt has reigned as America's premium quality truck manufacturer since the company's founding in 1939. Our dedication to deliver products and services focused on improving customers' performance, image, profitability, and peace of mind truly makes Peterbilt the Class of the Industry.

Requisition Summary

The Senior Data Analyst has a key role in handling multiple sales operations and customer focused matters relating to Peterbilt's National Account, Regional and Vocational Sales teams, as well as those of Sales Operations. The successful candidate must be detail oriented, organized, have excellent communication skills and be a team player with an analytical approach to solution-based thinking. Daily activities involved in this role include sales reporting for the Peterbilt General Sales Managers, Region Sales Managers, and District Sales Managers including, but not limited to, Tableau dashboard management and general communication with the team.

Job Responsibilities

• Extract, clean, merge, transform and compile data from various data sources, including relational databases, flat files, NoSQL databases and unstructured data
• Create and implement data visualization models and dashboards supporting data projects using MS SQL, Snowflake, Tableau and Power BI or other comparable tools
• Develop automated processing using various tools including, but not limited to SmartSheet, UIPath, Microsoft Power Automate and other supported automation technologies
• Provide accurate, relevant and meaningful ad-hoc analysis to management upon request to support strategic and tactical decision-making
• Deliver well-researched and experience-based technical solution recommendations, ensuring they are viable and aligned with best practices to support effective implementation.
• Implement various sales and sales operations initiatives by providing data architectural design and development support.
• Up to 5% travel is expected for this position

Required Qualifications

• Bachelor’s Degree required (quantitative field preferred)
• Bachelor's Degree in Business Administration, Information Systems, Computer Science or related field is strongly desired.
• 7 years of related experience in a data or systems analyst role
• Advanced knowledge of Excel and Access required
• Knowledge of SQL and/or Snowflake required
• Experience with data visualization required (Tableau and/or PowerBI)

Preferred Qualifications

• ITIL Foundations Certification preferred
• Proficient with Peterbilt CARS and OPS system preferred.
• Strong troubleshooting and problem-solving skills
• Experience with Agile Methodologies a plus
• Six Sigma experience a plus
• Must be a highly-motivated self-starter and self-directed learner with a creative mind, high attention to detail, and a solution-oriented outlook
• Ability to succeed in a multi-functional business environment and influence adoption of new ideas
• Excellent interpersonal and organizational skills, including active listening, problem solving when under pressure, and facilitation
• Capacity to lead and work effectively with cross-functional teams
• Highly self-motivated and flexible with focus on delivery

Additional Preferred Qualifications

• Excellent verbal and written communication skills and the ability to interact professionally with a diverse group of executives, managers, and subject matter experts
• Strong knowledge of Agile methodologies including Scrum or Kanban
• Demonstrated problem solving, facilitation, and customer service skills
• Able to work effectively in a team environment with little or no supervision
• Strong understanding of business process, preferably in supply chain operations
• Effective presentation skills suitable for senior management
• Working knowledge of application technology stack and requirements for integration into the business environment
• On-call availability for business support
• Experience in Manufacturing industry
• Self-motivated and able to work effectively with little or no supervision
• Proficient with Microsoft productivity tools, including: Word, Excel, PowerPoint, Visio, Project, Azure DevOps

General Description Of All Benefits

As a U.S. PACCAR employee, you have a full range of benefit options including:

• 401k with up to a 5% company match
• Fully funded pension plan that provides monthly benefits after retirement
• Comprehensive paid time off – minimum of 10 paid vacation days (additional days are provided with additional seniority/years of service), 12 paid holidays, and sick time
• Tuition reimbursement for continued education
• Medical, dental, and vision plans for you and your family
• Flexible spending accounts (FSA) and health savings account (HSA)
• Paid short-and long-term disability programs
• Life and accidental death and dismemberment insurance
• EAP services including wellness plans, estate planning, financial counseling and more
• This position is also eligible for a holiday gift.

Additional Job Board Information

PACCAR is an E-Verify & Equal Opportunity Employer/Protected Veteran/Disability corporation. Peterbilt promotes Diversity and Inclusion through mentorship, events, and affinity support groups – The Diversity Council, Peterbilt Women’s Initiative (PBWIN), Veterans Group, Peterbilt Black Organization for Leadership & Development (B.O.L.D.), and ADVOCATE (an LGBTQ+ support group).