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

Data Analyst - Power BI

Yash Technologies

  • Pune, IN
  • 4.5 LPA
  • 2 Years
  • Posted Nov 08, 2026
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 leading technology integrator in India, known for helping enterprises re‑imagine their operating models, boost competitiveness, and drive digital transformation. With a strong focus on innovation, YASH serves clients across multiple sectors including banking, retail, healthcare, and pharma. The company’s culture is built around continuous learning, collaborative problem‑solving, and a commitment to delivering real‑world impact in an increasingly virtual world.

YASH’s Hyperlearning workplace emphasizes flexibility, trust, and open collaboration, allowing employees to experiment with emerging tools while maintaining a client‑first mindset.

As a Data Analyst specializing in Power BI, you will join a dynamic analytics team that translates complex business problems into actionable insights. You will work closely with both client stakeholders and internal solution architects to gather requirements, design data models, and build interactive dashboards that drive decision‑making. This role is ideal for fresh graduates or early‑career professionals with 1‑2 years of experience in data visualization, SQL, and cloud data platforms, especially those who are eager to grow in the pharma domain.

Key Responsibilities

  • Collaborate with clients and internal teams to understand business challenges and translate them into scalable analytical solutions.
  • Design, develop, and maintain Power BI dashboards and reports, ensuring high performance and usability.
  • Create robust data models using SQL and Snowflake, and implement DAX measures and Power Query transformations.
  • Prepare data extracts and visualizations in Excel and PowerPoint for stakeholder presentations.
  • Own end‑to‑end delivery of individual analytics requests, from requirement gathering to deployment.
  • Follow Agile methodologies, participate in sprint planning, and deliver incremental value.
  • Drive best practices in data governance, documentation, and version control.
  • Identify automation opportunities and propose innovative solutions to improve reporting efficiency.
  • Stay updated with the latest Power BI features and industry trends, sharing knowledge with the team.
  • Provide support and training to business users to foster self‑service analytics.

Tech Stack: Power BI, DAX, Power Query, SQL, Snowflake, Excel, PowerPoint, Agile tools (Jira/Confluence), basic Python/R for data manipulation (optional).

Growth Path: Starting as a Data Analyst, you can progress to Senior Analyst, Analytics Lead, and eventually to Solution Architect or Product Manager roles within YASH’s analytics practice. The company encourages certifications (Microsoft Certified: Data Analyst Associate) and offers internal up‑skilling programs.

Why Join YASH Technologies? You will work in an inclusive environment that values continuous learning and provides exposure to cutting‑edge technologies across diverse industries. The flexible work arrangements, supportive leadership, and clear career progression make YASH an attractive place for ambitious analysts looking to make a tangible impact.

Eligibility & process

Who can apply

Graduates with B.Tech/B.E. in Computer Science, Information Technology, Electronics, or related engineering streams; MBA with analytics focus is also acceptable. Minimum aggregate of 60% (or CGPA 6.0/10). No active backlogs at the time of joining. Freshers and candidates with up to 2 years of relevant experience are eligible. Must be able to work from Pune office or hybrid model.

Skills & stack

Power BI DAX Power Query SQL Snowflake Data Modeling Advanced Excel Powerpoint

Selection process

  1. Round 1: Aptitude test and basic technical assessment
  2. Round 2: Technical interview focusing on Power BI, SQL, and case studies
  3. Round 3: HR interview covering cultural fit and career aspirations

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, DAX, Power Query, SQL, Snowflake, Data Modeling, Advanced Excel, Powerpoint) & 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