Business Insight

Role Overview: At McCormick, you will be a part of the Global Business Solutions Transformation Team, reporting to the Service Operations Manager. Your primary responsibility will be to deliver accurate, standardized, and insight-driven reporting to support data-based decision-making. You will play a crucial role in ensuring data quality and integrity across multiple sources, managing KPI governance and documentation, and developing structured Excel and Power BI dashboards focused on actionable performance insights. Additionally, you will monitor trends, highlight risks and improvement opportunities, and leverage AI tools to streamline reporting processes and enhance automation. Key Responsibilities: - Data Management & Accuracy: - Collect, validate, cleanse, and manage datasets from multiple sources. - Ensure high levels of data accuracy, consistency, and integrity. - Build and maintain structured Excel files with formulas, pivot tables, lookups, and data validation. - Perform periodic reporting cycles and support ad hoc data requests. - Reporting, Metrics & KPI Management: - Ensure KPI standardization and consistency across reports and dashboards. - Document KPI methodologies and assumptions for transparency and governance. - Monitor performance trends, highlight risks, and improvement opportunities. - Conduct proper root cause analysis of underperforming scores. - Create user-friendly guides, SOPs, and process documentation. - Support knowledge sharing by maintaining structured documentation repositories. - Power BI Reporting: - Develop and maintain Power BI dashboards and reports focused on actionable KPIs. - Transform and model data within Power BI using Power Query and DAX. - Visualize trends, variances, and performance drivers clearly and effectively. - Troubleshoot and continuously improve existing reports. - AI & Continuous Improvement: - Leverage AI tools to enhance data analysis, automation, KPI tracking, and documentation efficiency. - Identify opportunities to streamline reporting processes. - Demonstrate curiosity and willingness to experiment with emerging technologies. Qualification Required: - Level of Education and Discipline: - Bachelor's degree in a related field such as Data Analytics, Statistics, Mathematics, or similar. - Certifications and/or Licenses: - Power BI Technical Skills Must have: - Strong Excel skills (formulas, pivot tables, data cleaning, structured datasets). - Strong Power BI experience (dashboard creation, data modeling fundamentals). - Experience defining, calculating, and monitoring KPIs. - Strong analytical mindset with attention to detail and data accuracy. Nice to have: - Understanding of data governance and metric standardization. - PowerApp - Sharepoint - Python Interpersonal Skills: - Clear written and verbal communication skills. - Fluent English. - Great attention to details and strong focus on delivering against deadlines. - Ability to translate business objectives into measurable metrics. - Highly organized and capable of managing multiple tasks simultaneously. - Strong problem-solving mindset. - Willingness to learn and take on new challenges. - Ability to work independently while collaborating effectively within a team. Role Overview: At McCormick, you will be a part of the Global Business Solutions Transformation Team, reporting to the Service Operations Manager. Your primary responsibility will be to deliver accurate, standardized, and insight-driven reporting to support data-based decision-making. You will play a crucial role in ensuring data quality and integrity across multiple sources, managing KPI governance and documentation, and developing structured Excel and Power BI dashboards focused on actionable performance insights. Additionally, you will monitor trends, highlight risks and improvement opportunities, and leverage AI tools to streamline reporting processes and enhance automation. Key Responsibilities: - Data Management & Accuracy: - Collect, validate, cleanse, and manage datasets from multiple sources. - Ensure high levels of data accuracy, consistency, and integrity. - Build and maintain structured Excel files with formulas, pivot tables, lookups, and data validation. - Perform periodic reporting cycles and support ad hoc data requests. - Reporting, Metrics & KPI Management: - Ensure KPI standardization and consistency across reports and dashboards. - Document KPI methodologies and assumptions for transparency and governance. - Monitor performance trends, highlight risks, and improvement opportunities. - Conduct proper root cause analysis of underperforming scores. - Create user-friendly guides, SOPs, and process documentation. - Support knowledge sharing by maintaining structured documentation repositories. - Power BI Reporting: - Develop and maintain Power BI dashboards and reports focused on actionable KPIs. - Transform and model data within Power BI using Power