Responsibilities The Advanced Analytics COE is a growing team focused on modernizing reporting and developing actionable insights for senior leaders through automation, visualization, and functional expertise. This transformational journey will align cross functional executive leadership towers with actionable insights that will shape the future of PFNA. This approach allows a team member the opportunity to develop deep functional expertise across these functional environments. The goal of the Advanced Analytics COE is to answer the question before it is asked. This L9-L10 role supports and influences critical PFNA roles in sales and finance including Route Sales Representative, Sales District Leader, Zone and Region Leadership Team, Key Account Manager, National Account Manager, Net Sales Manager, Pricing Coordinator, Finance Admin, and Sales Admin. This can include live support, formal and in-formal training, email, instant messaging, and other forms of communication. Position capabilities will require the business acumen for gathering data from multiple sources across the PepsiCo enterprise and manipulating the data into meaningful and action ready reporting and analyses. Ability to convert strategies into actionable plans and processes. Ability to work in an unstructured environment. Takes initiative and works independently with minimal direction. Ability to work and communicate effectively with field, customer and headquarter teams. Partner with leadership to identify opportunities and help define the short-term and long-term roadmap, including the customer/end user experience and features Proficiency writing and troubleshooting Teradata queries Provide support researching and resolving data issues Provide support in managing SQL Server queries, stored procedures, agent jobs. Provide baseline support for all Growth Office Power BI applications Lead the preparation and execution of User Acceptance Testing (UAT) for application enhancements and releases. Communicate and partner with stakeholders and application end users to gather requirements (UCD) for enhancements by engaging with end users frequently, both in formal and informal settings Ensure high quality of customer service by developing skills within the team that promote responsiveness, professionalism and customized support As a Subject Matter Expert (SME), develop and share experience and knowledge of applications and assertively address implications of change to existing applications during key meetings Promote excellent documentation standards by leading the team in development of accurate and complete resources, job aids, learnings, one pagers and training materials Leads onboarding of new team members and training of existing team members and prepares training content to be shared during weekly team meetings Role is designed to backfill key DBA on the team with longevity to stay in this role preferred. (5-10 Years). Note:- COVID-19 vaccination is a condition of employment for this role. Please note that all such company vaccine requirements provide the opportunity to request an approved accommodation or exemption under applicable law. Qualifications Bachelors Degree or equivalent work experience Very Strong analytical and technical skills 5+ years of Database experience 3+ years Data acquisition/modeling experience using PowerBI, SSAS, SSMS, & Azure Demonstrated ability to initiate and drive a project agenda to completion Strong communication skills (verbal and written), including the ability to create presentations and present to small groups Ability to take initiative, problem-solve with limited direction, and navigate ambiguity to resolve issues Ability to manage multiple tasks, organize & prioritize, and coordinate across multiple teams Ability to gather data from multiple sources across PepsiCo and manipulate the data to develop meaningful and action-based reporting and analysis Demonstrate flexibility and the ability to adapt to change Must thrive in a high paced work environment, balance numerous tasks, have a strong focus on detail and be able to adhere to strict deadlines Ability to work independently and as part of a virtual team Preferred: 5+ years experience with FLUS business process and technology solutions Power BI performance tuning via DAX Studio 1+ years of Microsoft Power BI programing using DAX language Experience using Visual Studio SSAS to create and deploy tabular data models for use in Power BI Experience using Visual Studio SSDT/SSIS to create automated ETL processes Preferred Experience using Azure services 1-2 years - Experience creating Data Models inside Power BI 1-2 years - Experience with Teradata, DB2, SAP, Oracle and Sql Server databases","location_name":"TX-Plano-7701a-HDQ-TX224B","street_address":"7701 Legacy Dr","city":"Plano","state":"Texas