Senior Snowflake Engineer

TheStaffed; Pennsylvania; On-site; USD 140,000 - 200,000; Full time

Job summary

TheStaffed seeks a Senior Snowflake Engineer to design, build, and optimize cloud-based data solutions. You will focus on enterprise data ingestion, transformation, and architectural support across trading, ERP, and transactional systems.

Qualifications include 10–15 years of hands-on data engineering experience, expertise in Snowflake, SQL-based warehousing, and strong AWS skills. You will contribute to scalable, cost-efficient data platforms and automated pipelines.

Qualifications

• 10+ years of hands-on experience in data engineering and cloud platforms.
• Strong background in SQL-based data warehousing and data modeling.
• Experience with Snowflake performance tuning and multi-layer architectures.

Responsibilities

• Build and maintain data ingestion pipelines into Snowflake from diverse sources.
• Design and implement data transformations and reusable UDFs across ingestion layers.
• Optimize Snowflake workloads for performance, cost, and reliability.
• Support cloud architecture decisions for warehouse/lakehouse designs and data platforms.
• Deliver use cases through iterative design, testing, and production deployment.
• Document reusable platform capabilities and best practices for future use cases.
• Support production readiness, deployment, rollback, and business continuity.

Skills

Data engineering

Cloud platforms

CI/CD practices

Tools

Snowflake

AWS

ETL/ELT

S3

Job description

Our client is seeking a Senior Snowflake Engineer with 10--15 years of experience to design, build, and optimize cloud-based data solutions, with a focus on enterprise data ingestion, transformation, and architectural support across trading, ERP, and transactional systems.

Responsibilities & Qualifications

• Build and maintain automated and manual data ingestion pipelines into Snowflake, with support for diverse data sources and formats
• Design and implement data transformations, mappings, and reusable UDFs across ingestion layers to ensure data quality and consistency
• Optimize Snowflake workloads and pipelines for performance, reliability, and cost efficiency
• Support architectural decisions regarding cloud connectivity, platform configuration, and warehouse/lakehouse design patterns
• Deliver prioritized use cases through iterative cycles including design, build, UAT, operational testing, and production deployment
• Establish and document reusable platform capabilities and best practices to accelerate future use case delivery
• Support production readiness, deployment, rollback, recovery, and business continuity procedures
• Collaborate on complex data modeling for transactional systems, trading platforms, and ERP environments

Requirements

• 10--15 years of hands-on experience with data engineering, cloud platforms, and SQL-based data warehousing
• Advanced proficiency in Snowflake including performance tuning, access controls, and multi-layer architecture patterns
• Strong expertise in AWS services including S3, Glue, Lambda, Athena, EMR, and Redshift
• Demonstrated experience with data modeling, ETL/ELT design, and lakehouse/warehouse architectural patterns
• Background building data solutions for transactional systems, trading platforms, or ERP environments
• Solid understanding of cloud-based data architectures and scalability considerations
• Experience with version control, CI/CD pipelines, and collaborative development practices