BlackRock is hiring!
Position: Data Analyst
Qualification: Bachelor's Degree
Salary: 6 - 15 LPA (Expected)
Experience: Entry Level
Location: Bengaluru, India (Hybrid)

📌Apply Now: https://careers.blackrock.com/job/bengaluru/data-management-analyst/45831/81540166224

👉WhatsApp Channel: https://whatsapp.com/channel/0029Vaxjq5a4dTnKNrdeiZ0J

👉Telegram Link: https://news.1rj.ru/str/addlist/4q2PYC0pH_VjZDk5

All the best 👍

NielsenIQ is hiring!
Position: Junior Associate, Power BI
Qualification: Bachelor’s Degree
Salary: 6 - 10 LPA (Expected)
Experience: Entry Level
Location: Pune, India

📌Apply Link: https://jobs.smartrecruiters.com/NielsenIQ/744000063280269-jr-associate-bi

👉WhatsApp Channel: https://whatsapp.com/channel/0029Vaxjq5a4dTnKNrdeiZ0J

👉Telegram Link: https://news.1rj.ru/str/addlist/4q2PYC0pH_VjZDk5

All the best 👍

Fam is hiring Product Analyst Intern 🚀

Experience : Freshers
Location : Bangalore

Apply link : https://jobs.lever.co/fampay/8838779b-4eb1-4150-8fa2-a4cd29cadcbe/apply?lever-source=LinkedIn

👉WhatsApp Channel: https://whatsapp.com/channel/0029Vaxjq5a4dTnKNrdeiZ0J

👉Telegram Link: https://news.1rj.ru/str/addlist/4q2PYC0pH_VjZDk5

All the best 👍

Zelestra is hiring Junior Data Scientist 🚀

Qualification : Bachelor's degree
Experience : 0-2 Years
Location :; Gurugram

Apply link : https://careers.solarpack.es/job/Haryana-Junior-Data-Scientist/1162773055/

👉WhatsApp Channel: https://whatsapp.com/channel/0029Vaxjq5a4dTnKNrdeiZ0J

👉Telegram Link: https://news.1rj.ru/str/addlist/4q2PYC0pH_VjZDk5

All the best 👍

Airtel is hiring Business Analyst 🚀

Experience with Excel ✅
Location : Gurugram

Apply link : https://www.linkedin.com/jobs/view/4241888047

👉WhatsApp Channel: https://whatsapp.com/channel/0029Vaxjq5a4dTnKNrdeiZ0J

👉Telegram Link: https://news.1rj.ru/str/addlist/4q2PYC0pH_VjZDk5

All the best 👍

Roblox is hiring Business Analyst 🚀

Experience : 2+ Years
Location : Gurugram

Apply link : https://careers.roblox.com/jobs/6754913?gh_jid=6754913&gh_src=da92d0c91

👉WhatsApp Channel: https://whatsapp.com/channel/0029Vaxjq5a4dTnKNrdeiZ0J

👉Telegram Link: https://news.1rj.ru/str/addlist/4q2PYC0pH_VjZDk5

All the best 👍

Razorpay hiring Analyst - Risk Management

Apply link: https://job-boards.greenhouse.io/razorpaysoftwareprivatelimited/jobs/4573732005

👉WhatsApp Channel: https://whatsapp.com/channel/0029Vaxjq5a4dTnKNrdeiZ0J

👉Telegram Link: https://news.1rj.ru/str/addlist/4q2PYC0pH_VjZDk5

All the best 👍👍

S&P Global is hiring Freshers!
Position: Data Analyst
Qualification: Bachelor’s/ Master’s Degree/ MBA
Salary: 5 - 9 LPA (Expected)
Experience: Freshers
Location: Gurgaon; Ahmedabad; Hyderabad, India

📌Apply Now: https://careers.spglobal.com/jobs/315425

👉WhatsApp Channel: https://whatsapp.com/channel/0029Vaxjq5a4dTnKNrdeiZ0J

👉Telegram Link: https://news.1rj.ru/str/addlist/4q2PYC0pH_VjZDk5

All the best 👍👍

DATA ANALYST Interview Questions (0-3 yr) (SQL, Power BI)

👉 Power BI:

Q1: Explain step-by-step how you will create a sales dashboard from scratch.

Q2: Explain how you can optimize a slow Power BI report.

Q3: Explain Any 5 Chart Types and Their Uses in Representing Different Aspects of Data.

👉SQL:

Q1: Explain the difference between RANK(), DENSE_RANK(), and ROW_NUMBER() functions using example.

