What are the responsibilities and job description for the Business Intelligence and Analytics Coordinator position at Red Star?
Red Star Contract Manufacturing, Inc. seeks a Business Intelligence and Analytics Coordinator to lead the integration, optimization, and continuous improvement of the company's ERP system across manufacturing operations. Drive process automation, ensure data integrity, and deliver actionable insights to enhance decision-making at all organizational levels. Coordinate ERP implementation, integration, and functionality, reporting system automation, and reduction of manual processes. Develop and enforce data governance strategy, ensuring accurate forecasting of production capacity, labor efficiency, and inventory requirements. Design, automate, and maintain advanced reporting frameworks that reduce manual processes and increase data transparency. Provide strategic data-driven insights and recommendations to support organizational decision-making. Partner with cross-functional teams to enhance data accuracy and workflow efficiency. Deploy and manage dashboards, KPI scorecards, and analytics platforms to monitor operational performance. Build cost and profitability models for product, customer, and business units, including activity-based costing and COGS tracking to forecast production capacity, labor needs, and inventory requirements. Ensure compliance with internal controls, audit requirements, and regulatory requirements. #LI-DNI
Position requires a Bachelor's degree in Data Analytics, Industrial Engineering, Information Systems, or a related field, followed by 5 years of progressively responsible experience in production planning, manufacturing operations, or logistics in the medical device or a related pharmaceutical or biotechnology industry. Experience must include a minimum of: 5 years of experience implementing and optimizing ERP systems across multiple business units; 5 years of experience in data analysis and reporting; 5 years of experience working with business intelligence and data analysis software, including Power Query, and interpreting complex data; 5 years of experience preparing board-level executive materials and strategic recommendations based on complex data models; 5 years of experience with Microsoft Excel, including advanced formulas, pivot tables, and macros; and experience with data analysis tools, including SQL-based reporting. #LI-DNI
Job Location: Larwill, IN. To apply, please visit https://redstarcontractmfg.aaimtrack.com/jobs/ and search by job title. Alternatively, please send your resume, cover letter, and a copy of the ad to: S. Smiley, 1560 N. State Rd 5, Larwill, IN 46764.