Lead Data Architect

Posted by Rachel Silver

Company Details

Allegheny County Department of Human Services

Pittsburgh, PA

FTE only



We are embarking on an exciting journey to establish an internal development team at DHS, aimed at crafting innovative customer experiences to support our diverse range of services and programs. Your pivotal role as an inaugural backend developer will involve architecting a robust data pipeline that seamlessly integrates our provider and consumer-facing applications with our transactional and analytical data warehouses.

Previously, we heavily relied on a large contingent of third-party contractors for application development and maintenance. In this position, you’ll collaborate closely with these contractors to integrate new applications with our data stores and design resilient, production-grade data pipelines. As our internal development team expands, we’ll gradually transition towards developing more solutions in-house.

Key responsibilities:

  • Design and implement a data layer to support a diverse suite of applications in a microservices architecture
  • Collaborate effectively with DBAs, developers, product managers, and data scientists to simplify complex data problems and prioritize impact over technical sophistication.
  • Skillfully communicate with diverse audiences, regardless of their technical expertise, to understand the context behind data requirements and articulate solutions.
  • Take the lead in upholding best practices for service-oriented architecture, establishing rigorous standards for quality and fostering a culture of modularity and reusability.

The Ideal Candidate:

  • Has over 5 years of experience in data engineering including hands-on experience in constructing production data pipelines using a common backend language (preferably Python).
  • Demonstrates a comprehensive understanding of data modeling, database design, data governance, data architecture principles, and data operations.
  • Is proficient in integrating with or extending RESTful APIs to facilitate essential data flows across various applications.
  • Demonstrates excellent knowledge of modern-day cloud-native platforms like Kubernetes, AWS, or Azure, coupled with a strong understanding of the full Software Development Life Cycle (SDLC).
  • Displays expertise in data warehousing and modeling, with practical knowledge of Oracle Data Warehouse and other relational databases such as PostgreSQL and MSSQL.
  • Holds some familiarity with the .NET Framework and WCF Services


Resume and/or LinkedIn profile. Github repository link, if available.

“DHS strives to be the kind of place where a diverse mix of talented people want to come to grow and do their best work.”

-From the organization’s statement on Equity and Inclusion


How to Apply

Please log in or sign up to view this posting's application instructions.