Thomson Reuters is hiring!
Position: Business Analyst
Qualification: Bachelor’s/ Master’s Degree
Salary: 6 - 10 LPA (Expected)
Experience: Freshers/ Experienced
Location: Work From Home/ Office

📌Apply Link: https://careers.thomsonreuters.com/us/en/job/JREQ192166/Business-Analyst

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

👉 Telegram Channel: https://t.me/addlist/4q2PYC0pH_VjZDk5

All the best! 👍👍

𝐞𝐁𝐚𝐲 𝐢𝐬 𝐡𝐢𝐫𝐢𝐧𝐠!
Position: Data Analyst, Analytics
Qualification: Bachelor’s/ Master’s Degree
Salary: 6 - 10 LPA (Expected)
Experience: Freshers/ Experienced
Location: Home/ Office

📌Apply Now: https://jobs.ebayinc.com/us/en/job/R0068011/Data-Operations-Analyst

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

👉 Telegram Channel: https://t.me/addlist/4q2PYC0pH_VjZDk5

All the best! 👍👍

Excel Scenario-Based Questions Interview Questions and Answers :


Scenario 1) Imagine you have a dataset with missing values. How would you approach this problem in Excel?

Answer:

To handle missing values in Excel:

1. Identify Missing Data:

Use filters to quickly find blank cells.

Apply conditional formatting:
Home → Conditional Formatting → New Rule → Format only cells that are blank.


2. Handle Missing Data:

Delete rows with missing critical data (if appropriate).

Fill missing values:

Use =IF(A2="", "N/A", A2) to replace blanks with “N/A”.

Use Fill Down (Ctrl + D) if the previous value applies.

Use functions like =AVERAGEIF(range, "<>", range) to fill with average.


3. Use Power Query (for large datasets):

Load data into Power Query and use “Replace Values” or “Remove Empty” options.

Scenario 2) You are given a dataset with multiple sheets. How would you consolidate the data for analysis?

Answer:

Approach 1: Manual Consolidation

1. Use Copy-Paste from each sheet into a master sheet.
2. Add a new column to identify the source sheet (optional but useful).
3. Convert the master data into a table for analysis.



Approach 2: Use Power Query (Recommended for large datasets)

1. Go to Data → Get & Transform → Get Data → From Workbook.
2. Load each sheet into Power Query.
3. Use the Append Queries option to merge all sheets.


4. Clean and transform as needed, then load it back to Excel.

Approach 3: Use VBA (Advanced Users)

Write a macro to loop through all sheets and append data to a master sheet.

Hope it helps :)

Autodesk hiring BI Analyst

Apply link: https://autodesk.wd1.myworkdayjobs.com/Ext/job/Bengaluru-IND/Business-Intelligence-Analyst_25WD85527?src=JB-10065&source=LinkedIn

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

👉 Telegram Channel: https://t.me/addlist/4q2PYC0pH_VjZDk5

All the best! 👍👍

Cision hiring Analyst

Apply link: https://job-boards.eu.greenhouse.io/cision/jobs/4599481101?gh_src=Sslxbx

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

👉 Telegram Channel: https://t.me/addlist/4q2PYC0pH_VjZDk5

All the best! 👍👍

Uber hiring Data Scientist

Apply link: https://www.uber.com/global/en/careers/list/141654

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

👉 Telegram Channel: https://t.me/addlist/4q2PYC0pH_VjZDk5

All the best! 👍👍

𝐒&𝐏 𝐆𝐥𝐨𝐛𝐚𝐥 𝐢𝐬 𝐡𝐢𝐫𝐢𝐧𝐠 𝐅𝐫𝐞𝐬𝐡𝐞𝐫𝐬!
Position: Apprentice, Data Management
Qualifications: Graduate/ Post Graduation/ MBA
Salary: 4 - 6 LPA (Expected)
Batch: 2023/ 2024/ 2025/ 2026
Experience: Freshers
Location: Bangalore; Gurgaon; Mumbai, India

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

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

👉 Telegram Channel: https://t.me/addlist/4q2PYC0pH_VjZDk5

All the best! 👍👍

Teamware Solutions is hiring Data Analyst 🚀

Experience : 0-2 Years
Location : Mumbai

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

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

👉 Telegram Channel: https://t.me/addlist/4q2PYC0pH_VjZDk5

All the best! 👍👍

Wells Fargo is hiring!
Position: Data & Analytics, Analytics Associate
Qualifications: Bachelor’s/ Master’s Degree
Salary: 8 - 10 LPA (Expected)
Experience: Entry Level
Location: Bangalore, India

📌Apply Now: https://www.wellsfargojobs.com/en/jobs/r-464891/global-payments-analytics-associate/

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

👉 Telegram Channel: https://t.me/addlist/4q2PYC0pH_VjZDk5

All the best! 👍👍

VEGROW is hiring Data Analyst 🚀

Experience : 1 Year
Location :; Bangalore

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

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

👉 Telegram Channel: https://t.me/addlist/4q2PYC0pH_VjZDk5

All the best! 👍👍

Acuity knowledge Partners is hiring Data Analyst 🚀

Experience : 0-3 Years
Location : Gurugram

