Sr. Engineer, Enterprise Data Warehouse Build

Job Description

Auto req ID: 182369BR

Job Description

Bring your passion and talent to our stage and share our PepsiCo vision to be the Global Leader in Convenient Foods and Beverages by Winning with Purpose. “Winning with Purpose” reflects our ambition to win sustainably in the marketplace and embed purpose into all aspects of the business

PepsiCo IT exists to shape, create and deliver technology capabilities to accelerate PepsiCo’s growth. Our vision is to power PepsiCo with the best talent and technology in the world. To achieve this vision, our team spans a wide range of IT capabilities. We partner with every PepsiCo business function – consumer insights, marketing & innovation, sales & eCommerce, supply chain & operations, and all back-office functions – to increase business value through new technology and digital solutions.

India will be a global IT Technology Hub for PepsiCo. The global IT Technology Hub in India will play a significant role in the delivery of IT services across all five of our global capability teams:

  • Chief Technology Office (CTO)
  • Global IT Operations
  • Global Information Security
  • Global Development & Delivery
  • Strategy, Planning & Transformation
PepsiCo CTO’s mission is to drive the technology strategy and deliver innovative solutions using leading edge, state-of-the-art digital platforms and modern infrastructure to transform the way PepsiCo makes its products, moves the products across many geographies, and sells them in diversified markets. We push the boundaries of what is possible by leveraging some of the emerging technologies. PepsiCo CTO team is considered as the internal trusted advisor to the business teams globally. Leaders in this organization have rich consulting, management and technology delivery experience, who are also great mentors for many employees.

The CTO team brings the entrepreneurial spirit and speed of a startup company to innovate and solve real business challenges that are diverse, complex, and unique due to the global nature of PepsiCo’s business. These high-value innovations are delivered through internal teams as well as a partner eco-system of start-ups, academic institutions as well as large technology firms. CTO team members work with incubators and curated startup companies on a regular basis.

The CTO team delivers solutions leveraging leading-edge technologies in the areas of a) Big Data & advanced analytics using Teradata, HANA Enterprise, Hadoop, and Microsoft Azure Analytics, b) Artificial Intelligence (AI) using Machine Learning, Deep Learning, computer vision technologies for video, image, text, and voice analytics using programming languages such as R, python, Tensorflow, and GPU hardware for compute intensive applications, c) Internet of Things platforms (Cloud and Edge computing), d) Intelligent automation using RPA (UIPath), e) Augmented Reality using Apple ARkit and Android ARCore, f) Wearable devices & applications for hands free factory and warehouse operations, g) Blockchain for food safety and supply chain visibility, h) modern mobile application platforms, and i) modern infrastructure using hybrid multi-cloud environments and state-of-the-art collaboration and communication platforms. The CTO team also leverages agile development tools and processes (DevOps, Continuous Integration Continuous Delivery pipelines, etc.).

If solving sticky business problems using technology is your passion, PepsiCo CTO team provides unique opportunities to individuals like you. We invite you to take a look at the opportunities available to come and join our team.

We are seeking for an Analyst EDW Build, Primary focus would be to drive EDW build for key projects. This would include development work within the Enterprise Data Warehouse (EDW) platform on Teradata, and other related ETL technologies, with the responsibility of ensuring on time and on budget delivery; Satisfying project requirements, while adhering to enterprise architecture standards. Role will drive key EDW projects and resources, including innovation related initiatives (e.g. moving the EDW platform to the cloud; database encryption; enabling rapid experimentation etc.).


Functional Responsibilities:

  • Drive delivery of key EDW projects within time and budget
  • Drive solution design and build to ensure scalability, performance and reuse
  • Ensure on time and on budget delivery which satisfies project requirements, while adhering to enterprise architecture standards.
  • Facilitate work intake, prioritization and release timing; balancing demand and available resources. Ensure tactical initiatives are aligned with the strategic vision and business needs.
  • Key Competencies Required:
  • Strong database skills
  • Ability to work with virtual teams (remote work locations); within team of technical resources (employees and contractors) based in multiple global locations
  • Participate in technical discussions, driving clarity of complex issues/requirements to build robust solutions
  • Strong communication skills to meet with delivery teams and business-facing teams, understand sometimes ambiguous, needs, and translate to clear, aligned requirements

Key Qualifications/Requirements:
  • Bachelor’s degree in Computer Science, MIS, Business Management, or related field
  • 2 + years’ experience in Information Technology
  • 1-2 years’ experience in Data Warehouse and ETL build and technologies
  • Excellent remote collaboration skills
  • Experience working in a matrix organization with diverse priorities
  • Experience dealing with multiple vendors as necessary
  • Solutions Delivery experience - system development lifecycle, integration, and sustainability
  • Data modeling or database experience; experience with ER/Studio and/or Erwin modeling tools
  • Experience in Data, BI or Analytics projects
  • Good knowledge of data warehousing concepts and data catalog tools (Alation)
  • Good written and verbal communication skills along with collaboration and listening skills
  • Good understanding of PepsiCo business processes, data, and EDW/MDM environments
  • Ability to work with agile delivery methodologies
  • Ability to ideate requirements & design iteratively with business partners without formal requirements documentation

Relocation Eligible: Not Eligible for Relocation
Job Type: Regular