Intern - Data Analyst

Cankidsindia; New Delhi; On-site; INR 167,000 - 279,000; Part time

Job summary

CanKids KidsCan is seeking an Intern Data Analyst in Delhi for a six-month engagement to optimize fundraising and donor management operations. You will transform raw data into actionable intelligence, maintain donor databases, and deliver strategic insights that drive campaigns.

The role focuses on robust reporting, trend analyses, and management-ready summaries to inform critical decisions, with emphasis on data integrity and professional presentations.

Qualifications

• Strong proficiency in Microsoft Excel and experience with data management tools.
• Ability to perform data cleaning, validation, and quality control.
• Analytical skills to interpret donor trends and campaign metrics.
• Experience in creating data visualizations, dashboards, and professional presentations.
• Excellent organizational skills with a focus on accurate documentation and record-keeping.
• Ability to synthesize complex data into clear, concise, and actionable insights.
• Strong written and verbal communication skills suitable for a professional workplace.
• Commitment to delivering a high-quality final analytical report within the specified timeline.

Responsibilities

• Maintain and update databases related to fundraising activities, donor information, and ongoing campaigns.
• Develop and manage Excel tracking sheets, MIS, and standardized reporting templates.
• Execute routine data cleaning, validation, and quality assurance checks to guarantee high data integrity.
• Generate weekly and monthly performance reports detailing fundraising outcomes and campaign progress.
• Analyze donor behavior patterns, retention, acquisition, and giving trends.
• Evaluate campaign performance against targets and historical data.
• Create dashboards, charts, and visual data representations to track key metrics.
• Compile and present executive-level data summaries for leadership review.
• Identify trends and gaps, providing strategic recommendations to support goals.
• Ensure datasets, tracking tools, and reports are well documented and organized.
• Submit a comprehensive final analysis report at the end of the term.

Skills

Excel

Data Analysis

Data Visualization

Data Management

Communication

Documentation

Tools

MIS

Reporting Templates

Job description

Founded in 2004 by Poonam Bagai, herself a cancer survivor, CanKids KidsCan, the National Society for Change For Childhood Cancer In India partners with hospitals, medical professionals, and state governments to enable access and best standards of treatment, care and support across 60 cities and 22 states of India.

Catering to childhood cancer patients from primarily underprivileged families, CanKids is present in 141 hospitals across India. Through our signature programYANA (You Are Not Alone)– CanKids provides medical, drugs & diagnostics support, accommodation through Home Away from Homes, , patient transport, blood support, nutrition & rations, education and counselling support.

In order to increaseAccess2Care, CanKids has MOUs with 8 state governments asknowledgeandtechnical partnersfor childhood cancer and 16 State Projects Across India.

Job Description

Intern Data Analyst (6-Month Term)

Summary

We are seeking a detail-oriented Intern Data Analyst to join our team for a six-month engagement focused on optimizing our fundraising and donor management operations. This role is pivotal in transforming raw data into actionable intelligence, ensuring the integrity of our donor databases, and providing strategic insights that drive campaign success. The ideal candidate will support the organization by maintaining robust reporting systems, conducting comprehensive trend analyses, and delivering clear, management-ready summaries that inform critical decision-making processes.

Responsibilities

• Maintain and continuously update comprehensive databases related to fundraising activities, donor information, and ongoing campaigns.
  
• Develop and manage accurate Excel tracking sheets, Management Information Systems (MIS), and standardized reporting templates.
  
• Execute routine data cleaning, validation protocols, and quality assurance checks to guarantee high data integrity.
  
• Generate weekly and monthly performance reports detailing fundraising outcomes and campaign progress.
  
• Analyze donor behavior patterns, including retention rates, acquisition of new donors versus repeat contributors, and giving trends.
  
• Evaluate campaign performance by comparing actual results against established targets and historical data from previous periods.
  
• Create and sustain user-friendly dashboards, charts, and visual data representations to track key metrics.
  
• Compile and present executive-level data summaries and presentations tailored for leadership review.
  
• Identify emerging trends, operational gaps, and provide strategic recommendations to support organizational goals.
  
• Ensure all datasets, tracking tools, and reports are properly documented and systematically organized.
  
• Compile and submit a comprehensive final analysis report at the end of the six-month term, summarizing key findings, observed trends, and strategic recommendations.
  

Requirements

Requirements:

• Strong proficiency in Microsoft Excel and experience with data management tools.
  
• Demonstrated ability to perform data cleaning, validation, and quality control.
  
• Solid analytical skills with the capacity to interpret donor trends and campaign metrics.
  
• Experience in creating data visualizations, dashboards, and professional presentations.
  
• Excellent organizational skills with a focus on accurate documentation and record-keeping.
  
• Ability to synthesize complex data into clear, concise, and actionable insights.
  
• Strong written and verbal communication skills suitable for a professional workplace.
  
• Commitment to delivering a high-quality final analytical report within the specified timeline.