Senior Snowflake Data Engineer

We are seeking a Snowflake Data Engineer with strong SQL expertise to join our data engineering team in a hybrid role based in Virginia. The ideal candidate will have hands-on experience designing, developing, and optimizing data pipelines, Snowflake environments, and analytics-ready datasets. This role involves close collaboration with business stakeholders, data analysts, and architects to deliver scalable and high-performance solutions. Key Responsibilities: • Design, build, and optimize Snowflake data warehouses, schemas, and data models (staging, integration, and reporting layers). • Develop robust ETL/ELT pipelines using tools such as Informatica, Boomi, DBT, Matillion, or native Snowflake features (Snowpipe, Streams & Tasks). • Write complex, high-performance SQL and stored procedures for data transformations. • Implement performance tuning for queries, virtual warehouses, micro-partitioning, clustering, and caching. • Manage Snowflake security, roles, RBAC, data sharing, and resource monitoring. • Build and maintain data ingestion frameworks from cloud/on-prem sources (S3, Azure Blob, APIs, relational systems). • Collaborate with data analysts and business teams to understand requirements and translate them into technical solutions. • Troubleshoot pipeline and data quality issues; implement validation and monitoring. • Work with CI/CD tools (Git, Azure DevOps, Jenkins) for automated deployments. • Follow best practices for governance, documentation, and quality assurance. Required Skills: • 8+ years of experience as a Data Engineer. • Strong SQL experience (query optimization, window functions, complex joins). • 3+ years hands-on with Snowflake (Snowpipe, Streams & Tasks, Time Travel, Clustering, RBAC). • Ability to work in a hybrid schedule within Virginia.