R&D CRM reporting Analyst

Overview This position is part of the PepsiCo External Innovation Team. External Innovation works closely with internal stakeholders within Global R&D and provides external partnering capability to accelerate PepsiCo’s innovation agenda, mitigate development risk and uncover unique new business opportunities. The External Innovation Data Entry Analyst performs day-to-day leads management and supports the organization’s long-term business goals for emerging technology platforms.The roles and responsibilities include: Collect and manage data for new opportunities from our technology scouts, internal stakeholders and external partner ecosystem. Data input into the Leads Management System (Microsoft Dynamics Customer-Relationship Management Database). Customize and configure the LMS platform, implement LMS workflows, dashboards, and reports to streamline processes and improve data visibility. Collaborate with cross-functional teams, including R&D Stakeholders, IT and with external partners and vendors to ensure seamless data exchange, integration and communication. The ability to communicate well and develop positive working relationships with internal partners and colleagues in a team environment is essential. Good experience with various LMS, CRM tools (Salesforce/ HubSpot/ Microsoft Dynamics) data collection and management. Responsibilities Functional Responsibilities: The candidate must be detail-oriented and be able to manage several commitments simultaneously and meet stringent deadlines. The ability to communicate well and develop positive working relationships with internal partners and colleagues in a team environment is essential, as is the ability to work with a minimum amount of supervision. Good experience with various LMS, CRM tools (Salesforce/ HubSpot/ Microsoft Dynamics) data collection and management. Collect and manage data for new opportunities from our technology scouts, internal stakeholders and external partner ecosystem. Data input into the Leads Management System (Microsoft Dynamics Customer-Relationship Management Database). Assist in maintenance, optimization and continuous improvement of our data systems. Manage inquiries and requests for assistance for the Leads Management System in a timely manner. Take responsibility for training and roll-out of this key information management tool to key functional areas in R&D. Ensure that quality assurance standards for data entry are adhered to by database users. Data Analysis & Reporting: Analyze LMS and other data to provide insights and recommendations that support strategic decision-making. Generate and distribute regular reports on key performance indicators (KPIs) and metrics related to external innovation activities. MS Suite (Power Tools) Process Improvement: Identify opportunities to enhance the functionality and user experience of LMS and other software systems. Develop and implement best practices for data entry, maintenance, and management within the LMS and other software systems. Proven experience with CRM platforms such as Salesforce, HubSpot, or Microsoft Dynamics, and familiarity with project management and data analytics tools. Proficiency with Microsoft Office 365 suite of tools (particularly Excel and SharePoint) including manipulating data (filtering, queries, etc.) to extract critical info. Strong analytical and problem-solving skills with a high attention to detail. Assessing overall CRM user experience including bulk upload, adding files, tracking source, assigning owners/business unit, set status, track communication notes. Proficiency in SQL, data manipulation tools, and other relevant software (e.g., Tableau, Power BI). Good working experience of MS Suite ( Power Tools) for email alerts and tracking setup. Working knowledge of various CRM softwares/ tools which uses APIs to direct connect with external sources. Experience with Microsoft Dynamics or similar CRM tools. Friendly yet professional demeanor to conduct calls with internal associates and capture input. A pro-active nature to include a flexible approach to hours of work and location of duties Excellent communication and interpersonal skills. Ability to manage multiple projects and deadlines in a fast-paced environment. Knowledge of data protection regulations and best practices. Strong collaborator; Interested and motivated by working with others. Actively creates and participates in opportunities to co-create solutions across markets or brands. Qualifications Proven experience with CRM platforms such as Salesforce, HubSpot, or Microsoft Dynamics, and familiarity with project management and data analytics tools. Proficiency with Microsoft Office 365 suite of tools (particularly Excel and SharePoint) including manipulating data (filtering, queries, etc.) to extract critical info. Strong analytical and problem-solving skills with a high attention to detail. Assessing overall CRM user experience including bulk upload, adding files, tracking source, assigning owners/business unit, set status, track communication notes. Proficiency in SQL, data manipulation tools, and other relevant software (e.g., Tableau, Power BI). Good working experience of MS Suite ( Power Tools) for email alerts and tracking setup. Working knowledge of various CRM softwares/ tools which uses APIs to direct connect with external sources. Experience with Microsoft Dynamics or similar CRM tools. Friendly yet professional demeanor to conduct calls with internal associates and capture input. A pro-active nature to include a flexible approach to hours of work and location of duties Excellent communication and interpersonal skills. Ability to manage multiple projects and deadlines in a fast-paced environment. Knowledge of data protection regulations and best practices. Strong collaborator; Interested and motivated by working with others. Actively creates and participates in opportunities to co-create solutions across markets or brands. Essential: Good communication skills – English Stakeholder management skills – Working with different teams and to be able to conduct calls with internal associates and capture input. Good with repetitive tasks and doing things with high quality (attention to detail). Solution-oriented approach to problem solving. Understanding of internal & external data sources that could contribute to the reporting and analysis function. Flexible working hours (work day ends at 11:30 am CST) Experience in CRM tools like Salesforce, HubSpot, or Microsoft Dynamics, and familiarity with project management and data analytics tools. Good working experience of MS Suite (Power Tools) Nice to have STEM background who understands the business processes preferably within an innovation or technology-driven environment. Working experience of CRM tool migration from one platform to another.