Sr Lead Snowflake Engineer (In-Person interview in Tallahassee FL)

Candidates Must go for In-Person interview in Tallahassee FL

Job Title: Snowflake Data Engineer

Location: Tallahassee FL

Duration: 2 Years

The selected candidate will:

• Analyze current data environments, pipelines, and legacy structures to determine transformation needs and optimal migration strategies to Snowflake.
• Collaborate with stakeholders and data architects to design scalable, secure, and cost-effective Snowflake data architectures.
• Re-engineer legacy reporting logic (WebFOCUS, Mainframe FOCUS, T-SQL) into optimized Snowflake SQL.
• Develop and automate ELT/ETL pipelines using Snowflake native features (Snowpipe, Streams, Tasks) and tools such as Informatica, dbt, Airflow.
• Build reusable, secure data models and views in Snowflake for BI tools (Power BI, Tableau, Looker).
• Implement Snowflake performance optimization and governance best practices (security roles, RBAC, masking policies, cost monitoring, clustering).
• Support knowledge transfer, documentation, and training for internal teams.

Minimum Qualifications

• Bachelor’s degree in Information Technology, Computer Science, Data Analytics, Finance, or related field (or equivalent work experience).
• Minimum 3 years in data engineering, analytics, or cloud data warehousing.
• Minimum 2 years hands-on experience designing and implementing solutions using the Snowflake Data Cloud platform.

Required Technical Skills

• Expert-level SQL programming.
• Proven experience with Snowflake platform architecture and cloud data warehousing concepts.
• Expertise in building efficient, secure, and scalable Snowflake data models (views, materialized views, secure shares).
• Strong knowledge of ELT/ETL patterns and tools (dbt, Airflow, Talend, Informatica, MS SSIS, Fivetran).
• Solid understanding of Snowflake governance: security roles, masking policies, RBAC.
• Experience with cloud storage integration (AWS S3, Azure Blob) and Snowflake external tables.
• Dimensional modeling expertise (Star/Snowflake Schema), OLAP concepts, BI reporting layer design.
• Data migration from legacy systems (mainframe, DB2, MS SQL Server, Oracle) into Snowflake.

Preferred Skills

• Experience with BI tools (Power BI, Tableau, Looker) and semantic model building using Snowflake.
• Experience with financial, ERP, or general ledger datasets.
• Mainframe systems and flat file integration with cloud platforms.
• Familiarity with Agile/SCRUM methodologies.
• Oracle Data Warehouse experience.
• DevOps/CI-CD practices in data engineering (Git, dbt Cloud, GitHub Actions).

General Competencies

• Communication: Clear written and verbal communication for technical and non-technical audiences.
• Customer Service: Strong client focus, problem resolution skills.
• Decision Making: Objective, well-informed, and timely decision-making.
• Flexibility: Adaptable to changing priorities and feedback.
• Interpersonal Skills: Professional, respectful, and collaborative.
• Leadership: Motivates and guides teams effectively.
• Problem Solving: Analytical and creative in developing solutions.
• Team Building: Fosters teamwork and shared goals.