Data Analyst

There is only one city in the country that can say it is the Nation’s Capital – Washington, D.C. Given that distinction, The Metropolitan Police Department is the premiere law enforcement organization in the city. We receive over 22 million visitors a year, have almost 700,000 residents, and 21,000 private business. The Department consists of more than 4,200 members: approximately 3,550 sworn members and over 650 civilian employees. We are one of the most diverse and highly trained departments in the country. We have the honor of safeguarding and protecting not only our nation’s residents, but also people from all over the world.

The Metropolitan Police Department (MPD) offers an attractive benefits package. The benefits package includes competitive compensation, health insurance, prescription drug coverage, dental, vision, short- and long-term disability and life insurance, as well a strong retirement benefit and savings options. Employees are also eligible for our employer contributed 401a plan after one year of employment. Additional perks such as discounts on wireless carriers, gym memberships, amusement park tickets and much more! Additional information can be found at: DCHR Benefits

This position is located in the Metropolitan Police Department (MPD), Technical and Analytical Services Bureau (TASB), Applications Management Division, Data Quality Branch. The incumbent is responsible for monitoring 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.

This Data Analyst position is covered under the National Association of Government Employees (NAGE) bargaining unit and you may be required to pay an agency fee through direct payroll deductions.

The incumbent will be responsible for the following:

• Examines and evaluates 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.
• Screens 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.
• Ensures report data quality accuracy related to codes and related fields for both crime and crash incidents.
• Verifies and reclassifies, 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.
• Corresponds 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.
• Maintains records of reports that have been rejected, updated, re-coded, etc., and the reason for these actions. Provides this documentation when needed for audit purposes.
• Provides 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.
• Maintains and consults 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.
• Develops 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.
• Designs and implements reports using MS Excel, OneDrive, R, Tableau, or other reporting tools. Uses data and metrics to draw business insights, with a special focus on efficiency, easing administrative burden, improving information products and reports.
• Prepares records, correspondence and reports using word processing and spreadsheet applications that assist with improving the quality and accuracy of MPD’s data.
• Performs audits on statistics to ensure all information is complete and accurate, as needed.
• Visits police districts and specialized units to familiarize members with Data Quality Branch functions. Gathers requirements when districts require a new BI report to make their process more effective and efficient.
• Determines whether irregularities affect the validity of the information contained in reports.
• Provides on-the-job training to new or less-experienced professional or sworn members. This includes serving as a subject matter expert or “go-to” person for less senior staff needing assistance reviewing more complex reports.
• Provides regular procedural and technical support of the Records Management System and responds to any sworn member, court representative or citizen requests.
• Establishes and implements effective requirements practices, including use and continuous improvement of a data requirements process and tools. Implements ways to reuse requirements across projects.
• Asks probing questions to fully understand business requirements and provide feedback to the business on the implications of requests
• Quickly understands issues and challenges faced by the business. Accurately and concisely articulates issues, risks, questions, and recommendations to customers, team members and management.
• Builds and maintains highly effective relationships with all MPD teams and vendors. Ensures relationships with the customers and cross-team members are professional and meet management expectations.
• Performs other related duties as assigned.

Qualifications

• 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. Knowledge of Cognos, Power BI and/or Tableau is preferred.
• 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.

Licensures, Certifications and other requirements
N/A

Education
High School Diploma or Equivalent.

Work Experience
Applicants must have at least one (1) year of specialized experience equivalent to at least the CS-11 grade level, or its non-District equivalent, gained from public or private sector. Specialized experience for this position includes, but is not limited to: understanding criminal code and procedures to conduct examination of documents and electronic records, and to code and classify reports; experience with operating various software packages and database applications to develop, maintain, and update contents and run queries to analyze data; and the ability to express and present ideas regarding complex topics through both written and oral communications.

Work Environment
Work location is in an office environment. Work is sedentary and may require walking and standing in conjunction with travel and attendance at meeting and conferences away from the work site and carrying light items, such as laptops, papers, books, small parts, and driving an automobile.

Other Significant Factors
Promotion Potential: No Known Promotion Potential

This position is deemed as "Security Sensitive” pursuant to Chapter 4 of the D.C. Personnel Regulations, in addition to the general suitability screening and criminal background check (pre-employment and periodic), individuals may be subject to the following checks and tests:
a. Traffic record check (as applicable);
b. Pre-employment drug and alcohol test (as applicable);
c. Consumer credit check (as applicable);
d. Reasonable suspicion drug and alcohol test;
e. Random drug and alcohol test;
f. Return to duty or follow-up drug and alcohol test; and
g. Post-accident or incident drug and alcohol test.

The incumbent is required to possess and maintain a valid motor vehicle operator’s permit.

The District of Columbia Government is an Equal Opportunity Employer: all qualified candidates will receive consideration without regard to race, color, religion, national origin, sex, age, marital status, personal appearance, sexual orientation, gender identity or expression, family responsibilities, matriculation, political affiliation, genetic information, disability. Sexual harassment is a form of sex discrimination, which is also prohibited. In addition, harassment based on any of the above-protected categories is prohibited.

Click here to review additional information Employee Disclosure & Information for Applicants