Requisition No: 867714
Agency: Children and Families
Working Title: OPERATIONS REVIEW SPECIALIST - 60046106
Pay Plan: Career Service
Position Number: 60046106
Salary: $55,000 - $65,000
Posting Closing Date: 01/13/2026
Total Compensation Estimator Tool
OPERATIONS REVIEW SPECIALIST
This is an Open Competitive Opportunity
The Office of Information Technology Services is seeking a detail-oriented OPERATIONS REVIEW SPECIALISTto join our team. This position's primary responsibility is working with colleagues and stakeholders to support the Enterprise Data Warehouse. The ideal candidate easily adapts to a variety of assignments, works well with other team members and stakeholders, and excels at identifying the most efficient ETL process for a particular data source/destination. Additionally, they will mentor other staff on the use of processes, tools and best practices utilized in the Enterprise Data Warehouse. This position is located at the DCF Headquarters in Tallahassee, within the Office of Information Technology Services.
EXAMPLES OF WORK:
Load Data into the Enterprise Data Warehouse Work with business users to gather required metadata, standardize column and table names, add standardized metadata to Warehouse control tables, and monitor load processes to ensure data loads successfully. Create, update, and maintain documentation of load processes and functions.
Support Processes Preparing Data for Loading into the Enterprise Data Warehouse Build and support extract and load processes required to prepare data to be loaded into the Enterprise Data Warehouse when data cannot be loaded directly from source. These processes will mostly use Azure Synapse pipeline, but other tools (SSIS, sftp, mainframe interface, etc.) are required at times.
Provide Database Administrator Support to Applications Support application development teams by promoting objects from lower to higher regions. Complete review of objects to ensure compliance with database standards prior to promotion.
Master Data Management Work with other team members to maintain, validate, and enhance the Department's Master Data Management system. Work with business stakeholders to develop a process for stewardship of person matches. Research other utilizations for the MDM solution.
Data Catalog: Develop and maintain a Data Catalog for all Department data. Coordinate with business users to define columns. Prepare Catalog for insertion into the Statewide Data Catalog.
Cloud Migration Plan for and monitor migration of on-prem resources to Cloud-based storage.
Technical Documentation and Specifications Create detailed technical documentation, including design documents, workflow documentation, and user guides, for the various processes and tools utilized by the Data Management Team.
KNOWLEDGE, SKILLS, AND ABILITIES, including utilization of equipment, required for the position
Excellent verbal and written communication skills to effectively interact with stakeholders at all levels.
Knowledge of: various ETL (extract, transfer, and load) methodologies and techniques, especially cloud-based tools such as Azure Synapse Analytics; SDLC phases, including requirements gathering, design, development, testing, and deployment; relational database concepts; and project management principles.
Skilled at: evaluating complex technical problems, devising potential options, and implementing appropriate solutions; designing, implementing and documenting results of testing at various phases of development; creating business and technical documentation; writing complex SQL statements; and using Microsoft Office products.
Ability to: analyze and interpret technical data; determine work priorities and appropriately budget time spent on assigned tasks; communicate technical data processing information with diverse groups of stakeholders effectively; establish and maintain effective working relationships with others; provide excellent customer service; and understand and apply applicable rules, regulations, policies and procedures.
REQUIREMENTS:
PREFERENCES:
Preference will be given to candidates with experience in Azure Synapse Analytics, structured query language (SQL), master data management/master client index system, and data migration. Preference will be given to candidates who have a Microsoft Azure certification.
SPECIAL NOTES
Only US citizens and lawfully authorized alien workers will be hired.
Selective Service 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.
Florida Retirement System (FRS) 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 may be required to repay all benefits received depending upon the date of your retirement.
Veteran’s 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. 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.
BACKGROUND SCREENING REQUIREMENT: 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 be screened in accordance with the requirements of Chapter 435, F.S., and, if applicable, Chapter 408, F.S. No applicant may begin employment until the background investigation results are received, reviewed for any disqualifying offenses, and approved by the Agency. Background investigations 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. Employees also are subject to background re-screening at least every five (5) years. No applicant may begin employment until the background screening results are received, reviewed for any disqualifying offenses, and approved by the Agency.
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.
Join Florida’s talented workforce to fulfill your professional goals and achieve a meaningful career. Our talented public servants work hard to serve more than 19 million residents across Florida, and you, too, can realize success in the Sunshine State.
Working in Florida’s state government means being responsive to the issues impacting the taxpayers of our state. Florida’s state government boasts both fast-paced work environments in which critical thinking and creative problem-solving are a must as well as steady employment opportunities that prize consistent service to our state’s residents. In some positions, state employment means being able to influence policy decisions and help implement change. In others, state employment means being the reliable resource that our taxpayers have come to expect from Florida’s public servants. All positions offer the ability to gain valuable experience quickly, improving your overall skillset. The State of Florida is seeking individuals with leadership skills, creativity and dedication to their fellow Floridians and individuals who recognize the professional development opportunities and achievements possible through state service.
Florida boasts the third largest population in the country and is richly diverse in both population and landscape. With an award-winning park system, warm weather and beautiful bodies of water, Florida is the perfect environment for recreational activities and outdoor enthusiasts. Our favorable tax climate means your income goes further and our business-friendly policies foster private sector growth. Joining Florida’s talented, diverse workforce provides the opportunity to achieve your professional goals while living in a state that values quality of life, culture and recreation. For employment opportunities with the State of Florida, visit https://jobs.myflorida.com.
