Lead Data Engineer

**Overview**

**We Are PepsiCo**

Join PepsiCo and Dare for Better We are the perfect place for curious people, thinkers and change agents. From leadership to front lines, we're excited about the future and working together to make the world a better place.

Being part of PepsiCo means being part of one of the largest food and beverage companies in the world, with our iconic brands consumed more than a billion times a day in more than 200 countries.

Our product portfolio, which includes 22 of the world's most iconic brands, such as Sabritas, Gamesa, Quaker, Pepsi, Gatorade and Sonrics, has been a part of Mexican homes for more than 116 years.

A career at PepsiCo means working in a culture where all people are welcome. Here, you can dare to be you. No matter who you are, where you're from, or who you love, you can always influence the people around you and make a positive impact in the world.

**Know more**:

- PepsiCoJobs

**Join PepsiCo, dare for better.**

**Responsibilities**

**The Opportunity**

**Your Impact**
- As **Lead Data Engineer** your scope would consist of:

- Drive and lead delivery of key projects within time and budget
- Drive and lead solution design and build to ensure scalability, performance, and reuse
- Ability to recommend and drive consensus around preferred data integration/engineering approaches
- Ability to anticipate data bottlenecks (latency, quality, speed) and recommend appropriate remediation strategies
- 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.
- Ensure sustainability of live pipelines in production environment
- Hands on experience of implementing and designing data engineering workloads using Spark, Databricks, or similar modern data processing technology
- Work with product owners, scrum masters and technical committee to define the 3 months road-map for each program increment (sprint wise)
- Create documentation for learnings and knowledge transfer.
- Collaborate with internal clients (data science and product teams) to drive solutioning and POC discussions.

**Qualifications**

**¿Who Are We Looking For?**

**Required Skill-set**:

- Bachelor’s degree in Computer Science, MIS, Business Management, or related field
- 4 + years’ experience in Information Technology
- 4 + years of Azure, AWS and Cloud technologies
- 4+ years of experience of writing complex SQL queries in DWH or Datalake environment
- 4+ years of experience with a programming language (i.,e python, java or scala) preferably python.
- Experience of building frameworks for different processes such as data ingestion and dataops
- Good written and verbal communication skills along with collaboration and listening skills
- Well versed with Spark optimization techniques
- Big Data (Hadoop, HBase, MapReduce, Hive, HDFS etc.), Spark/PySpark
- Sound skills and hands on experience with Azure Data Lake, Azure Data Factory, Azure Data Bricks ,Azure Synapse Analytics, Azure Storage Explorer
- Proficient in creating Data Factory pipelines for on-cloud ETL processing; copy activity, custom Azure development etc.

**What can you expect from us**:

- Opportunities to learn and develop every day through a wide range of programs.
- Internal digital platforms that promote self-learning.
- Development programs according to Leadership skills.
- Specialized training according to the role.
- Learning experiences with internal and external providers.
- We love to celebrate success, which is why we have recognition programs for seniority, behavior, leadership, moments of life, among others.
- Financial wellness programs that will help you reach your goals in all stages of life.
- A flexibility program that will allow you to balance your personal and work life, adapting your working day to your lifestyle.
- And because your family is also important to us, they can also enjoy benefits such as our Wellness Line, thousands of Agreements and Discounts, Scholarship programs for your children, Aid Plans for different moments of life, among others.

We are an equal opportunity employer and value diversity at our company. We do not discriminate based on race, religion, color, national origin, gender, sexual orientation, age, marital status, veteran status, or disability status. We respect and value diversity as a work force and innovation for the organization.