City of Atlanta
Data Reporting Analyst, Sr.- Governmental Affairs
Job Description
General Description and Classification Standards
Performs seasoned-level reporting and analysis work in support of 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. Supervision Received Direction received is very general and focuses on end results and is typically collaborative in nature. Position plans own work and project schedules and sequences.
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.
Decision Making
May interpret organizational policies and recommend exceptions; establishes work methods, timetables, performance standards, etc.
Leadership Provided
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.
Qualifications – External
Minimum Qualifications – Education and Experience
Bachelors degree in business/public administration, accounting, finance, information technology, statistics, human resources, or a related field (equivalent professional experience may be considered for substitution for the required degree on an exception basis).
Four (4) years of work experience in creation, reporting, and/or management of data or closely related tasks (not including data entry).
Required Skills: SQL, Microsoft Access, Microsoft Excel
Preferred Education & Experience
Bachelors 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 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.