Job Description: Operations Data Analyst

Position Description

The Operations Data Analyst will work with large data sets related to customer orders, warehouse work orders and other transactional data required to support the Warehouse Operations team. The Operations Data Analyst must have intermediate to advanced Microsoft Excel skills, great attention to detail, independent drive to adhere to organizational data quality standards and the ability to think critically to solve business problems with data analysis. The Operations Data Analyst will work with an experienced Data Analyst and will support the Chief Development Officer, Chief Operating Officer and VP of Operations.

Responsibilities

Data Intake - adding customer and order data to the information repository
Data Validation - Reviewing all incoming data, scrubbing duplicates or invalid values, flagging and reporting any data issues prior to data storage
Data Transformation - Initially, leveraging pre-built data models and data transformation tools (such as Excel Power Query and Data Modeling Tools), to generate reports for the Operations team and to generate import files for the Warehouse Management System. Over time, the analyst should gain the skills to independently create new data models
Process and Training - Creating and maintaining standard operating procedures and training materials related to data processing
Continuous Improvement - always looking for ways to improve data quality and operational efficiency

Required Skills, Experience And Education

Intermediate to Advanced Excel with strong understanding of how to apply formulas such as XLOOKUP and when to use Data Modeling tools and Macros
Associate's in Information Systems, Computer Science or Business Administration

Preferred Skills

Operations background
Experience with Database Management Systems, Data Warehousing and Business Intelligence tools
Experience with NetSuite WMS
Experience with various CRM systems
Experience with ETL tools
Experience using Python and SQL
Experience with various CRM systems

Location: Onsite - Lebanon, TN

Schedule: Full Time (40 hours per week) - Monday - Friday 8:00 AM - 5:00 PM

Compensation: $65,000 - $75,000/year depending on experience.

Benefits: Paid Time Off, Health Insurance and 401(k) matching

FSI, Inc. jobs

Operations Data Analyst