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

Data Analyst - Power BI

Yash Technologies

  • Pune
  • 4.5 LPA
  • 2 Years
  • Posted Today
HR
Recruiter contact
Recruiter / hiring contact
No public email in this post. Use a source-linked contact instead.

About the role

YASH Technologies is a global technology integrator that helps enterprises re‑imagine their operating models, cut costs, and deliver superior stakeholder experiences. With a strong footprint in India and a client base spanning banking, healthcare, retail, and manufacturing, YASH has built a reputation for delivering end‑to‑end digital transformation projects. The company’s culture is anchored on continuous learning, collaborative problem‑solving, and a commitment to ethical business practices.

Employees enjoy a hyper‑learning environment where up‑skilling is encouraged through internal academies, certifications, and real‑world project exposure.

The Data Analyst – Power BI role is designed for fresh talent with 1‑2 years of experience who can translate complex business problems into actionable insights. As a member of the analytics team, you will partner with clients and internal stakeholders to gather requirements, design scalable data solutions, and build interactive visualizations that drive decision‑making. You will own the end‑to‑end lifecycle of Power BI deliverables, from data ingestion and modeling to dashboard deployment and performance tuning.

Key Responsibilities

  • Collaborate with business users to understand reporting needs and translate them into technical specifications.
  • Design, develop, and maintain Power BI dashboards, reports, and data models using DAX and Power Query.
  • Perform data extraction, transformation, and loading (ETL) using SQL and Snowflake.
  • Create interactive visualizations and drill‑through capabilities to enable self‑service analytics.
  • Develop and document business logic, calculations, and KPI definitions.
  • Conduct data validation and quality checks to ensure accuracy of insights.
  • Optimize report performance and implement best practices for data modeling.
  • Participate in Agile ceremonies, provide status updates, and adapt to changing priorities.
  • Mentor junior analysts and share knowledge on Power BI and data‑analytics best practices.
  • Stay updated with emerging BI tools and suggest automation opportunities.

Tech Stack: Power BI, SQL, Snowflake, Excel, DAX, Power Query, PowerPoint, Agile methodologies.

Growth Path: Starting as a Data Analyst, you can progress to Senior Analyst, BI Lead, or Solution Architect, with opportunities to specialize in data engineering, advanced analytics, or domain expertise (e.g., Pharma). YASH’s internal learning platform and mentorship programs accelerate career growth.

Why Join YASH: The company offers flexible work arrangements, a supportive learning ecosystem, and exposure to diverse industry projects. You will work alongside seasoned technologists, gain hands‑on experience with cutting‑edge BI tools, and contribute to high‑impact business transformations. If you are passionate about turning data into strategic value, YASH provides the platform to grow both technically and professionally.

Eligibility & process

Who can apply

Graduates (B.Tech/B.E., B.Sc., B.Com) in Computer Science, Information Technology, Electronics, or related streams. Minimum 60% aggregate (or CGPA 6.0/10). Freshers or candidates with up to 2 years of relevant experience. Must belong to the 2024‑2026 batch. No active backlogs at the time of joining.

Skills & stack

Power BI SQL Snowflake Advanced Excel DAX Power Query Data Modeling Business Analytics

Selection process

  1. Round 1: Aptitude Test
  2. Round 2: Technical Interview (Power BI, SQL, case study)
  3. Round 3: HR Interview

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 (Power BI, SQL, Snowflake, Advanced Excel, DAX, Power Query, Data Modeling, Business Analytics) & 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 Yash Technologies 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 Yash Technologies as a Data Analyst - Power BI?
Highlight Yash Technologies's market reputation, recent tech innovations, and how your skills in Power BI 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.
Yash Technologies 4.5 LPA
Recruiter Resume Apply
Chat Chat with Kashii