Shire Jobs

Job DescriptionOverviewThe PepsiCo North America (PBNA) Business Process Control Analytics team is looking for a Data Visualization Engineer who is data oriented, analytical, and has intellectual curiosity to understand processes within various functions of the PBNA Business Process Control Organization. The Data Visualization Analyst will primarily focus on providing impactful analytics and workgroup solutions that enhance decision making, increase productivity, and eliminate or streamline labor intense work. The ideal candidate will have experience in developing and sustaining data analytic solutions in a dynamic environment.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 non-technical team members* Able to troubleshoot and fix errors in existing solutionsCompensation and Benefits:* The expected compensation range for this position is between $72,900 - $122,100 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 5% 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 PlanQualifications* 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* End-to-end technical solution design, including data design, ETL process design, and dashboard designPreferred Qualifications:* 1+ year of development experience in SSIS Packages and Python to build high-volume 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 RelocationEEO StatementAll 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 IdentityIf 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.

Minimum Salary: 72,900 Maximum Salary: 122,100 Salary Unit: Yearly