KASHII UPDATEZ Everyday Student Requirements & Python Coding Tutorials by Python Kashi
JD #2396
Applications open Internship

Data Analyst

Blue Matter Consulting

  • Gurgaon, India / Pune, India
  • β‚Ή5 LPA – β‚Ή7 LPA per annum (typical entry‑level analyst package in the life‑sciences consulting space
  • Fresher (0-1 Yrs)
  • Posted Oct 29, 2026
HR
Recruiter contact
Recruiter / hiring contact
No public email in this post. Use a source-linked contact instead.

About the role

Blue Matter Consulting is a fast‑growing management consultancy that specializes in the biopharmaceutical sector. With eight global offices spanning Gurgaon, Mumbai, Pune, Zurich, London, Berlin, New York and San Francisco, the firm helps life‑science companies bring life‑saving therapies to market. Its culture is built on curiosity, integrity and collective excellence, and the firm lives by four core values – Speak the Truth, Solve for So What, Stay Curious and Win Together. These values shape every client interaction, internal collaboration and career progression. The Analytics Associate role sits at the heart of Blue Matter’s data‑driven decision‑making engine. Reporting to senior consultants, the associate works on high‑visibility projects that address commercial challenges in oncology, rare diseases, immunology and other therapeutic areas. The position is not a rote number‑crunching job; it demands a blend of analytical rigor, business acumen and storytelling. Associates are expected to dive deep into multi‑source datasets, surface hidden insights, and translate those insights into actionable recommendations that directly influence client strategy. Key responsibilities include: 1. Research therapy areas, competitive landscapes and market dynamics to become the client’s trusted subject‑matter expert. 2. Clean, merge and analyse complex datasets using SQL, Python, R or Excel, flagging anomalies and data‑quality issues promptly. 3. Develop and maintain visual dashboards and slide decks in Tableau, PowerBI or PowerPoint that clearly articulate the "So What?" behind every chart. 4. Propose and pilot new analytical tools, AI‑driven methods and automation techniques to improve efficiency. 5. Present findings to senior consultants and client stakeholders, challenging assumptions when evidence dictates. 6. Collaborate with on‑shore and off‑shore team members, sharing knowledge and supporting peers during tight deadlines. 7. Participate in internal reviews, incorporate feedback, and continuously refine analytical approaches. 8. Document methodology, assumptions and limitations to ensure reproducibility and transparency. The tech stack typically includes SQL, Python/R, Excel, Tableau/PowerBI, and Alteryx. A solid foundation in statistics and quantitative reasoning is essential, while exposure to the US pharmaceutical market is a plus. The growth path is clearly defined: Analyst β†’ Associate Consultant β†’ Consultant β†’ Senior Consultant β†’ Manager β†’ Associate Principal β†’ Principal, with merit‑based promotions and opportunities to lead cross‑functional project teams. Why join Blue Matter? You will work on mission‑critical projects that directly impact patient outcomes, gain T‑shaped expertise across analytics and life‑science strategy, and be part of a globally distributed, flat‑hierarchy team where every voice matters. The firm’s commitment to continuous learning, mentorship and transparent career progression makes it an ideal launchpad for ambitious fresh graduates seeking a meaningful career in data‑driven consulting.

Eligibility & process

Who can apply

BE/BTech/BS/MTech/MS in Statistics, Mathematics, Engineering, Data Science or related quantitative field; Minimum 60% aggregate (or CGPA 6.0/10); No active backlogs at the time of joining; Graduation batch 2025‑2027 acceptable; Strong analytical mindset and proficiency in at least one analytical tool (SQL, Python, R, Excel, Alteryx).

Skills & stack

SQL Python Advanced Excel Tableau Power BI Alteryx Data Cleaning Statistical Analysis

Selection process

  1. Round 1: Online aptitude & logical reasoning test
  2. Round 2: Technical interview (SQL/Python/analytics case)
  3. Round 3: HR interview (fit & cultural alignment)

Prep kit

20 resources
Study material 4
Company-specific guides 4
Likely coding questions 4
Round-wise strategy 4
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 (SQL, Python, Advanced Excel, Tableau, Power BI, Alteryx, Data Cleaning, Statistical Analysis) & 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 Blue Matter Consulting Core Values, Learning Agility & Offer Terms Demonstrate passion, strong communication, and readiness for full-time collaboration.
Technical questions 5
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.
Behavioural & HR questions 3
Why do you want to join Blue Matter Consulting as a Data Analyst?
Highlight Blue Matter Consulting's market reputation, recent tech innovations, and how your skills in SQL directly solve their team's objectives.
Describe a challenging bug or academic project roadblock and how you resolved it.
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?
Explain your prioritization strategy, proactive communication with mentors/peers, and agile mindset.
Blue Matter Consulting β‚Ή5 LPA – β‚Ή7 LPA per annum (typical entry‑level analyst package in the life‑sciences consulting space
Recruiter Resume Apply
Chat Chat with Kashii