> Markdown version of [/jobs/ext/2592906-data-analyst](https://www.wearedevelopers.com/jobs/ext/2592906-data-analyst). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Data Analyst - **Company:** SPECIALIZED STAFFING - **Location:** Aurora, OH, United States - **Salary:** $45,760.0 - $52,000.0 - **Contract:** Permanent contract - **Skills:** Microsoft Excel, Data Cleansing, Transaction Data, Microsoft Business Central, Data Management - **Published:** August 11, 2026 - **Apply:** https://www.indeed.com/viewjob?jk=235718f6bcb6d041 ## About the Role We are seeking a detail-oriented Data Analyst to support purchasing and supply chain operations through data cleanup, validation, analysis, and system maintenance. This role will use Microsoft Dynamics 365 Business Central and Excel to improve purchasing data accuracy, maintain supplier and item information, and investigate the root causes of material shortages., * Proficiency in Microsoft Excel. * Working knowledge of ERP systems. * Strong analytical and problem-solving skills. * Excellent attention to detail and data accuracy. * Ability to analyze transactional data and identify trends, discrepancies, and root causes. * Strong organizational and communication skills. Preferred Qualifications * Previous experience using Microsoft Dynamics 365 Business Central. * Previous experience in a supply chain function, such as planning, scheduling, purchasing, materials management, or inventory control. * Experience analyzing purchasing, inventory, supplier, or demand data. * Experience maintaining purchase orders, item master data, or supplier records. ## Description * Clean up and maintain purchasing records in Microsoft Dynamics 365 Business Central. * Analyze internal purchase orders and reschedule or cancel them based on current requirements. * Add and maintain supplier promise dates for external purchase orders. * Validate open-order details, including purchase order numbers, quantities, pricing, dates, and order status. * Update item cards with vendor information, ordering parameters, and order modifiers. * Analyze reported material and inventory shortages. * Conduct root cause analysis using system transactions, demand changes, purchasing history, and supplier performance. * Identify shortages caused by supplier misses, changes in demand, inaccurate system data, or transaction issues. * Prepare reports and communicate findings, discrepancies, and recommended corrective actions to relevant stakeholders. * Support continuous improvement initiatives related to data quality, purchasing processes, and supply chain visibility. ## Related Videos - [It's all about the Data](https://www.wearedevelopers.com/videos/425-it-s-all-about-the-data) - [In-depth .NET Azure Functions: Isolated mode, performance and durable AI agents](https://www.wearedevelopers.com/videos/100207-in-depth-net-azure-functions-isolated-mode-performance-and-durable-ai-agents) - [RPA in the Public Sector](https://www.wearedevelopers.com/videos/86-rpa-in-the-public-sector) - [Empowering Retail Through Applied Machine Learning](https://www.wearedevelopers.com/videos/976-empowering-retail-through-applied-machine-learning) - [Anomaly Detection - Using unsupervised Machine Learning for detecting anomalies in customer base](https://www.wearedevelopers.com/videos/6-anomaly-detection-using-unsupervised-machine-learning-for-detecting-anomalies-in-customer-base) - [From Global Capability Centers to AI-Powered Command Centers](https://www.wearedevelopers.com/videos/100096-from-global-capability-centers-to-ai-powered-command-centers) ## Related Articles - [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk) - [Data Analyst Salary Germany](https://www.wearedevelopers.com/magazine/277-data-analyst-salary-germany) - [Data Analyst Salary Austria](https://www.wearedevelopers.com/magazine/275-data-analyst-salary-austria) - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [What Are The Top Skills Required For Azure Developers?](https://www.wearedevelopers.com/magazine/77-what-are-the-top-skills-required-for-azure-developers) - [Data Analyst Salary in Switzerland](https://www.wearedevelopers.com/magazine/276-data-analyst-salary-in-switzerland)