Home
Jobs

Immediate openings For business analyst

5 - 9 years

5 - 8 Lacs

Posted:3 days ago| Platform: Naukri logo

Apply

Work Mode

Work from Office

Job Type

Full Time

Job Description

Project Process Description

Business Analyst is part of the Food and Transport support team who supports in fulfilling REWS movement requests (domestic and international) through the product lifecycle keeping in mind country specific regulations. Liaising with larger operations teams around EMEA and APAC is a key responsibility. Additionally, they support managing clients Transportation, Health & Performance and Events programs support tasks.

Candidate Qualification

Relevant Experience and Minimum # of Years/ Months

5-8 years of experience in Food, Transportation, Fitness industry, Event management, vendor management

Core Competencies

  • High school graduate or equivalent
  • Advance MS-Excel, Google Spreadsheets,
  • Familiar with spreadsheets, stock management, budgeting, forecasting and PO management, vendor management
  • Experience in Hospitality, logistics industry, vendor management, FMCG industry.
  • Comfortable with a rapidly changing environment
  • Experience with Google eco systems and ERP tools. Generating summary reports using multiple Excel sheets or Google spreadsheets.

Excellent interpersonal and communication skills with the ability to operate and communicate effectively with people at all levels of the business

Skills

Advanced MS Excel (or Google Spreadsheet), MS PowerPoint (Google Slides), Data Analytical skills, visualization and report creation skills, slide preparation .

Role & Responsibilities

Create/prepare/review/update/monitor major operational tools for Workplace Programs execution

Listed below but not limited to:

  • Creating reports using multiple spreadsheets
  • Creating data reports, charts, graphs and Google slide decks
  • Hands on experience on Google slides or MS PowerPoint
  • Monthly Management Reports and templates using Google spreadsheets
  • Various templates using sheets, slides, docs and forms
  • Event planning sheets
  • Action item templates
  • Forms, sites
  • Monitoring and Maintenance of program stats
  • Managing Google Groups or other Google ECO systems
  • Auditing of budgets spends against the forecasts and actuals budgets
  • Support client stake holders and coordinating internal resources and third parties/vendors for the flawless execution of projects

Ensuring that all projects are delivered on-time, within scope

Technical skills :

Google Sheets and Excel Formulas Expertise

  • Core Formulas:


Arithmetic operations (SUM, AVERAGE, COUNT, MIN, MAX)

Logical functions (IF, AND, OR, NOT)

Text functions (LEFT, RIGHT, MID, CONCATENATE, LEN, TRIM, LOWER, UPPER, PROPER)

Date and Time functions (TODAY, NOW, DAY, MONTH, YEAR, DATEDIF)

Lookup and Reference functions (VLOOKUP, HLOOKUP, INDEX, MATCH)

  • Intermediate Formulas:


Conditional aggregation (SUMIF, SUMIFS, COUNTIF, COUNTIFS, AVERAGEIF, AVERAGEIFS)

Array formulas (ARRAYFORMULA, UNIQUE, SORT, FILTER)

Data validation with formulas (ISNA, ISBLANK, ISERROR)

Named ranges

  • Advanced Formulas:


QUERY function for complex data manipulation

IMPORTRANGE for linking data between sheets

Nested formulas for advanced logic (e.g OFFSET + INDEX+MATCH)

  • Problem-Solving & Efficiency:


Debugging formula errors

Optimizing formulas for performance

Creating dynamic and robust spreadsheets

Understanding relative and absolute references

Using keyboard shortcuts for formula entry and editing

Data clean up

Data quality check and Data validation check

Create an auto process of dealing data, summarized report can be updated automatically

Excel Power Query

  • Merge and clean data from different sheets or files
  • Populated data template can be auto refreshed

MS PowerPoint or Google slides

  • Should have knowledge to create slide decks and visualization skills

Functional and Business analyst skills

  • Project management (Timeline, stakeholders interaction, business communication, Independent to attend with the clients and vendor partners etc.)
  • Requirements gathering
  • Identify requirements with business uses
  • Transfer business requirements to technical requirements
  • Excellent interpersonal and communication skills with the ability to operate and communicate effectively with people at all levels of the business
  • Support Google PgMs coordinating internal resources and vendor partners for the flawless execution of projects

The following are good to have skills but not mandatory

Google PLX platforms (Plx dashboard, Plx table)

  • Data clean up, data transformation and data visualization

SQL:

  • Exposure on data extraction skill from database
  • Combine data from multiple tables
  • Filter and sort data
  • Aggregate data (e.g., SUM, COUNT, AVG)
  • Insert new data
  • Update existing data
  • Delete data

Mock Interview

Practice Video Interview with JobPe AI

Start Food Interview
cta

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.

Job Application AI Bot

Job Application AI Bot

Apply to 20+ Portals in one click

Download Now

Download the Mobile App

Instantly access job listings, apply easily, and track applications.

coding practice

Enhance Your Skills

Practice coding challenges to boost your skills

Start Practicing Now
Cognizant
Cognizant

IT Services and IT Consulting

Teaneck New Jersey

RecommendedJobs for You