Data Engineer - Iot/OT (Finance)

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

- 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. Performs migration of legacy applications to current applications.

Troubleshoots. Quickly recognizes issues and performs the steps needed to solve 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 IT 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 Application Developers. Validates any work done, whether development or issue resolution will be thoroughly tested outside of the production environment before implementing into the production environment.

Provides support. Provides functional and highly technical user support where 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. Must be able to work in various temperatures. Move about in a manufacturing environment and surrounding property; often to collect data from sensors. May travel via car or plane to various work locations.

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

Travel: One to two offsite classes per year. Travel to Simmons facilities depending on focus.

Technical Experience: 5 years applicable functional and technical Applications experience, including a minimum of 2+ 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: ODI (Oracle Data Integrator), Oracle Data Warehouse, Oracle Database, Universal Table Browser (UTB), Business Function Design, Object Management Workbench (OMW), SQL, PL/SQL, Microsoft Office. OBIEE experience is a plus. Must have a basic understanding of the system development life cycle; software project management approaches; and requirements, design, and test techniques. Ability to follow best coding standards practices. Expert in performance tuning of ETL/ELT/SQL code.

Industry Experience: Preference for food processing organization.

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

We value military experience and welcome veterans to join our team.