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

NatureSweet

Packaging Manager Job at NatureSweet

 ...supermarket retailers throughout the United States, Mexico, and Canada. NatureSweet is dedicated to having a positive social, environmental, and economic impact within our communities, and our commitment is to transform the lives of agricultural workers throughout North... 

18 Degrees Family Services for Western Massachusetts

Artistic Program Director Job at 18 Degrees Family Services for Western Massachusetts

 ...Artistic Director is a unique position that combines the best of music instruction and pedagogy; with a passion for helping students...  ...musicianship and demonstrated skills as a music educator/performer; experience leading and conducting ensembles. Applications reviewed on... 

Curative

Locum Tenens Family Medicine Physician - Weekdays Only Job at Curative

 ...adult and geriatric patients On-site support: pharmacy, psych, dental, rehab, and care team Epic EMR with Dragon dictation...  ...Daily rounding, admissions, discharges, care assessments Review labs, imaging, and medication plans Participate in care plan meetings... 

International Leadership Charter High School

School Counselor Job at International Leadership Charter High School

 ...and arranging for needed services. Consult with parents, teachers, and other school...  ...Master's degree in Counseling and/or Social Work Minimum of three (3) years of...  ...with parents and students as partners in education. Belief that all students can learn and... 

TORQ Coatings

Call Center Representative Job at TORQ Coatings

Exciting Career Opportunity: Call Center Agent Location: Lombard, IL Compensation: $19-$21/hr Job Type: Part-Time, Onsite Industry: Consumer Services / Construction / Customer Service Why Join Us? TORQ Coatings is seeking reliable, coachable Call ...