Skip to Main Content

Data Analytics Specialist Internship #2301-005020-01

Date Opened
Friday, January 06, 2023 8:00 AM
Close Date
Tuesday, February 07, 2023 11:59 PM
  • $16.00 - $18.00/hour
Employment Type
  • Internship


The City of Charlotte is the largest municipality in North Carolina and the 17th largest city in the United States, with a total population of more than 872,498 citizens. A major commerce center, Charlotte hosts several of the nation’s largest banks and technology companies.

Also known as the Queen City, Charlotte is home to the Carolina Panthers, the Charlotte Hornets and the NASCAR Hall of Fame. We work hard to ensure that the community will be a winning city for everyone – a truly remarkable place to live, work, learn and play. Join us in helping to keep our City thriving, ensuring upward mobility and advancement in the workplace.




The Crime Analysis Division of the Charlotte-Mecklenburg Police Department is a support unit responsible for continually leveraging technology and employing a set of systematic, analytical processes to provide timely, targeted information related to crime patterns and trends.  The division supports a department of over 2,000 employees responsible for a jurisdiction of over 400 square miles and 900,000 citizens.  Staff members provide direct information and intelligence support to patrol operations, investigations, and specialized units for use in planning the deployment of resources aimed at reducing, preventing, and solving crimes. 

The Crime Analysis Division is looking to recruit university students interested in a career in Crime Analysis and data analytics. We are looking for innovative applicants that have the commitment and drive to initiate innovative analytical processes to reduce crime, respond to community concerns, address officer wellness, promote community transparency and awareness, and generate best practices across the profession that are evidence-based and put them into practice. If you are an individual that wants to be a part of shaping tomorrow’s police profession and the future of crime and data analytics, this is for you!

Major Duties and Responsibilities

•Using crime analysis software provided, conduct research to identify patterns and trends; analyze long term patterns and trends using probability studies and complex statistical analyses.

•Develop and test hypotheses; forecast future activity. 

•Assist in the preparation of patrol action plans by analyzing current trends versus officer deployment and activities.  

•Prepare a variety of reports such as crime and intelligence bulletins for immediate use within patrol and investigative divisions to support crime reduction efforts.

•Develop comprehensive victim and suspect profiles (including vehicles, addresses, associates).

•Prepare a variety of mapping (ArcGIS) products, indicating crime/criminal trends and providing analysis and explanations for these trends.

•Support problem-solving efforts by utilizing the SARA model to assist in long term crime reduction efforts.

•Compile and analyze findings, make interpretations then write comprehensive reports based on data; use these findings to help identify information gaps and future collection requirements. 

•Attend briefings/meetings within patrol and investigative divisions.  

Knowledge, Skills & Abilities

Knowledge of connecting to data in a variety of SQL Server/Oracle relational databases to analyze and report on findings.

ADA and Other Requirements
Positions in this class typically require grasping, stooping, squatting, lifting, kneeling, crouching, reaching, writing, pushing, talking, hearing, seeing, and repetitive motions

Sensory Requirements:
•Concentrated and attentive use of one or more senses (visual, audio, and other sensory modalities) for proof reading, data entry, tabulating data
•Ability to operate in an environment with frequent interruptions from people and or noises, which in return could result in some level of stress, fatigue, or strain 
•Comprehension of written information in work related documents
•Ability to hear, understand, and distinguish speech 

Working Conditions:
Positions in this class typically require:  grasping, talking, hearing, seeing, and repetitive motions.

Physical Requirements:

•Essential and marginal functions may require maintaining physical condition necessary for sitting, standing, climbing, or walking extended periods of time
•Light to moderate lifting and carrying; some crouching, stooping, squatting, crawling, reaching, pushing, and pulling when performing tasks
•Adequate vision, hearing, and speech required

Sensory Requirements:

•Concentrated and attentive use of one or more senses (visual, audio, and other sensory modalities) for proof reading, data entry, tabulating data
•Ability to operate in an environment with frequent interruptions from people and or noises, which in return could result in some level of stress, fatigue, or strain
•Comprehensive of written information in work related documents
•Ability to hear, understand, and distinguish speech

Working Conditions:

Work is performed in an indoor office environment with moderate exposure to atmospheric conditions; moderate exposure to environmental conditions (such as officers, community members, victims, etc.); and frequent exposure to computer screens, files and phone.

Preferred Qualification

Experience with one or more of the following software/coding languages: ESRI ArcGIS, SQL, Microsoft Access, Microsoft Excel, Python.  Experience with data analysis/research in one or more of the following areas: Criminal Investigative Analysis, Tactical Crime Analysis, Strategic Analysis, Administrative Analysis.

Minimum Qualifications

Currently enrolled in an accredited college or university and major course work with an emphasis in crime analysis, criminal justice, geography, mathematics, or related field (Masters level is preferred).  Candidate must have both technical skills and strong critical thinking skills.

Conditions of Employment

The City’s Background Check Policy requires background checks to be conducted on final internal or external candidate(s) applying for any position with the City of Charlotte. The type of information that will be collected as part of a background check includes, but is not limited to: reference checks, social security verification, education verification, criminal conviction record check, and, if applicable, a credit history check, sex offender registry and motor vehicle records check.

Background checks must be in compliance with all federal and state statutes, such as the Fair Credit Reporting Act (FCRA). The checks must be consistent with the guidelines set forth by these laws requiring organizations to obtain a candidate’s written authorization before obtaining a criminal background report, motor vehicle records check or credit report; and to properly store and dispose of information derived from such reports.

Final candidates must pass a pre-employment drug-screening test and physical examination. During the selection process, candidates may be asked to take a skills test, and/or participate in other assessments.

The City of Charlotte is an Equal Opportunity Employer.

How To Apply

Apply online.

Federal law requires employers to provide reasonable accommodations to qualified individuals with disabilities. Please tell us if you require a reasonable accommodation to apply for a job.

You are welcome to visit the City of Charlotte Human Resources Department lobby where we have workstations available. Our office is located at 700 East 4th Street, Suite 200, Charlotte, NC 28202. Our hours are Monday through Friday, 8 a.m. to 5 p.m. (EST), excluding official City holidays.

Anyone seeking an accommodation to apply for a job may call (704) 336-2285 for assistance or you may email questions to


The City of Charlotte provides a comprehensive benefits package to all employees.

Click here to learn more about the City of Charlotte’s benefits.

The City of Charlotte is a drug and alcohol-free workplace.

In Conclusion

If you have technical issues submitting your application, click here.

Table displaying apply links.