Data Analyst

The Metropolitan Police Department (MPD) is the law enforcement organization serving Washington, D.C. This Data Analyst role monitors and improves the quality, classification, and accuracy of crime, crash, and other field-reporting data while developing queries, dashboards, reports, and business processes. The position also provides technical support, requirements analysis, training, audits, and communication with MPD personnel, citizens, and vendors.

What you'll do:

• Examining and evaluating automated field reports and data stored in computer applications of varying degrees of complexity, accuracy and legibility to determine the appropriateness of initial classifications and other information entered by field reporting units and citizens. This may include incident reports, offense reports, traffic crash reports, arrest reports, DUI arrest reports, citizens-online reports, missing persons reports, field contact reports, etc
• Screening reports for data quality to determine that all required crime or crash related information is present in an acceptable form and secures any further information required prior to officially approving the report
• Ensuring report data quality accuracy related to codes and related fields for both crime and crash incidents
• Verifying and reclassifying, as necessary, the reports for Federal Bureau of Investigation (FBI) National Incident Based Reporting System (NIBRS) and Uniform Crime Reporting (UCR) Standards, as well as the Federal Motor Carrier Safety Administration (FMCSA)-Minimum Model Uniform Crash Criteria (MMUCC) Guidelines. Records any reclassifications into the relevant database/software application
• Corresponding with citizens and officers via email and/or telephone to improve the completeness and clarify of the content in their report for data quality purposes
• Maintaining records of reports that have been rejected, updated, re-coded, etc., and the reason for these actions. Providing this documentation when needed for audit purposes
• Providing more efficient methods for procedural processing. This includes testing and providing feedback on application functionality, as well as serving as a team leader in business process development
• Maintaining and consulting a reference library of: DC Code statutes; FBI, NIBRS and UCR procedures; written Departmental Directives; Teletypes; criminal arrest procedures; training guides and relevant memorandums; and Traffic Crash, Commercial Vehicles, and Citizen Online procedures
• Developing complex queries (SQL) used by reporting environments and data-driven dashboard applications, including queries and visualizations for ad-hoc requests and projects, as well as ongoing reporting
• Designing and implementing reports using MS Excel, OneDrive, R, Tableau, or other reporting tools. Using data and metrics to draw business insights, with a special focus on efficiency, easing administrative burden, improving information products and reports
• Preparing records, correspondence and reports using word processing and spreadsheet applications that assist with improving the quality and accuracy of MPD’s data
• Performing audits on statistics to ensure all information is complete and accurate, as needed

What they're looking for:

• • Knowledge in analytical and problem-solving skills, and the ability to plan long and short-term project work
• • Skilled in working closely with individuals and groups to identify issues, analyze alternatives, and resolve problems
• • Skilled in preparing analytical reports and decision memos, identify policy or process issues, and offer multiple resolution options
• • Skilled in responding to people in a tactful manner; react quickly and appropriately to requests for information; establish and maintain cooperative working relationships with MPD's staff and others
• • Knowledge of project management principles and methods
• • Advanced expertise in Microsoft Excel or similar tools including BI tools
• • Proficient in the use of personal computers and various software, such as Microsoft Word, Microsoft Visio, and PowerPoint
• • Knowledge in programming languages like SQL, analyzing and exploring the data, running queries and identifying and interpreting trends in data
• • Skill in using software database applications, with specific expertise in MPD's Records Management System (RMS)
• • Ability to identify issues and problems, and recommend solutions for enterprise-level initiatives
• • Ability to communicate effectively both orally and in writing; prepares and presents written and oral presentations
• • Ability to respond to people in a tactful manner; reacts quickly and appropriately to requests for information; establish and maintain cooperative working relationships with MPD's staff and others

Benefits:

• Health insurance
• Prescription drug coverage
• Dental insurance
• Vision insurance
• Short-term disability insurance
• Long-term disability insurance
• Life insurance
• Retirement benefit
• Savings options
• Employer-contributed 401a plan after one year of employment