Snowflake Data Engineer

• Build and maintain automated ingestion pipelines from SaaS applications, databases, streaming sources, and inbound Snowflake data shares — including source data contracts that catch upstream changes before they break downstream models. 
• Develop and maintain transformation models across the raw, transformation, and presentation layers — including SCD Type 2 history — with rigorous testing and documentation. 
• Build and operate pipeline orchestration with job-dependency management, change-data-capture, SLA monitoring, alerting, and incident response. 
• Build and operate secure outbound data delivery to third-party vendors through established EDP patterns (SFTP and secure data shares), including delivery monitoring and credential management. 
• Manage data warehouse operations — warehouse sizing, cost monitoring, role-based access control, and PII masking. 
• Support data governance and quality — maintain the data catalog and Snowflake-native lineage under the direction of data stewards, implement data-quality controls, and enforce platform standards. 
• Build and maintain GitHub-based version control, automated testing, and the CI/CD pipeline that gates code promotion across environments. 

Key Skills Required:

• Strong Snowflake skills — data modeling, performance, cost management, and security (RBAC, masking). 
• Strong experience with dbt — transformation pipelines, SCD Type 2 snapshots, automated testing, and data-quality controls. 
• Solid SQL and Python — enough to read, review, and rigorously validate data logic and AI-generated code — with sound engineering practices (Git / GitHub, automated testing, and CI/CD). 
• Experience building and operating production data pipelines — continuous ingestion, change-data-capture, orchestration, scheduling, SLA monitoring, alerting, and incident response. 
• Hands-on experience with AWS S3 and secure outbound delivery to external vendors via SFTP and secure data shares, including credential/key management. 
• Skilled at writing precise build specifications and rigorously reviewing and validating generated code — the foundation for directing AI coding tools such as Snowflake Cortex AI or Claude (hands-on AI-assisted experience welcome, not required). 
• Working knowledge of data governance, security, PII handling, and compliance frameworks. 
• Meticulous and highly organized — exacting about how data, code, and processes are structured, named, and documented. 
• Self-directed, with a strong work ethic and ownership mentality — takes initiative and follows through to completion. 
• Strong communication skills for technical coordination with vendors and cross-functional teams — proactive, keeps people informed, and documents work clearly. 
• Familiarity with agile methodologies and cross-functional collaboration. 

Education Requirements:

• Bachelor’s degree in Computer Science, Data Engineering, Information Systems, or a related field, or equivalent on-the-job experience, required. 
• Relevant certifications such as SnowPro Core / Advanced: Data Engineer or dbt certification are highly desirable. 

Experience Requirements:

• 5–8 years of experience in data engineering, data platform, or related roles. 
• 3+ years building and operating production pipelines on Snowflake (or a comparable cloud data warehouse) with dbt. 
• 2+ years with cloud-managed ingestion (Fivetran / Snowpark) and AWS S3. 
• Matillion experience a plus. 
• Fairway is an equal opportunity employer and affords equal opportunity to all applicants for all positions without regard to race, color, religion, gender, national origin, age, disability, veteran status or any other status protected under local, state, or federal laws.