Data Quality Associate

Our Vision:

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 (Centres/ Programmes/ Academic facilities/ Hubs/ Externally funded centres and Labs) 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.

Sourcing & enrichment:

• 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 (e.g., ZeroBounce/NeverBounce/Kickbox), phone lookup services, geocoding (Google Maps), and record linkage libs (e.g., Dedupe.io / RapidFuzz).

Stakeholder enablement:

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