What to do and What to avoid!

When sitting in front of an interviewer, your actions and words can make or break your chances.

It’s more than just answering questions, it's about presenting yourself as the ideal candidate.

Here are some clear do's and don'ts to keep in mind.

📌Do:

1. Be Prepared.
2. Dress Appropriately.
3. Be Punctual.
4. Maintain Good Posture.
5. Listen Carefully.
6. Ask Thoughtful Questions.
7. Be Honest.

📌Don't:

1. Don’t Fidget.
2. Don’t Speak Negatively About Past Employers.
3. Don’t Interrupt.
4. Don’t Overshare.
5. Don’t Forget to Follow Up.

By keeping these dos and don’ts in mind, you’ll be better prepared to make a strong impression in your interview.

Good luck!

Gallagher are hiring for Analyst/Senior Analyst with 2 to 6 years of experience.

Mandatory Skills:
Power BI
Excel
Sql
End-to-end dashboard creation experience.
Excellent communication.

Additional Notes:
Hybrid work mode
Location: Mumbai/Pune/Bangalore
Ready to work in shifts (UK/US)

Interested candidates can share their cv at jyotsna_tiwari@ajg.com

Data analyst starter kit:

- Become an expert at SQL and data wrangling.

- Learn to help others understand data through visualisations.

- Seek to answer specific questions and provide clarity.

- Remember, everything ends up in Excel.

The Salary Expectation Question: How to Make It a Win-Win!

📍Interviewer: What are your salary expectations for this role?

📌Interviewee: I'm looking for a competitive package that reflects my experience and the value I bring to the team. I did some research and found that the industry standard for this role ranges from Rs.X to Rs.Y.

📍Interviewer: We appreciate your research. Can you share more about what you prioritize in a compensation package?

📌Interviewee: While salary is important, I also value health benefits, opportunities for professional development, and work-life balance. I'm looking for a role where I can grow and contribute to the company's success.

📍Interviewer: It's great to hear you're looking at the bigger picture. We'll take this into account as we move forward. Any flexibility on the range?

📌Interviewee: Yes, I'm open to discussing the details and finding a package that works for both of us.

It’s okay to state your expectations confidently and be open to negotiation!

Many people reached out to me saying telegram may get banned in their countries. So I've decided to create WhatsApp channels based on your interests 👇👇

Free Courses with Certificate: https://whatsapp.com/channel/0029Vamhzk5JENy1Zg9KmO2g

Data Analysts: https://whatsapp.com/channel/0029VaGgzAk72WTmQFERKh02

MS Excel: https://whatsapp.com/channel/0029VaifY548qIzv0u1AHz3i

Jobs & Internship Opportunities:
https://whatsapp.com/channel/0029VaI5CV93AzNUiZ5Tt226

Web Development: https://whatsapp.com/channel/0029VaiSdWu4NVis9yNEE72z

Python Free Books & Projects: https://whatsapp.com/channel/0029VaiM08SDuMRaGKd9Wv0L

Java Resources: https://whatsapp.com/channel/0029VamdH5mHAdNMHMSBwg1s

Coding Interviews: https://whatsapp.com/channel/0029VammZijATRSlLxywEC3X

SQL: https://whatsapp.com/channel/0029VanC5rODzgT6TiTGoa1v

Power BI: https://whatsapp.com/channel/0029Vai1xKf1dAvuk6s1v22c

Programming Free Resources: https://whatsapp.com/channel/0029VahiFZQ4o7qN54LTzB17

Data Science Projects: https://whatsapp.com/channel/0029Va4QUHa6rsQjhITHK82y

Learn Data Science & Machine Learning: https://whatsapp.com/channel/0029Va8v3eo1NCrQfGMseL2D

Don’t worry Guys your contact number will stay hidden!

ENJOY LEARNING 👍👍

Template to ask for referrals
(For freshers)
👇👇

Hi [Name],

I hope this message finds you well.

My name is [Your Name], and I recently graduated with a degree in [Your Degree] from [Your University]. I am passionate about data analytics and have developed a strong foundation through my coursework and practical projects.
I am currently seeking opportunities to start my career as a Data Analyst and came across the exciting roles at [Company Name].

I am reaching out to you because I admire your professional journey and expertise in the field of data analytics. Your role at [Company Name] is particularly inspiring, and I am very interested in contributing to such an innovative and dynamic team.

I am confident that my skills and enthusiasm would make me a valuable addition to this role [Job ID / Link]. If possible, I would be incredibly grateful for your referral or any advice you could offer on how to best position myself for this opportunity.

