INTEGRATED DATA WAREHOUSE SR SPECIALIST

PepsiCo is a world leader in convenient foods and beverages, with 2005 revenues of more than $32 billion and more than 157,000 employees.

The company consists of Frito-Lay North America, PepsiCo Beverages North America, PepsiCo International and Quaker Foods North America. PepsiCo brands are available in nearly 200 countries and territories and generate sales at the retail level of about $85 billion.

PepsiCo offers product choices to meet a broad variety of needs and preference -- from fun-for-you items to product choices that contribute to healthier lifestyles.

PepsiCo’s mission is “To be the world's premier consumer products company focused on convenient foods and beverages. We seek to produce healthy financial rewards to investors as we provide opportunities for growth and enrichment to our employees, our business partners and the communities in which we operate. And in everything we do, we strive for honesty, fairness and integrity.”

Exempt Level 07/08 Sr. Specialist - No relocation available.
EAM - Enterprise Application Management team.  As a Data Warehouse Analyst within the EAM team, you will be responsible for providing ongoing support and maintenance of an important application for the Finance Organization called the Profitability Data Warehouse (PDW), using Business Objects, Informatica, and AIX skills.

Using Activity Based Costing, PDW provides customer and product level P&L statements for FLUS.  The main users of the system are HQ, Region Finance, and National Accounts teams.  Ad-hoc users access the system using Business Objects.  A website is also available for posting standard (static) reports.  Interacting with the PDW team lead and the users, you will be responsible for developing, coding, testing, and implementing new business requirements.  You will also be part of an on-call rotation to maintain PDW through its period close cycle.
REQUIREMENTS
Minimum 3 years combined in general application development.
Minimum 3 years designing, developing, and maintaining applications.
Preferred Business Objects, SQL, or Informatica experience.
Financial Accounting knowledge  helpful.
Strong knowledge of Finance Reporting
Excellent communications skills with a customer focus.
Strong relationship building skills with Team Members and Business Users.
Solid principles of Customer Service and Teamwork.
Strong problem-solving skills, troubleshooting, and root cause analysis.
Experience with data analysis in Microsoft Excel.