Retail Data Expert

The primary responsibility of this role is to provide technical, analytical, and reporting support to the West Coast ampm Retail business. The incumbent will be responsible for leading the royalty settlements process and associated third-party extracts.

This role involves working closely with various teams, including Category Management, Finance, Technology, Price Book, and GBS teams, to run reporting and billing calculations related to scan rebates and dedication promotions. The individual will ensure that the monthly consolidated business statement is accurate and published timely.

• Review and setup of new vendors in BP systems for rebate billing purposes.
• Oversight and final reporting of the disqualification site list for sites not following ampm guidelines.
• Engage with Collaborators to set up review of payments made and create a report and dashboard to have a view of payments.
• Identify trends and deficiencies for process work redundancies and improve efficiency.
• Setup review with customers to resolve queries and discrepancies.
• Act as a domain guide of process delivering knowledge and insight to continuously improve process.
• Monthly reformatting of the ampm site list for the GBS (BP Global Business Services) to process tobacco payouts.
• Coordination of site ATM commission reporting from various sources, aggregation of data into a single monthly report, and supplying the final report to the BP technology team for sales/royalty fee adjustment.
• Work closely with the Order Fulfillment team to assist in Order to Cash workflow.
• Monthly calculation of site eligibility for the COFO (Company Owned Franchise Operated) incentive/royalty reduction program.
• Review of bi-monthly promotional rates and deals with the Price Book team to verify accuracy.
• Weekly review and verification of scan rebate system reporting accuracy and coordination of any needed corrections with the BP Technology team.
• Monthly scan rebate and loyalty validation with the BP Category Management team to verify accuracy and resolve billing source (i.e., vendor or BP ad fund).
• Review, verify for completeness, and maintain monthly manufacturer rebate billing file.
• Pull and/or prepare monthly scan and dedication supporting data for vendor billing by GBS.
• Prepare monthly Other Payments File for payment of rebates and/or other marketing funds to Marathon.
• Prepare monthly item/site level scan reporting for MSCO/COCO (BP owned) ampm sites. Format and send to BP Finance for accounting application.
• Download, reformat, and upload net sales, tobacco & scan transactional level promotion detail into SAP monthly.
• Provide weekly transactional sales data for all tobacco products to Altria and RJR in a format designated by each supplier.
• Processing of the weekly open items report to track paid/unpaid items.

• Overall 8 to 10 years of experience and At least 3 years of Retail sales or marketing analytical experience.
• Strong analytical and problem-solving skills.
• The ability to find and manipulate sophisticated data from several different reporting systems, identify/fix irregularities or errors, and provide insights.
• Collaborator engagement and incident management.
• Good communication skills and ability to disseminate relevant information.
• Calendar focused, meeting reporting timelines and ensuring data integrity.
• Someone who looks for process standardization and simplification.
• A self-starter and autonomous worker.
• Creative approach and problem solver.
• Intermediate to advanced knowledge and usage of Excel (Xlookup (preferred) or VLOOKUP, understanding of pivot tables, VBA (basic-intermediate), power query/pivot.
• Intermediate experience with SAP and AWS (Data Warehouse).
• Intermediate to advanced Power BI skills.

This role offers a challenging and rewarding career path with opportunities for growth and development.

The successful candidate will have the opportunity to work with a dynamic team and contribute to the success of the organization.