JUSTICE ADMINISTRATIVE COMMISSION- DATA MANAGER - 21013466 jobs in United States
cer-icon
Apply on Employer Site
company-logo

State of Florida · 1 day ago

JUSTICE ADMINISTRATIVE COMMISSION- DATA MANAGER - 21013466

The Justice Administrative Commission (JAC) is a state agency that serves various judicial-related offices in Florida. They are seeking a Data Manager to oversee financial data management, create complex SQL queries, and perform accounting functions to support the agency's mission and enhance data accessibility.

Government Administration

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

Qualification

SQLData AnalyticsVBAMicrosoft AccessPowerBITableauFLAIRAnalytical SkillsCommunication SkillsProblem-Solving Skills

Required

High School Diploma (or equivalent)
Three years of overall experience in data analytics
Strong IT skills
Excellent verbal and written communication skills
Strong numerical and analytical skills for research and problem-solving
Ability to translate complex technical concepts into language that is understandable for non-technical stakeholders

Preferred

Bachelor's degree from an accredited college, majoring in computer science, data science, accounting, or finance
Data science majors
Proven experience with scripting languages, such as SQL or programming with Microsoft Access, Excel, and/or SQL Server data sets
Familiarity with data analytics tools such as PowerBI or Tableau
Knowledge of the FLAIR Information Warehouse and the tables

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
And more!

Company

State of Florida

company-logo
The State of Florida is an online telephone and email directory for state government agencies and employees in Florida.

Funding

Current Stage
Late Stage

Leadership Team

leader-logo
Richard Herstein, MD, MHA, MBA
Chief Hospital Administrator (CEO) and Chief Medical Officer (CMO)
linkedin
leader-logo
Jimmy Patronis
Chief Financial Officer
linkedin
Company data provided by crunchbase