Data/Reporting Analyst II

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

Job summary

City of Atlanta is seeking a Data Reporting Analyst II to support the Office of Park Planning and Design (OPPD) within DPR. The role focuses on managing planning and real estate data, designing dashboards, and producing monthly and fiscal reports to track project milestones.

Responsibilities include creating reports, coordinating with project managers, and establishing data standards. The position follows the City’s hybrid schedule, with in-person days and remote options.

Qualifications

• Bachelor’s degree in a related field (additional years of experience may substitute for the degree).
• Minimum 8 years of professional data creation, reporting, and/or management experience.
• Required skills: SQL, Microsoft Access, Microsoft Excel.

Responsibilities

• Manage data related to planning and real estate acquisitions and related information.
• Design, builds, and maintains tracking systems and databases for acquisitions and planning milestones.
• Create custom reports, dashboards, and data displays for projects; prepare monthly/quarterly/yearly reports.
• Coordinate data collection/analysis with project managers and other departments; ensure data quality.

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

Tools

ArcGIS

Power BI

Tableau

R

Python

Visual Basic

Job description

Job Description

Parks & Recreation

Data Reporting Analyst II

Posting Expires: November 19, 2026

Salary: $60,000 - $65,000/annually

General Description and Classification Standards

Performs seasoned-level reporting and analysis work in support of the Office of Park Planning and Design (OPPD) within the Department of Parks and Recreation (DPR), with a primary focus on the planning division. Manages data related to OPPD's planning efforts and real estate acquisitions, ensuring planning and real estate projects are properly recorded, filed, and reported so the team can meet critical project milestones. 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, GIS, 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

Essential Duties and Responsibilities: These are typical responsibilities for this position and should not be construed as exclusive or all inclusive.

• Manages data related to OPPD's planning efforts and real estate acquisitions, including property, parcel, acquisition, and planning study information.
• Designs, builds, and maintains tracking systems and databases for real estate acquisitions, recording key milestones, agreements, easements, due diligence items, surveys, and required filings.
• Ensures planning and real estate project records and documents (deeds, plats, legal descriptions, agreements, and county tax exemption filings) are properly recorded, filed, and retrievable.
• Tracks project milestones and deadlines for planning and real estate projects and alerts project managers to upcoming or missed milestones.
• Receives assignments and plans for data collection and analysis for assigned planning, real estate, and project delivery functions.
• Designs custom reports, dashboards, 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.
• Retrieves and summarizes data from various information systems, including GIS and parcel/property data, for inclusion into research, planning, or operating reports.
• Writes queries in the appropriate reporting language.
• Reviews monthly operating statistics and project data and prepares monthly, quarterly, and fiscal year reports on OPPD's project delivery pipeline.
• Supports planning studies and community engagement efforts by collecting, analyzing, and summarizing demographic, park access, survey, and other planning data.
• Generates reports, presentations, maps, graphics, forms, and other documents to demonstrate information flow and project results.
• Presents periodic reports or special projects to OPPD and DPR leadership.
• Coordinates with project managers, the Department of City Planning, and other City departments to collect, reconcile, and share planning and property data.
• Establishes data standards, work methods, and procedures for OPPD records and reporting, and serves as a technical resource to other employees.
• May provide leadership to interns, temporary employees, etc.
• 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

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.
• Knowledge of real property records and documents, such as deeds, plats, easements, legal descriptions, and tax parcel data, and of planning and project management terminology.
• Knowledge of data governance, records management, and quality control practices.
• Skill in operation of computers to retrieve data and prepare reports, dashboards, maps, 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 for technical and non-technical audiences.
• Ability to review data and identify data trends and/or inconsistencies.
• Ability to manage multiple priorities and deadlines and to work effectively with project managers, partner departments, and the public.

Qualifications

Minimum 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),
• with a minimum of four (4) years of professional related experience in creation, reporting, and/or management of data or closely related tasks (not including data entry).
• 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, or in planning, real estate, geography/GIS, or a related field, plus 5 years data analysis experience, including experience managing real estate, property, or planning data. Experience with GIS (ArcGIS), Power BI or Tableau, R, Python, or 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.