Data/Reporting Analyst Jobs

At the City of Atlanta, we are passionate about building and improving our community. Our police officers, firefighters and building inspectors keep our citizens safe. Our Public Works staff keeps our City clean and helps maintain, build and improve our City’s infrastructure. Our City planners help envision and shape future City growth. Our Parks & Recreation professionals enhance our quality of life.

Our engineers help keep our drinking water clean, the largest airport in the world (by passenger volume) operating and our buildings maintained. Along with the host of Finance, Procurement, and Human Resources professionals whose support is vital, we are the City of Atlanta! If you are seeking a meaningful role where you can make a real difference improving and growing our City, we welcome you to explore the job opportunities we have to offer.

Posting Expires: May 17, 2023

General Description And Classification Standards

• Produces reports and dashboards summarizing data and providing commentary or observations based on through analysis
• Performs reporting and analysis in support of departmental research, performance reporting, operations management, and departmental operations
• Plans and executes projects to study operations effectiveness and trends
• May also lead other related administrative or operations processes within the organization as needed
• Designs and prepares reports by accessing databases or by consolidating data from multiple data sources
• Sources of data may be enterprise systems, complex spreadsheets, databases, etc. requiring specialized expertise or training

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:

• Generates reports, presentations, graphics, forms, and other documents to demonstrate information flow and project results
• Receive and submit invoices for payment to MSO
• Work with vendor/contractor to complete submittals of E-Verify, additional estimates,
• Designs standard report formats based on organizational needs for information
• Reviews assigned operating records and/or databases for quality
• Innovation by identifying processes or reporting functions that do not provide the necessary level of completeness, detail, or accuracy
• Reviews monthly operating statistics and operating data and prepares operating reports
• Presents periodic reports or special projects to management; partners with 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.
• Track, document and prepare daily, weekly, monthly performance reporting/metrics for ATL Stats
• Receives assignments and plans for data collection and analysis for assigned departmental functions or activities.
• Assist managers with recruitment, record maintenance and payroll processing, and provide clerical support to all employees.
• Designs custom reports and data dashboards for projects and standard report formats for organizational needs
• Setting up requisitions, process and submit requisitions to MSO
• Analyze and track vendor/contractor encumbrances e.g., PO’s and invoices on hold reports

Decision Making

May interpret organizational policies and recommend exceptions; establishes work methods, timetables, performance standards, etc.

Leadership Provided

• Serves as a technical resource to other employees
• Provides leadership to assigned Supervisors, field staff, interns, temporary employees, etc.

Supervision Received

Direction received is general and focuses on end results and is typically collaborative in nature.

Knowledge, Skills & Abilities

• 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
• Functional knowledge of procurement, contracts, payroll, and SLA’s
• Ability to organize and present data in presentations and narrative reports
• Thorough knowledge of databases, reporting methods and formats and appropriate reporting languages
• Excellent customer service
• Ability to review data and identify data trends and/or inconsistencies

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).

3 years of work experience in creation, reporting, and/or management of data or closely related tasks (not including data entry).

Preferred Education & Experience

• Experience with R, Python, Visual Basic is preferred
• SQL, Microsoft Access, Microsoft Excel
• ATL Serv, Maximo, Hansen, or similar work order and asset management programs
• 3-4 years data analysis experience

Licensures and Certifications

No specific certifications or licensures required.

Essential Capabilities And Work Environment

Required physical, lifting, and sensory capabilities are requirements to perform the job successfully. Typical environmental conditions associated with job.