Thank you very much for considering my request. I understand how busy you must be and truly appreciate any assistance you can provide.

Best regards,
[Your Full Name]
[Your Email Address]

American Express is hiring!
Position: Business Analytics
Qualification: Bachelor’s Degree
Salary: 7 - 10 LPA (Expected)
Experience: 0 - 3 (Years)
Location: Work From Home/ Office

📌Apply Now: https://aexp.eightfold.ai/careers/job/24638280?domain=aexp.com&utm_source=linkedin

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

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

Like for more ❤️

All the best 👍👍

Fractal is hiring for Data Engineer (AWS + Python Developer)
Experience: 0 - 3 years
Expected Salary: 10-16 LPA
Apply here:
https://fractal.wd1.myworkdayjobs.com/Careers/job/Bengaluru/Data-Engineer--AWS---Python-Developer-_SR-26409

Data cleaning is the first step in the journey to discover the truth hidden in your data.

Data cleaning in some points :

👉Remove Duplicate Data: Use tools to eliminate repeated entries that can skew analysis.

👉Handle Missing Values: Replace, remove, or interpolate missing data points to ensure completeness.

👉Correct Data Types: Ensure all data is in the correct format (e.g., dates as datetime objects) for accurate processing.

👉Standardize Data: Convert data into a consistent format, such as standardizing text cases or units of measurement.

👉Filter Outliers: Identify and address extreme values that may distort analysis.

👉Normalize Data: Scale numerical data to ensure features contribute equally in models.

👉Remove Irrelevant Data: Drop columns or rows that do not contribute to the analysis or modeling goals.

👉Validate Data Integrity: Check for inconsistencies or errors, such as typos or incorrect data entries.

👉Document Cleaning Steps: Keep a record of all changes made during cleaning for transparency and reproducibility.

Below most used tools :

☑️Pandas (Python): A powerful data manipulation library for handling missing data, duplicates, and more in Python.

☑️OpenRefine: A free, open-source tool for cleaning messy data, particularly useful for transforming and reconciling datasets.

☑️Excel/Google Sheets: Widely used for basic data cleaning tasks like removing duplicates, filtering, and standardizing data.

☑️SQL: Useful for querying databases, handling missing data, filtering out outliers, and data type conversions.

☑️R: With packages like dplyr and tidyr, R is excellent for cleaning, transforming, and managing data.

☑️Tableau Prep: A tool designed for visual data cleaning and preparation, ideal for those who prefer a graphical interface.

☑️Alteryx: A data analytics platform that provides tools for blending and cleaning data without needing to write code.

☑️Trifacta: A data wrangling tool that offers intuitive interfaces for cleaning and preparing data at scale.

☑️Talend: A data integration tool that includes robust features for data quality, cleansing, and transformation.

Liven is hiring for Junior Data Engineer (Remote)
Experience: 0 - 1 years

Apply here: https://ats.rippling.com/liven/jobs/65a9816d-7b41-4a1a-ad7c-0226766276e1?jobSite=LinkedIn

Goldman Sachs is hiring!
Position: Internal Audit Analyst - Data Analytics
Qualification: Bachelor’s Degree
Salary: 6 - 10 LPA (Expected)
Location: Hyderabad; Bengaluru, India

📌Apply Now: https://hdpc.fa.us2.oraclecloud.com/hcmUI/CandidateExperience/en/sites/LateralHiring/job/134698?mode=job&iis=LinkedIn&utm_medium=jobshare

https://hdpc.fa.us2.oraclecloud.com/hcmUI/CandidateExperience/en/sites/LateralHiring/job/133519?mode=job&iis=LinkedIn&utm_medium=jobshare

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

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

Like for more ❤️

All the best 👍👍

Data analytics is not about the the tools you master but about the people you influence.

I see many debates around the best tools such as:

- Excel vs SQL
- Python vs R
- Tableau vs PowerBI
- ChatGPT vs no ChatGPT

The truth is that business doesn't care about how you come up with your insights.

All business cares about is:

- the story line
- how well they can understand it
- your communication style
- the overall feeling after a presentation

These make the difference in being perceived as a great data analyst...

not the tools you may or may not master 😅

Jobs from USA/ UK
👇👇
https://t.me/jobs_us_uk/3

Data Analyst Openings

Accenture - https://www.accenture.com/in-en/careers/jobdetails?id=R00226183_en&SRC=RECNau


