Analytical Insights Specialist

1 week ago

Pune, Maharashtra, India beBeeRetailAnalyst Full time ₹ 15,00,000 - ₹ 28,00,000

Job Summary:

We are seeking a highly skilled Data Analyst to join our team.

The successful candidate will be responsible for leading the royalty settlements process and associated 3rd party extracts, working closely with various teams to run reporting & billing calculations related to scan rebates and dedication promotions.

Key Responsibilities:

  • Review and set-up of new vendors in systems for rebate billing purposes.
  • Oversight and final reporting of the disqualification site list for sites not following 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 site list for Global Business Services (GBS) 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 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 Company Owned Franchise Operated (COFO) 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 technology team.
  • Monthly scan rebate and loyalty validation with the Category Management team to verify accuracy and resolve billing source.
  • 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 Master Site Control Office/Corporate Office Center Office (MSCO/COCO) ampm sites. Format and send to 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.

Requirements:

  • 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.

  • Data Insights Specialist

    2 weeks ago

    Pune, Maharashtra, India beBeeDataInsightsSpecialist Full time ₹ 9,00,000 - ₹ 12,00,000

    Job Role - Data Insights SpecialistWe are seeking an accomplished Data Insights Specialist to contribute to our data-driven initiatives. The ideal candidate will possess 3-5 years of experience in data analysis and a solid understanding of SQL, Python, and Power BI.Main Responsibilities:Data Extraction and Analysis: Proficient in SQL for data extraction,...

  • Pipeline Analytics Specialist

    2 weeks ago

    Pune, Maharashtra, India beBeeOncology Full time ₹ 15,00,000 - ₹ 20,00,000

    Senior Specialist Oncology Global Commercial Pipeline AnalyticsAs a Senior Specialist in Oncology Global Commercial Pipeline Analytics, you will partner closely with cross-functional teams to drive innovation and excellence in the oncology pipeline.Key Responsibilities:Develop analytics capabilities to support strategic decision-making for the Global...

  • Data Insights Specialist

    2 weeks ago

    Pune, Maharashtra, India beBeeDataInsights Full time ₹ 15,00,000 - ₹ 25,00,000

    Job Title: Data Insights SpecialistWe are seeking a highly skilled Data Insights Specialist to join our team. As a key member of our analytics group, you will play a critical role in driving business growth through data-driven insights.The ideal candidate will have experience working with StreamSets pipeline development and data integrations with AI tools...

  • Data Insights Specialist

    1 week ago

    Pune, Maharashtra, India beBeeDataInsights Full time ₹ 1,50,00,000 - ₹ 2,00,00,000

    Job Title: Data Insights SpecialistWe are seeking a highly skilled professional to lead our big data initiatives.The ideal candidate will have a strong background in analytics and experience with technologies such as PySpark, Hive, Spark, HBase, and DQ tools.Key responsibilities:Design and implement scalable big data solutions using PySpark, Hive, and...

  • Data Insight Specialist

    1 week ago

    Pune, Maharashtra, India beBeeInsight Full time US$ 1,05,000 - US$ 1,64,960

    Data Insights SpecialistWe are seeking a highly skilled Data Insights Specialist to join our global finance team. As a key member of this team, you will play a critical role in driving outstanding financial management and fact-based decision-making throughout the enterprise.The successful candidate will have excellent analytical skills, with the ability to...

  • Supply Chain Analytics Specialist

    2 weeks ago

    Pune, Maharashtra, India beBeeData Full time ₹ 1,04,000 - ₹ 1,30,878

    Job OverviewThe Supply Chain Analytics Specialist is responsible for leveraging data insights to drive strategic decision-making in supply chain operations.Key ResponsibilitiesAnalyze complex data sets to inform supply chain optimization strategies.Develop and implement predictive analytics models to forecast demand and improve inventory...

  • Senior Oncology Analytics Specialist

    2 weeks ago

    Pune, Maharashtra, India beBeeDataAnalytics Full time ₹ 15,00,000 - ₹ 20,00,000

    Job Title:">The role of the Senior Oncology Analytics Specialist is to spearhead the development and delivery of data-driven insights, strategic recommendations, and key business questions for the Global Oncology New Products Marketing team.">This position will be responsible for collaborating closely with cross-functional teams, including global marketing,...

  • Pharmaceutical Data Insights Specialist

    2 weeks ago

    Pune, Maharashtra, India beBeeDataDriven Full time ₹ 15,00,000 - ₹ 20,00,000

    This role is ideal for an ambitious professional with a passion for leveraging data insights to drive business growth in the pharmaceutical industry.As an Associate Specialist, you will play a critical part in supporting the development of analytics capabilities for the pharma pipeline in assigned therapeutic areas. You will work closely with global...

  • Data Insight Specialist

    1 week ago

    Pune, Maharashtra, India beBeeInsight Full time ₹ 9,00,000 - ₹ 12,00,000

    About UsAt H.E. Services, we strive to invest in people and processes that support our customers. Our goal is to develop innovative solutions that drive success.Job DescriptionWe are looking for a skilled Data Insight Specialist to join our team. In this role, you will be responsible for analyzing data to identify trends and patterns, and providing insights...

  • Kuwait Data Insights Specialist

    2 weeks ago

    Pune, Maharashtra, India beBeeDataInsights Full time US$ 90,000 - US$ 1,20,000

    We are seeking a Data Insights Specialist to join our team.This role is based in Kuwait and involves working with large datasets to provide critical insights that drive business decisions.Analyze data from various sources, including customer lifecycle activities, to identify trends and patterns.Create reports and dashboards using data analytics tools, such...