GOVERNMENT OPERATIONS CONSULTANT II - 60060533 - ESS Date: Jan 31, 2025 The State Personnel System is an E-Verify employer. For more information click on our E-Verify Website (http://www.dms.myflorida.com/workforce\_operations/human\_resource\_management/for\_job\_applicants/e\_verify) . Requisition No: 845759 Agency: Children and Families Working Title: GOVERNMENT OPERATIONS CONSULTANT II - 60060533 - ESS Pay Plan: Career Service Position Number: 60060533 Salary: To be determined based on experience - $47,500 minimum annually Posting Closing Date: 02/09/2025 Total Compensation Estimator Tool (https://compcalculator.myflorida.com/) THIS IS AN OPEN COMPETITIVE OPPORTUNITY Government Operations Consultant II 60060533 ESS Program - Data Unit Department of Children and Families 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 - $47,500 minimum annual Location is 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, Monday - Friday. Evening or weekend hours may be required as work volume dictates. TO BE CONSIDERED FOR THIS POSITION, RESPONSES TO THE QUALIFYING QUESTIONS ARE REQUIRED AND MUST BE VERIFIABLE BASED ON YOUR SUBMITTED APPLICATION. Applicants must meet theminimum requirementsto be hired for this position. *The requested information must be disclosed on the State of Florida Candidate Profile (application). * *Fill in all employment historyfields. * *It is not acceptable to write “see resume” on the Candidate Profile. * REQUIRED QUALIFICATIONS: + 2 years (24 months) of documented data reporting experience. + 2 years (24 months) of documented experience in creating and presenting reports. + 2 years (24 months) of Excel experience utilizing functions, macros, and pivot charts. + 2 years (24 months) of documented SQL experience. + Bachelor's degree from an accredited college or university in a related field OR Professional or non-professional experience as described below can substitute on a year-for-year basis for the preferred college degree (Minimum 4 years). PREFERRED QUALIFICATIONS. Preference will be given to applicants who meet the following: + 1 year (12 months) of documented experience working with the FLORIDA system. + 2 years (24 months) of experience Economic Self-sufficiency programs (Florida SNAP, TANF, and Medicaid eligibility policy). + Documented Power BI experience + Documented experience in C, C++, C#, T-SQL, Python, ANSI SQL POSITION DESCRIPTION This is an independent and complex professional consultative position in the Economic Self-Sufficiency (ESS) Program Data Analytics and Reporting 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 that 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. + DCF EMPLOYMENT DISCLOSURES The Department of Children and Families is a tobacco free environment. + US CITIZEN REQUIREMENT Only US citizens and lawfully authorized alien workers will be hired. + 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 . + 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. + 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. + 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. If you experience problems applying online, please call the People First Service Center at (877) 562-7287. 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 clickinghere (http://www.dms.myflorida.com/content/download/97612/566545) . All documentation is due by the close of the vacancy announcement. Location: TALLAHASSEE, FL, US, 32303 JACKSONVILLE, FL, US, 32202 MIAMI, FL, US, 33134 PANAMA CITY, FL, US, 32401 DAYTONA BEACH, FL, US, 32120 Nearest Major Market:Tallahassee