Data Engineer
3d Design Tools
Amazon Web Services
Analytics
Analytics Engineer
Apache Airflow
AWS
Aws Athena
Aws Data Engineer
Aws Data Warehouse
Aws Glue
Big Data
Bigdata
Bigquery
Cloud Computing
Cloud Data Engineering
Cloud Data Warehouse
Cloud Data Warehouse
Cloud Platform
Cloud Platforms
Data
Data Analysis
Data Analytics
Data Analytics Tools
Data Architecture
Data Build Tool
Data Engineer
Data Engineering
Data Integration
Data Integration Tools
Data Management
Data Modeling
Data Operations
Data Pipeline
Data Pipelines
Data Platform
Data Processing
Data Transforms
Data Warehouse
Data Warehousing
Database
Databases
Digital Marketing
ETL
Informatica
Information Technology (IT)
IT Services
Rendering Engines
Reporting and Analytics
Snowflake
Software Development
SQL
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
C