Via - https://jobs.lever.co/viacom18/3dd4b857-45d3-4c44-b6d7-4a4ab6358f9a

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

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

Like for more ❤️

All the best 👍👍

IBM is hiring Data Engineer!
Qualifications: Bachelor’s/ Master’s Degree
Salary: 6.8 - 11 LPA (Expected)
Experience: Freshers/ Experienced
Location: Bangalore; Hyderabad; Pune, India

📌Apply Now: https://careers.ibm.com/job/20893219/data-engineer-data-modeling-pune-in/?codes=SN_LinkedIn&Codes=SN_LinkedIn

https://careers.ibm.com/job/20738482/data-engineer-bangalore-in/?codes=SN_LinkedIn&Codes=SN_LinkedIn

https://careers.ibm.com/job/20815821/data-engineer-hyderabad-in/?codes=SN_LinkedIn&Codes=SN_LinkedIn

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

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

Like for more ❤️

All the best 👍👍

ServiceNow - Work From Home!
Position: Data Informatics Analyst
Qualification: Bachelor's/ Master’s Degree
Salary: 5 - 9 LPA (Expected)
Experience: Freshers/ Experienced
Location: Home (Remote)

📌Apply Now: https://careers.servicenow.com/en/jobs/744000010245340/sr-data-informatics-analyst/

Goldman Sachs is hiring Internal Audit Analyst - Data Analytics
Location: Hyderabad; Bengaluru, India

https://hdpc.fa.us2.oraclecloud.com/hcmUI/CandidateExperience/en/sites/LateralHiring/job/134698

https://hdpc.fa.us2.oraclecloud.com/hcmUI/CandidateExperience/en/sites/LateralHiring/job/133519

Latest Jobs & Internship Opportunities 👇👇

Company – C2FO
Role – Data and BI Analyst
Exp. – 0-3 yrs
Apply Here – https://jobs.dayforcehcm.com/en-US/c2fo/CANDIDATEPORTAL/jobs/808?source=LinkedIn

Company – United Airlines
Role – Associate - Data Scientist
Exp. – 0-2 yrs
Apply Here – https://careers.united.com/us/en/job/UAIUADUSGGN00001710EXTERNALENUSTALEO/Associate-Data-Scientist?utm_source=linkedin&utm_medium=phenom-feeds

Company – JLL Technologies
Role – Data Analyst 2
Exp. – 2-5 yrs
Apply Here – https://jll.wd1.myworkdayjobs.com/jlltcareers/job/Bengaluru-KA/Data-Analyst-2_REQ378268?source=APPLICANT_SOURCE-6-42

Company – Sattva Consulting
Role – Data Analyst- India Data Insights
Exp. – 1-3 yrs
Apply Here – https://www.sattva.co.in/join-us/careers/?jobId=veQNWIXHDUgt&ft_source=6000202916&ft_medium=6000146766

Company – Poshmark
Role – Data Analyst
Exp. – 1-3 yrs
Apply Here – https://poshmark.wd5.myworkdayjobs.com/Poshmark_Careers/job/Chennai-Tamil-Nadu-India/Data-Analyst_R-200114-1?source=LinkedIn

Company – UL Solutions
Role – Process Engineer - Data Analyst with PowerBi
Exp. – 1+ yrs
Apply Here – https://fa-eups-saasfaprod1.fa.ocs.oraclecloud.com/hcmUI/CandidateExperience/en/sites/ULSolutionsCareers/job/3759?utm_medium=jobboard&utm_source=linkedin

Company – Canam
Role – Data Scientist
Exp. – Fresher
Apply Here – https://www.canam.com/en/job/data-scientist/?utm_campaign=wrap&utm_medium=referral&source=linkedin&utm_source=Linkedin

Company – Exponentia.ai
Role – Data Engineer
Exp. – 3 yrs
Apply Here – https://careers.exponentia.ai/exponentia/jobview/data-engineer-mumbai-maharashtra-india-2024090219313393?source=linkedin

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

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

Like for more ❤️

All the best 👍👍

Hiring for data analyst at accenture (0-2 years)

https://www.accenture.com/in-en/careers/jobdetails?id=R00226183_en&SRC=RECNau

Company – Poshmark
Role – Data Analyst
Exp. – 1-3 yrs
Apply Here – https://poshmark.wd5.myworkdayjobs.com/Poshmark_Careers/job/Chennai-Tamil-Nadu-India/Data-Analyst_R-200114-1