Overview
Skills
Job Details
Job Details:
Title: Snowflake Developer / Analyst
Duration: 14+ months with a high possibility of extension
Location: Tallahassee, FL 32399 (onsite from day one)
Required Skills:
*) Candidate must have a minimum of 3 years of experience in data engineering, analytics, or cloud data warehousing, with at least 2 years of hands-on experience designing and implementing solutions using the Snowflake Data Cloud platform.
*) Expert-level SQL programming is REQUIRED for this position.
*) 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.
Preferred KSAs:
*) 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).