Overview We Are PepsiCo PepsiCo products are enjoyed by consumers more than one billion times a day in more than 200 countries and territories around the world. PepsiCo generated more than $79 billion in net revenue in 2021, driven by a complementary beverage and convenient foods portfolio that includes LAY’S ®️, DORITOS ®️, CHEETOS ®️, GATORADE ®️, PEPSI ®️, QUAKER ®️ and more. PepsiCo's product portfolio includes a wide range of enjoyable foods and beverages, including many iconic brands that generate more than $1 billion each in estimated annual retail sales. Guiding PepsiCo is our vision to Be the Global Leader in Beverages and Convenient Foods by Winning with PepsiCo Positive (pep+). pep+ is our strategic end-to-end transformation that puts sustainability and human capital at the center of how we will create value and growth by operating within planetary boundaries and inspiring positive change for planet and people. Our employees drive our culture. No two days are the same; we are dynamic and full of passionate teams that embrace new ideas through our collaborative spirit. At PepsiCo, we know that our company can only succeed when our associates and the society we serve flourishes. We are committed to fostering a diverse workforce by creating a collaborative, equitable and inclusive space where everyone, regardless of what we look like, where we come from or who we love, has a voice. At PepsiCo we create a Space to be y( )u. “We are an equal opportunity employer and comply with the with the global human rights policies and equality laws in the countries we operate in, we value diversity at our company; it is an essential part of our success. We do not discriminate based on age, pregnancy or marital/civil partnerships, religion or belief, gender, disability. Learn more about our culture and life at PepsiCo: https://stories.pepsicojobs.com/ Job Overview: The Tax Reporting & Insights Analyst will be a key member of the International Tax Reporting Center of Excellence (COE), reporting into the Tax Director, and supporting tax reporting activities across International Beverages and Asia Pacific Foods. This role is responsible for assisting in the preparation, validation, and analysis of HFM tax reporting data, while also contributing to the development of dashboards, automation tools, and insight generation. In addition to supporting core reporting processes, the analyst will play a critical role in enabling the transformation of the tax function into a value-added, insight-driven team. This includes supporting initiatives in automation, data visualization, and cross-functional collaboration with FP&A, Control, and other key stakeholders. This will be an exciting role with room for growth within the COE, as well as into broader reporting roles. Historically, this position has served as a springboard for individuals moving into BU reporting and other general reporting functions. We are looking for someone who is highly adaptable, eager to learn, and proactive in driving solutions. The ideal candidate is organized, detail-oriented, and capable of zooming in to solve technical issues while also stepping back to see the bigger picture. A true go-getter who thrives in a dynamic environment, constantly seeks ways to streamline their own work and that of the team, and embraces a continuous improvement mindset. Someone who challenges the status quo and understands that small, thoughtful changes aligned with the bigger picture can compound into significant long-term impact. The role is location free and the candidate should be based in one of these locations with PEP offices: Egypt, India, China, or Pakistan. No relocation will be available for this role. Responsibilities a) Core Reporting Support • Assist in the preparation and validation of HFM tax reporting submissions (actuals and forecasts). • Support the documentation and transition of HFM closing activities from market teams to the COE. • Prepare and review prior year top-side adjustment entries in HFM. • Validate annual submissions and prepare templates for BU controller review. • Coordinate with BU teams to gather information for COC analysis and tax forecast reviews. b) Analytics & Insight Generation • Support the creation of dashboards, monthly flash reports, and management review files. • Assist in analyzing financial results and identifying trends or anomalies. • Contribute to the development of tax forecasts and scenario models. c) Automation & Process Improvement • Collaborate with the wider reporting group to develop and deploy automation tools using Power BI, PowerAutomate, and SharePoint. • Support the simplification and harmonization of tax reporting templates and processes. • Participate in pilot initiatives and task forces to test and scale new reporting solutions. Qualifications Normally Required Education & Experience • Certified Public Accountant (CPA) or Chartered Accountant (CA) or ACCA or MBA • Minimum: 2-3 years of relevant accounting related experience. • Reporting experience: 1 year • Team-oriented and collaborative approach to work. • Strong attention to detail and data accuracy. • Proactive, self-starter with a continuous improvement mindset. • Strong communication and interpersonal skills. • Ability to work across cultures and time zones in a virtual team setting. • Able to analyze large data sets fast Additional Preferred Education & Experience • Big Four experience highly preferred. • Affinity with SAP, HFM, Smartview, and Microsoft Office tools (Excel, PowerPoint, Teams, SharePoint). • Process simplification • Experience with no-code programming and AI deployment and Microsoft app interoperability