DWM Data/Reporting Analyst II (OES)

City of Atlanta•Atlanta, GA

20h•Hybrid

About The Position

Performs seasoned-level reporting and analysis in support of departmental research, performance reporting, operations management, and departmental operations. Plans and executes projects to study operational effectiveness or trends; designs reports using databases and data consolidated from multiple sources; and summarizes findings with commentary or observations. The position does not perform data entry. Data may come from enterprise systems, complex spreadsheets, and databases requiring specialized expertise or training. The role may also lead related administrative or operational processes of similar professional challenge. Work is planned with general direction focused on outcomes, and the analyst plans their own work, project schedules, and sequences. 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 of in-person work.

Requirements

Bachelor’s degree in business/public administration, accounting, finance, information technology, statistics, human resources, or a related field.
At least four years of professional related experience in creation, reporting, or management of data, or closely related tasks; data entry experience does not count.
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.
Ability to lead groups and speak to groups.
Ability to organize and present data in presentations and narrative reports.
Ability to review data and identify trends or inconsistencies.

Nice To Haves

Bachelor’s degree as described in the minimum qualifications, 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 that lack completeness, detail, or accuracy.
Retrieve and summarize data from 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 when conducting studies, surveys, or audits.
Perform duties related to maintaining and operating administrative and information systems in the assigned area.
May interpret organizational policies, recommend exceptions, and establish work methods, timetables, and performance standards.
May provide leadership to lower-level staff, interns, or temporary employees, and serve as a technical resource or mentor.
May perform other duties as assigned.