SQL Data Analyst

Applications are open for the SQL Data Analyst position at Citiustech in Noida. 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 The SQL Data Analyst at Citiustech is the bridge between the data and the decision. Your work centres on writing the SQL that extracts, models and validates business data using SQL and relational databases, and on making sure that everyone reading your numbers understands what they mean and how far they can be trusted. Key responsibilities • Write, optimise and document SQL for analysis and reporting • Model and join data across many source tables reliably • Build the curated datasets that feed dashboards • Reconcile query output against source systems before publishing • Support ad-hoc data requests with fast, correct answers • 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 • Query Optimisation • Joins & Window Functions • Stored Procedures • Data Modelling • Advanced Excel • Power BI • Data Validation • ETL Concepts • Indexing Basics • Analytical Thinking • Documentation Eligibility criteria • Education: B.E./B.Tech/BCA/MCA/B.Sc or an equivalent degree. 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–3 years in analytics, reporting, MIS or a closely related function. • Technical skills: SQL, Query Optimisation, Joins & Window Functions, Stored Procedures, Data Modelling, Advanced Excel. • 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: ₹4,50,000 – ₹10,00,000 per year (4.5 LPA – 10 LPA), an indicative market range for this role in Noida. • Monthly equivalent: approximately ₹60,000 per month at the mid-point of the range. • Currency: INR (₹). • Performance bonus / variable pay as per Citiustech's policy, reviewed annually. • The exact offer is confirmed by Citiustech based on your interview performance and current compensation. Perks and benefits • Employee wellness programmes • 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) Location, work mode and employment type • Location: Noida, Uttar Pradesh • Work mode: Work From Office • Employment type: Full-time, permanent • Working hours: 10:00 AM – 7:00 PM, Monday to Friday • Number of openings: 1 • 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 — Business / stakeholder round — how you scope a question and communicate findings • Round 3 — Hiring manager discussion — role expectations, ownership and team fit • Round 4 — HR discussion — compensation, notice period, joining date and offer roll-out Who should apply Candidates from B.E./B.Tech/BCA/MCA/B.Sc or an equivalent degree with up to 3 years of relevant experience who are based in Noida or willing to relocate. You should be comfortable with SQL, Query Optimisation, Joins & Window Functions 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 Citiustech Citiustech invests in its analytics people — structured onboarding, mentorship from senior analysts, certification support and a clear path from analyst to senior analyst and beyond. 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 query layer every dashboard in your team is built on. 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 Citiustech's official careers page to submit your application. Applications close on 16 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 Citiustech for office and hybrid roles. • Citiustech 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. Responsibilities: Write, optimise and document SQL for analysis and reporting; Model and join data across many source tables reliably; Build the curated datasets that feed dashboards; Reconcile query output against source systems before publishing; Support ad-hoc data requests with fast, correct answers; Validate and reconcile numbers before publishing, and document data caveats; Automate recurring reporting to free up time for real analysis; Present findings clearly to non-technical stakeholders. Requirements: B.E./B.Tech/BCA/MCA/B.Sc or an equivalent degree from a recognised university; 0–3 years of experience in analytics, reporting or MIS — freshers and 2026 graduates are welcome; Working knowledge of SQL, Query Optimisation, Joins & Window Functions; Comfort with SQL and relational databases and with cleaning messy, real-world data; Ability to define a metric precisely and explain a result to a non-technical stakeholder; Attention to detail, ownership and the discipline to document your work; Based in Noida, Uttar Pradesh or willing to relocate.

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...