SQL Transformation Sr Analyst

hace 6 días


Miguel Hidalgo, México PepsiCo A tiempo completo

**Overview**

Are you looking for a challenging opportunity in an organization with a dynamic, innovative, and diverse environment?

If so, your future is at PepsiCo. As a world class company, we seek excellence in everything we do. Therefore, we need talented, innovative people who are passionate about what they do.

**Responsibilities**
- We are looking for a

**SQL Tranformation Sr Analyst (Go-to-Market)**

**Main Purpose**

As Transformation Sr. Analyst deliver exceptional operational services. Primary responsibilities include; supporting SQL*Server job/queries and troubleshooting the end-to-end processes when needed.

Additionally, this role is responsible for baseline support of existing Excel Reporting / Power BI Dashboards. These services include providing reporting and construction of new dashboards. These activities will be conducted in support of Field Sales and HQ based Go to Market teams. Ability to continuously identify opportunities and implement processes to improve quality and timeliness of team output is valued.

**Accountabilities / Responsibilities**
- Support SQL*Server jobs ranging in complexity from simple queries to highly complex queries with sub-queries.
- Most of the backend resides in SQL*Servers so we envision this resource needing heavy SQL*Server experience.
- Baseline support for our SQL*Server batch jobs.
- Issues resolution to minimize reporting downtime.
- Providing resolution in a timely manner, which may require monitoring jobs and fixing failures in individual job steps.
- Excel Reporting / Power Point / Power BI Dashboards.
- Ownership of ongoing maintenance and creation of new dashboards.
- Ownership of ongoing maintenance of sites/tools.
- Actively conduct on-going review of operational services to drive agility and effectiveness.
- Ensure delivery of accurate and timely data in accordance with agreed service level agreement.

**Qualifications**

**Qualifications / Requirement**
- Bachelor’s degree in a related field
- 4+ years development experience related to Data Analytics and Reporting including the usage of relevant tools and software packages.
- Knowledge on cloud-based data analytics platforms.
- Heavy SQL*Server experience including:

- Writing complex SQL*Server queries.
- Data modeling.
- SSIS experience pulling data from external sources.
- Heavy experience trouble-shooting SQL*Server batch jobs that fail in the evening.
- Excel/VBA data retrieval via SQL*Server stored procedures.
- Power BI / Power Apps experience.
- Strong knowledge of MS Office programs specifically Excel and Power Point.
- Numerate thinker, good at data analysis with strong attention to detail.
- Strong problem-solving skills.
- Language skills - English fluent is a must

If you have the profile that we are looking, send us your CV by this via, if it's possible that you can participate in this process we will contact you ASAP, if not we will keep your info in our base data for 6 months.

**Thank you so much for your interest in PepsiCo**

**INTERNAL CANDIDATES**:

