Data Engineer

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

Job summary

A.C.Coy Company in Pittsburgh, PA is seeking a Data Engineer to architect and own the transformation end-to-end for a 7-source data integration project.

You will build ELT pipelines with Airbyte or Fivetran, create dbt models, enforce data contracts, and deliver Snowflake-based dashboards via FastAPI and internal React apps. This role requires 7+ years of data engineering, a Bachelor's degree, and strong Python/Azure experience; onsite in Pittsburgh with no relocation.

Qualifications

• Bachelor's degree or 7+ years of data engineering experience.
• Deep hands-on Snowflake schema design, warehouse sizing and cost management.
• Experience with Airbyte or Fivetran for multi-source ingestion.

Responsibilities

• Architect and own end-to-end data transformation initiatives.
• Design, build and operate ELT pipelines for 7 sources nightly.
• Build dbt staging models to clean and standardise data across sources.
• Establish data contracts with defined schemas, null rates, SLAs.
• Build and maintain internal operational database and dashboards.
• Collaborate to migrate from Azure SQL to Snowflake-native environment.

Skills

Problem solving

Attention to detail

Education

Bachelor's Degree

Tools

Snowflake

dbt core

Airbyte/Fivetran

Data Warehouse/Data Lakes

Azure/Cloud

Python

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