Lead Data Architect

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

Job summary

You should have 5+ years in data engineering, strong data modeling and governance knowledge, and hands-on experience with Python, RESTful APIs, cloud platforms, and various data warehouses such as Oracle Data Warehouse, PostgreSQL, and MSSQL. Familiarity with .NET and WCF is noted.

Qualifications

• Has 5+ years of experience in data engineering, including building production data pipelines.
• Strong understanding of data modeling, governance, architecture principles, and data operations.
• Experience integrating data flows with RESTful APIs and cloud-native platforms.

Responsibilities

• Collaborate with DBAs, developers, product managers, and data scientists to simplify complex data problems.
• Communicate clearly with non-technical stakeholders to understand data requirements and solutions.
• Lead the adoption of best practices for service-oriented architecture and modular, reusable code.

Skills

Data engineering

Python

RESTful APIs

Data modeling

SDLC

Data warehousing concepts

Tools

Oracle Data Warehouse

PostgreSQL

MS SQL Server

.NET Framework

WCF Services

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.