DWM Data/Reporting Analyst II (OES)

City of Atlanta•Atlanta, GA

1d•$47,474 - $66,000•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 and prepares reports by accessing databases or consolidating data from multiple sources, establishes report formats, summarizes data, and provides commentary or observations based on analysis. This position does not perform data entry. Data sources may include enterprise systems, complex spreadsheets, and databases requiring specialized expertise or training. Positions in this class may also lead related administrative or operations processes of a similar level of professional challenge. The position receives very general direction focused on end results, typically in a collaborative setting, and plans its own work, project schedules, and sequences. It may provide leadership to lower-level employees, interns, or temporary employees and serves as a technical resource or mentor to other employees. 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.

Requirements

Bachelor’s degree in business or public administration, accounting, finance, information technology, statistics, human resources, or a related field.
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 requirement.
Required skills in 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 as described above, 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, identifying processes or reporting functions that lack necessary 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 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.