- Having worked at least 18 months in your current function.
- PDR evaluation of at least 2/2 on the last two years.
- Having not received any warrants and/or disciplinary notifications on the last 12 months.



  • Miguel Hidalgo, Ciudad de México PepsiCo A tiempo completo

    OverviewAre you looking for a challenging opportunity in an organization with a dynamic, innovative, and diverse environment?If so, your future is at PepsiCo. As a world class company, we seek excellence in everything we do. Therefore, we need talented, innovative people who are passionate about what they do.Responsibilities We are looking for aSQL...


  • Miguel Hidalgo, México PepsiCo A tiempo completo

    Overview: Are you looking for a challenging opportunity in an organization with a dynamic, innovative, and diverse environment? If so, your future is at PepsiCo. As a world class company, we seek excellence in everything we do. Therefore, we need talented, innovative people who are passionate about what they do. **Responsibilities**: We are looking for a ...

  • Analista SQL Sr

    hace 3 semanas


    Miguel Hidalgo, México SITI Servicios Integrales en TI A tiempo completo

    Ingenieria en Sistemas - **Al menos 3 años de experiência en el uso de SQL Server como desarrollo a nível Sr (desarrollo de objetos y modelado de datos), 3 años de experiência en el manejo de SQL Server Integration Services a nível Sr**_ - **SQL Server 2012 o superior**_ - **SQL server Integration Services 2012 o superior**_ - **Datatools**_ - **C# /...

  • Analista SQL Sr

    hace 2 semanas


    Miguel Hidalgo, México SITI Servicios Integrales en TI A tiempo completo

    Ingenieria en Sistemas - **Al menos 3 años de experiência en el uso de SQL Server como desarrollo a nível Sr (desarrollo de objetos y modelado de datos), 3 años de experiência en el manejo de SQL Server Integration Services a nível Sr**_ - **SQL Server 2012 o superior**_ - **SQL server Integration Services 2012 o superior**_ - **Datatools**_ - **C# /...

  • Transformation Sr Manager

    hace 4 semanas


    Miguel Hidalgo, México PepsiCo A tiempo completo

    Overview: **We Are PepsiCo** Join PepsiCo and dare to transform! 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,...


  • Miguel Hidalgo, Ciudad de México PepsiCo A tiempo completo

    Overview:We Are PepsiCoJoin PepsiCo and dare to transform 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...


  • Miguel Hidalgo, México PepsiCo A tiempo completo

    **Overview** 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...


  • Miguel Hidalgo, Ciudad de México PepsiCo A tiempo completo

    OverviewPepsiCo 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....


  • Miguel Hidalgo, México PepsiCo A tiempo completo

    Overview: 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 ®...


  • Miguel Hidalgo, México PepsiCo A tiempo completo

    **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...

  • Sr. Inventory

    hace 1 semana


    Miguel Hidalgo, México Carters Brands, S.A. de C.V. A tiempo completo

    Serving the needs of all families with young children,  Carter’s Inc. is the largest North American apparel retailer exclusively for babies and young children, encompassing Carter’s, OshKosh B’gosh, Skip*Hop and Little Planet brands. Meaningful work, constant learning, genuine people, and a community guided by core values that promote inclusion and...

  • Sector IT Sr Analyst

    hace 2 semanas


    Miguel Hidalgo, México PepsiCo A tiempo completo

    Overview: **We Are PepsiCo** Join PepsiCo and dare to transform! 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,...


  • Miguel Hidalgo, Ciudad de México PepsiCo A tiempo completo

    Overview: 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....


  • Miguel Hidalgo, México PepsiCo A tiempo completo

    Overview: 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...

  • Sr. Project Analyst

    hace 3 semanas


    Miguel Hidalgo, México PepsiCo A tiempo completo

    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 ®️,...

  • Sr. Project Analyst

    hace 3 semanas


    Miguel Hidalgo, México PepsiCo A tiempo completo

    **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...


  • Miguel Hidalgo, México PepsiCo A tiempo completo

    **Responsibilities**: **Are you looking for a challenging opportunity in an organization with a dynamic, innovative and diverse environment? if so, your future is at PepsiCo.** As a world class company, we seek excellence in everything we do from the launch of a new product to its execution at the point of sale. Therefore, we need talented and innovative...


  • Miguel Hidalgo, México PepsiCo A tiempo completo

    **Responsibilities**: **Are you looking for a challenging opportunity in an organization with a dynamic, innovative and diverse environment? if so, your future is at PepsiCo.** As a world class company, we seek excellence in everything we do from the launch of a new product to its execution at the point of sale. Therefore, we need talented and innovative...


  • Miguel Hidalgo, México PepsiCo A tiempo completo

    Overview: At PepsiCo, we’re redefining what it means to be a consumer products company with a digital-first mindset, and our Global IT team is leading that charge. Our technology teams unlock digital capabilities, enhance cybersecurity safeguards, deliver data-driven insights, and create unmatched consumer and customer experiences. Our culture is guided...


  • Miguel Hidalgo, Ciudad de México PepsiCo A tiempo completo

    OverviewWe 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 includesLAY'S , DORITOS , CHEETOS , GATORADE , PEPSI , QUAKER ...