HR DATA ANALYST - 55014560

State of Florida; Tallahassee (FL); On-site; USD 54,000 - 70,000; Full time

Job summary

State of Florida Department of Transportation seeks a HR Data Analyst to manage analytics for the FDOT workforce. Responsibilities include producing confidential employee reports and coordinating data across People First, PTMS, and related systems.

The role requires strong Excel and PowerBI skills, plus experience with SQL or Python to create original reports. Join a team that supports information governance and performance management across Central Office and District HR offices.

Qualifications

• Experience analyzing HR data to create original reports from source data.
• Proficient in Excel and PowerBI for data visualization.
• Familiarity with SQL or Python for data querying and manipulation.

Responsibilities

• Responds to executive requests for reports containing confidential employee data.
• Prepares recurring and ad hoc reports on various cadences (daily, weekly, monthly, quarterly).
• Formats data into final reports using pivot tables, VLOOKUP, and PowerBI visuals.
• Collaborates with Budget Office and IT to resolve data discrepancies across systems.

Skills

Excel

PowerBI

SQL/Python

SAP

Tools

PeopleFirst

Business Objects

SharePoint

Job description

The State Personnel System is an E-Verify employer. For more information click on ourE-Verify Website .

Requisition No:883467

Agency: Department of Transportation

Working Title: HR DATA ANALYST - 55014560

STATE OF FLORIDA DEPARTMENT OF TRANSPORTATION

JOB POSTING DESCRIPTION

927 / Human Resources

OPEN COMPETITIVE

SELECTED EXEMPT SERVICE

ANTICIPATED VACANCY

CONTACT PHONE NUMBER: [phone]

HIRING SALARY RANGE: $ 2,082.93 - $ 2,695.56/biweekly range/ $ 54,156.27 - $ 70,084.59 /annual range

Join FDOT and be part of the team that works as one to improve safety, enhance mobility and inspire innovation in the Florida transportation system.

To ensure honesty and transparency, all applicants must provide their own work. Unless explicitly requested, the use of Artificial Intelligence (AI) tools to assist with qualifying questions, work samples, or interviews is strictly prohibited, and any breach of this requirement will lead to the applicant being removed from consideration.

Candidates must be United States (U.S.) citizens or lawfully authorized alien workers. Visa sponsorship is not available.

Our Mission

The mission of the Florida Department of Transportation is to provide a safe statewide transportation system that promotes the efficient movement of people and goods, supports the state’s economic competitiveness, prioritizes Florida’s environment and natural resources, and preserves the quality of life and connectedness of the state’s communities.

Our Vision

As a OneFDOT team, we serve the people of Florida by providing a transportation network that is well planned, supports economic growth, and has the goal of being congestion and fatality free.

The Work You Will Do:

HR Data Analyst, Assistant Secretary for Finance and Administration/Office of Administration/Human Resources

This position will be responsible for Data Analytics related to FDOT’s workforce.

The Difference You Will Make:

Through cooperation, coordination and collaboration among the OneFDOT team, you will be contributing to a strong and empowering culture of TRREC: Trust, Relationships, Respect, Empowerment, and Communication.

How You Will Grow:

FDOT encourages our team members to grow through engagement, empowerment, training, and professional development. Through our agency’s learning management system, you have access to hundreds of computer-based training and instructor‑led courses.

Annual Salary Range:

$ 54,156.27 - $ 70,084.59 /annual range

Your Specific Responsibilities:

Responds to requests from executive leadership, members of Central Office (CO) and District Human Resources Offices (HROs), and other internal and external stakeholders for reports containing confidential employee data. Coordinates and prepares daily, weekly, bi‑weekly, monthly, and quarterly recurring and on‑demand (ad hoc) reports. Assists with establishing methodologies for creating new (original) report types not already available in People First. Accesses confidential employee (source) data contained in the People First human resources information system catalog views, Business Objects - Web Intelligence, Performance and Talent Management System (PTMS), and internal HRO SharePoint databases. Formats source data into finalized reports utilizing a variety of functions to include pivot tables, vertical lookup tables (VLookup) and data visualization software (PowerBI). Works closely with the Budget Office and the Office of Information Technology (OIT) to research, identify, and reconcile employee data discrepancies in People First, Florida Accounting Information Resource (FLAIR), and other databases.

