DATA ENGINEER

We have an immediate opening for the position Data Engineer in Overland Park, Kansas. We are accepting applications for candidates in Overland Park, Kansas or St. Louis, Missouri area.

Position Description:

The suitable candidate will function as the lead in projects related to all aspects of collecting and preparing data for analytical or operational uses. The Data Engineer responsibilities include building data pipelines to pull together information from different source systems; integrating, consolidating and cleansing data; and structuring it for use in individual analytics applications as well as assisting with the overall data architecture. The candidate will work with domain experts, data scientists, analyst and engineers who are analyzing and visualizing the data to drive efficiencies and business decisions.

Position Responsibilities:

• The Data Engineer will have exposure to all business units, plants, processes, and products in order to work with data scientists, business analyst and other analytics community members.
• Supporting and providing data in a ready-to-use form to data scientists who are looking to run queries and algorithms against the information for predictive analytics, machine learning and data mining purposes.
• Develops, constructs, tests, and maintains architectures such as databases and large scale processing systems. Responsible for compiling and installing database systems, writing complex queries, scaling to multiple machines, DB administration, and putting disaster recovery systems into place.
• The ability to build a robust, fault-tolerant data pipeline that cleans, transforms, and aggregates unorganized and messy data into databases or data sources.
• Work with business units and departments to deliver data aggregations to executives, business analysts and other end users for more basic types of analysis to aid in ongoing operations.
• Recommending new data streams and ensuring data integrity
• Wrestle with problems associated with database integration and messy, unstructured data sets. Their ultimate aim is to provide clean, usable data to whomever may require it.
• Identifying new projects and opportunities, and the associated data requirements

Professional skills:

• Microsoft SQL Server Database management and query language.
• Data Modeling including management of both structured and unstructured data sets – must be versed in different approaches to data architecture and applications including traditional Data warehousing concepts and Data Lakes.
• Skilled in extract, transform and load tools (Data Services, Informatica, or SSIS) and REST- oriented APIs for creating and managing data integration jobs, and providing data analysts and business users with simplified access to prepared data sets.
• Practical understanding of statistics, predictive analytics, machine learning, and artificial intelligence algorithms concepts which may include C#, Java, Python, Ruby, Scala and SQL.
• Ability to understand a variety of applications and domains (embedded sensors, plant processes, shop floor, ERP,etc.)
• Excellent written and verbal communication skils
• Must be able to work with all relevant technical and non-technical parties to ensure that quality results are obtained.

Position Requirements:

• B.S in Computer Science, Engineering or related disciplines with experience in data engineer and database administration.
• Willingness to travel as much as 30% of the time.
• Desire to work in a dynamic environment and have a continuous improvement and development mindset

Through competitive wages, outstanding benefits, and internal advancement opportunities, you will have the chance to create a career of which you can be proud. If you are open to relocation, there are also vast advancement opportunities within the Amsted Corporation.

We offer a full range of benefits including medical, dental, vision, 401(k) with employer matching and an Employee Stock Ownership Plan. We are 100% employee owned.

All interested applicants please apply online at www.amstedrail.com.