KASHII UPDATEZ Everyday Student Requirements & Python Coding Tutorials by Python Kashi
KashiiUpdatez
REQUIREMENT_ID_93 โ€ข 3-DAY_ACTIVE_POLICY

Associate Data Analyst - Global Procurement & Planning COE

Company
Company Tevvity
Type
Opportunity Type Full-Time Job
Salary
Stipend / Salary 5 LPA
Location
Location Thฤne, India
Posted Date
Posted Date Today
SAP ECC SAP S/4HANA Microsoft Excel Power BI Tableau SQL Data Analysis Data Visualization Business Analytics Communication
๐Ÿ“–
Aptitude and Reasoning Practice Open Resource โ†—
Helps you sharpen quantitative and logical reasoning skills essential for the first interview round at Revvity.
๐Ÿ“–
Technical Interview Preparation Guide Open Resource โ†—
Covers common dataโ€‘analytics and SQL questions that are frequently asked in Revvity technical interviews.
๐Ÿ“–
Comprehensive Interview Coaching Open Resource โ†—
Provides interview strategies, mock questions and HR round tips useful for Revvity's selection process.
๐Ÿ“–
Coding and Problemโ€‘Solving Practice Open Resource โ†—
Offers a wide range of SQL and dataโ€‘manipulation problems to practice for technical assessments at Revvity.

Bachelor's degree in Supply Chain, Engineering, Statistics, Business Analytics, Information Technology, Mathematics or related field; minimum 60% aggregate (or CGPA 6.0/10); graduating batch 2022โ€‘2025; no active backlogs at the time of joining; internships or project work in data analysis is a plus.

1
Round 1: Aptitude & Logical Reasoning test
2
Round 2: Technical/Data Analytics interview (SQL, Excel, Power BI/Tableau)
3
Round 3: HR interview (fit and motivation)
Revvity is a global leader in life sciences, diagnostics and applied genomics, serving more than 190 countries. With a workforce of over 11,000 professionals, the company builds endโ€‘toโ€‘end solutions that help scientists, clinicians and researchers tackle the worldโ€™s toughest health challenges. Its portfolio spans newborn screening, oncology, immunology, reproductive health and many other critical domains, making Revvity a trusted partner for hospitals, research labs and biotech firms worldwide. The organizationโ€™s culture blends the agility of a disruptive startโ€‘up with the stability of a seasoned industry player, encouraging innovation while maintaining rigorous quality standards. The Associate Data Analyst โ€“ Global Procurement & Planning COE will be part of the Customer Operations team, supporting dataโ€‘driven decisionโ€‘making across order fulfillment, supply chain, logistics and customer care. This earlyโ€‘career role offers a fastโ€‘track learning curve, exposing the analyst to SAP ECC/S/4HANA, Power BI/Tableau dashboards and crossโ€‘functional collaboration with planning, procurement, manufacturing and logistics teams. The analyst will turn raw operational data into actionable insights that directly influence service levels, inventory health and overall customer satisfaction. Key Responsibilities: 1. Collect, clean, validate and analyse data from SAP ECC/S/4HANA and other enterprise systems. 2. Build and maintain operational dashboards and reports using Power BI or Tableau. 3. Monitor key performance indicators across supply chain, order fulfillment, inventory and customer service. 4. Identify trends, anomalies and improvement opportunities, presenting findings to global stakeholders. 5. Document and map orderโ€‘fulfillment and supplyโ€‘chain processes in line with Revvity standards. 6. Support rootโ€‘cause analysis and recommend corrective actions for process bottlenecks. 7. Ensure data accuracy across reporting databases and assist in SAP data extraction. 8. Participate in digital transformation projects, contributing analytical expertise. 9. Collaborate with planning, procurement, logistics, customer service and manufacturing teams. 10. Stay updated on industry trends, analytics tools and emerging technologies such as AI and automation. Tech Stack: SAP ECC / S/4HANA, Microsoft Excel (Pivot, Power Query, VLOOKUP/XLOOKUP), Power BI, Tableau, SQL (basic), Microsoft Office Suite. Growth Path: Starting as an Associate Analyst, high performers can progress to Senior Data Analyst, Business Intelligence Lead, or Functional Analyst roles within the Global Procurement & Planning COE, eventually moving into managerial positions overseeing analytics strategy for the entire supplyโ€‘chain ecosystem. Why Join Revvity? You will work on data that directly impacts patient outcomes and scientific breakthroughs, gain exposure to cuttingโ€‘edge lifeโ€‘science technologies, and develop a robust analytical skill set in a supportive, innovationโ€‘driven environment.

