Senior Data Engineer

Sightly

United States

Remote

USD 140,000 - 210,000

Full time

2 days ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Benefits offered by this job

Remote work

Job summary

Sightly is seeking a senior data engineer in the United States with 5+ years of experience building and operating production data pipelines. You will own end-to-end architecture, drive Data Platform improvements, and collaborate with analytics and product teams.

This role supports remote work and requires strong Python/SQL, Airflow, and Snowflake expertise. You will optimize pipelines ingesting media and advertising data, manage APIs and credentials, and contribute to AI-assisted data workflows

Qualifications

  • 5+ years of data engineering experience running production pipelines, including owning systems end to end and making architecture decisions.
  • Strong Python and SQL
  • Deep experience with Airflow (or a similar orchestrator) in production
  • Experience with Snowflake (or BigQuery or Redshift), including administration: warehouses, access control, cost management

Responsibilities

  • Build and run Python pipelines and Airflow DAGs ingesting YouTube, TikTok, Meta, Google Ads, DV360, social and news data
  • Handle API quotas, rate limits, retries and credential rotation
  • Maintain ad-platform performance pipelines feeding client reports, the Reporting API and automated billing
  • Own alerting, data freshness and pipeline health; lead incident response
  • Partner with analytics and product engineers on dbt models and serving data to Postgres and OpenSearch
  • Document pipelines, tables and runbooks
  • Shape the data platform as volume and use cases grow
  • Gather requirements from account managers, sales and strategy and ship rapid iterations
  • Report to the Director of Data
  • Remote work arrangement

Skills

Python
SQL
Airflow
Snowflake
dbt
OpenSearch
GCP
REST APIs
CI/CD
Git

Tools

Airflow
Snowflake
BigQuery
Redshift
Cloud Composer
Dataflow
Cloud Storage
OpenSearch

Job description

  • Build and run Python pipelines and Airflow DAGs ingesting YouTube, TikTok, Meta, Google Ads, DV360, social and news data
  • Handle API quotas, rate limits, retries and credential rotation
  • Manage Snowflake warehouses, roles, access, partner data sharing and costs
  • Tune schedules and storage, including the Iceberg migration
  • Maintain ad-platform performance pipelines feeding client reports, the Reporting API and automated billing
  • Own alerting, data freshness and pipeline health; lead incident response
  • Shape the data platform as volume and use cases grow
  • Gather requirements from account managers, sales and strategy and ship rapid iterations
  • Partner with analytics and product engineers on dbt models and serving data to Postgres and OpenSearch
  • Document pipelines, tables and runbooks
  • Help build safe, AI-assisted production data workflows with sandboxed environments, tests and CI/CD guardrails
  • Report to the Director of Data
  • 5+ years of data engineering experience running production pipelines, including owning systems end to end and making architecture decisions
  • Experience working directly with business users or clients: gathering requirements, explaining tradeoffs, and iterating quickly on feedback
  • Strong Python and SQL
  • Deep experience with Airflow (or a similar orchestrator) in production
  • Experience with Snowflake (or BigQuery or Redshift), including administration: warehouses, access control, cost management
  • Track record of integrating third-party REST APIs at volume, with quotas, pagination and failures
  • Experience on a major cloud platform, ideally GCP
  • At least working familiarity with Elasticsearch or OpenSearch; deep expertise is a big plus
  • Uses AI coding tools (such as Claude) as a core part of how you build
  • Comfortable with Git, code review and CI/CD
  • Hands-on dbt experience, ideally on Snowflake (nice to have)
  • GCP data services: Cloud Composer, Dataflow, Cloud Storage (nice to have)
  • Apache Iceberg (nice to have)
  • Experience with ad platform APIs or YouTube data (nice to have)
  • High-performance data processing in Python (nice to have)
  • Knowledge of or experience in the digital advertising and/or marketing field
  • Self-starter who seeks out unfamiliar, uncomfortable problems and learns fast
  • Client-minded communicator who enjoys working with non-technical people and can explain data in plain terms
  • Collaborative mentality, with a habit of mentoring teammates and raising the bar on code and design
  • Comfortable working in a fast-paced and dynamic environment
  • Must be authorized to work in the United States; sponsorship question is included in the application
  • Opportunities to get involved with projects that expand skillset and knowledge
  • Remote work arrangement
  • AI-assisted development workflows and sandboxed environments, tests, and CI/CD guardrails
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Senior Data Engineer
Senior Data Engineer

Zoominfo • United States

Remote
USD 110,000 - 170,000
Remote work
Sr Data Engineer
Sr Data Engineer

Cox Automotive • Atlanta (GA)

On-site
USD 140,000 - 190,000
Data Engineer, AI & Analytics
Data Engineer, AI & Analytics

powerdigitalmarketing • United States

Remote
USD 110,000 - 180,000
Senior Data Engineer
Senior Data Engineer

Scenthound • United States

Remote
USD 140,000 - 180,000
Health/Dental/Vision insurance
Paid time off
Company Paid Life and AD&D Insurance
+6
Data Engineer
Data Engineer

Tastytrade • United States

On-site
USD 120,000 - 180,000
Medical plans
Dental & Vision
401(k) with company match
+5
Senior Data Engineer
Senior Data Engineer

Agile Engine • United States

Remote
USD 140,000 - 200,000
Growth opportunities
Competitive compensation
100% remote
+4
Lead Data Engineer
Lead Data Engineer

Aimpoint Digital • United States

Remote
USD 140,000 - 210,000
Senior Data Engineer
Senior Data Engineer

Kula Example • San Francisco (CA)

On-site
USD 190,000 - 230,000
Senior Data Engineer
Senior Data Engineer

AgileEngine, LLC. • United States

Hybrid
USD 130,000 - 190,000
Professional growth
Flexible schedule
Remote and office options
Data Engineer
Data Engineer

Collectivus Holdings • United States

Remote
USD 100,000 - 150,000