The Role
Design, build, support, and troubleshoot data pipelines, integrations, and data warehouses. Collaborate with cross-functional teams, recommend tools and frameworks, ensure data governance, and mentor junior data engineers.
Summary Generated by Built In
You may know Penske for our big yellow trucks. But did you know we’re an industry-leading technology innovation company? At Penske we have a 50-year history of leading the transportation and supply-chain industry, delivering world-class and award-winning technology solutions. And, it starts with our associates. No matter what your skills or technology stack, our IT team is for you. You’ll work and grow alongside great people and on really cool projects. We inspire our IT experts to push the boundaries, create possibilities, be innovative, and, most of all, to have fun. Ultimately, you’ll help develop and ensure our technology solutions keep our company and our customers moving forward. Do you have what IT takes?
Summary Statement:
Working with a diverse team, you will play an integral role in engineering and supporting our data integrations between business critical applications and systems, while mentoring other associate data engineers on data engineering best practices in an effort to deliver our next generation of innovative solutions to our customers.
What you will be doing:
As an Associate Data Engineer III, you will participate in all aspects of Data Engineering by supporting existing data integrations and data pipelines and troubleshooting issues as they occur while also building new data pipelines, data ingestions, data integrations, data storage, and traditional Data-warehouse/BI systems across small and medium sized projects concurrently. You will support our software developers, database architects, data analysts and data scientists on vital initiatives and ensure optimal data delivery architecture consistent throughout ongoing projects. You will have an opportunity to lead the design of certain components and suggest new frameworks and tools based on industry and technological trends and advances. You will also consult with process owners in reviewing, interpreting & developing systems in accordance with user requirements. Finally, you will get an opportunity to work with a diverse team and mentor junior associate data engineers.
Penske Responsibilities:
• Be the primary contact and lead support associate for multiple data pipelines and integrations.
• Play a critical role in supporting the data engineering lifecycle (design, develop, test, release and support) based on detailed requirements and guidance from senior data engineers/leads.
• Collaborate with technical/business leaders, product owners, software engineers, data architects and data analysts to understand requirements / acceptance criteria.
• Contribute and maintain optimal data pipeline architecture.
• Assemble large, complex data sets that meet functional / non-functional business requirements.
• Recommend, design, and implement internal process improvements: automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability, etc.
• Build and leverage the infrastructure required for optimal extraction, transformation, and loading of data from a wide variety of data sources both on premise and cloud.
• Partner with cross functional teams to build analytics tools that utilize the data pipeline to provide actionable insights into key business performance metrics.
• Participate in building data security and data governance guidelines.
• Ensure solution is sustainable across implementation and use; troubleshooting open issues and bug-fixes; and ensuring on-time delivery and hand-offs.
• Communicate status and issues to team members and stakeholders.
• Assign and review tasks from junior and offshore data engineers.
• Participate in conducting new hire interviews.
• Influence the discovery and decision-making process when changes to standards and technology are required (tools, conventions and design patterns)
• Provide support to the business by responding to user questions, concerns, and issues (for example, technical feasibility, implementation strategies)
Penske Qualifications:
• Bachelor’s Degree in Computer Science/Computer Engineering or equivalent years of software development experience required
• 7+ years of overall technology experience required
• 5+ years of Data Engineering, Data Modeling and Data Warehousing experience required
• Knowledge of full data engineering lifecycle
• Experience with Data Engineering tools such as Talend, BODS
• Experience with relational SQL and NoSQL databases
• Experience in building traditional Data warehouses and DataMarts
• Experience in building processes supporting data transformation, data structures, metadata, dependency and workload management
• Strong analytic skills related to working with complex datasets.
• Some experience with big data tools such as Kafka
• Some experience with visualization tools such as Qlikview, Qliksense, Tableau, etc.
• Knowledge of technical project management
• Knowledge of appropriate design frameworks and patterns and experience in implementing them.
• Knowledge of industry wide technology strategies and best practices.
• Understanding of message queuing, stream processing, and highly scalable ‘big data’ data stores
• Ability to troubleshoot and resolve issues
• Ability to research emerging data engineering frameworks and tools
• Ability to estimate medium to large sized projects.
• Excellent communication and interpersonal skills
Physical Requirements:
• The physical demands described here are representative of those that must be met by an associate to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
• The associate must regularly lift and /or move up to 25lbs/12kg.
• Specific vision abilities required by this job include Close vision, Distance vision, Peripheral vision, Depth perception and Ability to adjust focus.
• While performing the duties of this Job, the associate is regularly required to stand; walk; sit and talk or hear. The associate is frequently required to use hands to finger, handle, or feel and reach with hands and arms.
Penske is an Equal Opportunity Employer.
About Penske Truck Leasing/Transportation Solutions
Penske Truck Leasing/Transportation Solutions is a premier global transportation provider that delivers essential and innovative transportation, logistics and technology services to help companies and people move forward. With headquarters in Reading, PA, Penske and its associates are driven by a dedication to excellence and a commitment to customer success. Visit Go Penske to learn more.
Skills Required
- Bachelor's Degree in Computer Science/Computer Engineering or equivalent experience
- 7+ years of overall technology experience
- 5+ years of Data Engineering, Data Modeling and Data Warehousing experience
- Knowledge of full data engineering lifecycle
- Experience with Talend
- Experience with BODS
- Experience with relational SQL databases
- Experience with NoSQL databases
- Experience building traditional Data Warehouses and DataMarts
- Experience building processes supporting data transformation, metadata, dependency and workload management
- Strong analytic skills working with complex datasets
- Some experience with big data tools such as Kafka
- Some experience with visualization tools such as QlikView, QlikSense, Tableau
- Knowledge of technical project management
- Knowledge of appropriate design frameworks and patterns
- Understanding of message queuing, stream processing, and highly scalable big data stores
- Ability to troubleshoot and resolve issues
- Ability to research emerging data engineering frameworks and tools
- Ability to estimate medium to large sized projects
- Excellent communication and interpersonal skills
Am I A Good Fit?
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.
Success! Refresh the page to see how your skills align with this role.
The Company
What We Do
Penske Logistics is a Penske Transportation Solutions company. We provide supply chain management and logistics solutions to leading brands around the world. Penske Logistics delivers value through its design, planning and execution in transportation, warehousing, freight management, and dry-van truckload services. Penske offers customized supply chain and logistics solutions including: Dedicated Contract Carriage; Distribution Center Management; Freight Management; Freight Brokerage; Transportation Management Solutions (TMS); Lead Logistics Provider (LLP), Control Tower and 4PL Solutions. We serve a variety of industries including: automotive; food, beverage, grocery, wine and spirits; cold chain; convenience and drug stores; quick service restaurants (QSRs); retail; big box retailers; building and construction products; CPG; healthcare; industrial manufacturing; consumer appliances and consumer electronics; and many others.
