Job Information
MyFlorida SENIOR DATA BASE ANALYST - 48001925 in TALLAHASSEE, Florida
SENIOR DATA BASE ANALYST - 48001925
Date: Jun 28, 2024
Location:
TALLAHASSEE, FL, US, 32399
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: 830778
Agency: Department of Education
Working Title: SENIOR DATA BASE ANALYST - 48001925
Pay Plan: Career Service
Position Number: 48001925
Salary: $48,140.46-50,724.36
Posting Closing Date: 07/12/2024
Total Compensation Estimator Tool (https://compcalculator.myflorida.com/)
Florida Department of Education
Division of Technology and Innovation
Location: Tallahassee, FL - Turlington Building
Senior Database Analyst - Career Service
Salary Range: $48,140.46 - $50,724.36
"Employment is contingent upon successful completion of a level 2 background screening pursuant to Chapter 435, Florida Statutes."
Florida Department of Education Mission Statement
Every day the Department of Education works hand in hand with parents, teachers, educators, and community members to improve Florida's education system for students of all backgrounds and abilities. Our site reflects this cooperative relationship and the role that so many Floridians play in ensuring student success.
The FDOE's mission for Florida's Early Learning-20 education system is to increase the proficiency of all students within one seamless, efficient system, by allowing them the opportunity to expand their knowledge and skills through learning opportunities and research valued by students, parents, and communities.
Serving approximately 3 million students, 4,400 public schools, 28 colleges, 200,00 instructional staff, 46,000 college professors and administrators, and 340,000 full-time staff throughout the state, FDOE enhances programs and services for Florida's students from early learning through college and career development. In addition, FDOE manages programs that assist individuals who are blind, visually impaired, or disabled succeed either in school settings or careers - encouraging independence and self-sufficiency.
FDOE's goal is to hire individuals to provide:
Higher Student Achievement
Seamless Articulation and Maximum Access
Skilled Workforce and Economic Development
Quality Services
Florida Department of Education (http://www.fldoe.org)
Florida Education and Training Placement Information Program
The Florida Education and Training Placement Information Program (FETPIP) is a data collection and consumer reporting system established by Florida Statutes Section 1008.39 to provide data and reporting on former students and program participants who have graduated, exited, or completed a public education or training program within the State of Florida. The statute requires all elements of Florida's workforce development system to use information provided through FETPIP for any project they may conduct requiring automated matching of administrative records for follow-up purposes.
Together with its intra-agency and external partners, FETPIP produces data, reports, business intelligence, and other work products that informs policy and decision making, state and federal accountability reporting, educational and vocational program performance, return on investment, and other metrics.
Job Description
The FETPIP Senior Database Analyst, as part of the FETPIP team, develops SAS programs and/or SQL queries to produce datasets, reports, and other work products. The candidate will transition new projects from concept to completion and will develop custom code to replicate existing processes. They will also perform technical writing, documentation creation/updates, data analysis, and extraction, transformation, and loading (ETL). The candidate will also assist with process development, creating and enforcing data standards, database management, and other duties, as assigned.
Examples Of Work Performed:
Develops custom SAS programs and/or SQL queries to produce datasets, reports, and other work products, as required.
Develops, updates, and maintains database documentation including data dictionaries, user documentation, application, and system documentation.
Develops and maintains SAS programs and/or SQL queries to perform ETL processes to load data into FETPIP database from customer created files.
Creates, alters, and updates existing SQL tables as required using SQL code.
Plans, designs, programs, and test database manipulations to extract selected data elements for FETPIP applications for reporting and analysis.
Coordinates with staff in the use and development of the FETPIP database to maintain data security and integrity, ensure efficient data handling and provide for the incorporation of new hardware and software developments where appropriate.
Actively protects and ensures data confidentiality for all FETPIP data through strict adherence to all State and Federal privacy laws, rules, regulations, and standards.
Follows and enforces mandates and conditions for existing all data sharing agreements for which FETPIP is party to.
Assists team in maintaining and providing improvements to FETPIP's web page including periodic and annual updates and web asset management.
Performs other duties as assigned by FETPIP director.
Agency Values:
Attendance is an essential function of this position.
The employee must be productive under tight timeframes, balance multiple and competing priorities and maintain goal-directed behavior and performance sometimes under stressful conditions.
The employee is expected to demonstrate, model, and reinforce the agency’s fundamental values of quality, fairness, cooperation, respect, commitment, excellence, honesty, and teamwork.
The employee must interact courteously with others.
The employee’s performance and behavior must demonstrate consideration of the workload concerns of others and must not negatively affect productivity and morale of the unit.
Employee is expected to demonstrate knowledge, skills and ability to prepare, provide, and disseminate quality products representative of the Department’s commitment to quality, efficient services, and practices.
Knowledge, Skills and Abilities:
Employee is expected to demonstrate knowledge, skills and ability to prepare, provide, and disseminate quality products representative of the Department’s commitment to quality, efficient services, and practices.
Knowledge of computer programming languages.
Knowledge of database structures and theories.
Knowledge of database best practices.
Knowledge of current database technologies.
Knowledge of the principles, practices, and techniques of computer programming and system design.
Knowledge of computer operations, procedures and systems.
Knowledge of methods of compiling, organizing, and analyzing data.
Knowledge of the methods of data collection and analysis.
Knowledge of basic management principles and practices.
Ability to determine work priorities, assign work, and ensure proper completion of work assignments.
Knowledge of data base structures and theories.
Knowledge of current data base technologies.
Ability to provide instruction or training to others.
Ability to plan, organize and coordinate work assignments.
Ability to identify/define user task needs and/or conduct project planning studies.
Ability to process information logically.
Ability to write functional programs and queries.
Ability to analyze and interpret computer program data.
Ability to prepare program specifications.
Ability to effectively communicate technical data processing information verbally and in writing.
Ability to provide instruction or training to others.
Ability to perform mathematical calculations.
Ability to establish and maintain effective working relationships with others.
Minimum Qualifications:
Relevant bachelor's degree from an accredited college or university or an equivalent combination of edcuation and experience.
One (1) to two (2) years writing intermediate to complex SQL queries or SAS programs.
One (1) year of data analysis and reporting experience.
Ability to adapt in a dynmanic environment and handle muitiple priorities
Desired Skills:
Experience creating visualizations, technical writing, and desktop publishing.
Educational Substitutions:
Three (3) or more years' experience in SAS or SQL programming, data analysis, research, or relevant experience as described above can substitute for the required college education.
APPLICATION INFORMATION & REQUIREMENTS
Candidate Profile (application) must be complete in its entirety. Your packet may be held up at the final review step if you are missing the below items:
Work History (entered with the most recent/current listed first):
Any and all State of Florida jobs
Any and all Florida University jobs
All periods of employment from high school graduation
Periods of unemployment
Employment gaps of three months or more*
Education
Volunteer Experience
Include supervisor names and phone numbers including current place of employment.
*Employment gaps of three months or moremust be addressed– you will need to account for and explain any gaps in employment including unemployment. You can either list these in your application under Period of Employment or attach a word document listing your gaps.
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 isunacceptableto use the statement “See Resume” in place of entering work history. Your candidate profile will convert to your official application.
If claimingVeteran’s Preference (https://www.dms.myflorida.com/content/download/130394/809960/2017-004AdministrationofVeterans) , candidateMUSTattach supporting documentation (DD214).
If claimingRight to First Interview (https://www.flrules.org/gateway/ruleno.asp?id=60L-33.004&Section=0) , candidateMUSTattach a copy of your official layoff letter when applying. This only applies to employees laid off from Career Service positions.
All documentation is due by the close of the vacancy announcement.
If you experience problems applying online, please call the People First Service Center at (877) 562-7287
WORKING FOR THE STATE OF FLORIDA HAS BENEFITS!
- State Group Insurance coverage options+
(health, life, dental, vision, and other supplemental option)
Retirement plan options, including employer contributions ( www.myfrs.com )
Nine paid holidays and a Personal Holiday each year
- Annual and Sick Leave Benefits
Student Loan Forgiveness Program (Eligibility required)
- Flexible Spending Accounts
Tuition Fee Waivers (Accepted by major Florida colleges/universities)
Ongoing comprehensive training provided
Career Growth
Highly skilled, professional environment
Maternity and Parental Leave Benefits
For a more complete list of benefits, visit www.mybenefits.myflorida.com .
- We care about the success of our employees.
We care about the success of our clients.
- We are always improving our technology, our tools, our customer’s experiences and ourselves.
A rewarding experience for reliable, compassionate and professional employees.
LEAVE INFORMATION:
Annual Leave- All full-time Career Service employees filling established positions earn annual leave in varying increments dependent upon years of creditable service. Employees with up to 5 years of creditable service earn 8.667 hours per month, with 5 to 10 years earn 10.833 hours per month and those with over 10 years of service earn 13 hours per month.
Sick Leave- Career Service employees earn 8.667 hours of sick leave credits per month .
Position Location:
This position is located at FLDOE Headquarters in the Turlington Bulding at 325 West Gaines Street, Tallahassee, FL 32399.
Background Screening Requirements:
It is the policy of the Florida Department of Education that applicants for employment undergo level 2 employment screening in accordance with the requirements of Chapter 435, Florida Statutes, as a condition of employment or being permitted to serve as a volunteer.
All applicants for employment or to volunteer who are selected for an interview will be provided with the Consent to Background Screening form for level 2 screening, the Affidavit of Good Moral Character, and the Notice of Rights. The leading candidate for employment or to volunteer will be required to execute the Consent form and Affidavit, report to a designated location, and submit fingerprints for level 2 screening.
No applicant for a designated position will be employed or permitted to volunteer until the level 2 screening results are received, reviewed, and approved by the Department.
Level 2 background screening shall include, but not be limited to, fingerprinting for statewide criminal and juvenile records checked through the Florida Department of Law Enforcement, and federal criminal records checked through the Federal Bureau of Investigation, and may include local criminal records checks through local law enforcement agencies.
It is the policy of the Department of Education to give preference to eligible veterans and the spouses of veterans in appointment and retention in positions of public employment.
The Department of Education is an Equal Opportunity Employer/Affirmative Action Employer.
Selective Services System (http://www.sss.gov) (SSS)
Male applicants born on or after October 1, 1962, will not be eligible for hire or promotion in the Other Personal Services (OPS) or Career Service, or appointment in the Selected Exempt Service (SES) or Senior Management Service (SMS) unless they are registered with the Selective Service System (SSS) before their 26th birthday, or have a Letter of Registration Exemption from the SSS. Verification of Selective Service registration will be conducted prior to hire. For more information, please visit the SSS website: http://www.sss.gov.
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.
Nearest Major Market:Tallahassee