Entry Level Excel Data Analyst Jobs in Ohio (NOW HIRING)

I. Job ProfileJob TitleManufacturing Data AnalystDepartmentARG AssemblyDirect SupervisorLead SupervisorDirect SubordinatesNoneII. Job Summary：
  1. Verify data in Plex, in charge of correcting and standardizing the Plex operation and provide training to guarantee the accuracy of the system.
 2. Collect, analyze, track and supervise the implementation of important data of the department, such as KPI data, weekly reports, monthly reports, handling of overdue inventory, writing of work instructions, etc. III. Job Functions and Duties NO.Representative Duties1Collect, clean, and organize large datasets from multiple systems, including ERP (Enterprise Resource Planning), MES (Manufacturing Execution System), sensor networks, and inventory platforms such as Plex.2Perform quantitative analysis and build predictive models to uncover trends in production efficiency, material usage, and quality deviations.3Generate automated reports and interactive dashboards for cross-functional teams (manufacturing, quality, supply chain, finance), highlighting key performance indicators (KPIs) such as yield, OEE (Overall Equipment Effectiveness), and scrap rates.4Conduct root cause analysis on production inefficiencies and quality issues; provide actionable insights that support process improvement and cost reduction initiatives.5Utilize statistical software for hypothesis testing, regression analysis, and variance analysis in support of operational decision-making.6Apply financial and operational modeling techniques to optimize production scheduling, reduce inventory holding costs, and improve ROI on capital equipment.7Develop and maintain data pipelines and analytical frameworks that ensure data accuracy, integrity, and scalability.8Collaborate with production teams and train operators and engineers on data collection methods, dashboard interpretation, and continuous improvement practices.10Apply financial modeling techniques to evaluate ROI on capital equipment investments and analyze trade-offs in production scheduling, labor allocation, and raw material purchasing strategies.11Build operational and financial forecasting models integrating manufacturing KPIs with budgeting and cash flow planning, directly supporting monthly variance analysis and strategic decision-making. Ensure accurate barcode-based packing and inventory tracking, integrating logistics data with financial reconciliation systems to support timely and accurate cost-of-goods-sold (COGS) reporting.12Support and hoc financial analysis, including cost-benefit analyses for new process implementations and budgeting impact projections for new production lines.13Nothing in the Position Description restricts management's right to assign or re-assign duties and responsibilities to this job at any time.IⅤ. QualificationJob RequirementsLanguageLanguages spoken commonly in the workplace are English and/or Mandarin. - Ability to read, understand and comprehend documents such as safety rules, operating and maintenance instructions. Ability to interpret a variety of instructions furnished in written, oral, diagram, or schedule form.
 Ability to speak effectively and interact with other team members, engineers, leadership and customers.
English-Chinese (Preferred)ExperienceMore than one year working experienceEducationBachelor's degree and abovePhysical ConditionThe employee is regularly required to be in good health, available to work long time with computer, and bear high stressOther RequirementsMATHEMATICAL SKILLS -
 Ability to add, subtract, multiply, and divide into all units of measure, using whole numbers, common fractions, and decimals.
 REASONING ABILITY - Ability to solve practical problems and deal with a variety of variables.
 COMPUTER SKILLS - Knowledge of and familiarity manufacturing software.Knowledge, Skills & Abilities utilized on the jobProfessional Knowledge, SkillsFamiliar with company's production process and Plex operationFamiliar with EXCEL and other office software, need strong data analysis abilityGood logic ability, strong data analysis abilityFamiliar with supply chain managementTraining RequiredPRP operationPRP managementManagement method for material planningOperation training for supply chain management and logistics managementProgram manualV. Work Environment:
 While performing the duties of this job, the employee is occasionally exposed to extreme heat. The noise level in the work environment is usually moderate. Safety requirements for this position are safety glasses, steel-toed work boots and reflective vests.VI. Key Performance Indicators:
 On time shipments-OEM/On time shipments_ARG/Improvement project earnings_1K/Days of Inventory WIP/Days of Inventory FG(OEM)/Hourly employee OT hours_Hr/Month/FBT/GT production batch