Data Engineer

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

APPLICANTS MUST LIVE IN THE PITTSBURGH, PA AREA CURRENTLY, NO RELOCATION.

Location

100% Onsite in Pittsburgh, PA (Fridays can be 4 hours days every week OR 8 hour days every other week.)

Job Type

Full Time/Permanent

Work Authorization

U.S. Citizens or Green Card Holders Only

Overview

The A.C.Coy Company has an immediate need for a Data Engineer. In this role, you will architect, build, and own this transformation end-to-end.

Responsibilities

You will be the founding data engineer on this initiative. You will design and implement pipelines that unify data from 7 operational source systems

• Design, build and operate reliable ELT ingestion pipelines using Airbyte / Fivetran or similar to pull data from all 7 operational sources into Snowflake Bronze on a nightly schedule
• Build and maintain dbt staging models (Silver layer) that clean, deduplicate, and standardise data from all 7 sources into consistent schemas
• Establish and enforce data contracts for each source domain — agreed schemas, null rates, acceptable value ranges, and freshness SLAs
• Design and maintain the internal operational database
• Build and maintain FastAPI endpoints that serve Snowflake Gold data to our internal React application — customer views, pipeline dashboards, inventory risk, margin reports
• Collaborate with the engineering team to decouple legacy Azure SQL Managed Instance dependencies and migrate data to the new Snowflake-native environment
• Own the end-to-end dashboard layer: from Gold model design through to published, production-grade dashboards consumed by executive and operational stakeholders

Education

Bachelor's Degree or a minimum of 7+ years’ of Data Engineering experience

Qualifications

This is a high-ownership, high-impact role. You will work directly with engineering and business leadership to define the data strategy, not just execute tasks.

3- 5 years of experience as a Data Engineer with the following:

• Snowflake - Deep hands-on experience with schema design, warehouse sizing, clustering, time travel, and cost management.
• dbt core - Production experience with modular models, macros, packages, and incremental materialization.
• ELT - Experience configuring and operating Airbyte / Fivetran or similar (or equivalent) for multi-source ingestion
• Data Warehouse/Data Lakes
• Azure/Cloud - Practical experience with Azure SQL Managed Instance, Storage, and DevOps pipelines
• Python - Strong Python for Data Sync Jobs, API clients, and FastAPI development