GOVERNMENT OPERATIONS CONSULTANT III - 40050048 (Senior Data Analyst)

This position performs advanced level work under the limited supervision of the Government Operations Consultant III-SES and serves as a Senior Data Analyst in the Data Management Unit of the Bureau of Labor Market Statistics Data Services Section. The incumbent in this position will act as the subject matter expert on the Alteryx platform. This is a highly responsible position requiring knowledge of data analysis methods and techniques.

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., 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.

The Difference You Will Make:

The mission of the Bureau of Labor Market Statistics (LMS) is to produce, analyze, and deliver timely and reliable labor statistics to improve economic decision-making. The LMS Data Services Section is responsible for managing the economic data produced and acquired by LMS staff and creating useful data products that benefit Floridians and help drive economic policy. The Data Services Section also aids numerous other FloridaCommerce Program areas with data analytics and business intelligence, helping to turn data into useful information.

FloridaCommerce is a fast-paced work environment in which critical thinking and prioritizing are a must.

How You Will Grow:

FloridaCommerce encourages its employees to constantly innovate and seek efficiencies. Trainings are made available throughout the year and on request with the Office of Training and Development within the Bureau of Human Resource Management. In accordance with our Vision and Mission, the employee:

• Furthers Florida’s economic vision by providing support that enhances the economy and develops, safe, and healthy communities.
• Meets customer/client expectations with an emphasis on responsiveness, quality, quantity, and timeliness of work.
• Provides information clearly, accurately, and succinctly; and exhibits good listening skills.
• Works collaboratively to optimize the effectiveness of FloridaCommerce’s available resources and tools.
• Uses knowledge acquired through education, training, or experience to complete tasks.

These expectations are for all our employees, and you will be expected to model these as a leader. We believe in supporting and encouraging you as you take on important and often complex projects while offering you the opportunity to gain valuable experience.

Where You Will Work

• 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., * 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.

FloridaCommerce works across the state to support Florida’s economy, robust and talented workforce, and our local communities. We are dedicated to making a stronger and more resilient Florida, so our businesses, communities, and workforce are better prepared to withstand future economic slowdowns and natural disasters.

In collaboration with our partners, we salute our nation’s veterans and are honored to have the opportunity to support them and their family members by encouraging them to apply at FloridaCommerce for positions that fit their skill sets.

FloridaCommerce is an Equal Opportunity Employer/Program. Auxiliary aids and services are available upon request to individuals with disabilities. (TTY/TDD 1-800-955-8771 or the Florida Relay Service - 711.), Tallahassee is Florida’s Capital City and continues to grow by attracting development and new businesses. Tallahassee is a mid-sized city in the heart of Florida’s Big Bend. FloridaCommerce’s main office is located in Downtown Tallahassee, the political epicenter that draws in visitors each year to visit the state’s Capitol. Each spring, the legislative session opens, and people pour in to see the Florida Legislature perform business and approve the state’s annual budget. Being in Tallahassee will guarantee you an experience vibrant with a unique experience, professional growth, entertainment, and culture.

Tallahassee is:

• Known for its beautiful parks, rolling hills and oak trees, canopied roads, hotels, dining, museums, arts, music, and natural resources (https://talgov.com/ )
• Home to major college campuses, Florida State University (FSU), Florida A & M University (FAMU) and Tallahassee State College (TSC).
• Approximately 22 miles from the nearest beach ( https://choosetallahassee.com/beaches-near-tallahassee/ )
• Within a state having no state income tax for residents of Florida