Data Analyst Intern

Location: PA-CLIENT-STATE

Data Analyst Intern

Req number: R8551

Employment type: Full time

Worksite flexibility: RemoteWho we are 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.

Job Summary 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.

Job Description

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.

What You'll Do

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

What You'll Need

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

Preferred:

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

Physical Demands

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

Reasonable accommodation statement

If you require a reasonable accommodation in completing this application, interviewing, completing any pre-employment testing, or otherwise participating in the employment selection process, please direct your inquiries to [email protected] or (888) 824 – 8111.

EEO Statement

It is the policy of Computer Aid, Inc.(CAI) not to discriminate against any employee or applicant for employment because of race, color, religion, sex, sexual orientation, gender identity, national origin, age, marital status, genetic information, disability or because he or she is a protected veteran. It is also the policy of CAI to take affirmative action to employ and to advance in employment, all persons regardless of race, color, religion, sex, sexual orientation, gender identity, national origin, age, marital status, genetic information, disability or protected veteran status, and to base all employment decisions only on valid job requirements. This policy shall apply to all employment actions, including but not limited to recruitment, hiring, upgrading, promotion, transfer, demotion, layoff, recall, termination, rates of pay or other forms of compensation and selection for training, including apprenticeship, at all levels of employment.

Employees and applicants of CAI will not be subject to harassment on the basis of