Data Analyst (Fresher / Trainee)

Applications are open for the Data Analyst (Fresher / Trainee) position at ABC Consultants in Faridabad. You will join a working data analytics team, own a defined set of reports and analyses end to end, and see your findings turn into decisions that people act on. About the role In this Data Analyst (Fresher / Trainee) position you will be trusted with real business questions. Day to day that means learning the analytics stack on live business data under a senior analyst with Excel, SQL and Power BI, and holding a high bar on data quality, documentation and clarity of communication. Key responsibilities • Prepare and clean datasets for the analytics team • Build simple dashboards and recurring reports under review • Run first-pass analyses and summarise what you found • Cross-check numbers against source systems • Document your queries and steps so others can repeat them • Validate and reconcile numbers before they are published, and document known data caveats • Automate recurring reporting so the team spends its time on analysis rather than refreshes • Present findings to non-technical stakeholders in clear, plain language Required skills and tools • SQL Basics • Advanced Excel • Power BI • Data Cleaning • Descriptive Statistics • Data Visualization • Python Basics • Reporting • Attention to Detail • Analytical Thinking • Communication • Time Management Eligibility criteria • Education: B.E./B.Tech/BCA/MCA/B.Sc/B.Com/BBA — 2024–2026 batches. Candidates from any recognised university are welcome. • Graduation year: 2023–2026 batches. Freshers and final-year students awaiting results may apply. • Minimum 60% / 6.0 CGPA in the highest qualification (indicative — strong practical skills can offset this). • Experience: 0–1 years in analytics, reporting, MIS or a closely related function. • Technical skills: SQL Basics, Advanced Excel, Power BI, Data Cleaning, Descriptive Statistics, Data Visualization. • Soft skills: structured thinking, attention to detail, stakeholder communication, ownership and the confidence to flag a number that looks wrong. Salary and compensation • Annual CTC: ₹2,40,000 – ₹4,80,000 per year (2.4 LPA – 4.8 LPA), an indicative market range for this role in Faridabad. • Monthly equivalent: approximately ₹30,000 per month at the mid-point of the range. • Currency: INR (₹). • Performance bonus / variable pay as per ABC Consultants's policy, reviewed annually. • The exact offer is confirmed by ABC Consultants based on your interview performance and current compensation. Perks and benefits • Team offsites and networking opportunities • Competitive salary as per market benchmarks • Annual performance bonus / variable pay • Health insurance for you and your dependants • Provident Fund and statutory benefits • Structured onboarding and mentorship • Learning & certification support (SQL, Power BI, Tableau, cloud) • Paid leaves and public holidays Location, work mode and employment type • Location: Faridabad, Haryana • Work mode: Work From Office • Employment type: Full-time, permanent • Working hours: Standard business hours, Monday to Friday (5-day week) • Number of openings: 3 • Joining: immediate to 60 days, as per your notice period Selection process • Round 1 — Resume screening and profile shortlisting by the talent acquisition team • Round 2 — Hiring manager discussion — role expectations, ownership and team fit • Round 3 — Online assessment — SQL, Excel and quantitative aptitude • Round 4 — Technical interview 1 — SQL joins, aggregations, window functions and data modelling • Round 5 — HR discussion — compensation, notice period, joining date and offer roll-out Who should apply Candidates from B.E./B.Tech/BCA/MCA/B.Sc/B.Com/BBA — 2024–2026 batches with up to 1 years of relevant experience who are based in Faridabad or willing to relocate. You should be comfortable with SQL Basics, Advanced Excel, Power BI and able to explain your analysis to someone who has never seen the data. Portfolio projects, Kaggle work, a GitHub repo or published dashboards strengthen an application, especially for early-career candidates. Why join ABC Consultants At ABC Consultants the analytics function is treated as core, not a back-office service. You will have direct access to stakeholders, room to challenge assumptions and support to keep learning. High performers move into senior and lead analyst roles, take ownership of a business vertical, or specialise in data science, data engineering or product analytics. You will leave every year of this role with the first real analytics experience on your CV. How to apply Click Apply Now. If you are not signed in you will be asked to log in or create a free MyInternships.in candidate account first, after which you will be taken directly to ABC Consultants's official careers page to submit your application. Applications close on 23 September 2026 and are reviewed on a rolling basis, so apply early. Additional information • Documents required at the interview stage: updated resume, degree certificates or provisional certificate, and government photo ID. • Experienced candidates should also carry recent payslips and a relieving or experience letter. • There is no service bond for this position, and no equipment deposit is taken. • A laptop and licensed analytics tooling are provided by ABC Consultants for office and hybrid roles. • ABC Consultants and MyInternships.in never charge a fee at any stage of the application, selection or onboarding process. If anyone asks you for money in the name of this job, do not pay — report it.

Back to blog

Common Interview Questions And Answers

1. HOW DO YOU PLAN YOUR DAY?

This is what this question poses: When do you focus and start working seriously? What are the hours you work optimally? Are you a night owl? A morning bird? Remote teams can be made up of people working on different shifts and around the world, so you won't necessarily be stuck in the 9-5 schedule if it's not for you...

2. HOW DO YOU USE THE DIFFERENT COMMUNICATION TOOLS IN DIFFERENT SITUATIONS?

When you're working on a remote team, there's no way to chat in the hallway between meetings or catch up on the latest project during an office carpool. Therefore, virtual communication will be absolutely essential to get your work done...

3. WHAT IS "WORKING REMOTE" REALLY FOR YOU?

Many people want to work remotely because of the flexibility it allows. You can work anywhere and at any time of the day...

4. WHAT DO YOU NEED IN YOUR PHYSICAL WORKSPACE TO SUCCEED IN YOUR WORK?

With this question, companies are looking to see what equipment they may need to provide you with and to verify how aware you are of what remote working could mean for you physically and logistically...

5. HOW DO YOU PROCESS INFORMATION?

Several years ago, I was working in a team to plan a big event. My supervisor made us all work as a team before the big day. One of our activities has been to find out how each of us processes information...

6. HOW DO YOU MANAGE THE CALENDAR AND THE PROGRAM? WHICH APPLICATIONS / SYSTEM DO YOU USE?

Or you may receive even more specific questions, such as: What's on your calendar? Do you plan blocks of time to do certain types of work? Do you have an open calendar that everyone can see?...

7. HOW DO YOU ORGANIZE FILES, LINKS, AND TABS ON YOUR COMPUTER?

Just like your schedule, how you track files and other information is very important. After all, everything is digital!...

8. HOW TO PRIORITIZE WORK?

The day I watched Marie Forleo's film separating the important from the urgent, my life changed. Not all remote jobs start fast, but most of them are...

9. HOW DO YOU PREPARE FOR A MEETING AND PREPARE A MEETING? WHAT DO YOU SEE HAPPENING DURING THE MEETING?

Just as communication is essential when working remotely, so is organization. Because you won't have those opportunities in the elevator or a casual conversation in the lunchroom, you should take advantage of the little time you have in a video or phone conference...

10. HOW DO YOU USE TECHNOLOGY ON A DAILY BASIS, IN YOUR WORK AND FOR YOUR PLEASURE?

This is a great question because it shows your comfort level with technology, which is very important for a remote worker because you will be working with technology over time...