Immediate openings For business analyst Cognizant

5.0 - 9.0 years

5 - 8 Lacs

Hyderabad

Work from Office

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

Posted 1 day ago

Apply

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.