Senior Data Engineer

Description

Fairway, a leading provider of residential exterior home services and a Morgan Stanley Capital Partners portfolio company, delivers essential services such as weed control and fertilization, along with complementary offerings including irrigation, pest control, and tree and shrub maintenance. 

The Senior Data Engineer is responsible for building, operating, and hardening the data pipelines and platform infrastructure that power Fairway’s Enterprise Data Platform (EDP). This role builds and operates ingestion, transformation, and orchestration across the Snowflake data cloud — using dbt for transformation, managed ingestion services for source onboarding, and AWS S3 for file storage and landing zones. The Senior Data Engineer ensures the platform is reliable, secure, observable, and cost-efficient, and supports the technical execution of new-source onboarding. Above all, the ideal candidate is meticulous, highly organized, and exacting about how systems are structured and how they function — a self-directed driver with a strong work ethic and clear communication. In an AI-assisted development model, sound technical judgment, rigorous review, and organizational discipline are what turn generated code into reliable, well-structured output. 

Key Responsibilities: 

• 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 / Snowpipe) 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.