Human Resources Data Reporting Analyst

HR Data Reporting Analyst (DPW)

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: Open Until Filled

Salary:  $42,000 - $58,000

General Description and Classification Standards

Performs seasoned-level reporting and analysis work in support of HR & Business unit/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 performs data entry in support of and to develop required reports. Sources of data may be enterprise systems, complex spreadsheets, databases, etc. requiring specialized expertise or training in pivot tables, and data mining of HRIS/Oracle Cloud-type databases. Note: This position will work as an active member of the HR team and will need to be able to automate monthly transactional (e.g., headcount, open position, turnover, and NPS) reports. This role may also lead other related administrative or operations processes within the organization provided they have a similar level of professional challenge.

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 internal and external organizational departments.
  • 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.
  • Analyzes data and statistics for trends and patterns with attention to recruitment, hiring practices, motivation, turnover, and compliance with employment laws and regulations.
  • Prepares reports of data results, presenting and explaining findings to peers to include senior leadership.
  • Identifies and recommends reasonable short- and long-term goals, milestones, and benchmarks for key performance metrics.
  • Engage with staff to ensure data strategies and products are tailored to their needs and contributes to the overall success of the department.

Qualifications - External

Minimum Qualifications, Education and Experience

• Bachelor’s degree in business, 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).
• 4 years of work experience in creation, reporting, and/or management of data or closely related tasks (not including data entry).
• Exposure to and understanding of various HRIS products and how they product standard HR Reporting. Required Skills: SQL, Microsoft Access, Microsoft Excel

 Preferred Education & Experience

Bachelor’s degree as described above, plus 5 years data analysis experience. Experience with Oracle Cloud, Advanced Microsoft Excel, R, Python, and Visual Basic is preferred.  2 or more years of experience as an HR Specialist.

Licensures and Certifications

No specific certifications or licensures required.

Individual positions may require completion of training in specific reporting languages or software.