Senior Data Engineer - OT (Finance)

Purpose of the Position

Advance Simmons Foods Business Intelligence capabilities, serving as a key player in driving business value through data integration company-wide.

Essential Position Responsibilities - This is a Salary Exempt position.

Organizes data both at the macro level (i.e. which subject areas are managed in which sources) and at the micro level (i.e. data models, for a new application). Provides a logical data model as a standard for the source and for consuming applications to inherit, with elements and business rules needed for the creation of data quality rules. Delivers multiple data integration projects by leveraging implementation experience, technological know-how and expertise in related best practices.

Maps data warehouse and ETL (Extracted/Transformed/Loaded) / ELT (Extracted/Loaded/Transformed) designs used to manage data, sets standards for data management, analyzes current state and conceives desired future state, and conceives projects needed to close the gap between current state and future goals. Conceptualizes and influences application and interface projects, providing advice and assistance toward desirable outcomes. Works with analysts to gather requirements and translate them into data architect tasks.

Maintains purchased applications. Maintains, implements, upgrades and supports existing applications that are purchased by Simmons Information Services. Builds and performs training and documentation for these applications. Participates in migrations and leads the migration activity to be successful from Legacy systems.

Troubleshooting issues . Quickly recognizes issues and performs the steps needed to resolve the issue as quickly and effectively as possible. Includes other team members depending on the magnitude of the issue. Participates in After Action Review with the IS team to document resolution and what was learned for future reference.

Gives recommendations and feedback to the Application Manager and helps facilitate the growth of the overall team. Validates that any work done, whether development or issue resolution, will be thoroughly tested outside of the production environment before being implemented into the production environment.

Provides user support. Provides functional, training and highly technical knowhow user support as needed.

Participates as a member of the Team. Participates in the ongoing development, communication and implementation of team concepts, programs and policies; coordinates work to ensure best practices with all team members. Attends appropriate team meetings. As a member of the Team, fosters strong cohesiveness regarding all major issues; e.g., direction, annual plan, budget, policy changes, etc. Accepts responsibility to quickly identify any areas that lack cohesiveness, bringing them to the attention of the team leader and working with the team in a supportive manner to resolve issues and actively look for ways, and reinforce actions needed, to achieve synergy possible within the larger organization.

Simmons Operating systems principles and objectives : Is familiar with Simmons' established operating systems (e.g. quality, security, office environment, company policies, LEAN); understands the responsibility to maintain familiarity with the systems and this position's role in support of these systems - including a consideration of the impact of individual actions on the systems and the responsibility to communicate concerns and improvement ideas.

Performs other duties as necessary in support of business objectives : This position description is intended to guide the activities of the person in this position and is not intended to limit the thinking and creativity of the person as to the work of this function nor is it intended that this describe all the work that may be required of the person in this position.

Physical Activities : Enters and locates information on a computer. Visually verifies information, often in small print. Communicates with Customers, Vendors, or Employees via telephone, in person, and/or electronic mail. May present information to small or large groups. Move about in an office environment and surrounding property daily. Move about in a manufacturing environment and surrounding property occasionally. May travel via car or plane to various work locations.

Personal Protective Equipment (PPE) : As required by the visiting facility.

Travel : One to two offsite classes per year. Travels to Simmons facilities as needed.

Technical Experience : 10 years applicable functional and technical application and data management experience, including a minimum of 5 years of experience with dimensional data modeling & schema design in Data Warehouses, 2+ years of experience in custom or structured ETL/ELT design, implementation and maintenance. Computer skills required: database management solutions such as Oracle SQL Developer or Microsoft SQL Server Management Studio, SQL, PL/SQL, development and integration with REST/SOAP web services, Microsoft Office. Technical Experience with Oracle Database, Agile PLM for Process Applications, Infinity Quality Systems, and Oracle Integration Cloud a plus. Working experience with IoT software packages, device connectivity, and real-time data acquisition is also a plus. Expert in performance tuning of ETL/ELT/SQL code. Familiarity with predictive analysis/ machine learning using relevant tools and coding languages (e.g. R, Python, and Apache Spark, Azure ML). Preference for experience in one or more emerging big data technologies such as Hadoop, Cassandra, MongoDB and associated data integration tools like Kafka and Nifi. Experience with data visualization platforms like Microsoft Power BI or Tableau is also a plus. Must have an understanding of the system development life cycle; software project management approaches; and requirements, design, test, and implementation techniques. Ability to follow best coding standards practices.

Strongly Preferred requirements:

• Ignition Experience (SCADA Platform) - Data connectivity, acquisition and visualization (Rockwell Factory Talk and Wonderware acceptable as SCADA but Ignition preferred)
• Experience working with database platforms and building data pipelines
• Knowledge of how to build and consume APIs
• Controls Experience
• OT Networking

Industry Experience : Preference for manufacturing or food processing organization.

Minimum Education : Bachelor's degree in computer science, or 10 years business experience using and developing software applications and developing technical applications.

Preferred Education : N/A