Sr Business Intelligence Engineer

Key Skills

ETL frameworks, Java Programming, PowerBI, Python Programming, Servers services, Snowflake, S-Plus, SQL, Tableau, Teradata

Job Description

PepsiCo operates in an environment undergoing immense and rapid change, driven by eCommerce and emergent retail technologies. To ensure continued success in the food and beverage space, PepsiCo has assembled a dedicated eCommerce team – tasked with optimizing eCommerce operations and developing innovations that will give PepsiCo a sustainable competitive advantage. While tied closely to broader PepsiCo, the eCommerce group more closely resembles a start-up environment; embracing the core values of having bias for action, being results oriented, maintaining a community-focus, and prioritizing people.

PepsiCo’s Data Science and Analytics group is a team of data engineers, BI developers, technology specialists, and business innovators who operate within eCommerce to build industry-leading systems and solutions. By focusing on machine learning and automation, the Data Science & Analytics group is pushing the bounds of possibility for PepsiCo and its strategic partners.

What PepsiCo Data Science & Analytics Business Intelligence team does:

• Create data visualizations to unlock sales & share trends across e-commerce sales channels
• Integrate data utilizing Airflow, SSIS, Tableau Prep, and other tools to provide quick but unified insights
• Integrate advanced analytics into Business Intelligence solutions to deliver clear and meaningful insights to the business
• Deploy data platforms and applications to enable business users and data scientists alike to rapidly derive value from raw data
• Work with PepsiCo’s strategic partners to expand their technical capabilities, thereby creating a more robust data environment
• Develop scalable tools to drive automation and optimize business operations

As a Senior Business Intelligence Engineer you will guide a team of developers to design and deliver solutions that could touch everything from semantic layer development to UAT and user training on the newly developed suites of data platforms. You will interact with databases and files on a regular basis and use your expertise to simplify processes where possible. You will manage timelines, mitigate blockers, and leverage staff to deliver viable business intelligence products such as data lakes, data warehouses, and pipelines - while focusing on repeatability, scalability and automation. Within the team, you will also assist the team by providing guidance on career development and growth.

Responsibilities:
Conduct and manage the full lifecycle of back end business intelligence work including requirements gathering, design, documentation, testing and validation to support the implementation of Business Intelligence analytics solutions.

• Gather, understand, & document requirements from stakeholders and cross functional teams
• Function as a subject matter expert in the BI and analytics space
• Plan and manage project delivery including building roadmaps, identifying risks, and leveraging junior resources
• Advanced SQL programming for ad hoc analysis and data consumption (including SQL Server, Snowflake, Tera data & Postgres)
• Develop pipelines, data models, data lakes, data warehouses
• Design reporting and business intelligence products, including visualizations & self-service tools
• Maintaining data quality and overseeing database security
• Present products to business users and seek feedback for continued improvement
• Mentor a team of junior staff from career development perspective
• Validate and review products for quality assurance prior to delivery
• ???????COVID-19 vaccination is a condition of employment for this role. Please note that all such company vaccine requirements provide the opportunity to request an approved accommodation or exemption under applicable law

Qualifications/Requirements

• Bachelor’s Degree (Computer Science, Engineering, or other STEM related area preferred)
• Minimum of five (5) years of experience with writing, debugging and performance tuning complex SQL queries
• Advanced development experience (3+ years) with at least one data visualization platform (Tableau, PowerBI preferred)
• Knowledge of dimensional data modelling
• Experience managing the delivery of end to end BI solution builds, including timeline and plan resource
• Experience mentoring a team of developers
• Excellent analytic skills and strong communication skills – written and verbal presentations
• Be inquisitive for knowledge, driven for results, yet humble

Additional Qualifications:

• Experience managing and maintaining a database supporting live business tools
• Experience working with Snowflake a plus
• Experience with the full Microsoft BI Stack (SSIS, SSAS, SQL Server, etc.) a plus
• Programming in Python, ETL tools (DBT is a plus)