Data Quality Associate

Indian Institute of Technology Bombay Development and Relations Foundation (IITB DRF); Mumbai; On-site; INR 600,000 - 800,000; Full time

Job summary

A top engineering institute in India is seeking a data quality Associate to manage the alumni database. This role involves ensuring data accuracy, building deduplication workflows, and collaborating with various teams to maintain a reliable alumni record. The ideal candidate should have hands-on experience in SQL and CRM operations, preferably within the nonprofit or higher education sectors. Full-time employment with a focus on data governance and quality assurance is offered.

Qualifications

• 4–8 years in data quality or CRM operations.
• Hands-on experience with SQL and advanced Excel.
• Comfort with APIs and consent management.

Responsibilities

• Define alumni data model and validation rules.
• Build automated deduplication and standardization processes.
• Operate alumni CRM and train staff on data entry standards.

Skills

SQL

Advanced Excel

Data stewardship

Data profiling

Python

Tools

Salesforce NPSP

Talend Open Studio

Looker Studio

Job description

Help IIT Bombay rank among the top engineering and technology institutes worldwide by fostering strong relationships with its alumni, corporations and philanthropists.

About us

The Indian Institute of Technology Bombay, set up in 1958 as the second IIT, is recognised worldwide as a leader in the field of science and engineering education and research. The Institute was granted the status of ‘Institution of Eminence’ by the Ministry of Education (the then Ministry of Human Resources Development) on July 9, 2018. IIT Bombay is reputed for the quality of its faculty, cutting edge research, industry relations and the outstanding calibre of students graduating from its undergraduate and postgraduate programmes. The Institute has 17 academic departments, 35 other academic entities and three schools. Over the last six decades, more than 75,000 engineers and scientists have graduated from the Institute. It is served by 751 faculty members and about 150 visiting and part-time faculty considered not only amongst the best within the country but also highly recognised in the world for achievements in the field of education and research. On June 4, 2024, IIT Bombay was ranked 1st in India and 118th in the world in the Quacquarelli Symonds (QS) World University Rankings for 2025. On March 12, 2025, IIT Bombay was ranked 28th in Engineering and Technology in the Quacquarelli Symonds (QS) World University Rankings by Subject for 2025.

IITB DRF assists fundraising endeavours by way of donor solicitations, managing donor programs, maintaining financial accounts and reporting details of all activities implemented with alumni donations.

Job Purpose

Own the completeness, accuracy, and freshness of the alumni database. You’ll design data standards, build and run deduplication and enrichment workflows, validate email/phone/contactability, and set up ongoing governance so records stay clean and campaign ready. You’ll collaborate with Alumni Relations, Advancement/AG, and IT/CRM to turn messy inputs into a single reliable “golden record” for every alum.

Key Responsibilities

Data standards & governance

• Define the alumni data model, field standards (names, degrees, departments, graduation year, employment, city/state/country/PIN), and validation rules.
• Maintain a data dictionary, quality rules, and SOPs; run monthly audits and publish DQ dashboards.
• Ensure compliance with India’s DPDP Act (2023) and internal consent/opt‑out policies (lawful purpose, notice, retention, access logs).

Quality control & remediation

• Build automated deduplication (exact + fuzzy matching), survivorship rules, and merge queues.
• Standardize addresses (India Post PINs), phone formats (E.164), and email patterns; set up input validation on forms.
• Reduce bounces via email verification and re‑permissioning workflows; manage hard/soft bounce handling.
• Plan outreach to alumni to fill gaps (surveys, event RSVPs, reunion forms) with progressive profiling.
• Enrich employment and location via approved sources/APIs and manual research when needed.
• Run quarterly verification campaigns and monitor freshness SLAs.

Tooling & integrations

• Operate the alumni CRM (e.g., Salesforce NPSP / Blackbaud RE NXT / Slate / Zoho CRM / Almabase / AlmaConnect / Hivebrite).
• Build low‑code ETL pipelines (e.g., Talend Open Studio, Pentaho Kettle, Airbyte, Google Apps Script), and quality checks (SQL + Excel).
• Use email validation (ZeroBounce/NeverBounce/Kickbox), phone lookup services, geocoding (Google Maps), and record linkage libs (Dedupe.io / RapidFuzz).
• Partner with communications for segmentation lists; set up list QA gates before sends.
• Train staff on data entry standards; review new integrations/forms for DQ impact.

Desired Experience / competencies

• 4–8 years (Lead) / 1–3 years (Associate) in data quality, CRM operations, or data stewardship; nonprofit/higher‑ed experience a plus.
• Hands‑on SQL, advanced Excel/Google Sheets, basic Python (pandas) or Apps Script for cleanup jobs.
• Practical experience with dedupe/fuzzy matching, data profiling, address and contact standardization.
• Familiarity with email deliverability concepts (SPF/DKIM alignment, bounce handling) and consent/opt‑out management.
• Comfort with APIs, CSV pipelines, and QA checklists.
• Working knowledge of India’s DPDP Act and privacy‑by‑design practices.
• Experience with Salesforce NPSP or Blackbaud admin, or alumni platforms (Almabase/AlmaConnect/Hivebrite).
• Exposure to enrichment tools (Apollo/Lusha/RocketReach/ZoomInfo used responsibly under consent policies).
• Basic BI (Looker Studio/Power BI) for DQ dashboards.

Seniority level

Associate

Employment type

Full‑time

Job function

Analyst and Quality Assurance

Industries

IT System Data Services and Data Infrastructure and Analytics