Requisition No: 828085 

Agency: Children and Families

Working Title: OPERATIONS REVIEW SPECIALIST - 60019743 - ESS Program Data unit

 Pay Plan: Career Service

Position Number: 60019743 

Salary: $55,500 minimal annual 

Posting Closing Date: 04/28/2024 

Total Compensation Estimator Tool

THIS IS AN INTERNAL OPPURTUNITY

Department of Children and Families

Operations Review Specialist 

ESS Program Data Unit

This is NOT a telework position. The selected candidate must work in the office.

This is a full-time position working 40 hours per week.

Salary: To be determined - $55,500 minimal annual

Location: Open statewide. The position will be located in Florida based on the selected candidate.

Regular business hours of operation are 8:00 AM to 5:00 PM EST, Monday - Friday.

Evening or weekend hours may be required as work volume dictates.

REQUIRED QUALIFICATIONS:

• Must be a current DCF employee.
• 1 year (12 months) of documented data reporting experience.
• 1 year (12 months) of documented experience in creating and presenting reports.
• 2 years (24 months) of Excel experience utilizing functions, macros, and pivot charts.
• 2 year (24 months) of documented experience working with the FLORIDA system
• 1 year (12 months) of documented SQL experience
• 4 years (48 months) of experience in Economic Self-Sufficiency programs (Florida SNAP, TANF, and Medicaid eligibility policy)
• Bachelor's degree from an accredited college or university in a related field. If selected for this position a copy of the required degree, or official transcripts, in English, will be required. 

Related work experience can substitute as a year-for-year basis (minimum 4 years).

PREFERRED QUALIFICATIONS. Preference will be given to applicants who meet the following:

• Documented Access Database experience.
• Documented Power BI experience

 
POSITION DESCRIPTION

This is an independent and complex professional consultative position in the Economic Self-Sufficiency (ESS) Program Data Analytics unit. This position provides operational, data management and coordinative assistance in ESS Program areas. This position conducts studies and evaluations of organizational performance data and provides assistance that may help the organization to operate more efficiently and effectively. 

This is a position located in Florida and reports directly to the Data Analyst Supervisor for the ESS Program office.

The incumbent is a member of the DCF DSNAP Disaster Response team and, in that capacity, may be required on short notice to perform duties and travel in support of disaster relief. During such events, incumbent may be required to work more than 8 hours a day.

Job Description and Responsibilities

The incumbent will ensure the job duties and responsibilities are completed in a timely manner and with a high accuracy rate. It is important for the applicant to display a professional attitude and strong work ethic. 

The incumbent's primary duties include analysis of broad range of data from public assistance programs including Supplemental Nutrition Assistance Program (SNAP), Temporary Assistance for Needy Families (TANF), and Medicaid while utilizing Sequel (SQL) and Business Intelligence (BI) software. Other duties include automation of Extract Transform Load (ETL) and maintenance of data from DCF data warehouse and external data sources. This position is responsible for working with DCF management team and stakeholders to provide accurate data products while ensuring compliance with Department's policy and adhering to time sensitive deadlines. The incumbent’s typical workday will include interpreting data requests, researching, developing queries as well as testing and validation of data. This is a highly technical position and requires ability to adapt and solve complex problems.

Duties Include:

• Query data from various sources and produce reports and visualizations to provide statistical analysis of performance metrics related to the ESS programs.
• Identify trends and patterns of public assistance data to help families become self-sufficient.
• Perform data analysis on ESS program data to identify common problems and issues that require corrective actions.
• Develop and validate reports and present data to Executive management team.
• Assist in the development and maintenance of reports to produce public record requests. 
• Learn and utilize MS SQL Server, Excel, Power BI and Qlik to perform complex data analysis.
• Provide technical assistance to field staff.
• Perform other duties as assigned.

KNOWLEDGE, SKILLS & ABILITIES:

• Knowledge of business mathematics
• Advanced Microsoft Office Suite skills including Excel, Word, and PowerPoint
• Knowledge of Sequel and ability to learn other software as needed.
• Ability to manage projects.
• Complex problem-solving skills
• Critical thinking skills
• Ability to learn technical skills using online resources
• Ability to create professional presentations using PowerPoint
• Ability to create functions in Excel
• Ability to create pivot tables and various charts in Excel
• Ability to troubleshoot errors and validate data discrepancies
• Ability to construct logical arguments and expose discrepancies
• Ability to analyze and interpret data
• Ability to combine data to form general rules or conclusions
• Ability to communicate effectively verbally and in writing
• Ability to establish and maintain effective working relationships with others
• Ability to prioritize workload, work independently and make decisions 

