Data Analyst

PACCAR; Bellevue (WA); On-site; USD 81,000 - 121,000; Full time

Benefits offered by this job

401k match

Pension

Paid time off

Holidays

Tuition reimbursement

Medical/Dental/Vision

FSA

HSA

Disability insurance

Life insurance

EAP services

Holiday gift

Job summary

PACCAR is seeking an analytics expert who will provide Business Intelligence and advanced data analytics across Sales & Marketing, Used Equipment Sales, and Credit. You will source data from multiple platforms, integrate it for business needs, and develop analytic products to improve efficiency.

Success depends on curiosity, comfort in ambiguity, a passion for learning, and strong analytic skills to build dashboards and models using SQL, Tableau, Python/R across on-prem and cloud environments.

Qualifications

• Bachelor’s degree in Business Analytics/Intelligence, Data Science, Statistics, Computer Science or related field.
• Minimum 3 years of professional experience.
• Proficiency with analytic programming languages (R, Python).
• Strong business acumen and communication skills.
• Understanding of data warehousing concepts and ETL processes.
• Proficiency with SQL querying and relational DB platforms (SQL Server, Snowflake).
• Excel expertise with VBA scripting and advanced functions.
• Data visualization using Tableau or Power BI.

Responsibilities

• Contribute to Data Science initiatives by providing robust analysis and developing analytic tools focusing on pricing optimization, product development, risk identification, and customer identification within a complex environment
• Deliver timely, relevant, and accurate analytic results to business users at all levels
• Employ AI/ML algorithms for models supporting pricing, customer identification, rate setting and other processes
• Identify, analyze, and interpret trends and patterns in complex data sets
• Develop high-performance SQL queries to support reporting and analysis
• Create and support executive dashboards using Tableau
• Provide rapid responses to ad-hoc analytic requests
• Expand analytic capacity by developing automated deployment pipelines, APIs, and data processing applications
• Maintain working relationships with IT and regional finance to enable digital initiatives
• Develop and present data science solutions to senior managers

Skills

Python

R

SQL

SQL Server

Snowflake

Tableau

Power BI

Excel

VBA

Data Visualization

Education

Bachelor’s degree in Business Analytics/Intelligence, Data Science, Statistics, Computer Science or related field

Minimum 3 years of experience in a professional or corporate setting

Tools

Tableau

Power BI

SQL Server

Snowflake

AWS

SSIS

VBA

Job description

Company Information

PACCAR is a Fortune 500 company established in 1905. PACCAR Inc is recognized as a global leader in the commercial vehicle, financial, and customer service fields with internationally recognized brands such as Kenworth, Peterbilt, and DAF trucks. 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 designs and manufactures advanced diesel engines and also provides customized financial services, information technology and truck parts related to its principal business.

Whether you want to design the transportation technology of tomorrow, support the staff functions of a dynamic, international leader, or build our excellent products and services — you can develop the career you desire with PACCAR. Get started!

Requisition Summary

This position serves as a trusted analytics expert, responsible for providing PACCAR Financial Corp (PFC) with Business Intelligence and Advanced Data Analytics/Data Science across functional areas of Sales & Marketing, Used Equipment Sales, and Credit. This position is responsible for applying a detailed understanding of PFC processes and systems, sourcing data from a wide range of data platforms, integrating relevant data to support business requirements, and developing analytic products that enhance business efficiency.

Success in this role will hinge on your curiosity, ability to work well in ambiguity, a passion for learning, and adept analytic technical skills.

Job Functions / Responsibilities

• Contribute to Data Science initiatives by providing robust analysis and developing analytic tools focusing on pricing optimization, product development, risk identification, and customer identification within a complex environment
• Deliver timely, relevant, and accurate analytic results to business users at all levels
  • Employ appropriate AI/ML Algorithms in creation and employment of models that support PFC’s strategic initiatives for pricing, customer identification, rate setting, and other business processes
  • Identify, analyze, and interpret trends and patterns in complex data sets
  • Develop high-performance SQL queries to support reporting and analysis
  • Create and support executive-level dashboards using Tableau
  • Provide rapid responses to ad-hoc analytic requests
• Enhance the value of PFC’s data assets
  • Maintain expertise in emerging technologies and analytic tools
  • Expand the department’s analytic capacity by developing automated deployment pipelines, APIs, and data processing applications using on-premises and cloud-based tools
  • Maintain strong working relationships with IT departments and regional finance offices to facilitate adoption of digital transformation initiatives
  • Develop and present data science solutions to senior managers and executives
• Support PFC initiatives as an integral member of an effective cross-functional analytics team
• Develop and implement process improvements leveraging AI to enhance data analysis and modeling capabilities, increasing the speed, accuracy, and efficiency of our work.

Qualifications & Skills

• Bachelor’s degree in Business Analytics/Intelligence, Data Science, Statistics, Computer Science or related field
• Minimum 3 years of experience in a professional or corporate setting
• Proficiency with analytic programming languages (R, Python)
• Strong business acumen and communication skills
• Understands and can apply foundational statistical concepts, and apply appropriate techniques to analyze data and generate useful business insights
• Highly-motivated self-directed learner with a creative mind, insatiable curiosity, and meticulous attention to detail
• Understanding of data warehousing concepts and development approaches
• Proficiency with SQL querying and use of relational database platforms (SQL Server and Snowflake)
• Expertise in Microsoft Excel: adept at leveraging Excel functions and able to develop and edit VBA-scripted functions
• Proficiency with data visualizations and tools such as Tableau or Power BI

Qualifications Desired

• MBA or Master’s degree in Analytics, Data Science, Operations Research, MIS or related field; or professional certifications such as CFA, CBIP, or MSCE in Business Intelligence.
• Demonstrable in-depth understanding of data structures and ETL processes (including SSIS)
• Expertise in a data-centric programming language such as Python or Javascript
• Hands-on data modeling experience
• Proficiency with core AWS services
• Basic understanding of commercial financial principles

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 Information

PACCAR is an E-Verify and Equal Opportunity Employer/Protected Veteran/Disability. At PACCAR, we value talent and promote growth and development. We carefully consider numerous compensation factors including your education, training, or experience. The salary range for this position is $80,800 - $120,800 annually. Additionally, this role is eligible for the full range of benefit options listed above.