Data Visualization Analyst - Purchase, United States - PepsiCo

PepsiCo

Verified Company

Purchase, United States

3 weeks ago

Posted by:

Mark Lane

beBee recruiter

Description

Overview:

Responsibilities:

Support PBNA Finance and Control teams at the Division and Sector level through the development, implementation, and sustainment of data analytic solutions
Interact with stakeholders to identify analytic opportunities and improvements utilizing new tools & approaches
Build and own the automation and monitoring frameworks that captures metrics and operational KPIs for data pipeline quality and performance.
Write SQL queries to support data pipeline and ingestion
Design Tableau/Power BI dashboards to meet stakeholders' needs
Empower the business by creating value through the increased adoption of data, data science and business intelligence landscape
Demonstrate innovative and creative thought leadership on analytic logic, tools, and designs
Lead/manage ad hoc related projects and report to management.

Skills & Capabilities:

Extensive experience in the creation, governance, maintenance, and sustainment of analytic solutions, databases, and data warehouses. Specific experience working with data structures in SQL Server, Teradata, Oracle and SAP.
Proficient in SQL Server and capable of creating and using Stored Procedures, User Defined Functions, creating Sub-Queries and Joins for complex queries involving multiple tables and Exception Handlers
Proficient in data visualization/reporting solutions and tools such as Tableau, Power BI and SAP Business Objects
Experience in Extract, Transform and Load (ETL) processes using Python, Spark or other programming languages
Intellectual curiosity and willingness to learn new tools and techniques to support a rapidly changing landscape of stakeholder needs
Analytical mindset that can define or identify a problem, generate alternatives or potential solutions, evaluate, and implement the chosen solution
Strong communication skills and ability partner with both technical and nontechnical team members
Able to troubleshoot and fix errors in existing solutions

Compensation and Benefits:

The expected compensation range for this position is between $72,900 $122,100 based on a fulltime schedule
Location, confirmed jobrelated skills and experience will be considered in setting actual starting salary
Bonus based on performance and eligibility; target payout is 5% of annual salary paid out annually

Qualifications:

Bachelor's degree or Master's degree in Analytics, Information Systems, Statistics, Economics, Mathematics, Engineering, or Computer Science
3+ years of overall professional experience in either a technical (I/T) department or as a liaison between I/T and Finance
2+ years of experience in SQL query, optimization, and performance tuning
2+ years of experience in Tableau, PowerBI or other visualization tools
Endtoend technical solution design, including data design, ETL process design, and dashboard design

Preferred Qualifications:

1+ year of development experience in SSIS Packages and Python to build highvolume ETL/ELT pipelines.
Fluent with Azure cloud services. Azure Certification is a plus
Fluent in GIT
Development experience in SSIS Packages and Python to build ETL/ELT pipelines
Experience with data science, cloud platforms, and other programming languages
Familiarity with Office 365 online environment including Power Apps

Relocation Eligible:
Not Eligible for Relocation

>:

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 available EEO is the Law & EEO is the Law Supplement documents.

View PepsiCo EEO Policy.

Please view our Pay Transparency Statement