Enterprise Data Operations Manager, BI Architect

Overview

Job Location: Candidate must be located 90 miles from Plano, TX. Candidate should expect to be in office 2 times per week. Relocation assistance is not provided for this role.

 

PepsiCo operates in an environment undergoing immense and rapid change. Big-data and digital technologies are driving business transformation that is unlocking new capabilities and business innovations in areas like eCommerce, mobile experiences and IoT.  The key to winning in these areas is being able to leverage Enterprise Data foundations built on PepsiCo's global business scale to enable business insights, advanced analytics and new product development.

 

PepsiCo's Enterprise Data Operations team is tasked with the responsibility of developing quality data collection processes, maintaining the integrity of our data foundations and enabling business leaders and data scientists across the company to have rapid access to the data they need for decision-making and innovation.

What PepsiCo Enterprise Data Operations does:

• Maintain a predictable, transparent, global operating rhythm that ensures always-on access to high-quality data for stakeholders across the company
• Responsible for day-to-day data collection, transportation, maintenance/curation and access to the PepsiCo corporate data asset
• Work cross-functionally across the enterprise to centralize data and standardize it for use by business, data science or other stakeholders
• Increase awareness about available data and democratize access to it across the company

 

 

#LI-HYBRID

Responsibilities

As a BI Architect, you will leverage your understanding of cloud architecture and BI requirements across solutions to architect solutions that maximize the performance and security of different solutions.

 

This role will require a balance of understanding the needs of the end user/business to be able to prioritize architecture decisions with that audience in mind. Additionally, the candidate will be curious to understand current architecture patterns while looking to optimize and streamline using new next generation tools. You will need to closely coordinate w/ IT partners on approved architecture patterns, outside partners driving new capability, BI team partners who are developing the front end, as well as data engineering, science and automation partners working on solutioning as well. This role will require strong coordination and communication efforts - you will be building and optimizing solutions and need to be able to partner well across the full ecosystem of folks managing and delivering digital products. 

 

• Lead business partner on translating all dimensions and features of D&A products into metrics outputs that will drive business understanding and impact
• Team leader - work with business intelligence developers and managers to push the boundaries and implement best practice, bringing best in class BI tool to our users
• Team player - work with Data Engineering team to design scalable data model and architecture that leads to the best BI performance
• Work closely with Data Engineers, Data Scientists, and Business Partners to deeply understand the data and how to model it appropriately
• Contribute and maintain BI semantic model that enables self-service reporting capabilities and enable analysts to drive business decisions in an efficient and scalable manner
• Explore new technologies and techniques that can expand BI team's capability to serve business needs
• This role will focus on performance optimization and making tradeoff among different tech stacks

Compensation and Benefits

• The expected compensation range for this position is between $125,000 - $217,500 based on a full-time schedule.
• Location, confirmed job-related skills and experience will be considered in setting actual starting salary.
• Bonus based on performance and eligibility; target payout is 12% of annual salary paid out annually.
• Paid time off subject to eligibility, including paid parental leave, vacation, sick, and bereavement.
• In addition to salary, PepsiCo offers a comprehensive benefits package to support our employees and their families, subject to elections and eligibility: Medical, Dental, Vision, Disability, Health and Dependent Care Reimbursement Accounts, Employee Assistance Program (EAP), Insurance (Accident, Group Legal, Life), Defined Contribution Retirement Plan.

 

 

#LI-HYBRID

Qualifications

• Bachelor's Degree Required, Advanced Degree preferred
• 8+ years of relevant business intelligence and relational database experience
• Strive to write elegant code, and are comfortable with picking up new technologies
• Proficient in SQL and have basic understanding of at least one major programming language(eg. Python)
• Experience with data modeling (Eg. Kimball, Inmon), data warehousing, and working with ETL
• Experience working with large-scale, complex datasets
• Experience with business intelligence tools (Eg. Power BI is highly preferred, Tableau)

Skills, Abilities, Knowledge:

• Excellent communication skills, both verbal and written, along with the ability to influence and demonstrate confidence in communications with senior level management.
• Highly influential and having the ability to educate challenging stakeholders on the role of data and its purpose in the business.
• Ability to challenge the status quo
• Strong leadership skills - experience managing a team to drive high-impact work.
• Ability to excel in a high demand, performance-driven environment, working on multiple tasks in parallel
• Strong strategic thinking and creative problem solving
• Be highly motivated and entrepreneurial
• Collaboration / teamwork skills
• Excellent project management skills
• Demonstrated ability to influence others
• Be a quick learner and have a strong curiosity for the unknown
• Thrive in ambiguity and flexible to quick strategic changes 
• Experience with and embraces agile methodologies. Proven track record of leading, mentoring, hiring and scaling data teams.
• Ability to understand and translate business requirements into compelling outputs
• Positive and flexible attitude to enable adjusting to different needs in an ever-changing environment.
• Strong leadership, organizational and interpersonal skills; comfortable managing trade-offs.

 

 

>

All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, protected veteran status, or disability status. 

 

PepsiCo is an Equal Opportunity Employer: Female / Minority / Disability / Protected Veteran / Sexual Orientation / Gender Identity 

 

If you'd like more information about your EEO rights as an applicant under the law, please download the availableEEO is the Law&EEO is the Law Supplementdocuments. ViewPepsiCo EEO Policy. 

 

Please view ourPay Transparency Statement 

Employment Type: FULL_TIME