Overview
Job Description
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.
Automate your job search with Sonara.
Submit 10x as many applications with less effort than one manual application.
