Hybrid Data/Reporting Analyst, Sr na City of Atlanta

Posting Expires: 8/21/25

Salary Range: $47,474.94-$63,379.04

General  Description  and Classification  Standards  
Performs seasoned -level reporting and analysis work in support of the Atlanta Department of Transportation departmental research, performance reporting, operations management, and departmental operations. Plans and executes projects to study operations effectiveness or trends. Designs and prepares reports by accessing databases or by 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 other related administrative or operations processes within the organization provided they have a similar level of professional challenge.  The Sr. Data Analyst for the Atlanta Department of Transportation (ATLDOT) Communications team is a technical professional who will manage tracking , designing, data modeling, and measured deliverables from Capital Delivery, Engineering, and Strategy & Planning. The metrics managed by this position will be essential to the reporting of projects, performance objectives and core benchmarks.   
 

Supervision Received  
The Senior Data Analyst works under the direct supervision of the Chief Communications Officer (CCO).   The 
candidate must be able to work well both independently as well as collaboratively with a team.  
 

RESPONSIBILITIES  Essential Duties & Responsibilities  
These are typical responsibilities for this position and should not be construed as exclusive or all inclusive. May 
perform other duties as assigned.  
• Receives assignments and plans for data collection and analysis for assigned departmental functions or 
activities.  
• 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. 
• Present s specialist able to breakdown complex metrics and visually communicate data in an innovative, 
digestible manner.  
• Create s graphs, charts, tables and technical reports to deliver findings and support collateral. 

• Identifies insights and metrics that support public engagement, editorial content, social media postings 
and presentations.  
• Manage s the Communications asset budget. All shirts, banners, paper, and departmental swag, will be 
purchased, tracked and managed by this role. 
 
Decision Making  
May interpret organizational policies and recommend exceptions; establishes work methods, timetables, 
performance standards, etc. Provides leadership to lower level, interns, temporary employees, etc. Serves as a 
technical resource or mentor to other employees.  
 

Knowledge, Skills & Abilities  
This is a partial listing of necessary knowledge, skills, and abilities required to perform the job successfully. It is not 
an exhaustive list. 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.  
• Strong written skills  
• Proficient in Zoho sheets, BI visualization software and/or Quip  
• Strong grammar skills  
• Proficient knowledge of Microsoft Office Suite, Microsoft Excel and Power Point.  
• Ability to work well in a team environment and can relate to people at all levels of the organization  
• Attention to detail and quality control of ideas, correspondence, and department planning  
• Ability to perform multiple duties and change from one task to another without loss of efficiency or 
composure  
 

QUALIFICATIONS  
Minimum Qualifications - Education and Experience  
1. Bachelor’s degree in business/public administration, accounting, finance, information technology, 
statistics, human resources, or a related field .  
2. Four (4) years of work experience in creation, reporting, and/or management of data or closely related 
tasks (not including data entry).  
3. Required Skills: SQL, Microsoft Access, Microsoft Excel  
 

Preferred Education & Experience  
Degree as described above, plus 5 years data analysis experience. Experience with R, Python, Visual Basic is 
preferred.  
Licensures and Certifications  
No specific certifications or licensures are required . Individual positions may require completion of training in 
specific reporting languages or software 
Essential Capabilities and Work Environment  
Required physical, lifting, and sensory capabilities are requirements to perform the job successfully. Typical 
environmental conditions associated with job. 
Lifting Requirements : 

Sedentary work : Exerting up to 10 pounds of force occasionally and/or negligible amount of force