Title: On-Site Senior Snowflake Developer (Snowflake platform architecture/Snowflake-based solutions/ETL)
Location: Tallahassee, FL
Pay Rate: DOE
Length: Multi-Year
Travel Required: none
Telecommute: no
Skills: “Snowflake Developer”; Snowflake-based solutions; Datawarehouse Analyst; Snowflake’s native features; RBAC within Snowflake; ELT/ETL data pipelines; Snowpipe, Streams, Tasks, Informatica;dbt,Airflow, Talend, MS SSIS, Fivetran; Snowflake SQL; WebFOCUS, Mainframe FOCUS, T-SQL; data governance/models/migration/visualization; legacy structures; cloud storage integrations; AWS S3, Azure Blob; financial, ERP, or general ledger data; mainframe systems, legacy flat files, Oracle Data Warehouse; power BI, Tableau, or Looker; BI semantic models; DevOps, CI/CD practices; DB2, SQL Server, MS Office/Sharepoint; Agile/SCRUM; training; knowledge transfer; DOCUMENTATATION, Govt
Telecommuting:
None Allowed
Background: As a result of the Department’s efforts to re-engineer and modernize core financial systems, there has been over 1,500 computing assets identified as performing some level of financial planning, analysis, and management functionality that are impacted by the State of Florida’s accounting system. The Florida Planning, Accounting, and Ledger Management (PALM) project is a multiyear endeavor to replace the State of Florida’s accounting and cash management systems with a modern financial management solution. The Florida PALM Project is targeted to replace Central, Payroll, and Departmental FLAIR functionality, with go-live scheduled for January 6, 2026.
The 1,500+ computing assets are comprised of interfaces, enterprise applications, databases, automated processes, and reporting programs within FDOT that will require remediation due to:
• Adoption of the Florida PALM Standardized Business Process Model
• Transition to the Florida PALM Chart of Accounts values
• Replacement of Central, Payroll and Departmental FLAIR functionality
• Redevelopment of agency incoming and outgoing interfaces to the statewide accounting system
• Implementation of Information Warehouse data to support agency specific reporting requirements.
The computing asset modifications to complete the FDOT PALM System Transition (FPST) will take place over the course of two years in alignment with the Florida PALM Project scheduled timeline.
Of the 1,500+ computing assets, over 1,000 are reports containing financial data. These reports primarily consist of a listing of detailed financial transactions requiring staff to spend hours manipulating the data into a format so that it can be analyzed.
To prepare for the transition to Florida PALM, our agency is seeking a resource knowledgeable in Snowflake to assist in the agency’s effort to modernize legacy mainframe flat file data into Snowflake-compatible data formats. Our goal is to transform our data into actionable insights through a modern data platform, enabling our organization to deliver true management decision support.
Our management has the vision to transform our department into a truly data driven organization and we just need the right resource to help us execute that vision.5 Education Bachelor’s Degree in a field of study related to Information Technology, Computer Science, Data Analytics, or Finance. Work experience may substitute on a year-for-year basis for the degree.
Education : Bachelor’s Degree in Computer Science, Information Systems, or related field is required. Equivalent work experience may substitute for the degree requirement.