Q2 – Q4 use Table: employee (EmpID, ManagerID, JoinDate, Dept, Salary)

Q2: Find the nth highest salary from the Employee table.

Q3: You have an employee table with employee ID and manager ID. Find all employees under a specific manager, including their subordinates at any level.

Q4: Write a query to find the cumulative salary of employees department-wise, who have joined the company in the last 30 days.

Q5: Find the top 2 customers with the highest order amount for each product category, handling ties appropriately. Table: Customer (CustomerID, ProductCategory, OrderAmount)

👉Behavioral:

Q1: Why do you want to become a data analyst and why did you apply to this company?

Q2: Describe a time when you had to manage a difficult task with tight deadlines. How did you handle it?

I have curated best top-notch Data Analytics Resources 👇👇
https://whatsapp.com/channel/0029VaGgzAk72WTmQFERKh02

Hope this helps you 😊

Barclays is hiring!
Position: Business Analyst
Qualification: Bachelor’s/ Master’s Degree
Salary: 8 - 12 LPA (Expected)
Experience: Freshers/ Experienced
Location: Mumbai/ Pune/ (Hybrid)

📌Apply Now: https://search.jobs.barclays/job/pune/business-analyst/13015/82125567984

👉WhatsApp Channel: https://whatsapp.com/channel/0029Vaxjq5a4dTnKNrdeiZ0J

👉Telegram Link: https://news.1rj.ru/str/addlist/4q2PYC0pH_VjZDk5

All the best 👍👍

S&P Global is hiring Freshers!
Position: Data Analyst
Qualification: Bachelor’s/ Master’s Degree/ MBA
Salary: 5 - 9 LPA (Expected)
Experience: Freshers
Location: Gurgaon; Ahmedabad; Hyderabad, India

📌Apply Now: https://careers.spglobal.com/jobs/315425

👉WhatsApp Channel: https://whatsapp.com/channel/0029Vaxjq5a4dTnKNrdeiZ0J

👉Telegram Link: https://news.1rj.ru/str/addlist/4q2PYC0pH_VjZDk5

All the best 👍👍

Goldman Sachs senior data analyst interview asked questions

SQL

1 find avg of salaries department wise from table
2 Write a SQL query to see employee name and manager name using a self-join on 'employees' table with columns 'emp_id', 'name', and 'manager_id'.
3 newest joinee for every department (solved using lead lag)

POWER BI

1. What does Filter context in DAX mean?
2. Explain how to implement Row-Level Security (RLS) in Power BI.
3. Describe different types of filters in Power BI.
4. Explain the difference between 'ALL' and 'ALLSELECTED' in DAX.
5. How do you calculate the total sales for a specific product using DAX?

PYTHON

1. Create a dictionary, add elements to it, modify an element, and then print the dictionary in alphabetical order of keys.
2. Find unique values in a list of assorted numbers and print the count of how many times each value is repeated.
3. Find and print duplicate values in a list of assorted numbers, along with the number of times each value is repeated.

I have curated best 80+ top-notch Data Analytics Resources 👇👇
https://news.1rj.ru/str/DataSimplifier

Hope this helps you 😊

Deloitte is hiring Analyst 🚀

Experience : 2+ Years
Location :; Gurugram

Apply link : https://www.linkedin.com/jobs/view/4243341367

👉WhatsApp Channel: https://whatsapp.com/channel/0029Vaxjq5a4dTnKNrdeiZ0J

👉Telegram Link: https://news.1rj.ru/str/addlist/4q2PYC0pH_VjZDk5

All the best 👍👍

Apna Mart is hiring Data Analyst 🚀

Experience : 1 Year
Location : Bangalore

Apply link : https://www.linkedin.com/jobs/view/4246627664

👉WhatsApp Channel: https://whatsapp.com/channel/0029Vaxjq5a4dTnKNrdeiZ0J

👉Telegram Link: https://news.1rj.ru/str/addlist/4q2PYC0pH_VjZDk5

All the best 👍👍

NTT DATA is hiring!
Position: Data Analyst
Qualification: Bachelor's/ Master’s Degree
Salary: 5 - 10 LPA (Expected)
Experience: Freshers/ Experienced
Location: Bangalore, India (Hybrid)

📌Apply Now: https://nttdata.eightfold.ai/careers/job/563327923717998?domain=nttdata.com&hl=en

👉WhatsApp Channel: https://whatsapp.com/channel/0029Vaxjq5a4dTnKNrdeiZ0J

👉Telegram Link: https://news.1rj.ru/str/addlist/4q2PYC0pH_VjZDk5

All the best 👍👍