Intern - Data Analyst

CanKids KidsCan; New Delhi; On-site; INR 167,000 - 234,000; Full time

Job summary

CanKids KidsCan in India invites an Intern Data Analyst for a six-month engagement to optimize fundraising and donor management operations.

You will maintain donor databases, develop Excel tracking sheets and MIS, perform data cleaning and validation, and generate regular reports with insights to guide campaigns and leadership decisions.

Qualifications

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

Responsibilities

• Maintain and continuously update comprehensive databases related to fundraising activities, donor information, and ongoing campaigns.
• Develop and manage accurate Excel tracking sheets, 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.

Skills

Excel

Data management

Data cleaning

Data validation

Data visualization

Dashboards

Presentations

Documentation

Analytics

Written and verbal communication

Tools

MIS

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.