Data Engineer
3d Design Tools
Amazon Athena
Amazon Web Services
Analytics
Apache Airflow
AWS
Aws Data Warehouse
Aws Glue
Big Data
Bigdata
Business Intelligence
Cloud
Cloud Computing
Cloud Data Warehouse
Cloud Data Warehouse
Cloud Platform
Cloud Platforms
Data
Data Analysis
Data Analytics
Data Architecture
Data Build Tool
Data Engineer
Data Engineering
Data Integration
Data Lake
Data Management
Data Modeling
Data Operations
Data Pipeline
Data Pipelines
Data Platform
Data Processing
Data Warehouse
Data Warehousing
Database
Databases
Digital Marketing
ETL
Google Cloud Bigquery
Informatica
Information Technology (IT)
Integration
IT Services
Rendering Engines
Reporting and Analytics
Snowflake
Spark
SQL
Workflow Orchestration
Job Description
Wolfe, LLC is a Pittsburgh-based FinTech company using AI across its products and internal operations. The Data Engineer role strengthens this transition by building and maintaining governed data pipelines and data models within the Data Platform team.
Responsibilities
- Build and maintain ELT/ETL pipelines across lakehouse Bronze, Silver, and Gold layers so data arrives consistently and on schedule.
- Ingest and integrate enterprise and marketing data sources, including GA4, ad platforms, CRM, email, affiliate, and social, into governed, curated datasets.
- Create dimensional models and semantic data products following established platform patterns, enabling business teams to query data directly for self-service analytics.
- Implement automated data quality checks, monitoring, and observability across production pipelines, and troubleshoot pipeline failures and performance issues.
- Apply data governance requirements such as cataloging, lineage, tagging, and access controls in partnership with Data Stewards and senior Data Platform team members.
- Deliver clean, production-ready datasets that support AI/ML and Agentic AI workflows.
Required Qualifications
- 2 to 4 years of data engineering experience, including hands-on experience building and maintaining production pipelines.
- Strong SQL skills and working proficiency in Python and/or Spark.
- Experience building and orchestrating pipelines with Airflow, dbt, or comparable tooling.
- Experience with AWS data services (Glue, S3, Athena, IAM) and cloud data warehouses (Redshift, Snowflake, or BigQuery preferred).
- Knowledge of dimensional modeling and data governance concepts, including cataloging, lineage, and access control.
- Familiarity with AI/ML workflows, with exposure to Agentic AI concepts considered a plus.
Technologies
- ELT, ETL, SQL
- Python, Spark
- Airflow, dbt
- AWS Glue, S3, Athena, IAM
- Redshift, Snowflake, BigQuery
- Lakehouse
Impact Statement
- Onboard at least two existing data sources (for example, GA4 plus one ad platform or core operational system) onto governed pipelines, with documented lineage and data quality checks.
- With guidance from a senior engineer, deliver one new dimensional model or semantic data product used by Marketing or business stakeholders for self-service analytics.
- Stand up automated data quality monitoring on at least one production pipeline, including alerting for failures and anomalies.
Compensation and Benefits
Pay: $75,000.00 to $85,000.00 per year
- Restricted Stock Units (RSUs)
- Profit Share
- Medical, Prescription, Vision, and Dental insurance for employees and dependents (Wolfe pays 80% of premium)
- Short-Term Disability Insurance (Wolfe pays 100% of premium)
- Voluntary Long-Term Disability Insurance, Life Insurance, Critical Illness Insurance, Accident Insurance, and Hospital Indemnity coverage
- PTO (vacation and sick time)
- Corporate Holidays and Floating Holidays
- 401(k)
- Employee recognition program
- Charitable Donation to a charity of your choice yearly
- Employee Referral Bonus
- Tuition Reimbursement
- Internal Training and Information sessions
- Family Picnic, Holiday Party, and other outings
- Internal Culture Club
Location and Schedule
- Location: Pittsburgh, PA (onsite)
- Preferred commute area: Pittsburgh, PA 15220