Senior Data Architect: Data Pipelines & Cloud Platforms

Allegheny County - Department of Human Services; Pittsburgh (Allegheny County); On-site; USD 110,000 - 150,000; Full time

Job description

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:

• 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

Application

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