DWM Data/Reporting Analyst II (OSSEM)

City of Atlanta•Atlanta, GA

About The Position

Performs seasoned-level reporting and analysis work supporting 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. Lays out report formats and produces reports. Summarizes data and provides commentary or observations based on analysis. Position does not perform data entry. Sources of data may be enterprise systems, complex spreadsheets, databases, etc., requiring specialized expertise or training. Note: positions in this class may also lead to other related administrative or operations processes within the organization, provided they have a similar level of professional challenge. The directions received are general. The position focuses on end results and is typically collaborative in nature. The position plans its own work and project schedules and sequences. These are typical responsibilities for this position and should not be construed as exclusive or all inclusive. COA may change the specific job duties with or without prior notice based on the needs of the organization.

Requirements

Thorough knowledge of databases, reporting methods and formats, and appropriate reporting languages.
Work experience and familiarity with utilizing Drivecam, driver safety monitoring, or similar systems.
Skill in the operation of computers to retrieve data and prepare reports and presentations.
Skill in writing narrative reports.
Skill in communicating.
Skill in leading groups and in speaking to groups.
Ability to conduct training on a one-on-one basis or to a group.
Ability to organize and present data in presentations and narrative reports.
Ability to review data and identify data trends and/or inconsistencies.
Bachelor’s Degree in Business Administration, Public Administration, Accounting, Finance, Information Technology, Statistics, Human Resources, or a related field, and five (5) years of work experience in creation, reporting, and/or management of data or closely related tasks (not including data entry).
Microsoft applications including but not limited to Excel, PowerPoint, and similar applications for data reporting.
Driver’s license - Valid driver’s license in the state of Georgia.

Nice To Haves

Experience with Lytx or any Fleet safety platform is preferred.

Responsibilities

Receives assignments and plans for data collection and analysis for assigned departmental functions or activities.
Data collection from various systems/sources.
Prepare reports using data collected from various systems/sources.
Designs custom reports and data displays for projects and standard report formats for ongoing functions based on organizational needs for information.
Reviews assigned operating records and/or databases for quality.
Identifies processes or reporting functions that do not provide the necessary level of completeness, detail, or accuracy.
Designs standard report formats based on organizational needs for information.
Retrieves and summarizes data from various information systems for inclusion into research or operating reports.
Writes queries in the appropriate reporting language.
Reviews monthly operating statistics and operating data and prepares operating reports.
Leads or participates in internal and external research projects by collecting, reviewing, and summarizing results.
Generates reports, presentations, graphics, forms, and other documents to demonstrate information flow and project results.
Presents periodic reports or special projects to organizational management.
Interacts with line staff, managers, and supervisors when conducting studies, surveys, or audits.
Performs other duties related to the maintenance and operation of administrative and information systems related to the area of assignment.
Provides leadership to lower level, interns, temporary employees, etc.
Serves as a technical resource or mentor to other employees.
Designs standard reporting formats based on organizational needs for information.
Reviews monthly operating statistics and operating data and prepares operating reports.
Supports key communication functions
Assists the communications and community engagement teams on public meetings, events, and in-house activities.
Performs season-level reporting and analysis work in support of departmental performance reporting, operations management, and departmental operations.
Lays out report formats and produces reports.
Summarizes data and provides commentary or observations based on analysis.
Presents periodic reports/special projects to organizational management.
Monitors the vehicle inventory, including but not limited to active, surplus, and assets for maintenance inspection and completion.
Monitoring and analyzing in-vehicle camera footage.
Conducts training related, but not limited to, driver safety and other related topics.
Seasonally assigned in the field during product installation and research, works with employees and vendors.
Conducts inventory reporting.
May perform other administrative duties as assigned.