DATA WAREHOUSE & REPORTING LEAD - 72002381

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

Job summary

An established industry player is seeking a Data Warehouse & Reporting Lead to oversee the development and management of reporting solutions within a vital system. This role involves collaborating with state agencies, enhancing reporting capabilities, and ensuring security compliance. The ideal candidate will possess strong knowledge of data warehousing and reporting solutions, along with excellent communication and organizational skills. Join a committed team that values diversity and offers a supportive work environment where your contributions will make a significant impact on state operations. If you are passionate about data and security, this opportunity is perfect for you.

Qualifications

• Strong knowledge of the People First BOBJ reporting solution and data warehouse.
• Ability to manage multiple large work assignments effectively.

Responsibilities

• Manage development and maintenance of the data warehouse and reporting solutions.
• Conduct security audits and analyze potential security issues.

Skills

People First BOBJ reporting solution

Data Warehouse knowledge

Written communication

Oral communication

Problem-solving techniques

Teamwork

Independent work

Organizational skills

Education

Knowledge of People First system

Experience with People First BOBJ reporting

Job description

DATA WAREHOUSE & REPORTING LEAD - 72002381

Date: Apr 1, 2025

Data Warehouse, Reporting & Security Lead

Division of People First

State of Florida Department of Management Services

This position is located in Tallahassee, FL

Applications will be accepted until the position is filled. Individuals who have previously submitted an application will automatically be considered and do not need to reapply.

Position Overview and Responsibilities:

Specific responsibilities of the Data Warehouse, Reporting & Security Lead include, but are not limited to:

Reporting

• Manages the development, implementation, maintenance, enhancement, and monitoring of the data warehouse and business objects (BOBJ) reporting solution in the People First system.
• Develops and provides customized statewide workforce reports (agency specific and statewide data) to state agencies, executive leadership, legislative staff, and the Department’s divisions to support state and federal reporting, grant / federal funding, state / federal reimbursement, agency litigation, executive leadership decisions, legislative staff analysis, collective bargaining and benefits analysis.
• Provides technical assistance to agency report users on the data warehouse, BOBJ reporting solution, and ad hoc report development.
• Provides training to agency report users on the BOBJ reporting solution, including developing training materials.
• Performs independent reviews and analysis to detect systemic issues for the data warehouse and BOBJ reporting solution in the People First system.
• Recommends enhancements, develops business requirements, reviews functional design documents, develops thorough test scripts, conducts testing of enhancements during the user acceptance testing process, and conducts post-implementation validations for the data warehouse and BOBJ reporting solution in the People First system.
• Acts as a liaison for the People First team with the service provider, state agencies, the Department’s Division of State Group Insurance (DSGI), and Division of State Human Resource Management (HRM) for the data warehouse and BOBJ reporting solution.
• Logs, processes, tracks, and completes the People First team’s public records requests.

Security – Operational and Prevention

• Manages the development, implementation, maintenance, enhancement, and monitoring of security items in the People First system.
• Recommends enhancements, develops business requirements, reviews functional design documents, develops thorough test scripts, conducts testing of enhancements during the user acceptance testing process, and conducts post-implementation validations for security items in the People First system.
• Conducts security audits to identify potential security issues, suspicious activity, or theft cases of the People First system.
• Analyzes security infractions and violations of the People First system.
• Reviews the service provider / subcontractor(s)’s SOC 1 / SOC 2, Type 2 reports for security implications to ensure compliance in accordance with the Next Generation People First contract.

Knowledge, Skills, and Abilities:

• Strong knowledge of the People First BOBJ reporting solution
• Strong knowledge of the People First data warehouse
• Strong written and oral communication skills
• Ability to work effectively within a team-based work group
• Ability to utilize problem-solving techniques
• Ability to work independently
• Ability to identify, plan, organize, prioritize, and coordinate multiple large work assignments at the same time

Minimum Qualifications:

• Preference will be given to candidates with a working knowledge of the People First system, knowledge of the data in the People First Data Warehouse/BOBJ views, and experience using the People First BOBJ reporting solution.

Special Notes:
DMS is committed to successfully recruiting and onboarding talented and skilled individuals into its workforce. We recognize the extensive training, experience, and transferrable skills that veterans and individuals with disabilities bring to the workforce. Veterans and individuals with disabilities are encouraged to contact our recruiter for guidance and answers to questions through the following provided email addresses:
[e-mail]
[e-mail]
An individual with a disability is qualified if he or she satisfies the skills, experience, and other job related requirements for a position and can perform the essential functions of the position with or without reasonable accommodation. Candidates requiring a reasonable accommodation, as defined by the Americans with Disabilities Act, must contact the DMS Human Resources (HR) Office at [phone]. DMS requests applicants notify HR in advance to allow sufficient time to provide the accommodation.

The State of Florida is an Equal Opportunity Employer/Affirmative Action Employer, and does not tolerate discrimination or violence in the workplace.

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.