Overview
The City of Charlotte is the largest municipality in North Carolina and the 15th largest city in the United States, with a total population of more than 897,000 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.
Summary
The Data Analytics Specialist Lead position responsibility is directly related to the utilization of a variety of databases and information sources within the Charlotte-Mecklenburg Police Department for the purpose of providing decision support mechanisms for police personnel. This position requires high levels of interaction with patrol and investigative personnel as well as oral and written communication skills including the ability to articulate ideas, concepts, findings, results as well as interpretations and evaluations of data. Work involves operating in a team environment and is performed with latitude for independent judgment and initiative.
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.
• Actively participate in accountability review sessions, providing analysis and findings in a format that allows for its assessment by command staff.
• 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.
• Respond to ad-hoc requests for data and reports from all levels of the department, other agencies, the media, and citizens with statistical summaries and reports.
• 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 to collaborate on crime series and trends, wanted suspects, and major cases. Share information gleaned at such meetings as relevant to department personnel for increased awareness, response planning or investigative support.
• Attend regional meetings of crime analysis professionals in order to share information on crime patterns, new methodologies, and developing tools.
• Performs other duties as assigned
Knowledge, Skills & Abilities
• Must have strong working knowledge of connecting to data in a variety of SQL Server/Oracle databases using software such as Toad Data Point, MS Access, ArcGIS, and link analysis software to query, analyze and report on findings
• Must have knowledge of data warehousing/data marts, ETL processes, GIS, algorithms/statistical methods, and crime analysis techniques to support business processes
• Data analysis/research in Criminal Investigative Analysis, Tactical Crime Analysis, Intelligence Analysis.
• Strong critical thinking skills
• Ability to think long-term and strategically
• Ability to handle change and be flexible in a dynamic environment
• Experience in building collaborative partnerships both internally and externally to enhance and expand delivery of business intelligence services
• Ability to identify critical priorities and align analytical efforts
• Ability to coach and mentor a diverse group of data analytics and business intelligence professionals
• Familiarity with CMPD systems such as KBCOPS, CJ Leads, and CAD
ADA and Other Requirements:
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 for 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 proofreading, 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 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
Master’s Degree with an emphasis on criminal justice, geography, mathematics, or related field.
Minimum Qualifications
High School Graduate or Equivalent and seven years related work experience
OR
Associate's Degree and five years related work experience
OR
Bachelor's Degree and three years related work experience
OR
Master's Degree and one year related work experience
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 CityHrJobPostingsNotify@ci.charlotte.nc.us.
Benefits
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.
