Share this Job

Data Warehouse Architect Job

Apply now »

Date: May 20, 2018

Location: Renton, WA, US

Company: PACCAR

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 premium light-, medium- and heavy-duty trucks under the Kenworth, Peterbilt and DAF nameplates 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!

Division Information

PACCAR Parts is the global provider of aftermarket parts and services to support Kenworth, Peterbilt, DAF and TRP dealers around the world.  This includes 18 distribution centers globally that support 2,200 dealerships and over 1,000,000 customers.  Aftermarket support includes world class customer centers that deliver industry leading uptime in conjunction with our outstanding supply chain that delivers record levels of inventory availability for dealers and customers. 

Requisition Summary

The Data Manager is responsible for defining the data structure and governance of data for the Division. This may include creating a data strategy, aggregating data from multiple sources, interpreting data, analyzing results using statistical techniques and providing ongoing reports

Job Functions / Responsibilities

  • Attains knowledge of data warehouse architecture and practices Agile development methods and techniques
  • Analyzes and designs ETL solutions based on the data mapping and provides data specifications for integrating new and/or updating data within the data warehouse
  • Designs and/or develops database objects (databases, tables, stored procedures, views etc.) to support ETL and data integrations
  • Analyzes Business Intelligence (BI) requirements and designs/develops reporting solutions to support standard reporting, dashboard and self-service environment
  • Develop framework for data governance to ensure compliance with business and IT rules
  • Work with management team to create a prioritized list of needs for each business segment
  • Leads Data Analysts throughout the Division to deploy best practices
  • Serves as the subject matter expert on data warehouse architecture, data warehouse, and data mart models
  • Identify and recommend new ways to save money by streamlining business processes
  • Use statistical methods to analyze data and generate useful business reports
  • Writing relational and multidimensional database queries
  • Configuring, deploying and maintaining database servers
  • Provides to PACCAR Parts Business areas on-going support for operational, corporate and data warehouse staff in relation to existing reports with respect to their definitions and differences


  • Bachelor’s Degree in Information Science, Analytics, Computer Science, Computer Engineering or related field; Master’s degree a plus
  • 2+ years Data mining experience
  • 4+ years in a data analyst role
  • 2+ years of experience on Databases including: SQL, SSIS, SSRS, SSMS, Data Engineering practices
  • Knowledge of ETL and data warehouse concepts and processes
  • Experience with Tableau, Lumira, Power BI or an equivalent reporting tool to create impactful reports, visualizations, and interactive dashboards
  • Ability to work well with others demonstrated strong communication skills and self-motivation.
  • Strong attention to detail


  • Experience with ERPs, Manufacturing Execution Systems, Order Processing, Finance or Sales Systems is a plus.
  • Familiarity with Agile software development practices
  • Six Sigma with DFSS experience

Additional Job Board Information

PACCAR is an Equal Opportunity Employer/Protected Veteran/Disability.

Nearest Major Market: Seattle
Nearest Secondary Market: Bellevue

Job Segment: Data Architect, Data Warehouse, Database, Architecture, Engineer, Data, Technology, Engineering

Find similar jobs: