Remote Data Architect — Lakehouse & Geospatial Modeling

Irth Solutions, L.L.C.; United States; Hybrid; USD 120,000 - 180,000; Full time

Job summary

Irth Solutions, L.L.C. is seeking a mid-level Data Architect to design the unified data model powering an AI-driven threat and risk platform for pipeline asset integrity.

You will own data schema across asset, inspection, incident, GIS, and consequence data, enabling probabilistic risk models and cross-product analytics. In this hands-on role, you will establish data lineage, governance, and quality standards while partnering with data engineers to implement scalable pipelines and semantic

Qualifications

• 5–8 years in data architecture or senior data engineering with end-to-end data model ownership.
• Hands-on Databricks experience including Delta Lake and Unity Catalog.
• Strong medallion and lakehouse architecture, 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 CDC, SCD, schema evolution, and data-quality frameworks.
• Knowledge of RBAC, data governance, and encryption.

Responsibilities

• Design the schema and unified data model for the platform, spanning asset, inspection, incident, geospatial, and consequence data across products.
• Apply medallion architecture patterns and define the semantic layer consumed by downstream models, reporting, and applications.
• Model data required by probabilistic risk models with defined sources and data-quality expectations.
• Design cross-product entity resolution and ingestion patterns for batch, streaming, and CDC sources.
• Produce architecture documentation, diagrams, data dictionaries, and decision records.
• Collaborate with data engineers and application teams to implement the data model and governance.
• Support performance and cost optimization in storage and compute.

Skills

Advanced SQL

Python

PySpark

Data modeling

Data governance

Tools

Databricks

Delta Lake

Unity Catalog

SQL Warehouses

CDC / SCD

Job description

Irth Solutions, L.L.C. is seeking a mid-level Data Architect to design the unified data model powering an AI-driven threat and risk platform for pipeline asset integrity.

You will own data schema across asset, inspection, incident, GIS, and consequence data, enabling probabilistic risk models and cross-product analytics. In this hands-on role, you will establish data lineage, governance, and quality standards while partnering with data engineers to implement scalable pipelines and semantic