Apply link : https://acuitykp.darwinbox.com/ms/candidate/careers/a684f97d0db874

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

👉 Telegram Channel: https://t.me/addlist/4q2PYC0pH_VjZDk5

All the best! 👍👍

Razorpay is hiring!
Position: Analytics Specialist
Qualifications: Bachelor’s/ Master’s Degree
Salary: 5 - 12 LPA (Expected)
Experience: Freshers/ Experienced
Location: Bangalore, India

📌Apply Now: https://razorpay.com/jobs/jobs-all/detail/?gh_jid=4576150005

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

👉 Telegram Channel: https://t.me/addlist/4q2PYC0pH_VjZDk5

All the best! 👍👍

Slice is hiring Analytics Intern 🚀

Skills : SQL & Python
Experience : Freshers
Location : Bangalore

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

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

👉 Telegram Channel: https://t.me/addlist/4q2PYC0pH_VjZDk5

All the best! 👍👍

American Express is hiring Data Analyst 🚀

Experience : 1-2 Year
Location : Gurugram

Apply link : https://aexp.eightfold.ai/careers/job/29141108?hl=en&utm_source=linkedin&domain=aexp.com

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

👉 Telegram Channel: https://t.me/addlist/4q2PYC0pH_VjZDk5

All the best! 👍👍

NatWest Group is hiring!
Position: Business Analyst
Qualifications: Bachelor’s/ Master’s/ MBA
Salary: 6 - 9 LPA (Expected)
Experience: Freshers/ Experienced
Location: Chennai; Gurugram, India (Hybrid)

📌Apply Now: https://jobs.natwestgroup.com/jobs/16087836-business-analyst

https://jobs.natwestgroup.com/jobs/15760012-business-analyst

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

👉 Telegram Channel: https://t.me/addlist/4q2PYC0pH_VjZDk5

All the best! 👍👍

DeHaat is hiring Analytics Intern 🚀

Freshers are eligible
Location : Gurugram

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

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

👉 Telegram Channel: https://t.me/addlist/4q2PYC0pH_VjZDk5

All the best! 👍👍

Data Analyst Interview Questions with Answers

Q1: How do you ensure data consistency and integrity in a data warehousing environment?

Ans: I implement data validation checks, use constraints like primary and foreign keys, and ensure that ETL processes have error-handling mechanisms. Regular audits and data reconciliation processes are also set up to ensure data accuracy and consistency.

Q2: Describe a situation where you had to design a star schema for a data warehousing project.

Ans: For a retail sales data warehousing project, I designed a star schema with a central fact table containing sales transactions. Surrounding this were dimension tables like Products, Stores, Time, and Customers. This structure allowed for efficient querying and reporting of sales metrics across various dimensions.

Q3: How would you use data analytics to assess credit risk for loan applicants?

Ans: I'd analyze the applicant's financial history, including credit score, income, employment stability, and existing debts. Using predictive modeling, I'd assess the probability of default based on historical data of similar applicants. This would help in making informed lending decisions.

Q4: Describe a situation where you had to ensure data security for sensitive financial data.

Ans: While working on a project involving customer transaction data, I ensured that all data was encrypted both at rest and in transit. I also implemented role-based access controls, ensuring that only authorized personnel could access specific data sets. Regular audits and penetration tests were conducted to identify and rectify potential vulnerabilities.

React ❤️ for more

Gartner is hiring!
Position: Associate Data Engineer
Qualifications: Bachelor's/ Master’s Degree
Salary: 9 - 15 LPA (Expected)
Experience: Freshers/ Experienced
Location: Gurgaon, India

📌Apply Now: https://jobs.gartner.com/jobs/job/100508-associate-data-engineer/

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

👉 Telegram Channel: https://t.me/addlist/4q2PYC0pH_VjZDk5

All the best! 👍👍

Uber is hiring Data Analyst!
Qualification: Bachelor's/ Master’s Degree
Salary: 7 - 12 LPA (Expected)
Experience: Freshers/ Experienced
Location: Hyderabad, India

📌Apply Now: https://www.uber.com/global/en/careers/list/144332/?uclick_id=897120ba-c8b3-4063-888c-dd8078b23545

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

👉 Telegram Channel: https://t.me/addlist/4q2PYC0pH_VjZDk5

All the best! 👍👍

McKinsey is hiring!
Position: Junior Analyst
Qualification: Bachelor’s Degree/ MBA
Salary: 7 - 12 LPA (Expected)
Experience: Freshers/ Experienced
Location: Bengaluru, India

📌Apply Now: https://www.mckinsey.com/careers/search-jobs/jobs/juniorcapabilitiesinsightsanalyst-riskresilience-98601

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

👉 Telegram Channel: https://t.me/addlist/4q2PYC0pH_VjZDk5

All the best! 👍👍

📌Goldman Sachs is hiring for Data Engineer - Analyst
Experience: 1 year's
Expected Salary: 10 - 18 LPA
Apply here: https://hdpc.fa.us2.oraclecloud.com/hcmUI/CandidateExperience/en/sites/LateralHiring/job/149322

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

👉 Telegram Channel: https://t.me/addlist/4q2PYC0pH_VjZDk5

All the best! 👍👍