What are the responsibilities and job description for the Senior Data Engineer position at firstPRO, Inc?
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
Salary : $65 - $70