Airport Data/Reporting Analyst II- Regulatory Compliance

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

Job summary

City of Atlanta is seeking a seasoned data reporting and analytics professional to support departmental research, performance reporting, and operations management. The role designs reports, queries data, and presents findings to management, with hybrid work and an emphasis on data quality and process improvement.

Requires a Bachelor’s degree in a related field and at least four years of data reporting experience, plus proficiency in SQL, Access, and Excel.

Qualifications

• Bachelor’s degree in business/public administration, accounting, finance, information technology, statistics, human resources, or a related field.
• Minimum of four (4) years of professional related experience in creation, reporting, and/or management of data or closely related tasks.
• Required Skills: SQL, Microsoft Access, Microsoft Excel.

Responsibilities

• 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.
• May interpret organizational policies and recommend exceptions; establishes work methods, timetables, performance standards, etc.
• May provides leadership to lower level, interns, temporary employees, etc.
• Serves as a technical resource or mentor to other employees.
• May perform other duties as assigned.

Skills

SQL

Microsoft Access

Microsoft Excel

Education

Bachelor’s degree in business/public administration, accounting, finance, information technology, statistics, human resources, or a related field

Job description

Job Description

Salary range: $47,474-$65,000

Posting expires: November 13, 2026

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.

Responsibilities

• 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.
• May interpret organizational policies and recommend exceptions; establishes work methods, timetables, performance standards, etc.
• May provides leadership to lower level, interns, temporary employees, etc.
• Serves as a technical resource or mentor to other employees.
• 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.

Qualifications

• Bachelor’s degree in business/public administration, accounting, finance, information technology, statistics, human resources, or a related field (Additional years of experience may be considered as a substitute for the required degree on an exceptional basis, with a minimum of eight (8) years of professional related experience in creation, reporting, and/or management of data or closely related tasks).
• A minimum of four (4) years of professional related experience in creation, reporting, and/or management of data or closely related tasks.
• Required Skills: SQL, Microsoft Access, 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.