What are the responsibilities and job description for the Sr Lead Snowflake Engineer (In-Person interview in Tallahassee FL) position at SIRITECH SOLUTIONS CORP?
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.