Manufacturing BI Analyst — Power BI & Insights

ADP, Inc.; Tracy (CA); On-site; USD 75,000 - 90,000; Full time

Job summary

American Custom Meats seeks a Business Intelligence Analyst to develop and improve BI, analytics, and reporting tools across the organization. You will transform data from operational and business systems into insights supporting leadership decisions, manufacturing performance, pricing, profitability, and continuous improvement.

The role requires 3+ years in data analytics and strong Power BI skills. You will work across departments to enhance reporting and data accessibility, with exposure to

Qualifications

• 3+ years of experience in data analytics, business intelligence, financial analysis, manufacturing analytics, or a related field.
• Strong proficiency in Microsoft Power BI, including dashboard development and data modeling.
• Advanced Microsoft Excel skills, including PivotTables, complex formulas, data analysis, and financial modeling.
• Experience extracting, combining, and validating data from ERP or other business systems.

Responsibilities

• Design, develop, and maintain Power BI dashboards, reports, and data models.
• Analyze and validate data from Canopy ERP, Redzone, and other business systems.
• Develop reporting for production volume, throughput, labor utilization, downtime, yield, inventory, OTIF, manufacturing costs, and profitability.
• Establish consistent KPIs and identify and resolve data integrity issues.
• Develop and maintain pricing, costing, and margin-analysis tools.
• Provide analytical support and recommendations related to pricing, product profitability, and business opportunities.
• Analyze manufacturing performance and identify trends and opportunities for improvement.
• Support and administer the Redzone productivity platform and serve as a primary contact with the vendor.
• Train and support managers and other users on Power BI, Redzone, dashboards, and analytical tools.
• Partner with Operations, Sales, Finance, Supply Chain, FSQA, Technical Services, and other teams to improve reporting and data accessibility.

Skills

Power BI

Excel

Data analysis

ERP data extraction

Tools

SQL

Power Query

Redzone

Job description

American Custom Meats seeks a Business Intelligence Analyst to develop and improve BI, analytics, and reporting tools across the organization. You will transform data from operational and business systems into insights supporting leadership decisions, manufacturing performance, pricing, profitability, and continuous improvement.

The role requires 3+ years in data analytics and strong Power BI skills. You will work across departments to enhance reporting and data accessibility, with exposure to