Pittsburgh Onsite Data Engineer: Snowflake & ELT Lead

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

Job summary

A.C.Coy Company in Pittsburgh, PA is seeking a Data Engineer to architect, build, and own this transformation end-to-end on site. You will design pipelines unifying data from seven source systems to Snowflake, develop dbt models, enforce data contracts, and deliver production dashboards used by executives and operations.

You will collaborate with the engineering team to migrate from Azure SQL Managed Instance to Snowflake-native environments and create FastAPI endpoints serving Gold data to

Qualifications

• Bachelor's degree or 7+ years of data engineering experience.
• 3–5 years of data engineering experience with Snowflake, dbt core, ELT.
• Hands-on Snowflake schema design, warehouse sizing, and time travel.
• Experience with Airbyte/Fivetran or similar for multi-source ingestion.
• Azure SQL Managed Instance, Storage, and DevOps pipelines.
• Strong Python for data sync jobs and FastAPI development.

Responsibilities

• Design, build and operate ELT ingestion pipelines from 7 sources into Snowflake Bronze nightly.
• Build and maintain dbt staging models (Silver) and standardise data schemas.
• Establish and enforce data contracts for source domains with agreed schemas and SLAs.
• Design and maintain the internal operational database.
• Build and maintain FastAPI endpoints serving Snowflake Gold data to internal apps.
• Migrate data from Azure SQL Managed Instance to Snowflake-native environments.
• Own end-to-end dashboard layer from Gold model design to production-grade dashboards.

Skills

Snowflake

dbt core

ELT pipelines

Data Warehouses

Azure/Cloud

Python

Education

Bachelor's degree

7+ years Data Eng experience

Job description

A.C.Coy Company in Pittsburgh, PA is seeking a Data Engineer to architect, build, and own this transformation end-to-end on site. You will design pipelines unifying data from seven source systems to Snowflake, develop dbt models, enforce data contracts, and deliver production dashboards used by executives and operations.

You will collaborate with the engineering team to migrate from Azure SQL Managed Instance to Snowflake-native environments and create FastAPI endpoints serving Gold data to