Data Engineer

PerfectServe

. Build and maintain ingestion pipelines from production source systems .

Posted 9/24/2026full-timeRemote • United StatesMid-LevelSenior💰 $115,000 - $140,000 per yearWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates expertise in building and maintaining data ingestion pipelines, applying dimensional and medallion modeling patterns, and ensuring data quality through testing and documentation. Proficient in SQL, Python, and cloud data warehousing technologies, with hands-on experience in transformation frameworks and orchestration tools.

Highest-signal resume keywords

Data Pipeline DevelopmentSQL ProficiencyPython ProgrammingCloud Data Warehouse ExperienceELT and Orchestration Tools

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

Data Pipeline DevelopmentSQLPythonDbtSnowflakeBigQueryRedshiftFivetranAirflowData Quality Testing

Soft Skills

CollaborationDocumentation

Tools & Technologies

DbtFivetranAirflowSnowflakeBigQueryRedshiftAWS

Industry Keywords

Data IngestionDimensional ModelingMedallion ModelingData Quality ChecksData Model Design

Tech Stack

Tools & technologies

AirflowAmazon RedshiftAWSBigQueryCloudPythonSQLGo

About the role

Key responsibilities & impact

Build and maintain ingestion pipelines from production source systems
Write transformation models that turn raw data into datasets people can trust
Apply dimensional and medallion modelling patterns as the warehouse takes shape
Deploy pipelines to production, and test them properly — idempotency, data quality checks
Contribute to data model and schema design, and to design reviews
Document what you build, including runbooks for the pipelines you own
Work closely with a staff data engineer and a platform engineer while building PerfectServe's data platform

Requirements

What you’ll need

Professional experience building data pipelines, with production ownership of at least some
Strong SQL, and a working programming language — Python, Go or equivalent
Hands-on dbt, or another transformation framework
A cloud data warehouse — Snowflake, BigQuery, Redshift or similar
Practical ELT and orchestration experience (Fivetran, Airflow or equivalent)
Working AWS knowledge — object storage, access basics, and enough networking to reason about where data moves
A testing instinct for data, not only for code

Benefits

Comp & perks

Remote first work environment
Health, Dental, Vision, Life and Disability Insurance options available day one.
401K - with match and immediately vested.
17 company holidays, 2 floating holidays plus competitive paid time off policy
Internal Advancement Opportunities