BAT is evolving at pace into a global multi-category business. Our purpose is to create A Better Tomorrow by Building a Smokeless World.
To achieve our ambition, we are looking for colleagues who are ready to join us on this journey! Tomorrow cant wait, lets shape it together!
British American Tobacco Indonesia has an exciting opportunity for a FMC Trade Analytics Officer in Jakarta
Your Key Responsibilities Will Include
Compile, validate and distribute the FMC weekly performance tracker (volume, value, coverage, efficiency) for all conventional cigarette brands by balancing source data (in-market sales, accounts offtake, industry and competitors report) and resolving any discrepancies.
Continuously optimize data ingestion and processing workflows by building and maintaining ETL processes using Excel, Power Pivot, VBA/macros
Prepare and structure presentation decks with up-to-date charts and trends for weekly ad-hoc reviews including a value-adding narrative structure on highlights and key takeaways
Help define and monitor FMC launch and performance KPIs in collaboration with commercial planning and brand teams by delivering ad-hoc analyses (e.g., outlet-level diagnostics, promotional uplift measurement) as needed.
Provide cross-functional support by acting as a data champion within Sales, Account Management and Brand Deployment, providing technical support on reporting platforms
What are we looking for
Bachelors degree (any subject area); related fields a plus. Strong Excel (Power Pivot, pivot tables, VBA/macros) and Power BI experience. Familiarity with SQL, Python, R and/or Tableau is advantageous.
Minimum 1 year experience with familiarity in trade data. Having tobacco/FMCG experience is an added advantage.
Strong analytical skills, meticulous with a knack for accuracy in slide preparation
Excellent communication and storytelling (narration) skills; able to translate data trends into clear narrative elements with action plans/strategies.
Proactive, collaborative and able to prioritize multiple tasks in a dynamic environment
What we offer you
We offer a market leading annual performance bonus (subject to eligibility)
Our range of benefits varies by country and includes diverse health plans, initiatives for work-life balance, transportation support, and a flexible holiday plan with additional incentives
Your journey with us isn&apost limited by boundaries; it&aposs propelled by your aspirations. Join us at BAT and become a part of an environment that thrives on internal advancement, where your career progression isn&apost just a statement it&aposs a reality we&aposre eager to build together. Seize the opportunity and own your development; your next chapter starts here.
You&aposll have access to online learning platforms and personalized growth programs to nurture your leadership skills
We prioritise continuous improvement within a transformative environment, preparing for ongoing changes
WHY JOIN BAT
Were one of the few companies named as a Global Top Employer by the Top Employers Institute certified in offering excellent employee conditions.
Collaboration, inclusion and partnership underpin everything we do here at BAT. We are looking forward to enabling every individual to thrive, regardless of gender, sexual orientation, marital or civil partnership status, gender reassignment, race, religion or belief, colour, nationality, ethnic or national origin, disability, age, skills, experience, education, socio-economic and professional background, veteran status, perspectives and thinking styles. We know that embracing talent from all backgrounds is what makes us stronger and best prepared to meet our business goals.
We see the career breaks as opportunities not obstacles. Through The Global Returners program, we support professionals looking to restart their careers after an extended absence from the workforce (e.g. time out caring for family, parental leave, national service, sabbatical and/or starting an own venture).
Come bring your difference and see what is possible for you at BAT. Learn more about our culture and our award winning employee experience here.
If you require any reasonable adjustments or accommodations to help you perform at your best during the recruitment process, you are encouraged to notify us. We are fully committed to support you by making appropriate arrangements for you to demonstrate your full potential.
