Immediate openings For business analyst
- Cognizant
- 5 - 9 years
- Hyderabad
- 3 days ago
- Email to a friend
- Report this job
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
Job Classification
Industry: BPM / BPOFunctional Area / Department: Sales & Business DevelopmentRole Category: BD / Pre SalesRole: Merchant Acquisition - BD / Pre SalesEmployement Type: Full timeContact Details:
Company: CognizantLocation(s): Hyderabad
Keyskills: Transportation REWS vendor management Event Management Fitness industry Food
Similar positions
Job Listings
We are in open beta version of website, please let us know if any issues, at: info(at)indigojobs.in