Data Architect (Mid-Level)
- Compensation
- Not disclosed
- Location
- United States
- Work setup
- Remote
- Seniority
- Middle
- Employment
- Not specified
- Experience
- 5+ years
- Category
- Architecture
- Posted
Skills
Must have
- 5–8 years of experience in data architecture, data modeling, or senior data engineering, including end-to-end ownership of a non-trivial data model.
- Hands-on experience with Databricks, including Delta Lake, Unity Catalog, SQL Warehouses, and pipeline orchestration.
- Strong command of medallion and lakehouse architecture patterns, dimensional modeling, and semantic layer design.
- Advanced SQL skills and proficiency in Python or PySpark.
- Experience with at least one major cloud platform; Azure experience preferred.
- Practical experience with change data capture (CDC), slowly changing dimensions (SCD), schema evolution, and data-quality frameworks.
- Working knowledge of data governance, including cataloging, lineage, classification, role-based access control (RBAC), and encryption.
- Strong documentation and diagramming skills, with the ability to explain data models clearly to both technical and non-technical stakeholders.
Nice to have
- Experience designing geospatial data models and working with GIS tooling, spatial joins, and linear referencing.
- Experience with multi-tenant platforms, data residency requirements, or regulated environments.
- Familiarity with metadata and lineage tools such as Unity Catalog, Microsoft Purview, or equivalent platforms.
- Experience modeling data specifically for machine learning or probabilistic risk models.
- Experience designing semantic layers for business intelligence (BI) consumption.
- Databricks or cloud data certifications.
- Experience using AI-assisted coding tools such as Cursor or GitHub Copilot and/or agentic coding tools such as Claude Code as part of a professional development workflow.
- Familiarity with pipeline or utility asset data, including inline inspection results, alignment sheets, facilities, and centerline geometry.
- Understanding of asset integrity concepts such as corrosion growth, defect tracking, and consequence-of-failure modeling.
- Awareness of regulatory reporting requirements applicable to pipeline integrity data.
- Experience migrating data from legacy desktop or spreadsheet-based systems.
Full description
Data Architect – Insights (AI/ML)
Location: Remote (US)
Department: Insights (AI/ML)
Reports to: Engineering Manager
About the Role
Irth is building a new AI-driven threat and risk management platform for pipeline asset integrity. The platform brings together three capabilities that have historically been separate at Irth:
- A governed, cross-product data platform built on Databricks and Azure
- An AI-powered ingestion layer that normalizes, repairs, and enriches customer data without services-heavy onboarding
- A reusable analytical layer that runs industry-standard, Irth-developed, and customer-built risk models against the data
We are seeking a mid-level Data Architect to design the schema and data model that powers this platform. You will create a unified structure spanning asset integrity, damage prevention, and land and stakeholder management, capable of supporting probabilistic risk models that require dozens of precisely defined input attributes per pipeline segment.
This is a hands-on design role. You will establish standards for data lineage, governance, and quality while working closely with the data engineering team to implement them. This role is ideal for someone with substantial experience in lakehouse and medallion architecture who is ready to own the data model for a platform rather than a single project.
Key Responsibilities
1. Data Modeling & Architecture
- Design the schema and unified data model for the platform, spanning asset, inspection, incident, geospatial, and consequence data across multiple products.
- Apply medallion architecture patterns (Bronze, Silver, Gold) and define the semantic layer consumed by downstream models, reporting, and applications.
- Model the data required by probabilistic risk models, ensuring every required input attribute has a defined source, transformation path, and data-quality expectation.
- Design cross-product entity resolution so records from separate products reconcile to shared assets and entities.
- Define ingestion patterns for batch, streaming, and change-data-capture (CDC) sources, including schema evolution and slowly changing dimensions.
- Produce architecture documentation, diagrams, data dictionaries, and decision records that engineers can implement without ambiguity.
2. Geospatial & Domain Data Design
- Design the shared GIS layer as a first-class component of the data model, including pipeline centerlines, consequence-area polygons, right-of-way corridors, and parcel data.
- Model linear referencing and dynamic segmentation so risk results align with centerline geometry and can be aggregated across differing segmentations.