Data Analyst Intern

Req number:

R8551

Employment type:

Full time

Worksite flexibility:

Remote

CAI is a global services firm with over 9,000 associates worldwide and a yearly revenue of $1.3 billion+. We have over 40 years of excellence in uniting talent and technology to power the possible for our clients, colleagues, and communities. As a privately held company, we have the freedom and focus to do what is right—whatever it takes. Our tailor-made solutions create lasting results across the public and commercial sectors, and we are trailblazers in bringing neurodiversity to the enterprise.

We are looking for a Data Analyst Intern to support data analytics, data cleansing, dashboard reporting, and data and program quality review while gaining hands-on experience turning data into meaningful insights.

We are looking for a Data Analyst Intern to assist with data analytics, data cleansing, dashboard reporting, and data and program quality review. This position will be a full-time internship and remote . The internship dates are June 7, 2027 through August 6, 202

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.

• 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

Required:

• 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 Power Point

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