Senior Data Engineer

Fairway

Senior Data Engineer responsible for building and operating automated ingestion pipelines and data models for Fairway’s Enterprise Data Platform. Ensuring reliability and cost-efficiency in data operations for home service solutions.

Posted 6/2/2026full-timePlano • Texas • 🇺🇸 United StatesSeniorWebsite

Tech Stack

Tools & technologies

AWSCloudPythonSQL

About the role

Key responsibilities & impact

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.

Requirements

What you’ll need

Bachelor's degree in Computer Science, Data Engineering, Information Systems, or a related field, or equivalent on-the-job experience, required.
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.
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).
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.

Benefits

Comp & perks

Equal opportunity employment

ATS Keywords

✓ Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

data engineeringdata modelingSQLPythondbtSCD Type 2automated testingdata-quality controlscloud-managed ingestiondata governance

Soft Skills

meticuloushighly organizedself-directedstrong work ethicownership mentalitystrong communication skillsproactiveinitiativecross-functional collaborationtechnical coordination

Certifications

Bachelor's degree in Computer ScienceBachelor's degree in Data EngineeringBachelor's degree in Information Systems