Sr. Executive, Production Program and Analytics

Job Context

We are seeking a detail-oriented Sr. Executive, Production Program and Analytics to transform production and operational data into actionable insights and Business Intelligence (BI) dashboards. The role involves managing project management systems, software workflows, and Google Sheets-based data backends, developing and maintaining Looker Studio dashboards, monitoring KPIs, and providing analytical support for production planning, sourcing, material management, and overall supply chain operations.

Key Responsibilities

• Develop, maintain, and optimize Google Sheets-based data systems, backend structures, and reporting workflows.

• Consolidate data from production, sourcing, procurement, material planning, inventory, and other operational departments.

• Ensure data accuracy, consistency, completeness, and timely updates through standardized structures, formulas, and validation rules.

• Identify data gaps, inconsistencies, and duplicate records, coordinating with relevant teams to resolve them.

• Design and maintain Looker Studio (Data Studio) dashboards for management and operational teams.

• Translate business requirements into meaningful dashboards, reports, KPIs, and data visualizations.

• Develop dashboards covering production schedules, material sourcing, delivery performance, production progress, consumption, and inventory.

• Automate dashboard updates, minimize manual intervention, and continuously improve reporting accuracy, usability, and performance.

• Monitor production program progress against planned schedules, targets, material availability, and delivery commitments.

• Analyze production status, program releases, capacity, workloads, and completion timelines.

• Identify operational delays, bottlenecks, risks, and deviations, providing early-warning insights to management.

• Establish and monitor operational KPIs and performance measurement frameworks.

• Prepare daily, weekly, and monthly analytical reports, highlighting trends, variances, performance gaps, and root causes.

• Conduct comparative analyses across suppliers, factories, products, seasons, production programs, and timelines.

• Provide data-driven recommendations to improve production efficiency and operational decision-making.

• Identify repetitive reporting tasks and automate them using advanced Google Sheets functions and data management techniques.

• Improve data integration between operational teams and reporting dashboards.

• Implement standardized reporting formats and effective data governance practices.