Data Engineer
A.C.Coy Company · Homestead, Pennsylvania, United States
FULL TIMEpermanent
Job Description
APPLICANTS MUST LIVE IN THE PITTSBURGH, PA AREA CURRENTLY, NO RELOCATION.
If you are considering sending an application, make sure to hit the apply button below after reading through the entire description.
No 3rd Parties/Sub Vendors
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/PermanentWork 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 systemsDesign, 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 scheduleBuild and maintain dbt staging models (Silver layer) that clean, deduplicate, and standardise data from all 7 sources into consistent schemasEstablish and enforce data contracts for each source domain — agreed schemas, null rates, acceptable value ranges, and freshness SLAsDesign and maintain the internal operational databaseBuild and maintain FastAPI endpoints that serve Snowflake Gold data to our internal React application — customer views, pipeline dashboards, inventory risk, margin reportsCollaborate with the engineering team to decouple legacy Azure SQL Managed Instance dependencies and migrate data to the new Snowflake-native environmentOwn 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. xzbcwsv 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 ingestionData Warehouse/Data LakesAzure/Cloud - Practical experience with Azure SQL Managed Instance, Storage, and DevOps pipelinesPython - Strong Python for Data Sync Jobs, API clients, and FastAPI developmentReporting- Tableau, PowerBI, or similar
If you are considering sending an application, make sure to hit the apply button below after reading through the entire description.
No 3rd Parties/Sub Vendors
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/PermanentWork 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 systemsDesign, 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 scheduleBuild and maintain dbt staging models (Silver layer) that clean, deduplicate, and standardise data from all 7 sources into consistent schemasEstablish and enforce data contracts for each source domain — agreed schemas, null rates, acceptable value ranges, and freshness SLAsDesign and maintain the internal operational databaseBuild and maintain FastAPI endpoints that serve Snowflake Gold data to our internal React application — customer views, pipeline dashboards, inventory risk, margin reportsCollaborate with the engineering team to decouple legacy Azure SQL Managed Instance dependencies and migrate data to the new Snowflake-native environmentOwn 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. xzbcwsv 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 ingestionData Warehouse/Data LakesAzure/Cloud - Practical experience with Azure SQL Managed Instance, Storage, and DevOps pipelinesPython - Strong Python for Data Sync Jobs, API clients, and FastAPI developmentReporting- Tableau, PowerBI, or similar
Details
| Company | A.C.Coy Company |
| Location | Homestead, Pennsylvania, United States |
| Type | FULL TIME |
| Niche | tech |
| Experience | permanent |