firstPRO, Inc

Senior Data Engineer

⭐ - Featured Role | Apply direct with Data Freelance Hub
This role is a Senior Data Engineer contract position, fully remote, with a pay rate of "unknown". Requires 2+ years of hands-on Snowflake experience, strong SQL skills, and experience with on-prem to Snowflake migrations. U.S. residency is mandatory.
🌎 - Country
United States
💱 - Currency
$ USD
-
💰 - Day rate
560
-
🗓️ - Date
December 31, 2025
🕒 - Duration
Unknown
-
🏝️ - Location
Remote
-
📄 - Contract
Unknown
-
🔒 - Security
Unknown
-
📍 - Location detailed
Philadelphia, PA
-
🧠 - Skills detailed
#Data Pipeline #AWS (Amazon Web Services) #Azure #Datasets #GCP (Google Cloud Platform) #Airflow #Scripting #Migration #Data Engineering #Scala #SQL (Structured Query Language) #dbt (data build tool) #Cloud #SQL Queries #Snowflake #Python
Role description
We are seeking a Senior Data Engineer with deep, hands-on Snowflake experience to design, optimize, and support scalable data solutions in a fully remote, U.S.-based role. This position focuses on high-impact Snowflake work, including performance tuning, complex data challenges, and on-prem to cloud migration initiatives. The ideal candidate is highly technical, communicative, and comfortable working with messy, real-world data across multiple sources. Responsibilities • Design, build, and optimize scalable data pipelines and data models in Snowflake • Leverage advanced Snowflake features to improve performance, efficiency, and scalability • Tune and optimize complex SQL queries and workloads • Support and execute migrations from on-prem data environments to Snowflake • Work with inconsistent, multi-source internal and external datasets • Partner with stakeholders to gather requirements and translate them into technical solutions • Document data processes, architectures, and optimization strategies Requirements • Senior-level experience as a Data Engineer • Minimum 2+ years of hands-on Snowflake experience, beyond basic querying • Strong SQL skills with proven performance tuning and optimization experience • Experience supporting or leading on-prem to Snowflake migrations • Python experience or equivalent scripting language proficiency • Experience working with complex, messy, or poorly structured data • Strong written and verbal communication skills • Must reside in the United States and be generally aligned to U.S. Eastern Time Nice to Have: • Mortgage or financial services data experience • Experience with Airflow, dbt, or similar orchestration tools • Cloud platform experience (AWS, Azure, or GCP) • Background in regulated or highly data-governed environments