Hopper

Ads Data Engineer

Hopper

full-time

Posted on:

Location Type: Remote

Location: Remote • Massachusetts • 🇺🇸 United States

Visit company website
✨ AI Apply
Apply

Job Level

Mid-LevelSenior

Tech Stack

AirflowAmazon RedshiftBigQueryCloudETLKafkaPythonScalaSQL

About the role

  • Own the Data Architecture: Design, build, and maintain scalable and reliable ETL/ELT pipelines to process high-volume advertising data.
  • Build the Foundation: Develop and manage our analytical data warehouse, establishing it as the single source of truth for all reporting and analytics.
  • Enable Insights: Create clean, reliable, and performant data models that power our advertiser reporting dashboards, internal analytics, and billing systems.
  • Ensure Data Integrity: Implement robust data quality checks, monitoring, and alerting to ensure the accuracy and trustworthiness of our data.
  • Collaborate and Empower: Work closely with the engineering and product teams to define data requirements and deliver the necessary data infrastructure to support new ad products and features.
  • Prepare for the Future: Build the foundational data systems that will enable future ML-driven optimizations for audience targeting and performance prediction.

Requirements

  • 4+ years of data engineering experience, with a demonstrated track record of building and maintaining data infrastructure at scale.
  • Expert-level proficiency in SQL and a programming language like Python or Scala for data processing.
  • Hands-on experience with cloud-based data warehousing solutions (e.g., BigQuery, Snowflake, Redshift).
  • Proven success building and operationalizing data pipelines using orchestration tools (e.g., SQLMesh, Airflow, dbt).
  • Experience with real-time data streaming technologies (e.g., Google Pub/Sub, Kafka, Kinesis).
  • Strong understanding of data modeling concepts and experience designing schemas for analytical workloads.
  • Experience with ad tech, retail media, or large-scale data systems is strongly preferred.
  • Excellent communication skills and an ability to collaborate effectively with both technical and business stakeholders.
  • A strong sense of ownership and the ability to operate with a high degree of autonomy in a fast-paced, entrepreneurial culture.
Benefits
  • Well-funded and proven startup with large ambitions, competitive salary and the upsides of pre-IPO equity packages.
  • Unlimited PTO.
  • Carrot Cash travel stipend.
  • Access to co-working space on demand through FlexDesk AND Work-from-home stipend.
  • Please ask us about our very generous parental leave, much above industry standards!.
  • Entrepreneurial culture where pushing limits and taking risks is everyday business.
  • Open communication with management and company leadership.
  • Small, dynamic teams = massive impact. 100% employer paid Medical, Dental and Vision coverage for employees.
  • Access to Disability & Life insurance.
  • Health Reimbursement Account (HRA).
  • DCA/ FSA and access to 401k plan.

Applicant Tracking System Keywords

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

Hard skills
data engineeringETLELTSQLPythonScaladata modelingdata quality checksdata pipelinesreal-time data streaming
Soft skills
communicationcollaborationownershipautonomy