Data Engineer

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

About JLG, an Oshkosh company

JLG began in 1969, when our founder, John L. Grove set out to resolve growing safety concerns in the construction industry. Since then we have been committed to understanding the challenges and delivering innovative solutions to the access market. We partner with customers to provide quality equipment, training opportunities and trusted support within the access industry. We are a global company, and our products-including mobile elevating work platforms, telehandlers, utility vehicles and accessories-can be found all over the world.

JOB SUMMARY

As a key member in the Advanced Data Analytics team, the Data Analyst will work with this and a cross-functional team to develop and execute the data analytics strategy and apply to Oshkosh Corporation products. Advanced Data Analytics wok encompasses the acquisition, processing and machine learning of engineering or service data and application to preventive maintenance and intelligent control of on or off-road vehicles.

ESSENTIAL DUTIES AND RESPONSIBILITIES

These duties are not meant to be all-inclusive and other duties may be assigned.

• Design and develop scalable ETL solutions to deliver data from source systems to analytics platforms (structured and unstructured; bath and streaming).
• Responsible for testing and validation in order to support the accuracy of data transformations and data verification used with enterprise-wide analytics.
• Assist in ensuring proper data governance (quality security, etc. within the data lake and enterprise data warehouse systems across all business segments).
• Assist with performance-tuning data processes as well as troubleshooting data processing issues.
• Collaborate, coordinate, and communicate across disciplines, departments and segments.
• Develop rapid prototyping and design processes for fast solution delivery to the business.
• Maintain reference architecture and documentation for the purposes of architectural governance and application roadmap.
• Assist in education others on best practices surrounding data work (i.e. data modeling, database design, ETL design, job scheduling and monitoring, etc.).
• Assist or direct feasibility studies and project estimates (manpower, budget development, and timelines, etc.) on proposed research and development projects.

MINIMUM QUALIFICATIONS

• Bachelor's degree in computer science, data science or a related field with three (3) or more years of working as a data engineer, ETL developer and/or data warehouse DBA.

PREFERRED QUALIFICATIONS

• Experience with big data tools and architectures, such as Cloudera Hadoop, HDFS, Hive, and Spark.
• Working knowledge of telematics interfaces and streaming solutions (MQTT, NiFi, Kafka, etc.).
• Automotive or heavy duty on or off-road vehicle, digital data bus, including Ethernet or Controller Area Network (CAN) experience.
• Highly organized and detail-oriented, with strong critical thinking, analytical, and problem-solving skills.
• Ability to handle multiple tasks in a fast-paced environment, both independently and as part of a team.
• Display excellent interpersonal skills as well as the ability to effectively present information and respond to question from leadership and peers.
• Strong proficiency with SQL, Bash, and Python (and experience with the Anaconda distribution).

Pay Range

$82,900.00 - $134,300.00

The above pay range reflects the minimum and maximum target pay for the position across all U.S. locations. Within this range, individual pay is determined by various factors, including the scope and responsibilities of the role, the candidate's experience, education and skills, as well as the equity of pay among team members in similar positions. Beyond offering a competitive total rewards package, we prioritize a people-first culture and offer various opportunities to support team member growth and success.

Oshkosh is committed to working with and offering reasonable accommodation to job applicants with disabilities. If you need assistance or an accommodation due to disability for any part of the employment process, please contact us at [e-mail].

Oshkosh Corporation is a merit-based Equal Opportunity Employer. Job opportunities are open for application to all qualified individuals and selection decisions are made without regard to race, color, religion, sex, national origin, age, disability, veteran status, or other protected characteristic. To the extent that information is provided or collected regarding categories as provided by law it will in no way affect the decision regarding an employment application.

Oshkosh Corporation will not discharge or in any manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of o