Sr Snowflake Engineer

We are seeking a Senior Snowflake Engineer for a 6-month contract position in Allentown, Pennsylvania. In this role, you will help build out the data platform foundation and deliver business use cases through an iterative, Agile wave-based approach. You will work on Trading Risk data use cases, moving them from design through production while establishing standardized architecture, security, governance, data quality, CI/CD, and operational practices that can support additional use cases and teams.

Responsibilities

• Build automated and manual data ingestion pipelines into Snowflake
• Implement transformations and mappings across the ingestion layers
• Develop reusable data transformation components and UDFs
• Support architectural decisions related to connectivity, platform configuration, and workload design
• Optimize pipelines and Snowflake workloads for performance, reliability, and cost
• Deliver prioritized use cases through iterative Design, Build, Business Testing, Operational Testing, and Production cycles
• Support UAT, production readiness, deployment, rollback, recovery, and business continuity procedures
• Help establish reusable platform capabilities to enable efficient delivery of subsequent use cases

Qualifications

• Required
• Hands-on experience building manual and automated pipelines in Snowflake
• Expertise with data models, performance optimization, and access controls
• Experience with data warehouse and data lakes
• Experience with transactional data systems such as ERPs or Trading platforms
• Knowledge of AWS and its services including S3, Glue, Lambda, EMR, and Redshift