FMC Trade Analytics Officer

The British American Tobacco Group; Daerah Khusus Ibukota Jakarta; On-site; IDR 200.000.000 - 300.000.000; Full time

Job summary

A leading company is seeking a FMC Trade Analytics Officer in Jakarta, where you'll be responsible for analyzing trade data, optimizing workflows, and supporting brand teams with key performance metrics. If you're skilled in Excel, Power BI, and have a strong analytical mindset, this role offers an excellent opportunity for career progression within a global leader in the industry.

Benefits

Market leading annual performance bonus

Diverse health plans

Work-life balance initiatives

Transportation support

Flexible holiday plan

Qualifications

• Bachelor’s degree in any subject area; related fields a plus.
• Minimum 1 year experience in trade data.
• Strong analytical skills with attention to detail.

Responsibilities

• Compile and distribute FMC weekly performance tracker for all brands.
• Optimize data ingestion with ETL processes using Excel and VBA.
• Prepare presentation decks for weekly reviews.

Skills

Excel

Power BI

SQL

Python

R

Tableau

Analytical Skills

Communication Skills

Education

Bachelor's degree

Job description

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 can’t wait, let’s 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?

• Bachelor’s 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't limited by boundaries; it's 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't just a statement – it's a reality we're eager to build together. Seize the opportunity and own your development; your next chapter starts here.
• You'll 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?
We’re 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.