PACCAR

Data Engineer (Data Warehouse Developer)

PACCAR  •  Pune, IN (Onsite)  •  3 months ago
Apply
AI can make mistakes so check important info. Chat history is never stored.

Job Description

We are looking for an enthusiastic and inquisitive Data Engineer (Data Warehouse Developer) in DAF who is responsible for designing and building the data warehouse environment that supports analytics and reporting. They focus on data integration, transformation, and ensuring data is accurate and accessible for decision-making. Data warehouse developer maintains the ETL process for the data warehouse, from AWS dropzone till Snowflake reporting tables.

Key Responsibilities –

  • Design and develop solutions to meet the business and IT requirements
  • Design and implement data warehouse schemas such as star, snowflake, or galaxy schemas.
  • Create and maintain logical and physical data models aligned with reporting and analytics need
  • Develop, test, and maintain ETL (Extract, Transform, Load) processes to load data from various sources into the data warehouse.
  • Ensure data quality, consistency, and integrity during the ETL process.
  • Optimize ETL processes for performance and scalability, reliability and cost efficient and configure monitoring.
  • Tune SQL queries and database performance to ensure fast data retrieval and reporting.
  • Work closely with business analysts, data architects, it architects and BI developers to deliver compliant data solutions
  • Communicate with stakeholders to gather requirements and provide updates on development progress.
  • Coordinate with business stakeholders to understand the requirements and relevant user stories
  • Understand and communicate technical needs effectively with business, internal users within the teams.
  • Work as part of an Agile Team to deliver projects that meet customer expectations and achieve desired business benefits

Education Requirements:

  • Bachelor’s degree in Computer Science, Information Technology, or related fields.

Knowledge & Skills REQUIRED:

  • 7-10+ years of hands-on IT technical experience.
  • Expertise working on RDBMS: Snowflake
  • Working knowledge of AWS services like S3, Lambda etc.
  • Understanding of Python or other programming languages.
  • Working knowledge of GIT/Github for source management and pipelines.
  • Knowledge of and experience with reporting tool: Tableau

Technical / Professional Experience Desired:

  • Databases: NoSQL, Cloud databases
  • ETL: Big Data ETL (Spark, Hadoop)
  • Programming: Advanced DevOps scripting
  • Cloud: AWS Redshift, Azure Synapse, GCP BigQuery
  • DevOps & Source Control: Docker, Kubernetes, advanced CI/CD
  • Data Modelling: Advanced data modelling techniques
  • Reporting & BI: Power BI, Looker
  • Data Quality: Data governance and compliance
  • Monitoring & Performance Optimization: Solution Monitoring, Operational Dashboard and Alert Management

COMPETENCIES AND BEHAVIORS:

  • Excellent problem-solving skills and written and verbal communication skills.
  • Able to work effectively in a team environment with little or no supervision.
  • Able to prioritize and track multiple initiatives concurrently.
  • Embody and promote PACCAR ITD values of Teamwork, Continuous Improvement, Commitment, Openness, and Learning
PACCAR

About PACCAR

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. PACCAR also designs and manufactures advanced diesel engines, provides financial services, information technology, and distributes truck parts related to its principal business.

Kenworth Truck Company builds premium commercial vehicles for sale in the U.S., Canada, Mexico and Australia and for export throughout the world. Peterbilt Motors also designs, manufactures and distributes premium commercial vehicles in the US and Canada. DAF Trucks manufactures trucks in the Netherlands, Belgium, Brasil and the United Kingdom for sale throughout Western and Eastern Europe, and export to Asia, Africa, North and South America.

PACCAR Parts operates a network of parts distribution centers offering aftermarket support to Kenworth, Peterbilt and DAF dealers and customers around the world. Aftermarket support includes customer call centers operating 24 hours a day throughout the year and technologically advanced systems to enhance inventory control and expedite order processing.

PACCAR Financial Services provides finance, lease and insurance services to dealers and customers in more than 100 countries including a portfolio of more than 175,000 trucks and trailers and total assets in excess of $12 billion. The group includes PACCAR Leasing, a major full-service truck leasing company in North America, with a fleet of over 39,000 vehicles.

Environmental responsibility is one of PACCAR’s core values. The company regularly develops new programs to help protect and preserve the environment and PACCAR has established ambitious goals to further reduce emissions and enhance fuel efficiency in its truck models.

Industry
Automotive & Mobility
Company Size
10,000+ employees
Headquarters
Bellevue, WA
Year Founded
Unknown
Social Media