Airport Data/Reporting Analyst II- Regulatory Compliance

City of Atlanta•Atlanta, GA

6d•$47,474 - $65,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 and trends. Designs and prepares reports using databases and data consolidated from multiple sources, including enterprise systems and complex spreadsheets. Summarizes data and provides analytical commentary or observations; the position does not perform data entry. The position receives general direction focused on end results, typically in a collaborative setting, and plans its own work, project schedules, and sequences. It may also lead related administrative or operational processes of a similar professional level. The role follows the City’s hybrid work schedule policy as assigned: at least four days per week in person at City worksites or facilities, with the option to work remotely one day per week based on eligibility, departmental needs, and supervisor approval. The schedule may change to five days in person.

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, management, or closely related tasks.
Required skills: SQL, Microsoft Access, and Microsoft Excel.
Thorough knowledge of databases, reporting methods and formats, and appropriate reporting languages.
Computer skills for retrieving data and preparing reports and presentations; ability to write narrative reports and communicate effectively.
Ability to lead groups and speak to groups.
Ability to organize and present data in presentations and narrative reports.
Ability to review data and identify trends or inconsistencies.

Nice To Haves

Bachelor’s degree in a listed or related field plus five years of data analysis experience.
Experience with R, Python, or Visual Basic.
On an exceptional basis, additional years of professional related experience may substitute for the degree, with at least eight years of professional related experience in data creation, reporting, management, or closely related tasks.

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.
Review operating records and databases for quality, identifying gaps in completeness, detail, or accuracy.
Retrieve and summarize data from multiple 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 that demonstrate information flow and project results.
Present periodic reports and special projects to organizational management.
Interact with staff, managers, and supervisors while conducting studies, surveys, or audits.
Perform duties related to maintaining and operating administrative and information systems in the assigned area.
May interpret organizational policies and recommend exceptions, and establish work methods, timetables, and performance standards.
May provide leadership to lower-level employees, interns, or temporary employees.
Serve as a technical resource or mentor to other employees.
Perform other duties as assigned.