GOVERNMENT OPERATIONS CONSULTANT III - 40050048 (Senior Data Analyst)

State of Florida•TALLAHASSEE, FL

2d•Onsite

About The Position

This advanced-level role serves as a Senior Data Analyst under the limited supervision of the Government Operations Consultant III-SES and functions as the bureau’s subject matter expert for the Alteryx platform and Alteryx Server. Core duties include supporting maintenance of the Workforce Information Database, developing automated ETL workflows, and performing complex data queries using R, Python, and SQL. The position also contributes to reporting and visualization efforts, prepares and validates datasets, documents analytical processes, and supports Tableau development. Additionally, the Senior Analyst provides guidance and support to junior analysts to strengthen analytical capacity across the team.

Requirements

Ability to work independently and as part of a team.
Ability to travel.
Ability to communicate effectively verbally and in writing.
Ability to establish and maintain effective working relationships and deal with others in a courteous, tactful, and diplomatic manner.
Ability to understand and apply applicable rules, regulations, policies, and procedures.
Ability to plan, organize and coordinate work assignments.
Ability to develop training materials and train others.
Ability to formulate and recommend policies and procedures.
Skill in utilizing problem solving techniques.
Skill in process mapping.
Skill in conducting research.
Skill in managing projects.
Ability to organize data into logical format for presentation in reports, documents, and other written materials.
Knowledge of the methods of data collection, analysis, and storage.
Ability to learn new software tools, programming languages, and domain areas.
Ability to operate a computer.
Ability to use Tableau or other BI tools.
Skill in visualizing data.
Skill in using Alteryx, R, Python, and/or other Extract, Transform, and Load (ETL) tools.
Skill in using Structured Query Language (SQL).
Skill in using Microsoft Office.
Skill in MS SQL Server, Postgres, Oracle, Snowflake, or other Relational Database Management Systems (RDBMS) and Data Warehouses.
Skill in database administration.
Skill in Extracting, Transforming, and Loading (ETL) data across a variety of platforms and tools.
As a condition of pre-employment eligibility, a Level 2 security background screening is required, which consists of fingerprinting and a check of local, state, and national law enforcement records.

Nice To Haves

One year of experience in SQL queries, including intermediate/advanced level queries and scripting.
Skill in MS SQL Server, Postgres, Oracle, Snowflake, or other Relational Database Management System and Data Warehouses.
One year of experience using Alteryx, R, Python, and/or other Extract, Transform, and Load (ETL) tools.
Alteryx Designer Core Certification or Alteryx Designer Advanced Certification.
Tableau Desktop Specialist or Tableau Certified Data Analyst certification.

Responsibilities

Responsible for the implementation and management of the Alteryx and Alteryx Server tools for the Bureau. This includes being the subject matter expert (SME) on the use of the tool, providing guidance to users, and serving as the Alteryx Server Site administrator.
Creates automated Extract, Transform, and Load (ETL) workflows in tools such as Alteryx to improve process efficiency.
Provides support and serves as the back up to the Database Administrator in the maintenance of the Workforce Information Database (WID).
Queries and manipulates data using programming languages such as R, Python, and/or Structured Query Language (SQL).
Assists in the development and maintenance of reporting tools, publications, and website design ideas that bring simplicity and user friendliness to complex reports and data.
Assists in building, implementing, and supporting visualizations in Tableau using various data sources including(but not limited to) Microsoft SQL Server, Excel, and Snowflake.
Research and gathers economic, demographic, and employment data needed for projects and assignments.
Cleans and formats data sets to be used in visualizations, spreadsheets, programming, model building, statistics, and regression analysis.
Contributes to projects and assignments as part of project teams, ensuring timely, accurate, and high-quality delivery while maintaining effective working relationships with colleagues and stakeholders.
Responsible for mapping and documenting processes, coordinating process improvement efforts, and maintaining records of data sources, assumptions, and methodologies used in projects and analytical tasks.
Uses standard productivity tools such as Microsoft Word, Excel, and PowerPoint to produce reports, documents, and other written materials for projects utilizing FloridaCommerce and external data sources.
Performs other duties as required.

Benefits

State Group Insurance coverage options (health, life, dental, vision, and other supplemental option)
Retirement plan options, including employer contributions
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