KASHII UPDATEZ Everyday Student Requirements & Python Coding Tutorials by Python Kashi
JD #3653
Applications open Full-Time Job

Data Analyst - Power BI

Yash

  • Pune
  • 4.5 LPA
  • Fresher (0-1 Yrs)
  • 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 fast‑growing global IT services and consulting firm headquartered in India. With a presence in more than 30 countries, the company delivers end‑to‑end digital transformation solutions across industries such as Banking, Healthcare, Pharma, and Retail. Yash prides itself on a culture of continuous learning, innovation, and client‑first mindset, which has helped it secure partnerships with Fortune‑500 enterprises and earn multiple industry accolades.

In the past few years, Yash has heavily invested in data‑driven services, building a dedicated analytics practice that helps clients turn raw data into actionable insights. The firm’s analytics wing works with cutting‑edge platforms like Snowflake, Power BI, and advanced Excel modeling to deliver dashboards, predictive models, and strategic recommendations. This focus on data excellence makes Yash an attractive destination for fresh talent eager to dive deep into the world of business intelligence.

The role of Data Analyst – Power BI at Yash Technologies is designed for fresh graduates who are passionate about turning data into visual stories. You will be responsible for end‑to‑end implementation of analytics solutions, from data extraction and modeling to creating interactive dashboards that drive business decisions. Working closely with senior analysts and domain experts, you will gain exposure to real‑world projects in the Pharma sector, which is a plus for candidates looking to specialize in a regulated industry.

Key Responsibilities

  • Design, develop, and maintain scalable Power BI dashboards and reports.
  • Build robust data models using SQL and Snowflake, ensuring data integrity and performance.
  • Perform data cleaning, transformation, and enrichment using Power Query and Excel.
  • Write DAX measures and calculations to support complex business logic.
  • Collaborate with business stakeholders to gather requirements and translate them into technical specifications.
  • Conduct ad‑hoc analysis and generate insights that influence strategic decisions.
  • Automate repetitive reporting tasks to improve efficiency.
  • Follow Agile methodologies, participate in sprint planning, and deliver incremental value.
  • Stay updated with the latest BI trends and propose innovative solutions.
  • Ensure documentation of data pipelines, dashboards, and best practices.

Tech Stack: SQL, Snowflake, Microsoft Excel, Power BI (including DAX and Power Query), PowerPoint, Agile tools.

Growth Path: Starting as a Junior Data Analyst, you can progress to Senior Analyst, then to BI Lead, and eventually to Analytics Manager or Solution Architect, depending on performance and continuous learning.

Why Join Yash Technologies? You will work in a collaborative environment that encourages experimentation, receive mentorship from industry veterans, and get hands‑on experience with enterprise‑grade BI tools. The company’s commitment to employee upskilling, coupled with a competitive salary of 4.5 LPA, makes it an ideal launchpad for a rewarding analytics career.

Eligibility & process

Who can apply

Graduates (B.Tech/B.E., B.Sc, B.Com or equivalent) from any stream with a minimum of 60% aggregate. Freshers from the 2025, 2026 or 2027 batch are eligible. No active backlogs at the time of joining. Strong analytical mindset and basic knowledge of SQL/Excel is preferred.

Skills & stack

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

Selection process

  1. Round 1: Aptitude Test
  2. Round 2: Technical Interview (SQL, Power BI, 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 (SQL, Snowflake, Microsoft Excel, Power BI, 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 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 as a Data Analyst - Power BI?
Highlight Yash'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.
Yash 4.5 LPA
Recruiter Resume Apply
Chat Chat with Kashii