GOVERNMENT OPERATIONS CONSULTANT III - 40050048 (Senior Data Analyst)

The State of Florida; Tallahassee (FL); Sur place; USD 52 000 - 70 000; Plein temps

Avantages offerts par ce poste

State Group Insurance

Retirement plan options

Nine paid holidays

Annual and Sick Leave

Tuition Fee Waivers

Training and career growth

Résumé du poste

The State of Florida’s FloridaCommerce Bureau seeks a Senior Data Analyst to lead advanced analytics and data engineering efforts in Tallahassee. You will serve as the Alteryx and Alteryx Server SME, build ETL workflows, and support Tableau visualizations across multiple data sources including SQL Server, Excel, and Snowflake.

You will collaborate with cross-functional teams to deliver reliable labor and workforce data products, maintain data origins and methodologies, and contribute to

Qualifications

• SME for Alteryx and Alteryx Server; advanced data analysis and data engineering expertise.
• Build automated ETL workflows to improve process efficiency.
• Support reporting and Tableau visualizations using multiple data sources.
• Collaborate with stakeholders to deliver timely, accurate analytical outputs.

Responsabilités

• Serve as subject matter expert for Alteryx platform and Alteryx Server site administration.
• Create automated ETL workflows using Alteryx; streamline analytic processes.
• Support data querying with R, Python, and SQL; maintain data quality.

Connaissances

Alteryx

Alteryx Server

SQL

Tableau

R

Python

ETL

Data Viz

Outils

MS SQL Server

Postgres

Snowflake

Description du poste

This role supports FloridaCommerce’s Bureau of Labor Market Statistics by combining advanced data analysis with data engineering and visualization work. You will serve as the subject matter expert for the Alteryx platform and Alteryx Server within the Data Management Unit, contributing to reliable labor and workforce data products for Florida.

Role Overview

As a Senior Data Analyst (Government Operations Consultant III), you will perform advanced-level work under the limited supervision of the Government Operations Consultant III-SES. The position functions as the bureau’s subject matter expert for Alteryx and Alteryx Server and supports the Data Services work of the Bureau of Labor Market Statistics Data Services Section.

• Manage and support the implementation and operations of Alteryx and Alteryx Server for the Bureau.
• Build automated Extract, Transform, and Load (ETL) workflows to improve process efficiency.
• Support Workforce Information Database (WID) maintenance and assist as a backup to the Database Administrator.
• Contribute to reporting and Tableau visualizations using multiple data sources.

Core Responsibilities

• Serve as subject matter expert for the Alteryx platform, providing guidance to users and acting as Alteryx Server Site administrator.
• Create automated ETL workflows in tools such as Alteryx to streamline analytic processes.
• Support data querying and manipulation using R, Python, and/or SQL.
• Assist in development and maintenance of reporting tools, publications, and website design ideas that improve simplicity and usability for complex reporting.
• Build, implement, and support Tableau visualizations using data sources including (but not limited to) Microsoft SQL Server, Excel, and Snowflake.
• Research and gather economic, demographic, and employment data needed for assignments.
• Clean and format data sets for use in visualizations, spreadsheets, programming, model building, statistics, and regression analysis.
• Collaborate with project teams to deliver timely, accurate, and high-quality analytical outputs while maintaining effective relationships with colleagues and stakeholders.
• Map and document processes, coordinate process improvement efforts, and maintain records of data sources, assumptions, and methodologies.
• Use Microsoft Word, Excel, and PowerPoint to produce project reports, documents, and other written materials using FloridaCommerce and external data sources.
• Perform other duties as required.

Required Qualifications

• 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 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 problem solving, process mapping, research, and project management.
• Ability to organize data into logical formats for presentation in reports and documents.
• Knowledge of 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 and to visualize data.
• Skill in using Alteryx, R, Python, and/or other ETL tools.
• Skill in using SQL.
• Skill in using Microsoft Office.
• Skill in MS SQL Server, Postgres, Oracle, Snowflake, or other RDBMS and data warehouses.
• Skill in database administration.
• Skill in extracting, transforming, and loading data across a variety of platforms and tools.
• Duties and responsibilities are performed at the assigned work location.
• As a condition of pre-employment eligibility, a Level 2 security background screening is required, including fingerprinting and a check of local, state, and national law enforcement records.
• Travel may be required and the employee must provide their own transportation.

Preferred Qualifications

• 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 systems and data warehouses.
• One year of experience using Alteryx, R, Python, and/or other ETL tools.
• Alteryx Designer Core Certification or Alteryx Designer Advanced Certification.
• Tableau Desktop Specialist or Tableau Certified Data Analyst certification.

Technologies

• Alteryx, Alteryx Server
• ETL
• R, Python
• Structured Query Language (SQL)
• Tableau
• Microsoft SQL Server, Excel, Snowflake
• Microsoft Word, PowerPoint, Microsoft Office
• Postgres, Oracle
• Relational Database Management Systems (RDBMS)
• Workforce Information Database (WID)

Location

Tallahassee, FL (onsite). Nearest major market: Tallahassee.

Location code: 32399.

About FloridaCommerce and the Bureau

FloridaCommerce supports Florida’s economy, workforce, and local communities across the state. The Bureau of Labor Market Statistics (LMS) produces, analyzes, and delivers timely and reliable labor statistics to improve economic decision-making.

The LMS Data Services Section manages economic data produced and acquired by LMS staff and creates data products for the benefit of Floridians and economic policy. The section also assists other FloridaCommerce program areas with data analytics and business intelligence, supporting efforts to turn data into usable information.

Training and Growth

FloridaCommerce encourages innovation and efficiency improvements. Trainings are made available throughout the year and on request through the Office of Training and Development within the Bureau of Human Resource Management.

Compensation

Salary: USD 61,029 per year.

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
• Career growth and a highly skilled, professional environment

Workplace and Compliance Information

• Reasonable accommodation requests under the ADA must be reported to the hiring agency in advance to allow sufficient time for accommodation.
• Florida supports a drug-free workplace. Employees are subject to reasonable suspicion drug testing in accordance with Section 112.0455, F.S., and the 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 for waivers for postsecondary educational requirements. Candidates claiming Veterans’ Preference must attach supporting documentation with each submission, including the character of service (for example, DD Form 214 Member Copy #4) and any other documentation required by Rule 55A-7, Florida Administrative Code. All documentation is due by the close of the vacancy announcement.