Hybrid Data Engineer: Redshift, dbt & Airflow Expert

Casper

Richmond (VA)

Hybrid

USD 115,000 - 130,000

Full time

14 days+

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Benefits offered by this job

Medical, vision, and dental insurance
Paid Time Off
Employee Discount on products
Tuition reimbursement
And more!

Job summary

Casper is seeking a data engineer to join its Data Engineering team in Richmond, VA, for a hybrid role. You will own the data warehouse architecture, develop dbt models, and build robust data ingestion pipelines to support analytics and LookML modeling across the semantic layer.

Ideal candidates have 3+ years of experience with Python/SQL, Airflow, and cloud data warehouses such as Redshift or Snowflake, plus familiarity with BI tools and ecosystem tooling.

Qualifications

  • 3 years of experience with cloud data warehouses such as Redshift or Snowflake.
  • Strong Python and SQL skills.
  • Experience with Airflow, containerization and orchestration.
  • Knowledge of modern BI tools and dbt.

Responsibilities

  • Own the storage architecture in Amazon Redshift, including distribution and sort key design, RA3/managed storage tuning, and tiering cold data to S3/Spectrum to keep the warehouse fast and cost-efficient as data volume grows.
  • Design and maintain dbt models for high-volume event data at multi-billion row scale while balancing cost and efficiency.
  • Build resilient ingestion pipelines from third-party platforms with idempotent loads so bad or partial loads never silently reach production tables.
  • Diagnose and resolve pipeline performance bottlenecks and fine tuning workloads between raw to BI layer to prevent data outages.
  • Set up monitoring and alerting across the pipeline to catch data anomalies before they compound.
  • Work closely with data analysts to align warehouse design with stakeholder needs and LookML modeling, ensuring a robust, scalable foundation from raw tables through to the semantic layer
  • Collaborate with other engineers and product managers in solving interesting and challenging problems across our systems
  • Advance modern, agile software development practices and help build a culture of great engineering and organizational practices
  • Learn from the team and on your own what you might not know about data infrastructure, business operations, and open source tooling to make you a stronger asset to the team

Skills

Python
SQL
Airflow
Containerization
Orchestration
dbt
Cloud data warehouse

Education

3 years relevant work experience

Tools

Redshift
Snowflake
AWS
Looker
Airflow
dbt
Fivetran

Job description

Casper is seeking a data engineer to join its Data Engineering team in Richmond, VA, for a hybrid role. You will own the data warehouse architecture, develop dbt models, and build robust data ingestion pipelines to support analytics and LookML modeling across the semantic layer.

Ideal candidates have 3+ years of experience with Python/SQL, Airflow, and cloud data warehouses such as Redshift or Snowflake, plus familiarity with BI tools and ecosystem tooling.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Hybrid Data Engineer - Redshift, dbt & Airflow
Hybrid Data Engineer - Redshift, dbt & Airflow

Carpenter Canada Co. • Richmond (VA)

Hybrid
USD 115,000 - 130,000
Medical, vision, and dental insurance
Paid Time Off
Employee discounts
+2
Senior Data Analytics Engineer - Redshift, Airflow & BI
Senior Data Analytics Engineer - Redshift, Airflow & BI

Harvey Nash • Arlington (VA)

On-site
USD 91,000 - 129,000
Data Engineer
Data Engineer

Casper • Richmond (VA)

Hybrid
USD 115,000 - 130,000
Medical, vision, and dental insurance
Paid Time Off
Employee Discount on products
+2
Data Engineer
Data Engineer

Carpenter Canada Co. • Richmond (VA)

Hybrid
USD 115,000 - 130,000
Medical, vision, and dental insurance
Paid Time Off
Employee discounts
+2
Senior Data Engineer: Snowflake, dbt, Python & Airflow
Senior Data Engineer: Snowflake, dbt, Python & Airflow

Mindera • United States

Remote
USD 140,000 - 190,000
Senior Big Data Engineer: Snowflake + dbt (Remote)
Senior Big Data Engineer: Snowflake + dbt (Remote)

Ulvior • United States

Remote
USD 40,000 - 45,000
Medical insurance for you and family
Food vouchers
Extra days off
+2
Hybrid Data Analyst/Engineer (Python, SQL, Snowflake)
Hybrid Data Analyst/Engineer (Python, SQL, Snowflake)

Apex Systems, LLC • McLean (VA)

Hybrid
USD 76,000 - 79,000
ESPP (Employee Stock Purchase Program)
401(k) plan with company match
Health Savings Account (HSA)
+1
Senior Data Engineer
Senior Data Engineer

Aloola.io • Beverly Hills (CA)

On-site
USD 150,000 - 230,000
Data Engineer
Data Engineer

TechDigital Group • Torrance (CA)

On-site
USD 100,000 - 130,000
Data Engineer
Data Engineer

tastylive, Inc. • Chicago (IL)

Hybrid
USD 110,000 - 150,000