snowflake developer.

Saxon Global • Tallahassee, FL

1d • Onsite

About The Position

The Florida Department of Transportation is undertaking a significant modernization effort, the Florida PALM Standardized Business Process Model, which involves transitioning to a new Chart of Accounts, replacing legacy FLAIR functionality, redeveloping interfaces to the statewide accounting system, and implementing an Information Warehouse for agency-specific reporting. This project is scheduled to span two years. To support this transition, the agency is seeking a Snowflake-knowledgeable resource to assist in modernizing legacy mainframe flat file data into Snowflake-compatible data formats.

Requirements

• 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.
• Minimum of 8 years of experience in data engineering, analytics, or cloud data warehousing.
• At least 2 years of hands-on experience designing and implementing solutions using the Snowflake Data Cloud platform.
• Expert level SQL programming is REQUIRED.
• Proven experience with Snowflake platform architecture and data warehousing concepts.
• Expertise in building efficient, secure, and scalable data models in Snowflake using views, materialized views, and secure shares.
• Strong knowledge of ELT/ETL patterns and tools (e.g., dbt, Airflow, Talend, Informatica, MS SSIS, Fivetran).
• Solid understanding of data governance, security roles, masking policies, and RBAC within Snowflake.
• Experience working with cloud storage integrations (e.g., AWS S3, Azure Blob) and external tables in Snowflake.
• Familiarity with dimensional modeling (Star/Snowflake Schema), OLAP concepts, and reporting layers for BI tools.
• Strong communication and analytical skills for working with cross-functional teams and converting data requirements into technical solutions.
• Strong understanding of current data governance concepts and best practices.
• Knowledge of data migration best practices from external data sources and legacy systems (e.g., mainframe, DB2, MS SQL Server, Oracle) into Snowflake.

Nice To Haves

• Experience with data visualization tools (Power BI, Tableau, Looker) and building BI semantic models using Snowflake as a backend.
• Experience working with financial, ERP, or general ledger data in a reporting or analytics capacity.
• Exposure to mainframe systems, legacy flat files, and their integration with cloud-based platforms.
• Familiarity with Agile/SCRUM frameworks and experience working in iterative development cycles.
• Experience with Oracle Data Warehouse.
• Understanding of DevOps and CI/CD practices in data engineering (e.g., Git, dbt Cloud, or GitHub Actions).

Responsibilities

• Analyze the current data environment, including data sources, pipelines, and legacy structures, to determine required transformations and optimal migration strategies into Snowflake.
• Collaborate with stakeholders and data architects to design and implement scalable, secure, and cost-effective data architecture using Snowflake.
• Re-engineer legacy reporting logic (e.g., WebFOCUS, Mainframe FOCUS, and T-SQL) by translating them into Snowflake SQL and optimizing performance.
• Develop and automate ELT/ETL data pipelines using Snowflake's native features and tools such as Snowpipe, Streams, Tasks, Informatica, and integration with external orchestration tools (e.g., dbt, Airflow).

What This Job Offers

• Job Type: Full-time
• Career Level: Senior