DeveloperJobs.io
← Back to all jobs

Job Description

The Data Engineer will join the Data Platform team to deliver ELT/ETL pipelines and governed datasets built from enterprise and marketing data. This role supports analytics needs and AI-enabled initiatives, with a focus on data modeling, quality, monitoring, and governance practices. The position is based in Pittsburgh, PA and requires 5-day onsite attendance.

Responsibilities

  • Design, build, and maintain ELT/ETL pipelines that move data reliably from source systems into curated layers.
  • Connect, normalize, and integrate enterprise and marketing data sources (including GA4, advertising platforms, CRM, email, affiliate, and social) into governed datasets.
  • Create dimensional models and semantic data products that support self-service analytics for business stakeholders.
  • Implement automated data-quality checks, monitoring, and observability; investigate and address pipeline failures or performance issues.
  • Apply data governance practices in partnership with the broader data team, including cataloging, lineage, tagging, and access controls.
  • Deliver clean, production-ready datasets to enable AI/ML and emerging agentic AI use cases.

Required Qualifications

  • 2 to 4 years of hands-on data engineering experience supporting production data pipelines.
  • Strong SQL skills with working proficiency in Python and/or Spark.
  • Experience orchestrating pipelines using tools such as Airflow or dbt.
  • Experience with AWS data services, including S3, Glue, Athena, and IAM.
  • Experience with cloud data warehouses such as Redshift, Snowflake, or BigQuery (preferred).
  • Working knowledge of dimensional modeling and data governance concepts, including cataloging, lineage, and access control.
  • Bachelor’s degree.

Technologies

  • ELT/ETL, SQL
  • Python, Spark
  • Airflow, dbt
  • AWS: S3, Glue, Athena, IAM
  • Data warehouses: Redshift, Snowflake, BigQuery
  • Dimensional modeling
  • GA4, CRM

Compensation

  • $75,000 - $85,000 per year.
  • Compensation listed is not guaranteed. Offers may vary based on experience level, qualifications, internal equity, and may be outside of the stated range.

Location and Work Schedule

  • Pittsburgh, PA (onsite)
  • 5-day onsite position

Inclusion & Belonging

The Hollister Group is an equal opportunity employer. The company welcomes and encourages applications from people who are under-represented in their respective occupation or position.

Similar Jobs