Data Analytics Specialist Senior

Department: Charlotte-Mecklenburg Police Department

Salary: $81,226.00 - $116,762.94 Commensurate with Experience

Welcome to the City of Charlotte

Charlotte is America’s Queen City, opening her arms to a diverse and inclusive community of residents, businesses and visitors alike. Here you will find a safe, family-oriented city where people work together to help everyone thrive. The mission of the City of Charlotte is to deliver quality public services and promote the safety, health, and quality of life for all residents.

Our guiding principles include:

• Attracting and retaining a skilled and diverse workforce

• Valuing teamwork, openness, accountability, productivity, and employee development

• Providing all customers with courteous, responsive, accessible, and seamless quality services

• Taking initiative to identify, analyze, and solve problems

• Collaborating with stakeholders to make informed decisions

SUMMARY

The Data Analytics Specialist Senior position will be expected to offer data driven intelligence to every aspect of the organization based on ever-evolving leadership demands. This position will work closely with other senior members and supervisors of the Crime Analysis & Data Analytics Division to dissect and document new data sources and software solutions to advance analytical capabilities, including establishing new standard operating procedures and peer review processes.

Major Duties and Responsibilities:

• Using crime analysis software provided, conduct research and administrative analysis 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
• Perform research and trend assessments using a variety of complex data sources to generate and present findings
• Conduct quality assessments of data, ETL processes, and dashboard/application outputs.
• Research criminal intelligence and crime analysis industry trends and software solutions
• Assist with system administration of various software packages used by the Crime Analysis & Data Analytics Division
• Prepare a variety of work products, including mapping (ArcGIS) outputs, to support management and supervision decisions as well as to further investigations
• Support problem-solving efforts by utilizing the SARA model to assist in long term crime reduction efforts and workload assessments
• Respond to ad-hoc requests for data from all levels of the department 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 recommend action steps
• Performs other duties as assigned

Minimum Qualifications:

• Bachelor’s Degree with an emphasis on criminal justice, public administration, mathematics or related field
• Minimum of seven (7) years working experience with analysis/statistical research, preferably in a law enforcement setting
• Valid North Carolina or South Carolina Driver’s License

Preferred Qualifications:

• Master’s Degree with an emphasis on criminal justice, public administration, mathematics or related field
• Minimum of four (4) years working experience with analysis/statistical research, preferably in a law enforcement setting

Knowledge, Skills, and 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. 

Other:

Candidate must have US Citizenship and maintain a valid driver’s license.

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 and does not unlawfully discriminate on the basis of race, religion, color, sex, national origin, marital status, age, disability, sexual orientation, political affiliation or on the basis of actual or perceived gender as expressed through dress, appearance, or behavior.

Our culture is to serve the community honorably.

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 self-service application kiosks are available. They are located in our office at 700 East 4th Street, Suite 200, Charlotte, NC 28202. We are open Monday through Friday, from 9:30 a.m. to 3:30 p.m. (EST), excluding official City holidays.

For questions about your application or the hiring process, please email [email protected]

The City of Charlotte is committed to making our services and programs accessible to all. Upon request, auxiliary aids, written materials in alternate formats, language access, and other reasonable accommodations or modifications will be provided. To make a request, please fill out the Innovation & Technology ADA request form or call 704.336.4120.

BENEFITS

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

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

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