Data Architect-II

About the Company

Mosaic is PepsiCo’s financial planning and reporting transformation program, bringing an aligned business process and toolset to all key business units enabling PepsiCo to get consistent and standardized financial metrics across geographies. Started in 2019 the program is already rolled out to Europe and most of North America and continues across the world.

There are three key components to the program:

• A standardized planning tool - IBM Cognos TM12.
• A global data warehouse based on Azure Cloud known as SPOT (single point of truth).
• The SPOT team is made up of functional data analysts & data engineers.
• An extensive suite of dashboards known as Cockpit using Tableau. The Cockpit team are generally finance analysts with Tableau skills.

About the Role

As part of the Mosaic program, we have a Data Sharing POD (product orientated delivery) Team within the SPOT digital product management team to focus on how we can share the financial data we are the custodians of, with other PepsiCo projects and business processes in a controlled and secured way. We are looking for an additional data analyst(s) to take on the day-to-day tasks associated with this.

Responsibilities

• Building a strong knowledge of the data available in SPOT.
• Understanding/analyzing new business requests for use of SPOT data.
• Aligning new business requests with the finance planning data product owners with respect to what data will be shared and what level of security should be applied.
• Setting up the data access policies using an internally developed tool.
• Supporting downstream users of SPOT data with any queries they have about the data structure or data content.
• When not focused on data sharing activities, the analyst would support any other tasks needed across the wider SPOT team deliverables.

Qualifications

The existing SPOT functional data analysts come from a range of backgrounds from data engineers to business analysts. What unites the team is a passion for data, attention to detail, ability to navigate and understand complex data flows, and a customer-centric mindset. This is a high profile and at times high pressured transformation program and everyone on the team must be responsive to our stakeholders needs.

Required Skills

Technical

• Confident using SQL to explore, investigate & understand data in a structured database. Current technologies are: Databricks, DBSQL & Databricks Unity Catalog.
• Nice but not essential: capable of reading and understanding SQL data transformation scripts.

Functional

• Capable of taking business requirements and translating these into technical data requirements with respect to configuring the correct data access rules.
• Some background of working with financial data would be beneficial to understand the finance terminology - but you don't need to be an accountant!

Soft skills

• Good English language skills are essential as this is the business language in PepsiCo.
• Love for data and problem solving - demanding sharp analytical skills to handle/evaluate large amount of data (strong attention to detail).
• Good communicator and a good people person given the need to collaborate effectively across teams and people of diverse backgrounds.
• Pioneer and innovative mindset required as we are shaping the future of data use within PepsiCo - comfortable with the uncomfortable.
• Working within an Agile program and project.
• Ability to operate autonomously and proactively, managing multiple deliverables at a single time in a fast-paced, results-oriented environment.
• Working & interacting with multiple geographies & teams throughout the globe.

Pay range and compensation package-INR 45-48 LPA

We expect the successful candidate to be on-site in the PepsiCo Hyderabad office at least two days a week to work with and learn from the wider team. Being a global team, we expect the successful candidate to be able to flex their working day to attend meetings outside of 9-5.

Equal Opportunity Statement

We are committed to diversity and inclusivity.