Pittsburgh Data Engineer: End-to-End ELT & Snowflake

A.C.Coy Company; Homestead (Allegheny County); On-site; USD 120,000 - 160,000; Full time

Job summary

A.C.Coy Company is hiring a Data Engineer to architect, build, and own data transformation end-to-end in a 100% onsite role in Pittsburgh, PA. You will lead the first data engineering effort, designing pipelines that unify data from seven sources and deliver dashboards for executives and operations.

You will implement ELT pipelines with Airbyte/Fivetran, create stable dbt models, and deploy FastAPI endpoints to feed a React-based UI.

Qualifications

• 7+ years’ of Data Engineering experience
• High ownership with leadership in defining data strategy
• Experience designing end-to-end data platforms and dashboards

Responsibilities

• Design, build and operate ELT pipelines from 7 sources into Snowflake Bronze nightly
• Build dbt staging models to standardise data into consistent schemas
• Establish data contracts for source domains with SLAs and freshness
• Design and maintain the internal operational database
• Develop FastAPI endpoints serving Snowflake gold data to internal apps
• Migrate data from legacy Azure SQL to Snowflake-native environment
• Own end-to-end dashboard layer from model design to production dashboards

Skills

Snowflake

dbt core

ELT

Python

Azure

Data Warehouse

Cloud

Education

Bachelor's Degree

Tools

Airbyte

Fivetran

FastAPI

Azure SQL Managed Instance

Job description

A.C.Coy Company is hiring a Data Engineer to architect, build, and own data transformation end-to-end in a 100% onsite role in Pittsburgh, PA. You will lead the first data engineering effort, designing pipelines that unify data from seven sources and deliver dashboards for executives and operations.

You will implement ELT pipelines with Airbyte/Fivetran, create stable dbt models, and deploy FastAPI endpoints to feed a React-based UI.