Business Insights & Analytics Analyst

OVERVIEW

The Business Intelligence & Reporting Analyst is responsible for collecting, creating, enhancing, and delivering business reporting and analytics that support decision-making across the organization. This role serves as the subject matter expert for Circana/Nielsen syndicated data and plays a key role in developing, maintaining, and improving Power BI dashboards, reports, and data visualizations.

Working closely with Commercial Excellence, Revenue Growth Management, Trade Marketing, Commercial Planning, and senior leadership teams, this position ensures timely, accurate, and actionable reporting from multiple data sources including Circana/Nielsen, SAP, Data Lake, Blue Planner, Marketing Mix, and other business systems. The analyst will also partner with Global IT and external data providers to ensure data accuracy, integrity, and alignment across reporting platforms.

WHAT YOU WILL DO

Reporting & Analytics

• Manage, update, and distribute monthly and quarterly Circana/Nielsen reports and insights.


• Review and maintain product hierarchies and item classifications within the Circana/Nielsen database.


• Analyze syndicated sales data and develop executive-level summaries and business insights.


• Publish reports and communicate updates to stakeholders across the organization.


• Drive results by effectively managing priorities, timelines, and deliverables to ensure timely and accurate reporting.

Dashboard Development & Maintenance

• Maintain and validate existing Power BI dashboards utilizing Data Lake and other data sources.


• Partner with Global IT to resolve data integration, mapping, and reporting discrepancies.


• Design, develop, and enhance Power BI dashboards and custom reports to support evolving business needs.


• Improve reporting capabilities by leveraging existing and new data sources to provide deeper business insights.

Data Quality & Governance

• Identify and resolve data quality and cleansing issues across multiple internal and external data sources.


• Collaborate with data owners to ensure data accuracy, consistency, and documentation.


• Support the organization's "One Source of Truth" initiative by aligning reporting across SAP, Circana/Nielsen, and Data Lake platforms.


• Validate data transformations and reporting outputs to ensure accuracy and reliability.


• Analyze complex datasets, identify key business drivers, and recommend actionable solutions.

Cross-Functional Partnership & Business Support

• Collaborate with teams across Commercial Insights, Shopper Marketing, Category Management, Revenue Growth Management, Trade Marketing, Commercial Planning, Sales, Marketing, and Leadership.


• Gather reporting requirements and translate business needs into actionable dashboards and analytics solutions.


• Recommend process improvements and reporting enhancements that drive business value and decision-making.


• Adapt quickly to evolving business priorities and changing reporting requirements while maintaining high-quality deliverables.

WHAT WE NEED FROM YOU

• Bachelor's degree required, preferably in Business Analytics, Finance, Economics, Statistics, Mathematics, Data Analytics, Information Systems, or a related analytical discipline.


• 1–3+ years of experience in business intelligence, analytics, reporting, or a related field.


• Experience working with syndicated retail or consumer data sources such as Circana, Nielsen, 84.51°, or Numerator.


• Experience collaborating with cross-functional commercial teams including Sales, Marketing, Revenue Growth Management, and E-commerce.


• Consumer packaged goods (CPG) or fast-moving consumer goods (FMCG) industry experience preferred.


• Advanced Power BI development, maintenance, and reporting capabilities.


• Working knowledge of DAX, field parameters, and dashboard design best practices.


• Experience with data cleansing, validation, and data management processes.


• Basic SQL querying and data modeling skills.


• Strong Microsoft Excel and PowerPoint skills.


• Experience working with Circana/Nielsen data required.


• Exposure to Databricks, Python, R, advanced analytics tools, or Data Lake architecture is a plus.


• Strong written, verbal, and presentation skills with the ability to communicate insights to stakeholders at all levels of the organization.

Additional Information

• Occasional travel required (1–2 times annually) for conferences, training, or global meetings.


• This role offers career growth opportunities into advanced analytics, data science, business intelligence leadership, and other commercial strategy functions.

WHAT WE OFFER

At Perfetti Van Melle, we are committed to fostering a diverse, equitable, and inclusive workplace, where all individuals, regardless of background or identity, are valued, respected, and empowered to contribute their unique perspectives to the sweet success of our candy-loving community. Additionally, we have a core value of Care For Our People and we are proud to offer benefit programs that support our team members' goals and well-being including:

• PTO package including vacation, sick, personal, and pay it forward time off


• 13 paid holidays


• 401k with Company Match up to 8%, ranking in the top 1% of the country


• Annual Bonus potential and merit-based increases


• Comprehensive Health Insurance


• Annual well-being subsidy


• 20 weeks Maternity & 12 weeks Paternity leave options


• Sam's Club or Costco annual membership reimbursement


• Tuition-Free College Program or Free Continued Education (BA, Masters, etc.)


• Modest monthly candy allotment (Airheads, Airheads Xtremes, and Mentos)

Join a 2024 NKY Best Workplace by applying today!

Perfetti Van Melle, USA is an equal opportunity/affirmative action employer. All qualified applicants will receive consideration for employment without regard to sex, gender identity, sexual orientation, race, color, religion, national origin, disability, protected veteran status, age, or any other characteristic protected by law.