Financial Data Analyst

Job Overview

Keurig Dr. Pepper is seeking a hands-on experienced analyst for its Coffee Manufacturing operation. If you are looking for a dynamic and challenging work environment with the opportunity to expand your influence across the organization, grow personally and professionally with long-term goals, this position has much to offer. This position requires a process leader who will partner with the financial management team to provide decision support, drive savings, and increase productivity.

As a Financial Data Analyst, your primary responsibilities will be driven by interpretation and reporting requests. By applying transformations and analysis to SQL/Excel-based datasets, you will create clear and concise reporting via SQL, Power BI, and Excel. Previously developed models will require consistent maintenance, modification, and summarization.

This position can be based in one of the following locations: Frisco, TX, Knoxville, TN or Sumner, WA

Key Responsibilities

Large Data Interpretation/Modeling Support

Generate financial models and analyses using advanced analytical tools and multiple reporting systems; provides readily accessible information and projections with guidance.Perform ad hoc projects and analysis derived from varying datasets.Lead financial process improvement regarding information and model management.Maintain complex information schemas and provide support to end-users with statistical extraction.

Budget/Forecasting/Action Planning

Develop and maintain financial models to support forecasting, budgeting, and decision-making processes.Create ad hoc models to convert financial and operational inputs into legible KPIs to track progress against forecasts.Compile financial/operational KPIs and present in real-time actionable format.Prepare comprehensive reports and dashboards to communicate key findings and recommendations to stakeholders. Utilize data visualization tools to present complex information in a clear and concise manner.

System/Financial Reconciliation

Collect, clean, and organize financial data from various sources including databases, APIs, and external vendors.Reconcile granular datasets between multiple source systems using independently developed models.Troubleshoot incongruent system results and work with different IT & Operational stakeholders to resolve discrepancies.

Total Rewards

Salary Range: $52,500 - $93,500Actual placement within the compensation range may vary depending on experience, skills, and other factors Benefits, subject to election and eligibility: Medical, Dental, Vision, Disability, Paid Time Off (including paid parental leave, vacation, and sick time), 401k with company match, Tuition Reimbursement, and Mileage Reimbursement Annual bonus based on performance and eligibility

Requirements

BS/BA degree in Finance, Analytics, or equivalent experience.2+ years of experience with problem-solving and analytical thinking.Required advanced technical skillset in Excel.Familiarity with Power BI/Power Query.Strong understanding of table relationship management, including joins between multiple fact and dimension tables.VBA, Tableau, SQL experience a plus.Manufacturing Finance/Accounting experience a plus.Ability to work both independently and collaboratively on parallel process streams.

Company Overview

Keurig Dr Pepper (NASDAQ: KDP) is a modern beverage company with a bold vision built to deliver growth and opportunity. We operate with a differentiated business model and world-class brand portfolio, powered by a talented and engaged team that is anchored in our values. We work with big, exciting beverage brands and the #1 single-serve coffee brewing system in North America at KDP, and we have fun doing it!

Together, we have built a leading beverage company in North America offering hot and cold beverages together at scale. Whatever your area of expertise, at KDP you can be a part of a team that’s proud of its brands, partnerships, innovation, and growth. Will you join us?

We strive to be an employer of choice, providing a culture and opportunities that empower our team of ~28,000 employees to grow and develop. We offer robust benefits to support your health and wellness as well as your personal and financial well-being. We also provide employee programs designed to enhance your professional growth and development, while ensuring you feel valued, inspired and appreciated at work.

Keurig Dr Pepper is an equal opportunity employer and affirmatively seeks diversity in its workforce. Keurig Dr Pepper recruits qualified applicants and advances in employment its employees without regard to race, color, religion, gender, sexual orientation, gender identity, gender expression, age, disability or association with a person with a disability, medical condition, genetic information, ethnic or national origin, marital status, veteran status, or any other status protected by law.