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