Data Management Specialist

Position Title: Data Management Specialist
Work Schedule: Monday – Friday, 8:00 AM – 5:00 PM

Position Summary

We are seeking a detail-oriented Data Management Specialist with advanced Microsoft Excel skills to support the accurate, timely, and secure management of operational, customer, inventory, quality, and financial data.

This position is responsible for entering, validating, organizing, analyzing, and reporting data while maintaining high standards for accuracy, quality, continuous improvement, and customer service.

The ideal candidate will have significant hands-on experience with Microsoft Excel, strong analytical and problem-solving skills, and the ability to manage large datasets in a fast-paced business environment.

Key Responsibilities

Data Entry & Management

• Accurately enter, update, and maintain data in ERP systems, databases, spreadsheets, and other business applications.

• Maintain organized electronic records in accordance with departmental procedures and company retention requirements.

• Support data-entry activities related to inventory, production, purchasing, quality, shipping, customer service, and finance.

• Protect confidential employee, customer, supplier, and business information.

Advanced Excel & Reporting

• Utilize advanced Microsoft Excel functions to organize, analyze, reconcile, and report data.

• Work extensively with formulas, pivot tables, lookups, conditional formatting, charts, and data validation.

• Create, maintain, and update standardized Excel trackers, templates, and reports for operational teams.

• Sort, filter, and reconcile large datasets to ensure accuracy and consistency.

Data Accuracy & Quality Control

• Identify data discrepancies, investigate root causes, and coordinate corrections with appropriate internal stakeholders.

• Perform routine audits of data files and reports to ensure accuracy and compliance with internal procedures.

• Maintain accurate documentation and support data integrity across multiple systems.

Process Improvement & Collaboration

• Identify opportunities to reduce manual processes, improve data quality, and streamline reporting.

• Assist with continuous improvement initiatives related to data management and reporting.

• Collaborate with cross-functional teams to resolve data issues and support operational needs.

• Perform additional duties as assigned.

Required Qualifications

Education & Experience

• High school diploma or equivalent required; associate degree or relevant technical training preferred.

• Minimum of 3 years of experience in data entry, administrative support, operations support, or a related field.

• Significant hands-on experience using Microsoft Excel in a professional environment.

• Strong attention to detail and demonstrated ability to maintain high levels of data accuracy.

Advanced Microsoft Excel Skills

Candidates must demonstrate proficiency with:

• Pivot tables and pivot charts

• XLOOKUP and VLOOKUP

• INDEX/MATCH and IF statements

• Data validation and conditional formatting

• Sorting, filtering, and reconciling large datasets

• Text, date, and mathematical formulas

• Spreadsheet protection and template development

• Data analysis and reporting

Technical & Professional Skills

• Experience with ERP, MRP, CRM, or inventory management systems preferred.

• Proficiency with Microsoft Outlook, Word, and Teams.

• Strong organizational and time-management skills.

• Ability to prioritize multiple assignments and meet deadlines.

• Ability to work independently in a fast-paced environment.

• Strong written and verbal communication skills.

• Excellent analytical and problem-solving abilities.

Preferred Qualifications

• Experience supporting manufacturing, supply chain, distribution, quality, or industrial operations.

• Familiarity with SAP, Oracle, Microsoft Dynamics, or similar ERP platforms.

• Experience using Power Query, Power Pivot, or basic Excel macros/VBA.

• Knowledge of document control, quality systems, or ISO-related recordkeeping practices.