DWM Data Reporting Analyst II (DWM University)

City of Atlanta; Atlanta (GA); Hybrid; USD 47,000 - 63,000; Full time

Job summary

City of Atlanta seeks an experienced professional to perform advanced reporting and analysis to support departmental research, performance reporting, and operations management. You will design and prepare reports by querying databases and consolidating data from multiple sources, including the LMS, and lead related administrative processes as needed.

Responsibilities include building dashboards on training operations, reviewing data quality, and presenting findings to management.

Qualifications

• Bachelor’s degree in Information Technology, MIS, Data Analytics, Business or Public Administration, or a related field.
• Minimum of four (4) years of professional related experience in creation, reporting, and/or management of data.
• Required Skills: Microsoft Excel.

Responsibilities

• Receives assignments and plans data collection and analysis for assigned functions.
• Designs custom reports and data displays for projects based on information needs.
• Retrieves and summarizes data from various information systems, including the LMS.
• Builds and distributes reports and dashboards on training operations.
• Maintains training databases and dashboards to ensure records are accurate and current.
• Presents periodic reports and special project findings to management.

Skills

Databases

Reporting methods

Reporting languages

LMS

SQL

Communication

Education

Bachelor’s degree in IT / MIS / Data Analytics / Business or Public Administration

Tools

Microsoft Excel

SQL

LMS

Job description

Salary range: $47,474 - $63,379

General Description and Classification Standards

Performs advanced reporting and analysis in support of departmental research, performance reporting, and operations management. Plans and carries out projects that evaluate operational effectiveness and identify trends. Designs and prepares reports by querying databases or consolidating data from multiple sources, including determining report layouts and producing the final product. Summarizes findings and provides commentary and observations drawn from the analysis. This position does not perform data entry. Data sources may include enterprise systems, complex spreadsheets, and databases that require specialized expertise or training to use. Note: positions in this class may also lead related administrative or operational processes within the organization, provided the work carries a comparable level of professional challenge.

Job Description

Posting expires: October 21, 2026

Salary range: $47,474 - $63,379

General Description and Classification Standards

Performs advanced reporting and analysis in support of departmental research, performance reporting, and operations management. Plans and carries out projects that evaluate operational effectiveness and identify trends. Designs and prepares reports by querying databases or consolidating data from multiple sources, including determining report layouts and producing the final product. Summarizes findings and provides commentary and observations drawn from the analysis. This position does not perform data entry. Data sources may include enterprise systems, complex spreadsheets, and databases that require specialized expertise or training to use. Note: positions in this class may also lead related administrative or operational processes within the organization, provided the work carries a comparable level of professional challenge.

Supervision Received

Receives broad direction focused on end results, typically in a collaborative manner. Independently plans own work, including project schedules and sequencing.

Essential Duties and Responsibilities

• Receives assignments and plans data collection and analysis for assigned DWMU functions and activities.
• Designs custom reports and data displays for projects, and standard report formats for ongoing functions, based on DWMU’s information needs.
• Reviews assigned training records and databases for quality and identifies processes or reporting functions that lack the necessary completeness, detail, or accuracy.
• Retrieves and summarizes data from various information systems, including the LMS, using queries written in the appropriate reporting language.
• Reviews monthly training operating statistics and data and prepares operating reports.
• Builds and distributes reports and dashboards on training operations, including course completions, attendance, certification and renewal status, and upcoming expirations, so leadership can monitor compliance and training needs.
• Maintains training databases and dashboards to ensure records are accurate and current, and responds to ad hoc data requests from team members, supervisors, and managers.
• Leads or participates in internal and external research projects by collecting, reviewing, and summarizing results.
• Generates reports, presentations, graphics, forms, and other documents that demonstrate information flow, project results, and trends, and presents periodic reports and special project findings to DWMU management.
• Interacts with line staff, managers, and supervisors when conducting studies, surveys, or audits.
• Supports project coordination by tracking schedules, milestones, and deliverables, producing status reports, and consolidating data from multiple sources to highlight risks, delays, and resource needs.
• May interpret departmental policies and recommend exceptions; establishes work methods, timetables, and performance standards.
• May provide leadership to lower-level staff, interns, and temporary employees, and serves as a technical resource or mentor to other employees.
• Performs other duties related to the maintenance and operation of administrative and information systems in the area of assignment.
• May perform other duties as assigned.

The above statements reflect the general duties, responsibilities and competencies considered necessary to perform the essential duties and responsibilities of the job and should not be considered as a detailed description of all the work requirements of the position. COA may change the specific job duties with or without prior notice based on the needs of the organization.

Knowledge Skills and Abilities

• Thorough knowledge of databases, reporting methods and formats, and appropriate reporting languages.
• Skill in operation of computers to retrieve data and prepare reports and presentations; in writing narrative reports; in communicating.
• Skill in leading groups and in speaking to groups.
• Ability to organize and present data in presentations and narrative reports.
• Ability to review data and identify data trends and/or inconsistencies.

Minimum Qualifications

Education and Experience -

• Bachelor’s degree in Information Technology, Management Information Systems, Data Analytics, Business or Public Administration, or a related field,
• with a minimum of four (4) years of professional related experience in creation, reporting, and/or management of data or closely related tasks (not including data entry).
• Required Skills: Microsoft Excel.

Licensures and Certifications - No specific certifications or licensures required. Individual positions may require completion of training in specific reporting languages or software.

Preferred Requirements - Bachelor’s degree as described above, plus 5 years data analysis experience. Experience with R, Python, Visual Basic is preferred.

Work Environment

Required physical, lifting, and sensory capabilities are requirements to perform the job successfully. Typical environmental conditions associated with the job.

Lifting Requirements

Sedentary work: Exerting up to 10 pounds of force occasionally and/or negligible amount of force frequently or constantly to lift, carry, push, pull or otherwise move objects, including the human body.

Work Schedule

This position follows the City’s hybrid work schedule policy as assigned by the Department of Human Resources Commissioner and requires in-person work at City worksites/facilities at least four (4) days per week, with the option to work remotely one (1) day per week, based on eligibility, departmental needs, and supervisor approval. The hybrid work schedule is subject to change at any time to five (5) days in-person work.

It is the policy of the City of Atlanta (“COA”) that qualified individuals with disabilities are not discriminated against because of their disabilities regarding job application procedures, hiring, and other terms and conditions of employment. It is further the policy of the COA to provide reasonable accommodations to qualified individuals with disabilities in all aspects of the employment process. The COA is prepared to modify or adjust the job application process or the job or work environment to make reasonable accommodations to the known physical or mental limitations of the applicant or employee to enable the applicant or employee to be considered for the position he or she desires, to perform the essential functions of the position in question, or to enjoy equal benefits and privileges of employment as are enjoyed by other similarly situated employees without disabilities, unless the accommodation will impose an undue hardship. If reasonable accommodation is needed, please contact the Human Resources Director for your department.

The City of Atlanta is an Equal Opportunity Employer and does not unlawfully discriminate on the basis of race, color, religion, age, disability, sex, sexual orientation, ender identity, marital status, veteran’s status or national origin, or any other basis prohibited by federal, state, or local law. We value and encourage diversity in our workforce.