Acts as liaison with the People First Service Center and point of contact in support of the Department's performance management process in accordance with established procedures, guidance, rules, and statutes. Provides information, technical support and resolves PTMS navigational issues for Department managers, supervisors, and CO/District HROs. Provides executive leadership with status reports as needed. Acts as liaison with the Florida Commission on Ethics and point of contact in support of the Financial Disclosure reporting process. Provides executive leadership with status reports as needed. HRO point of contact for the Department's Internship Program providing technical assistance with tracking and reporting program data and responding to or forwarding applicant inquiries to the appropriate area.

Organizes and coordinates computer security and all systems access for CO and District HRO staff members with OIT's Security Office. Conducts the annual staff access and recertification/validation process.

Serves as the SharePoint Administrator and Web Author for HRO external and internal websites. Works closely with CO HRO subject matter experts, District HROs, and other Department offices to ensure hyperlinks are functioning and the information contained on websites is accurate and up to date.

Coordinates mass load activities with the Department of Management Services, District HRO's and the Comptroller's Office.

The Successful Candidate will have the following required Knowledge, Skills, and Abilities:

Knowledge of:

• State of Florida human resources employee data.
• Knowledge of analytical principles and using raw (source) data to create original report types.

Skills in:

• Skill in the use of Excel, PowerBI, programing language (SQL or Python), and SAP tools .
• Skill in customer service techniques.

Ability to:

• Ability to independently conduct research, analyze data, identify errors, and resolve discrepancies.
• Ability to organize and format data into logical formats for presentation in reports.
• Ability to work and communicate well in a collaborative team environment sharing and completing teamwork assignments on a daily basis.
• Ability to successfully manage multiple work assignments, projects and deadlines.

The State’s total compensation package for employees features a highly competitive set of employee benefits including:

• Health insurance (over 90% employer paid)
• $25,000 life insurance policy (100% employer paid)
• Dental, vision and supplemental insurances
• State of Florida retirement package
• 10 paid holidays a year
• Generous vacation and sick leave
• Tuition waiver for public college courses

SPECIAL REQUIREMENTS: You will be required to provide your Social Security Number to conduct required verifications. Male applicants born on or after October 1, 1962, will not be eligible for hire or promotion in the Career Service, or appointment in the Selected Exempt Service (SES) or Senior Management Service (SMS), unless they are registered with the Selective Service System (SSS) before their 26th birthday, or have a Letter of Registration Exemption from the SSS.

THE FLORIDA DEPARTMENT OF TRANSPORTATION VALUES AND SUPPORTS EMPLOYMENT OF INDIVIDUALS WITH DISABILITIES. QUALIFIED INDIVIDUALS WITH DISABILITIES ARE ENCOURAGED TO APPLY. In accordance with Section 110.112, Florida Statutes, and the Florida Department of Transportation’s Individuals with Disabilities Aff

Candidates requiring a reasonable accommodation, as defined by the Americans with Disabilities Act, must notify the agency hiring authority and/or People First Service Center (1-866-663-4735). Notification to the hiring authority must be made in advance to allow sufficient time to provide the accommodation.

The State of Florida supports a Drug-Free workplace. All employees are subject to reasonable suspicion drug testing in accordance with Section 112.0455, F.S., Drug-Free Workplace Act.

Location:

TALLAHASSEE, FL, US, 32399 TALLAHASSEE, FL, US, 32301 TALLAHASSEE, FL, US, 32302 TALLAHASSEE, FL, US, 32303 TALLAHASSEE, FL, US, 32304 TALLAHASSEE, FL, US, 32305 TALLAHASSEE, FL, US, 32307 TALLAHASSEE, FL, US, 32308 TALLAHASSEE, FL, US, 32309 TALLAHASSEE, FL, US, 32310 TALLAHASSEE, FL, US, 32311 TALLAHASSEE, FL, US, 32312 TALLAHASSEE, FL, US, 32316 TALLAHASSEE, FL, US, 32317

For assistance, call the People First Service Center at [phone] Monday - Friday, 8:00 a.m. to 6:00 p.m., Eastern time. Pursuant to Florida Law, 110.211 F. S., the State of Florida is an EEO employer.