Data Engineer Job at A.C.Coy Company, Homestead, PA

  • A.C.Coy Company
  • Homestead, PA

Job Description

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

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/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
  • Reporting - Tableau, PowerBI, or similar

Job Tags

Permanent employment, Full time, Live in, Immediate start, Relocation, Night shift

Similar Jobs

Victory Staffing

Event Planner Job at Victory Staffing

 ...Our recruiting agency is currently seeking a highly organized and creative Event Planner to join one of our esteemed clients. The ideal candidate will be responsible for coordinating, designing, and executing events that align with client goals, while ensuring smooth operations... 

Intersect Healthcare of Greenville

Food & Nutrition Aide Job at Intersect Healthcare of Greenville

 ...Job Description Job Description Job Title: Food and Nutrition Aide Michigans state-funded Senate Bill 690 (COVID-19) pay may be endingbut your earning power shouldnt. Join a team that values your dedication and is stepping up to help replace the missing... 

FedEx

Seasonal Package Handler - Part Time (Warehouse like) Job at FedEx

 ...reason. \n Additional Posting Information: Looking for Seasonal Package Handler - Part Time Early Morning, Afternoon, Evening and Overnight shifts.\n EEO Statement \n \n Federal Express Corporation is an Equal Opportunity Employer including, Vets/Disability.... 

Confluence Health

NUTRITION AMBASSADOR Job at Confluence Health

 ...software to submit meal orders, ensuring patient safety based upon therapeutic diet standards. # Utilizes knowledge of therapeutic nutrition to guide patients toward food items consistent with prescribed diet. # Assembles meal trays, ensuring accuracy, safety and... 

Mercy

CT Imaging Supervisor - Full Time - 9a-5p Job at Mercy

Find your calling at Mercy! Overview Supervises the daily operations of imaging procedures in the Hospital Imaging Services Department and Outpatient Center as well as the activities of personnel involved in providing these services. Under the supervision of the...