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.
