Share this Job

Date: Jan 15, 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’s Information Technology Division (ITD), located in Renton, WA utilizes cutting-edge technology to provide systems development, consulting, voice and data communications services to the entire Corporation, which has high visibility in the technology sector.

Requisition Summary

We are looking for an experienced Data Engineer with an uncanny ability to integrate multiple heterogeneous data sources to build efficient, flexible, and scalable data warehouse and reporting solutions. The ideal candidate is enthusiastic about learning new technologies and implementing solutions using these technologies to empower internal customers and scale the existing platform. The ideal candidate demonstrates solid business and communication skills and ability to work with Research Scientists and business owners across both technical and non-technical teams to develop and define key business questions, then build the data sets that answer those questions. In this role, you will serve as the expert at designing, implementing, and operating stable, scalable, low cost solutions to flow data from production systems into the data warehouse and into end-user facing reporting applications. Above all, you should be excited about bringing large datasets together to answer business questions and drive data driven decision making.

The Data Engineer will design, develop, implement, test, document, and operate large-scale, high-volume, high-performance data structures for business intelligence analytics and deep learning. Implement data structures using best practices in data modeling, ETL/ELT processes and AWS Redshift, Teradata, Oracle, DB2, and OLAP technologies He/she will be writing scalable queries and tuning performance on queries running over billion of rows of data.

The person in this position should be analytical, have an extremely high level of customer focus and a passion for process improvement.  The Data Engineer should be motivated self-starter that can work independently in a fast paced, ambiguous environment and should have excellent business and communication skills to be able to work with business owners to develop and define key business questions.

Job Functions / Responsibilities

  • Design, implement, and support data warehouse infrastructure using AWS cloud technology, Teradata, and multiple RDBMS engines.
  • Create ELT/ETL procedures to take data from various operational systems and create a unified dimensional or star schema data model for analytics and reporting.
  • Support Data Analysts and Research Scientist in analyzing usage data to derive new insights and fuel customer success
  • Use business intelligence and visualization software (e.g., OBIEE, Quicksight, Tableau Server, etc.) to empower non-technical, internal customers to drive their own analytics and reporting.
  • Generates scripts for database deployment.
  • Models physical/application data requirements in a data model tool, such as ERWin data modeler
  • Teaches data modeling and data design concept to IT and business people.
  • Provides data model estimates for new projects.
  • Manages data models and related artifacts in a source safe repository such as TFS.
  • Provides on-going support for Agile projects.
  • High degree of knowledge based on prior implementation experience with AWS Glue, Aurora, S3, Redshift, VPC, etc.
  • Performs expert-level data development and design work in Cloud environments that may include logical data topology design, cloud data architecture analysis and design; including integration with additional 3rd party data sources in multiple cloud platforms.
  • Contributes to and maintains data standards.
  • Ensures security is integrated into all data solutions to meet compliance standards.

Qualifications

  • Bachelor’s degree in Computer Science or related field.
  • 5+ years relevant experience in data modeling and data architect.
  • Expertise with SQL and relational database systems.
  • Knowledge of data warehousing concepts.
  • Experience in data mining, ETL, etc. and using databases in a business environment with large-scale, complex datasets.
  • Experience in modeling logical/business data requirements in a data model tool, such as ERWin data modeler.
  • Experience in generating scripts for physical database deployment.
  • Ability to teach data modeling and data design concept to IT and business people.
  • Familiarity with Cloud, NoSQL, and Hadoop data technologies
  • Familiarity with dimensional and data vault modeling techniques.
  • Proficiency with ETL tools and techniques.
  • Knowledge of more than one database platform, such as SQL Server, Oracle and Teradata.
  • Expertise in standard data model reports.
  • Must have knowledge of data normalization and denormalization techniques
  • Excellent interpersonal and organizational skills, including active listening, problem solving when under pressure, and facilitation.
  • Strong troubleshooting and problem solving skills.

Education

Bachelor’s degree in Computer Science or related field.

Additional Job Board Information

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


Nearest Major Market: Seattle
Nearest Secondary Market: Bellevue

Job Segment: Database, Consulting, Oracle, Warehouse, Data Warehouse, Technology, Manufacturing

Find similar jobs: