Job Description
Role - Snowflake Data Consultant
\n
Location: Boston (Preferred) or Tampa (Hybrid)
\n
Mode: Contract
\n
\n
- \n
- Overall 7+ years of experience in Data Engineering, Big Data, Data Warehousing, and Cloud Data Platforms, with strong expertise in Snowflake (4+ years).
- Partner with Product Owners, business stakeholders, and domain experts to gather requirements and translate them into scalable, high-quality solution designs aligned with industry best practices and architectural standards.
- Collaborate with Application Architects and cross-functional technical teams throughout the development lifecycle and resolve issues identified during System Integration Testing (SIT) and User Acceptance Testing (UAT).
- Design, develop, and maintain resilient and scalable ELT data pipelines for data ingestion, transformation, and consumption using Snowflake, Python, Snowpark, and orchestration frameworks.
- Develop and optimize complex SQL solutions, stored procedures, UDFs, Snowflake Tasks, Streams, and Snowpipe-based ingestion frameworks.
- Design logical and physical data models, database objects, schemas, views, and security frameworks, with a strong understanding of dimensional modeling and Data Vault methodologies.
- Implement Change Data Capture (CDC) and incremental data processing solutions leveraging Snowflake Streams and Tasks.
- Optimize Snowflake workloads through effective warehouse sizing, clustering strategies, partitioning approaches, and query performance tuning.
- Demonstrate advanced proficiency in SQL development, performance optimization, and troubleshooting.
- Hands-on experience with Snowflake capabilities including SnowSQL, Snowpipe, Tasks, Streams, Time Travel, Data Sharing, Stored Procedures, Secure Views, and External Tables.
- Actively participate in Agile ceremonies, including sprint planning, backlog grooming, code reviews, daily standups, and retrospectives.
- Follow test-first and test-driven development practices, performing comprehensive unit testing and peer reviews to ensure high-quality, maintainable, and performant code.
- Collaborate effectively with distributed teams, developers, architects, and business stakeholders to deliver enterprise-scale data solutions.
- Possess strong analytical, problem-solving, communication, and stakeholder management skills.
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n