Mission: The mission of the Department of Children and Families is to work in partnership with local communities to protect the vulnerable, promote strong and economically self-sufficient families, and advance personal and family recovery and resiliency.
Vision: We are a highly skilled workforce committed to empowering people with complex and varied needs to achieve the best outcomes for themselves and their families. In collaboration with community stakeholders, we will deliver world class and continuously improving service focused on providing the people we serve with the level and quality that we would demand and expect for our own families.
Values: A workforce that operates with integrity maintains loyalty to a code of ethics that requires the courage to take responsibility for providing the highest quality of service to the vulnerable. We are a solutions-focused learning organization built on a foundation of transparency in action and accountability of results. Both within the organization and among our stakeholders, we thrive in a culture of respect for diversity of opinion that is nurtured through open communication. High performing and committed, we are unified in our goal of excellence in achieving quality outcomes for those we serve.
To learn more please visit https://www.myflfamilies.com/

Growth Opportunities:

With 12,000 employees across the state DCF promotes opportunities and training for all. Our jobs are among the most challenging, complex, and difficult in State government. They are also among the most rewarding. All employees are encouraged to take advantage of available Department opportunities for advancement and professional development.

Benefits of Working for the State of Florida:

Working for the State of Florida is more than a paycheck. The State’s total compensation package for employees features a highly competitive set of employee benefits including:

• No state income tax for residents of Florida.
• Annual and Sick Leave benefits;
• Nine paid holidays and one Personal Holiday each year.
• State Group Insurance coverage options, including health, life, dental, vision, and other supplemental insurance options.
• Retirement plan options, including employer contributions (For more information, please click www.myfrs.com).
• Flexible Spending Accounts;
• Tuition waivers;
• And more!

For a more complete list of benefits, visit www.mybenefits.myflorida.com.

Candidate Profile (application) must be completed in its entirety.

• Include supervisor names and phone numbers for all periods of employment.
• Account for and explain any gaps in employment so that the hiring process is not delayed.
• Experience, education, training, knowledge, skills and/or abilities as well as responses to pre-qualifying questions must be verifiable to meet the minimum qualifications. 
• It is unacceptable to use the statement “See Resume” in place of entering work history.
• This position is designated as an essential position. Incumbents are expected to work during emergency situations or natural disasters and may be required to work before, during and beyond normal work hours/days.

1. DCF EMPLOYMENT DISCLOSURES
   The Department of Children and Families is a tobacco free environment.
2. US CITIZEN REQUIREMENT Only US citizens and lawfully authorized alien workers will be hired.
3. SELECTIVE SERVICE SYSTEM REGISTRATION All selected male candidates born on or after October 1, 1962, will not be eligible for hire or promotion into an authorized position unless they are registered with the Selective Service System (SSS). Verification of Selective Service registration will be conducted prior to hire. For more information, please visit the SSS website: http://www.sss.gov.
4. RETIREE NOTICE If you are a retiree of the Florida Retirement System (FRS), please check with the FRS on how your current benefits will be affected if you are re-employed with the State of Florida. Your current retirement benefits may be suspended or voided, and you required to repay all benefits received depending upon the date of your retirement.
5. BACKGROUND SCREENING It is the policy of the Florida Department of Children and Families that any applicant being considered for employment must successfully complete a State and National criminal history check as a condition of employment before beginning employment, and, if applicable, also be screened in accordance with the requirements of Chapter 435, F.S., and Chapter 408, F.S. No applicant may begin employment until the background screening results are received, reviewed for any disqualifying offenses, and approved by the Agency. Background screening shall include, but not be limited to, fingerprinting for State and Federal criminal records checks through the Florida Department of Law Enforcement (FDLE) and Federal Bureau of Investigation (FBI) and may include local criminal history checks through local law enforcement agencies.
6. BENEFIT RECOVERY SCREENING Candidates applying to positions in the Economic Self-Sufficiency Program may have a Benefit Recovery check completed to validate current or former public assistance case information before completing the hiring process.

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

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.

VETERANS’ PREFERENCE. Pursuant to Chapter 295, Florida Statutes, candidates eligible for Veterans’ Preference will receive preference in employment for Career Service vacancies and are encouraged to apply. Certain service members may be eligible to receive waivers for postsecondary educational requirements. Candidates claiming Veterans’ Preference must attach supporting documentation with each submission that includes character of service (for example, DD Form 214 Member Copy #4) along with any other documentation as required by Rule 55A-7, Florida Administrative Code. Veterans’ Preference documentation requirements are available by clicking here. All documentation is due by the close of the vacancy announcement.