Data Analyst Intern

Summary

CAI is a global services firm that unites talent and technology across public and commercial sectors. The Data Analyst Intern will assist with data analytics, data cleansing, dashboard reporting, and data and program quality review while supporting health and human services programs and gaining practical experience with data-driven reporting.

Responsibilities

• Gain real-world work experience in a corporate environment
• Gain in-demand technical and business skills and critical competencies
• Gain exposure to CAI's diverse and inclusive culture
• Collaborate with other interns on a community outreach project
• Gain exposure to CAI's leaders through the Executive Connections Program
• Participate in interactive, social events
• Assist with data analytics and reporting in various health and human services program areas such as behavioral health, child welfare, and child support
• Conduct research related to thought leadership, data analytics, and general business functions
• Organize tasks in a logical and cohesive manner
• Apply an understanding of social services and family support activities when applicable
• Write professional communications and documentation
• Work independently with guidance from senior staff
• Participate in public speaking opportunities
• Participate in HHS events throughout the internship

Skills

• This internship is a full-time opportunity requiring a commitment of 40 hours per week
• Candidates must be available during core business hours (8:30 a.m. EST to 5:00 p.m. EST) for the entire 9-week duration of the program
• Please note that all work must be performed within the United States
• This position does not offer work authorization sponsorship now or in the future
• Candidates requiring sponsorship will not be considered
• Current Junior pursuing a degree in Data Analytics, Statistics, Health Informatics, Economics, or a related field
• Coursework or project experience involving data analysis, statistics, or research methods
• Current Junior with a 3.5 GPA or higher
• Working knowledge of general office equipment such as a PC, mouse, keyboard, and monitor
• High proficiency in Microsoft Office applications, including Word, Excel, and PowerPoint
• Experience using Excel functions and features, including pivot tables, VLOOKUP/XLOOKUP, and formula-based data cleaning
• Working knowledge of SQL for querying and joining relational data, including SELECT statements, filtering, and aggregating
• Familiarity with Power BI or Tableau for building dashboards and visualizations
• Comfort working with large or complex datasets, including basic data cleaning and validation techniques
• Basic understanding of data structures, including rows, columns, keys, and tables, and how data flows between systems
• Ability to translate raw data into clear and accurate summaries, charts, and dashboards for non-technical audiences
• Strong attention to detail with a focus on data accuracy
• Ability to identify trends, outliers, and data quality issues and flag them appropriately
• Interest in or aptitude for performance metrics, KPIs, and program reporting
• Strong communication skills
• Strong problem-solving skills
• Ability to effectively multitask
• Excellent time management skills
• Strong organizational skills and attention to detail
• Ability to safely and successfully perform the essential job functions consistent with the ADA and other federal, state and local standards
• Sedentary work that involves sitting or remaining stationary most of the time
• Ability to conduct repetitive tasks on a computer, utilizing a mouse, keyboard, and monitor
• Prior internship, work-study, or academic project experience with data cleaning, analysis, or reporting
• Understanding of social services and family support activities
• Experience with public speaking

Qualifications

Must Haves

• This internship is a full-time opportunity requiring a commitment of 40 hours per week
• Candidates must be available during core business hours (8:30 a.m. EST to 5:00 p.m. EST) for the entire 9-week duration of the program
• Please note that all work must be performed within the United States
• This position does not offer work authorization sponsorship now or in the future
• Candidates requiring sponsorship will not be considered
• Current Junior pursuing a degree in Data Analytics, Statistics, Health Informatics, Economics, or a related field
• Coursework or project experience involving data analysis, statistics, or research methods
• Current Junior with a 3.5 GPA or higher
• Working knowledge of general office equipment such as a PC, mouse, keyboard, and monitor
• High proficiency in Microsoft Office applications, including Word, Excel, and PowerPoint
• Experience using Excel functions and features, including pivot tables, VLOOKUP/XLOOKUP, and formula-based data cleaning
• Working knowledge of SQL for querying and joining relational data, including SELECT statements, filtering, and aggregating
• Familiarity with Power BI or Tableau for building dashboards and visualizations
• Comfort working with large or complex datasets, including basic data cleaning and validation techniques
• Basic understanding of data structures, including rows, columns, keys, and tables, and how data flows between systems
• Ability to translate raw data into clear and accurate summaries, charts, and dashboards for non-technical audiences
• Strong attention to detail with a focus on data accuracy
• Ability to identify trends, outliers, and data quality issues and flag them appropriately
• Interest in or aptitude for performance metrics, KPIs, and program reporting
• Strong communication skills
• Strong problem-solving skills
• Ability to effectively multitask
• Excellent time management skills
• Strong organizational skills and attention to detail
• Ability to safely and successfully perform the essential job functions consistent with the ADA and other federal, state and local standards
• Sedentary work that involves sitting or remaining stationary most of the time
• Ability to conduct repetitive tasks on a computer, utilizing a mouse, keyboard, and monitor

Nice to Haves

• Prior internship, work-study, or academic project experience with data cleaning, analysis, or reporting
• Understanding of social services and family support activities
• Experience with public speaking

Benefits

• Remote work arrangement
• Gain real-world work experience in a corporate environment
• Gain in-demand technical and business skills and critical competencies
• Immersion in CAI’s diverse and inclusive culture
• Opportunity to collaborate with other interns on a community outreach project
• Exposure to CAI’s leaders through the Executive Connections Program
• Interactive, social events
• Medical, dental, and vision insurance
• 401k retirement account access
• Paid sick leave and/or other paid time off as provided by applicable law