Dr Pepper Snapple Group Business Systems Analyst in Plano, Texas
This role is a unique opportunity for an entry-level analyst or accountant who will interact with stakeholders from several areas within Dr Pepper Snapple Group such as Cash Accounting, Support Services, Corporate Accounting, Accounts Payable, Accounts Receivable, and CTA teams as well as third-party vendors (Concur) and JPMC. The candidate will reconcile, research and provide accruals/journal entries for various credit card, cash, and personal expenses and out of pocket accounts. The primary responsibilities of this role include accounting related to our day 1 Accruals (Credit Card and OOP), Personal Expense JE’s, Out of Pocket expenses, bank statement reconciliations, balance sheet accounts for JPM cash clearing, Concur credit card clearing , employee receivables and MISC journal entries for US and CAD across both processing SAP systems.
Ensure that AP reconciling is in compliance with GAAP, internal SOX controls and other authoritative accounting guidance as well as the company’s expenditure policy and guidelines.
The successful candidate will be highly self-motivated and able to work independently. The candidate will also be an effective problem-solver, making decisions based on fact, thorough research, and alignment with corporate policy.
Responsibilities 1. Accounting – * Prepare journal entries for accruals, misc. and personal expenses, * Prepare all monthly documentation to aid in the reconciliation of the general ledger (SAP),credit card and cash clearing accounts, researching and resolving out-of-balance (variance) items as necessary such as Expense itemization errors, outstanding fraud, hierarchy changes * Partner with various departments to research and resolve reconciling items * Upon completion of the statement reconciliation, prepare payment request for each credit card statement * Prepare reconciliation or ad hoc reports as necessary 2. SOX & Internal Controls - * Research and analyze Corporate Credit card clearing account, cash clearing account and SAP, Concur System against various DPS policies and procedures * Prepare and execute complex spreadsheets to identify problematic postings. Have in-depth understanding of systems, policies and procedures. * Report on any identified failures to internal stakeholders for review and correction. * Execute internal and SOX controls by creating the reports, performing the related review and completing by the required critical timelines * Escalate compliance failures and internal/SOX control issues to DPS management weekly and monthly. * Responsible for managing workload to ensure SLA and Productivity metric targets are being 3. *Business Decision Support* –// · Completing special projects and ad hoc reporting as requested// · Identification and implementation of improvements to processes and systems// · Complete Concur System Administrator ad hoc reports/partnering with IT as required · Cross Training and support of ESKER Business System Analyst
Skills * Strong communication skills and customer service focus
- Bachelor degree in Accounting, Finance, or Business-related degree
- 1 year of experience in reconciliations, accounting or subledgers
- 2 years of experience with Microsoft Excel (creating spreadsheets, v-lookups, formulas, pivot tables)
- 1 year of experience analysing data
Dr Pepper Snapple Group, Inc. (NYSE: DPS) is one of North America’s leading refreshment beverage companies, manufacturing, bottling and distributing more than 50 brands of carbonated soft drinks, juices, teas, mixers, waters and other premium beverages.
With a brand heritage spanning more than 200 years, the DPS portfolio includes some of the most recognized beverages in the Americas. More than 75 percent of the company’s overall volume is from brands that are either #1 or #2 in their flavor categories. In addition to its flagship Dr Pepper and Snapple brands, the DPS portfolio includes 7UP, Mott’s, A&W, Sunkist soda, Hawaiian Punch, Canada Dry, Schweppes, RC Cola, Diet Rite, Squirt, Peñafiel, Yoo-hoo, Rose’s, Clamato, Mr & Mrs T and other well-known consumer favorites.
Dr Pepper Snapple Group is an equal opportunity employer and affirmatively seeks diversity in its workforce. Dr Pepper Snapple Group recruits qualified applicants and advances in employment its employees without regard to race, color, religion, gender, sexual orientation, gender identity, gender expression, age, disability, genetic information, ethnic or national origin, marital status, veteran status, or any other status protected by law. Equal Opportunity Employer. EOE Minorities/ Females/ Protected Veterans/ Disabled
Job: *Information Technology
Title: Business Systems Analyst
Requisition ID: 1808099