Data Engineer- onsite in Pittsburgh, PA (CANDIDATES MUST LIVE IN PITTSBURGH)

Homestead, PA

Pay: Pay not listed
Work setting: Not stated
Employment: Full-time · Permanent — employment source
Location: Onsite in Pittsburgh, PA (CANDIDATES MUST LIVE IN PITTSBURGH) Job Type: Full Time/Permanent Work Authorization: No Sponsorship
Employment type in the employer’s listing: FULL_TIME
From the employer’s posting

Before you apply

Eligibility: Location: Onsite in Pittsburgh, PA (CANDIDATES MUST LIVE IN PITTSBURGH) — eligibility source
Location: Onsite in Pittsburgh, PA (CANDIDATES MUST LIVE IN PITTSBURGH)
Read the full posting
Sponsorship: Visa sponsorship not confirmed — sponsorship source
Work Authorization: No Sponsorship
Read the full posting

Apply at A.C. Coy

What you’ll work on

Full posting

Build and operate nightly ELT ingestion from 7 operational sources into Snowflake
Build dbt staging models that clean, deduplicate and standardise source data
Establish data contracts covering schemas, null rates, value ranges and freshness
Build FastAPI endpoints that serve Gold data to the internal React application
Own dashboards from Gold model design through to production reporting

From the employer’s posting

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

Build and maintain FastAPI endpoints that serve Snowflake Gold data to our internal React application

Own the end-to-end dashboard layer: from Gold model design through to published, production-grade dashboards consumed by executive and operational stakeholders

What you’ll bring

All qualifications

Core experience

3- 5 years of experience as a Data Engineer with the following:
Experience configuring and operating Airbyte / Fivetran or similar (or equivalent) for multi-source ingestion
Practical experience with Azure SQL Managed Instance, Storage, and DevOps pipelines
Strong Python for Data Sync Jobs, API clients, and FastAPI development

Qualification wording

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

Experience configuring and operating Airbyte / Fivetran or similar (or equivalent) for multi-source ingestion

Practical experience with Azure SQL Managed Instance, Storage, and DevOps pipelines

Strong Python for Data Sync Jobs, API clients, and FastAPI development

Tools in this posting

Python
SQL
Airbyte
Azure
dbt
Fivetran
Power BI
Snowflake
Tableau
FastAPI

Source

- Practical experience with Azure SQL Managed Instance, Storage, and DevOps pipelines - Python - Strong Python for Data Sync Jobs, API clients, and FastAPI development

- Python - Strong Python for Data Sync Jobs, API clients, and FastAPI development - Reporting- Tableau or PowerBI

- 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

- Azure/Cloud - Practical experience with Azure SQL Managed Instance, Storage, and DevOps pipelines - Python

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

- ELT - Experience configuring and operating Airbyte / Fivetran or similar (or equivalent) for multi-source ingestion - Data Warehouse/Data Lakes

- Data Warehouse/Data Lakes - Azure/Cloud - Practical experience with Azure SQL Managed Instance, Storage, and DevOps pipelines

- 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

- 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.

- Strong Python for Data Sync Jobs, API clients, and FastAPI development - Reporting- Tableau or PowerBI

- 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

- 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.

Posting record

Report an error

Status in our records: Live
First seen by us: Aug 21, 2026 · 65 days ago
Recorded sightings: 45
Last seen by us: Oct 25, 2026

These dates show when we found the listing. Check the employer’s website to confirm it is still accepting applications.

Your next step

Have your resume and examples of relevant work ready.
Check the listed location, eligibility and core experience before starting.
Ask the employer about the pay range before committing time to the process.

Complete your application on careers-accoy.icims.com. The employer’s form will show what is required.

Already applied? Track this application

Job description

View original posting ↗

Overview

Location: Onsite in Pittsburgh, PA (CANDIDATES MUST LIVE IN PITTSBURGH)

Job Type: Full Time/Permanent

Work Authorization: No Sponsorship

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

Qualifications

Education: Degree required- if no degree, then 7+ years’ of experience

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
- Reporting- Tableau or PowerBI

Source details

View original posting ↗

Source notes

Source excerpts

Selected passages from the saved posting. Check the full description for conditions and exceptions.

Pay: No pay amount identified in the saved description.
Location & working pattern: Homestead, PA
Overview Location: Onsite in Pittsburgh, PA (CANDIDATES MUST LIVE IN PITTSBURGH) Job Type: Full Time/Permanent
Work authorization: Job Type: Full Time/Permanent Work Authorization: No Sponsorship 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.

Open source at careers-accoy.icims.com ↗Read the full description ↓

See how this role fits your experience

Add your resume to compare the role’s scope, tools and requirements with your experience.

Upload resume Add LinkedIn