SYSTEMS PROJECT ANALYST - 60074838

Requisition No: 845224 

Agency: Children and Families

Working Title: SYSTEMS PROJECT ANALYST - 60074838

 Pay Plan: Career Service

Position Number: 60074838 

Salary:  $65,000 - $75,000 

Posting Closing Date: 02/05/2025 

Total Compensation Estimator Tool

Systems Project Analyst

This is an Open Competitive Opportunity

This position is in Tallahassee, FL in the office of Information Technology Services

The Office of Information Technology Services is seeking a detail-oriented SYSTEMS PROJECT ANALYST to 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.

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:

• 3+ years of experience in data/database management.
• 3+ years of experience with data migration/ETL tools and processes.
• 1+ years of experience in capturing metadata or building data dictionaries.
• Ability to provide excellent customer support and work well with others in a demanding, fast-paced enviornment.

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.