Vacancy expired!
Technical Experience:
5 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/SOAPweb services, Microsoft Office. Technical Experience with Oracle Database, Agile PLM for Process Applications, Infinity QualitySystems, and Oracle Integration Cloud a plus. Working experience with IoT software packages, device connectivity, and real-time dataacquisition also a plus. Expert in performance tuning of ETL/ELT/SQL code. Familiarity with predictive analysis/machine learning usingrelevant tools and coding languages (e.g. R, Python, and Apache Spark, Azure ML). Preference for experience in one or moreemerging 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 also a plus. Must have an understanding of the systemdevelopment life cycle; software project management approaches; and requirements, design, test, and implementation techniques.Ability to follow best coding standards practices.
Industry Experience
: Preference for manufacturing or food processing organization.
Minimum Education
:
Bachelor's degree in computer science, or 5 years business experience using and developing softwareapplications
ESSENTIAL POSITION RESPONSIBILITIES:
Organizes data both at the macro level (i.e. which subject areas are managed in which sources) and at the micro level (i.e. datamodels, 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 leveragingimplementation 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 managedata, sets standards for data management, analyzes current state and conceives desired future state, and conceives projects neededto close the gap between current state and future goals. Conceptualizes and influences application and interface projects, providingadvice and assistance toward desirable outcomes. Works with analysts to gather requirements and translate them into data architecttasks.
Maintains purchased applications.
Maintains, implements, upgrades and supports existing applications that are purchased bySimmons Information Services. Builds and performs training and documentation for these applications. Participates in migrations andleads the migration activity to be successful from Legacy systems.
Troubleshoots issues: Quickly recognizes issues and performs the steps needed to resolve the issue as quickly and effectively aspossible. Includes other team members depending on the magnitude of the issue. Participates in After Action Review with IS team todocument 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 thatany work done, whether development or issue resolution, will be thoroughly tested outside of the production environment before beingimplemented into the production environment.
Provides user support: Provides functional, training and highly technical know how user support as needed.
Participates as a member of the Team: Participates in the ongoing development, communication and implementation of teamconcepts, programs and policies; coordinates work to ensure best practices with all team members. Attends appropriate teammeetings. As a member of the Team, fosters strong cohesiveness regarding all major issues; e.g., direction, annual plan, budget, policychanges, etc. Accepts responsibility to quickly identify any areas that lack cohesiveness, bringing them to the attention of the teamleader and working with the team in a supportive manner to resolve issues and actively look for ways, and reinforce actions needed, toachieve synergy possible within the larger organization.
Physical Activities: Enters and locates information on a computer. Visually verifies information, often in small print. Communicateswith Customers, Vendors, or Employees via telephone, in person, and/or electronic mail. May present information to small or largegroups. Move about in an office environment and surrounding property daily. Move about in a manufacturing environment andsurrounding 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.
