APD - Data/Reporting Analyst II

City of Atlanta•Atlanta, GA

2d•$47,475 - $47,475•Hybrid

About The Position

The Data/Reporting Analyst II reports to the Atlanta Police Department Chief Administrative Office (CAO) and performs seasoned-level reporting and analysis in support of departmental research, performance reporting, operations management, and departmental operations. The position plans and executes projects to study operational effectiveness and trends, accesses databases and consolidates information from multiple sources, designs and produces reports, and summarizes findings with commentary or observations. The position does not perform data entry. Data sources may include enterprise systems, complex spreadsheets, and databases requiring specialized expertise or training. The role may also lead related administrative or operations processes of a similar level of professional challenge. The position receives general, collaborative direction focused on outcomes and plans its own work and project schedules. The position follows the City’s hybrid work schedule policy as assigned by the Department of Human Resources Commissioner. It requires in-person work at City worksites or facilities at least four days per week, with the option to work remotely one day per week subject to eligibility, departmental needs, and supervisor approval. The schedule may change to five days of in-person work. The position involves sedentary work, with occasional exertion of up to 10 pounds and frequent or constant exertion of negligible force. The City of Atlanta provides reasonable accommodations to qualified individuals with disabilities and is an Equal Opportunity Employer that values and encourages diversity.

Requirements

Bachelor’s degree in business or public administration, accounting, finance, information technology, statistics, human resources, or a related field; on an exceptional basis, additional experience may substitute for the degree, with at least eight years of professional related experience in data creation, reporting, and/or management.
At least four years of professional related experience in data creation, reporting, and/or management, or closely related tasks; data entry does not count toward this experience.
Required skills: SQL, Microsoft Access, and Microsoft Excel.
Thorough knowledge of databases, reporting methods and formats, and appropriate reporting languages.
Skill in using computers to retrieve data and prepare reports and presentations, writing narrative reports, and communicating.
Skill in leading groups and speaking to groups.
Ability to organize and present data in presentations and narrative reports.
Ability to review data and identify trends and/or inconsistencies.

Nice To Haves

Bachelor’s degree in a listed or related field, plus five years of data analysis experience.
Experience with R, Python, or Visual Basic.

Responsibilities

Plan data collection and analysis for assigned departmental functions or activities.
Design custom reports and data displays for projects, and standard report formats for ongoing functions, based on organizational information needs.
Review assigned operating records and databases for quality and identify processes or reporting functions that lack necessary completeness, detail, or accuracy.
Retrieve and summarize data from various information systems for research or operating reports.
Write queries in the appropriate reporting language.
Review monthly operating statistics and data and prepare operating reports.
Lead or participate in internal and external research projects by collecting, reviewing, and summarizing results.
Generate reports, presentations, graphics, forms, and other documents to demonstrate information flow and project results.
Present periodic reports or special projects to organizational management.
Interact with line staff, managers, and supervisors while conducting studies, surveys, or audits.
Perform duties related to maintaining and operating administrative and information systems in the assigned area.
May interpret organizational policies and recommend exceptions, and establish work methods, timetables, and performance standards.
May provide leadership to lower-level employees, interns, or temporary employees.
Serve as a technical resource or mentor to other employees.
Perform other duties as assigned.