Tevvity โ€” Data Analytics & SQL Interview Guide

Previously asked questions, exam syllabus, coding benchmarks & round strategy.

APTITUDE & LOGIC ๐Ÿ“–
Aptitude Practice Questions & Online Mock Tests

Curated logical, quantitative, and verbal reasoning problems to sharpen reasoning skills required for the initial screening test.

Open Resource โ†—
COMPANY GUIDE ๐ŸŽฏ
Tevvity Interview Preparation Corner

Comprehensive guide covering typical interview formats, common questions, and preparation tips for Tevvity and off-campus tech roles.

Open Resource โ†—
MOCK TESTS & PAPERS ๐Ÿ“
Comprehensive Interview Prep Resources & Syllabus

Collection of previous year questions, company-specific test patterns, and interview experiences for technical and HR rounds.

Open Resource โ†—
CODING PRACTICE ๐Ÿ’ป
Algorithm and Data Structure Problem Set

Practice problems to improve coding proficiency and algorithm problem-solving speed for technical rounds.

Open Resource โ†—
Round 1: Online Assessment (OA)
Aptitude, Quantitative Logic & 2 Coding Problems
Focus on accuracy and speed. Practice arrays, strings, and standard arithmetic puzzles.
Round 2: Technical Interview 1
Core Tech Stack (SAP ECC, SAP S/4HANA, Microsoft Excel, Power BI, Tableau, SQL, Data Analysis, Data Visualization, Business Analytics, Communication) & Live Code Tracing
Explain your thought process aloud. Analyze time & space complexities before coding.
Round 3: System Design & Problem Solving
Database Schemas, APIs & Architecture Basics
Clarify edge cases, diagram schemas cleanly, and discuss scalability trade-offs.
Round 4: HR & Cultural Fit Discussion
Tevvity Core Values, Learning Agility & Offer Terms
Demonstrate passion, strong communication, and readiness for full-time collaboration.
What is the difference between WHERE and HAVING clauses in SQL? Answer โ–ผ
Model Answer: WHERE filters rows before any groupings are applied, while HAVING filters aggregated groups after GROUP BY has executed.
Explain SQL Window functions: ROW_NUMBER(), RANK(), and DENSE_RANK(). Answer โ–ผ
Model Answer: ROW_NUMBER() assigns unique sequential integers. RANK() assigns identical ranks to ties and skips ranks. DENSE_RANK() assigns identical ranks to ties without skipping rank numbers.
How do you handle NULL and missing values during data cleaning in Python/Pandas? Answer โ–ผ
Model Answer: Use .isna().sum() to identify missing values. Impute with mean/median using .fillna() or remove with .dropna(subset=[...]) depending on variance impact.
What is the difference between Star Schema and Snowflake Schema in Data Warehousing? Answer โ–ผ
Model Answer: Star Schema has denormalized dimension tables directly connected to the central Fact table. Snowflake Schema normalizes dimension tables into sub-dimensions to minimize redundancy.
How do you calculate MoM (Month-over-Month) growth in SQL? Answer โ–ผ
Model Answer: Use LAG(revenue, 1) OVER (ORDER BY month) to fetch the previous month's revenue and compute (revenue - prev_revenue) / prev_revenue * 100.
Why do you want to join Tevvity as a Associate Data Analyst - Global Procurement & Planning COE?
Preparation Tip: Highlight Tevvity's market reputation, recent tech innovations, and how your skills in SAP ECC directly solve their team's objectives.
Describe a challenging bug or academic project roadblock and how you resolved it.
Preparation Tip: Use the STAR method: Situation (project context), Task (what needed solving), Action (specific tools/logic applied), Result (quantifiable positive outcome).
How do you handle strict deadlines or sudden scope changes?
Preparation Tip: Explain your prioritization strategy, proactive communication with mentors/peers, and agile mindset.

More Fresh Requirements in Software Engineering

View Category Feed โ†—
Tevvity
Associate Data Analyst - Global Procurement & Planning COE
Apply Apply Now โ†—
Chat Chat with Kashii