Data Engineer Sr

Oshkosh Corporation; Oshkosh (WI); On-site; USD 104,000 - 174,000; Full time

Job summary

Oshkosh Corporation is seeking a Data Engineer to join the Advanced Analytics team in Oshkosh, WI, focusing on CDC/ETL design and scalable data pipelines for analytics platforms.

You will collaborate with cross-functional teams to deliver data-driven insights for engineering and service data applications.

Qualifications

• Bachelor’s degree in computer science, data science or a related field with four (4) or more years of working as a data engineer, ETL developer and/or data warehouse DBA.
• 3-5 years of prior experience in a Data Engineering or Analytics organization in a technical role.
• 2+ years of software development experience (Python/Go preferred).
• 3+ years of major cloud provider experience (AWS/Azure/GCP).
• Strong proficiency with SQL, Bash, and Python (and experience with the Anaconda distribution).

Responsibilities

• Design and develop scalable Change Data Capture (CDC) and ETL solutions to deliver data from source systems to analytics platforms (structured and unstructured; batch and streaming).
• Use tools such as Terraform, Spark, Databricks, Snowflake, Git, and Azure infrastructure management (ADLS Gen2, Azure Compute, Azure Data Factory, AI Foundry, AKS, VPC’s, Storage Accounts, and others).
• 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.
• Follow the directors of the supervisory very efficiently and provide feedback on the technical hurdles and progresses with clarity and assess the priorities based on business needs.
• Complete the tasks under the guidance on mutually agreed schedule between the candidate and the supervisor/program manager with minimum mentoring.

Skills

Python/Go

SQL

Bash

Unix/Linux

Agile/Scrum

Cloud experience (AWS/Azure/GCP)

Spark

Databricks

Snowflake

ETL

Data governance

Kafka/NiFi

Education

Bachelor’s degree in CS/Data Science

Tools

Terraform

Spark

Databricks

Snowflake

Git

Azure Data Factory

Azure Synapse

ADLS Gen2

AKS

Job description

At Oshkosh, we build, serve and protect people and communities around the world by designing and manufacturing some of the toughest specialty trucks and access equipment. We employ over 18,000 team members all united by a common purpose. Our engineering and product innovation help keep soldiers and firefighters safe, is critical in building and keeping communities clean and helps people do their jobs every day.

As a key member in the Advanced Analytics team, the Data Engineer 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.

Your Impact

• Design and develop scalable Change Data Capture (CDC) and ETL solutions to deliver data from source systems to analytics platforms (structured and unstructured; batch and streaming).
• Use tools such as Terraform, Spark, Databricks, Snowflake, Git, and Azure infrastructure management (ADLS Gen2, Azure Compute, Azure Data Factory, AI Foundry, AKS, VPC’s, Storage Accounts, and others).
• 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.
• Follow the directors of the supervisory very efficiently and provide feedback on the technical hurdles and progresses with clarity and assess the priorities based on business needs.
• Complete the tasks under the guidance on mutually agreed schedule between the candidate and the supervisor/program manager with minimum mentoring.

Your Skills And Expertise

• Bachelor’s degree in computer science, data science or a related field with four (4) or more years of working as a data engineer, ETL developer and/or data warehouse DBA.
• 3-5 years of prior experience in a Data Engineering or Analytics organization in a technical role
• 2+ years of software development experience (Python/Go preferred).
• 3+ years of major cloud provider experience (AWS/Azure/GCP).
• Strong proficiency with SQL, Bash, and Python (and experience with the Anaconda distribution).

Standout Qualifications

• 2+ years experience operating in Unix/Linux and Windows server environments.
• 2+ years operating in an Agile / Scrum environment
• Experience with Cloud-based data services and solutions (Azure Synapse / Data Lake, AWS RedShift, Snowflake, GCP Big Query)
• Experience partnering with Analytics and Data Science teams in building out production grade GenAI/ML solutions.
• Familiarity with Change Data Capture solutions (Qlik Replicate, Striim, Debeezium, etc.).
• 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.

WHY OSHKOSH?

Moving the future forward is our priority and this includes your future. We encourage professional development and champion our employees’ success through various skills and training opportunities. Named one of the World’s Most Ethical Companies™ by Ethisphere Institute for six consecutive years, everything we do at Oshkosh is guided by our core values and the 15k+ team members around the world who embody them.

We put people first. We do the right thing. We persevere. We are better together.

Pay Range

$104,100.00 - $173,900.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 other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with Oshkosh Corporation's legal duty to furnish information.

Certain positions with Oshkosh Corporation require access to controlled goods and technologies subject to the International Traffic in Arms Regulations or the Export Administration Regulations. Applicants for these positions may need to be "U.S. Persons," as defined in these regulations. Generally, a "U.S. Person" is a U.S. citizen, lawful permanent resident, or an individual who has been admitted as a refugee or granted asylum.