Senior Data Engineer — ETL, Data Lakes & Analytics

Oshkosh AeroTech, LLC; Frederick (MD); On-site; USD 83,000 - 134,000; Full time

Job summary

Oshkosh Corporation's Advanced Data Analytics team seeks a Data Analyst to develop and execute analytics strategy, applying ML to maintenance and intelligent control of vehicles. You will work with cross-functional teams to enable data-driven decisions across Oshkosh products.

The role involves designing scalable ETL, data governance, and collaboration across disciplines, using SQL, Bash, Python, and Hadoop ecosystems. Growth opportunities and impact across global platforms are offered.

Qualifications

• Bachelor's degree in computer science, data science or related field with 3+ years working as a data engineer/ETL developer/DBA
• Experience with big data tools and architectures such as Cloudera Hadoop, HDFS, Hive, Spark
• Working knowledge of telematics interfaces and streaming solutions (MQTT, NiFi, Kafka)
• Highly organized with strong analytical and problem-solving skills
• Ability to handle multiple tasks in a fast-paced environment
• Strong proficiency with SQL, Bash, and Python (and Anaconda)

Responsibilities

• Design and develop scalable ETL solutions to deliver data from source systems to analytics platforms (structured and unstructured; batch and streaming)
• Test and validate data transformations and data verification for enterprise analytics
• Assist data governance across data lake and enterprise data warehouse systems
• Assist with performance tuning data processes and troubleshoot data issues
• Collaborate across disciplines, departments and segments
• Develop rapid prototyping and design processes for fast solution delivery
• Maintain reference architecture and documentation for governance and roadmaps
• Educate others on best data practices (data modeling, ETL design, job scheduling)
• Assist or direct feasibility studies and project estimates on R&D projects

Skills

SQL

Bash

Python

ETL

Education

Bachelor's degree in computer science, data science or related field

Tools

Cloudera Hadoop

HDFS

Hive

Spark

Job description

Oshkosh Corporation's Advanced Data Analytics team seeks a Data Analyst to develop and execute analytics strategy, applying ML to maintenance and intelligent control of vehicles. You will work with cross-functional teams to enable data-driven decisions across Oshkosh products.

The role involves designing scalable ETL, data governance, and collaboration across disciplines, using SQL, Bash, Python, and Hadoop ecosystems. Growth opportunities and impact across global platforms are offered.