> Markdown version of [/jobs/ext/2999346-data-engineer-onsite-in-pittsburgh-pa-candidates-must-live-in-pittsburgh](https://www.wearedevelopers.com/jobs/ext/2999346-data-engineer-onsite-in-pittsburgh-pa-candidates-must-live-in-pittsburgh). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md).

---

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

- **Company:** ACCAVALLO & COMPANY LLC
- **Location:** Pittsburgh, PA, United States
- **Experience:** Expert
- **Contract:** Permanent contract
- **Skills:** Application Programming Interfaces (APIs), Microsoft Azure, Cloud Computing, Cluster Analysis, Data Migration, Data Warehousing, Python (Programming Language), SQL Azure, Operational Databases, Power BI, Tableau (Software), Macros, Data Ingestion, ReactJS, Delivery Pipeline, Snowflake, Data Strategy, Fastapi, Data Lakes
- **Published:** September 19, 2026
- **Apply:** https://www.careerjet.com/job/us01c5c34fab3c5852bf86dc9174522ca7/eaa

## About the Role

Education: Degree required- if no degree, then 7+ years' of experience, * 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

## Description

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


## Related Videos

- [Watch Tests Go Brrrr! : Getting Started with Cypress in ReactJS](https://www.wearedevelopers.com/videos/282-watch-tests-go-brrrr-getting-started-with-cypress-in-reactjs)
- [Intro to FastAPI](https://www.wearedevelopers.com/videos/462-intro-to-fastapi)
- [Crafting Custom Frameworks with Rust: A Deep Dive into Procedural Macros](https://www.wearedevelopers.com/videos/849-crafting-custom-frameworks-with-rust-a-deep-dive-into-procedural-macros)
- [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works)
- [Building and Deploying Multi-Agent Systems with ADK and Vertex AI](https://www.wearedevelopers.com/videos/1918-building-and-deploying-multi-agent-systems-with-adk-and-vertex-ai)
- [Modern Data Architectures need Software Engineering](https://www.wearedevelopers.com/videos/1030-modern-data-architectures-need-software-engineering)

## Related Articles

- [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers)
- [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk)
- [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story)
- [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk)
- [Where To Find Software Engineering Jobs](https://www.wearedevelopers.com/magazine/396-where-to-find-software-engineering-jobs)
- [Fully Remote Software Engineer Jobs](https://www.wearedevelopers.com/magazine/447-fully-remote-software-engineer-jobs)