Fairway

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.

Senior Data Engineer