Senior Data Engineer Job at firstPRO, Inc, Philadelphia, PA

cWVqbFNTNVg1YjkvTU9sakJZMmJRNGw0MlE9PQ==
  • firstPRO, Inc
  • Philadelphia, PA

Job 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

Job Tags

Remote work,

Similar Jobs

Omega Construction, Inc.

Marketing and Creative Design Specialist Job at Omega Construction, Inc.

 ...Job Title : Marketing & Creative Design Specialist Reports To : Director of Business Development and Marketing The Marketing...  ...other members of the Marketing Team to support proposals, social media management, and additional marketing initiatives. The ideal candidate... 

CenTrio

Plant Operator Job at CenTrio

 ...hour Employee Assistance Program/Hotline ~ Corporate discounts (Travel, Entertainment, Home, Auto, Apparel, Health and Wellbeing, and...  ...force that reflect the multicultural nature of the nation and our world and bring unique strengths and abilities which contribute to... 

Nestlé

Line Operator 2 Job at Nestlé

 ...portfolio of beloved brands, including DiGiorno, Toll House, and Coffee mate, in 97% of U.S. households, we have a...  ...for Visa Sponsorship. POSITION SUMMARY: The Line Operator 2 is responsible for sheeting, scaling, and mixing all ingredients as prescribed by the Bill... 

Joulea

Systems Engineer - BACnet, BMS Systems Job at Joulea

 ...About Us Joulea is a startup building a software platform that reduces energy consumption in commercial buildings. Buildings consume...  ...Position Overview We are seeking a Systems Integration Engineer to join our team. The ideal candidate will be responsible for designing... 

firstPRO, Inc

Senior Data Engineer Job at firstPRO, Inc

 ...We are seeking a Senior Data Engineer with deep, hands-on Snowflake experience to design, optimize, and support scalable data solutions...  ...orchestration tools Cloud platform experience (AWS, Azure, or GCP) Background in regulated or highly data-governed environments...