IT Data Architect

Greater Pittsburgh Community Food Bank•Duquesne, PA
•$80,100 - $97,700

About The Position

Greater Pittsburgh Community Food Bank is seeking an IT Data Architect to lead the design and evolution of its organizational data infrastructure, oversee ingestion of data domains, and collaborate with data analysts on analysis and visualization. This new role combines hands-on data engineering and architecture with stakeholder collaboration on strategic direction, operating practices, and emerging data governance efforts. The role will design schemas, build pipelines, model data, and extend the organization’s analytics platform in a cloud-based hybrid environment. It will work closely with the IT Infrastructure and Support Supervisor and Director of Applications, provide data architecture and engineering support to application projects, and mentor data analysts. The current environment is built on Azure and Microsoft tools; the architect will evaluate the evolving data product landscape, including Microsoft Fabric and other vendors, and recommend how the environment should develop. The successful candidate will guide data solutions from requirements gathering and source-data exploration through pipeline development, analytical modeling, and visualization. They will set technical direction, communicate complex concepts to technical and non-technical stakeholders, establish engineering standards, help define the data team’s operating model, and incorporate security, governance, and data quality into solutions.

Requirements

  • Bachelor’s or Master’s degree in Information Systems, Computer Science, or equivalent practical experience in a related area.
  • At least 3 years of hands-on data engineering experience in the Microsoft Azure or equivalent ecosystem, including 1 to 2 years in a senior or lead capacity.
  • Expert SQL skills, including performance tuning across large datasets.
  • Working proficiency in Python or Scala for transformation and orchestration work.
  • Excellent written and verbal communication skills.
  • Relevant expertise across the Azure data stack, including Azure Data Factory, Azure SQL, Azure DevOps, Logic Apps, Functions, and Key Vault.
  • Strong data modeling skills across dimensional, data vault, and lakehouse medallion patterns, and the ability to defend design choices to technical and non-technical audiences.
  • Experience designing semantic models and supporting BI delivery in Power BI, including DAX, row-level security, and large-dataset performance considerations.
  • A track record of working directly with senior business stakeholders, scoping work, facilitating discovery sessions, and managing timelines and priorities.
  • Experience gathering functional requirements and translating them into technical design.
  • Experience incorporating security considerations into designs and decisions.
  • Experience with the Microsoft 365 productivity suite, including Word, and ability to use and maintain Excel reports.

Nice To Haves

  • Production experience with Git-based source control, CI/CD pipelines such as GitHub Actions or Azure DevOps Pipelines, and infrastructure-as-code patterns.

Responsibilities

  • Partner with leaders and end users across the organization to understand data needs, challenges, and opportunities and shape appropriate, flexible, and sustainable solutions.
  • Communicate complex data concepts to peers and senior leadership to enable collaborative decision-making.
  • Translate business requirements into technical requirements and create artifacts such as entity relationship diagrams and process flows.
  • Design and implement data solutions in a cloud-based hybrid environment for the movement, storage, aggregation, visualization, and analysis of data from disparate sources.
  • Build and maintain data schemas, pipelines, models, and other foundational platform components alongside the data analyst team.
  • Extend and strengthen the existing Azure environment, including Azure Data Factory, SQL Server, Azure DevOps, Microsoft Purview, Power BI, and Microsoft Fabric tools and concepts.
  • Expand the technology footprint with appropriate Azure tools, potentially including Azure SQL, Azure Functions, Synapse Analytics, and Databricks.
  • Design data warehouse and lakehouse solutions grounded in business use cases and the Food Bank’s mission.
  • Establish data engineering standards for version control, testing, code review, naming, and documentation.
  • Develop data governance and security practices covering data quality, catalog maintenance, lineage, access controls, classification, and personally identifiable information handling.
  • Design for AI and analytics use cases, including exposing curated data to semantic models and downstream machine-learning workloads.
  • Monitor Microsoft’s data and AI roadmap and recommend where the organization should invest, hold, or evolve its environment.
  • Define the data team operating model, set expectations, and conduct technical reviews.
  • Provide data architecture and engineering support to the Director of Applications and application team members on appropriate projects.
  • Participate in change control to coordinate application changes safely with the data environment, and vice versa.
  • Incorporate security into database, pipeline, and infrastructure designs; promote data classification and sensitivity labeling in the organization and its analytic dashboards.
  • Work with the VP of IT, IT Infrastructure and Support Supervisor, and Director of Applications to improve the organization’s security posture.
  • Mentor a small team of dotted-line-report data analysts and, where appropriate, help them develop toward data engineering roles.
© 2026 Teal Labs, Inc
Privacy PolicyTerms of Service