APD - Data/Reporting Analyst II
About The Position
The Data/Reporting Analyst II performs seasoned-level reporting and analysis in support of departmental research, performance reporting, operations management, and departmental operations for the Atlanta Police Department Chief Administrative Office. The role plans and executes projects to study operational effectiveness and trends, designs and prepares reports by accessing databases or consolidating data from multiple sources, and summarizes findings with commentary or observations. Data sources may include enterprise systems, complex spreadsheets, and databases requiring specialized expertise or training. The position does not perform data entry. The role receives general, collaborative direction focused on end results and plans its own work and project schedules. It may also lead related administrative or operational processes of comparable professional complexity. 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 based on eligibility, departmental needs, and supervisor approval. The schedule may change to five days in person. The work is sedentary, involving exertion of up to 10 pounds occasionally and negligible force frequently or constantly.
Requirements
- Bachelor’s degree in business/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 experience does not count toward this requirement.
- Required skills in SQL, Microsoft Access, and Microsoft Excel.
- Thorough knowledge of databases, reporting methods and formats, and appropriate reporting languages.
- Skill operating 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 operating records and databases for quality, and identify processes or reporting functions lacking completeness, detail, or accuracy.
- Retrieve and summarize data from multiple 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 for the assigned area.
- Interpret organizational policies and recommend exceptions; establish work methods, timetables, and performance standards, as applicable.
- Provide leadership to lower-level employees, interns, or temporary employees, as applicable.
- Serve as a technical resource or mentor to other employees.
- Perform other duties as assigned.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
