Operations BI Analyst: Power BI, SQL & Inventory Insights

Persimmon Technologies Corporation; Bedford (MA); On-site; USD 95,000 - 110,000; Full time

Job summary

Persimmon Technologies is seeking an Operations Business Intelligence Analyst to serve as the operational analytics partner, extracting and interpreting data from ERP, MES, and SQL databases to support data-driven decisions across manufacturing and supply chain.

The role requires advanced Excel and SQL skills, Power BI expertise, and the ability to independently solve complex problems while delivering dashboards, reports, and insights to leadership.

Qualifications

• Bachelor's degree in Business, Finance, Analytics, Engineering, Supply Chain, Operations Management, Mathematics or related discipline.
• Advanced Microsoft Excel and SQL skills.
• Experience with ERP/operational data.
• Ability to work independently and manage multiple priorities.

Responsibilities

• Develop and maintain operational dashboards, KPIs, and management reporting tools.
• Extract, analyze, validate, and interpret data from ERP, MES, SQL databases, and other systems.
• Drive insights and recommendations for inventory analysis, material planning, purchasing, and supply chain decisions.
• Analyze inventory shortages, excess inventory, supplier performance, lead times, and manufacturing performance.
• Perform BOM comparisons, cost analysis, product costing reviews, and material usage reporting.
• Create recurring and ad hoc reports for Operations and Executive Leadership.
• Identify trends, anomalies, risks, and opportunities through data analysis.
• Support process improvement initiatives through data-driven recommendations.
• Improve reporting efficiency through automation and streamlined reporting processes.
• Ensure reporting accuracy and data integrity across systems.
• Partner with Operations, Manufacturing Engineering, Supply Chain, Purchasing, Finance, and Leadership teams.

Skills

Excel

Power BI

SQL

Analytical thinking

Communication

Problem solving

Independent work

Education

Bachelor's degree in related field

Tools

Epicor

Aegis

MiSys

SQL databases

Job description

Persimmon Technologies is seeking an Operations Business Intelligence Analyst to serve as the operational analytics partner, extracting and interpreting data from ERP, MES, and SQL databases to support data-driven decisions across manufacturing and supply chain.

The role requires advanced Excel and SQL skills, Power BI expertise, and the ability to independently solve complex problems while delivering dashboards, reports, and insights to leadership.