JUSTICE ADMINISTRATIVE COMMISSION- DATA MANAGER - 21013466

State of Florida • Tallahassee, FL

10d • $60,000 - $70,000 • Hybrid

About The Position

JAC seeks a candidate to serve as the Data Manager for the Financial Services Section, reporting to the Financial Services Deputy Director. The person in this position works closely with JAC staff and staff from the Judicial-Related Offices we administratively serve. Their primary duties will involve working with financial, payroll, and Court-Appointed Attorney Tracking System (CAATS) databases.

The candidate selected to fill this position will be essential to helping the agency achieve its mission by creating complex queries and reports to analyze and summarize large volumes of data, and by presenting the results in an understandable format for stakeholders, the Legislature, and the Governor’s Office.

Requirements

• Applicants must have a High School Diploma (or equivalent), but a bachelor’s degree from an accredited college, majoring in computer science, data science, accounting, or finance, is preferred. Additional consideration will be given to data science majors.
• Applicants must have three years of overall experience in data analytics. This includes writing, debugging, and automating existing queries in Access, as well as reviewing data/reports for anomalies. Preference will be given to candidates with proven experience with scripting languages, such as SQL or programming with Microsoft Access, Excel, and/or SQL Server data sets.
• Applicants must have strong IT skills, excellent verbal and written communication skills, and strong numerical and analytical skills for research and problem-solving. Applicants should be able to translate complex technical concepts into language that is understandable for non-technical stakeholders.
• A resume is required, and candidates will not be considered unless one is provided.

Nice To Haves

• Familiarity with data analytics tools such as PowerBI or Tableau is a plus.
• Knowledge of the FLAIR Information Warehouse and the tables is a plus.

Responsibilities

• Create, optimize, and maintain complex SQL queries, views, and reports using programming languages, including SQL and VBA.
• Retrieve, analyze, and interpret large data sets from multiple data sources to organize and identify patterns and trends, including reviewing large datasets and reports for accuracy and anomalies
• Produce ad hoc reports for management, JROs, and public records requests as needed.
• Monitor court-appointed data to produce monthly and year-end projection reports, perform periodic quality control reviews, and monitor projections to ensure sufficient unexpended release for anticipated needs.
• Serve on the team responsible for implementing Florida PALM at JAC. Learn how the system will operate and determine its impact on JAC queries, reports, or other data requirements. This includes converting current queries, reports, and reconciliation processes.
• Identify opportunities to enhance automation, streamline data processes, and improve data accessibility to JAC and the JROs.
• Prepare payroll data for entry into FLAIR and reconcile JAC’s accounting records to ensure the expenditures match the payroll posted by the Department of Financial Services (DFS).
• Independently perform assigned reconciliations or other tasks such as analyzing the Trial Balance for atypical balances, reviewing revenues and expenditures for coding errors, and reconciling CAATS expenditures to the state accounting system (FLAIR) to identify discrepancies.
• Perform assigned financial statement tasks required to produce the State of Florida Annual Comprehensive Financial Reports (ACFR), which may include financial analysis and entering FLAIR transactions. Please note, there is a blackout period for annual leave from July 1st through August 15th, with required overtime.

Benefits

• 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;

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Education Level: High school or GED
• Number of Employees: 1,001-5,000 employees