Operations Business Intelligence Analyst

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

This role serves as the operational analytics partner to the business, supporting data-driven decision-making across manufacturing and supply chain functions. The position is responsible for extracting, validating, analyzing, and interpreting data from ERP, MES, SQL databases, and other operational systems. Key areas of focus include inventory management, material planning, purchasing, BOM analysis, lead time tracking, cost analysis, and KPI reporting. The role works closely with leadership to transform complex data into actionable business insights and support continuous improvement initiatives. The ideal candidate possesses advanced Excel and SQL skills, strong analytical capabilities, intellectual curiosity, and the ability to independently solve complex problems.

Reports to: Vp Of Operations

Direct Reports: None

Responsibilities and Deliverables

• Develop and maintain operational dashboards, KPIs, and management reporting tools.
• Extract, analyze, validate, and interpret data from Epicor, Aegis, MiSys, SQL databases, and other systems.
• Drive insights and recommendations for inventory analysis, material planning, purchasing, and supply chain decision making.
• 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 Required

• Advanced Microsoft Excel skills.

Position: Operations Business Intelligence Analyst

• Advanced Power BI skills
• Strong SQL skills.
• Experience working with ERP systems and operational data.
• Experience building reports, dashboards, and management reporting tools.
• Strong analytical and problemsolving abilities.
• Excellent written and verbal communication skills.
• Ability to work independently and manage multiple priorities.

Other Requirements

• Required approx. 20% travel to supplier locations which include local, domestic and international location
• Work is sedentary in nature, but may require standing, walking, grasping, and lifting/moving up to 25 pounds

Education Required

• Bachelor's degree in Business, Finance, Analytics, Engineering, Supply Chain, Operations Management, Mathematics, Statistics, or related discipline.

Why Persimmon Technologies

At Persimmon Technologies, we prioritize our employees' well-being and growth. We offer competitive compensation packages including comprehensive health benefits (medical, dental and vision), generous paid

time off, 100% company paid short-term, long-term disability insurance, 100% company paid Basic life and

AD&D insurance and a 401(k) plan with 5% company matching. Our commitment to professional development ensures continuous learning and career advancement. Join us and experience a workplace that supports your success and well-being.

Compensation: The compensation range for this position is $95K to $110K per year. The actual pay offered will be determined by multiple factors, including but not limited to the candidate’s relevant experience, skills, job-related knowledge, internal equity, and geographical location.

This position is not eligible for employer-sponsored work authorization now or in the future. Applicants must be legally authorized to work in the United States without requiring current or future employer sponsorship.

Equal Employment Opportunity Statement

Persimmon Technologies is committed to providing equal employment opportunities to all employees and applicants without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability, genetic information, veteran status, or any other characteristic protected by law. Reach out to HR if you require assistance in completing the applications or attending interviews.