Back to jobs

Data Architect (Mid-Level)

Pay
Pay not listedSimilar roles state $155K–$227K
Work setting
Remote — work setting source
Data Architect – Insights (AI/ML) Location: Remote (US) Department: Insights (AI/ML) Reports to: Engineering Manager About the Role
Read the full posting
Employment
Full-time — employment source
Employment type in the employer’s posting: Full-time
From the employer’s posting

What you’ll work on

Full posting

Irth is building a new AI-driven threat and risk management platform for pipeline asset integrity.

A governed, cross-product data platform built on Databricks and Azure

  • Design the unified data model and medallion (Bronze, Silver, Gold) layers across products

  • Model data for probabilistic risk models with defined sources and quality expectations

  • Design the shared GIS layer, including centerlines, consequence areas, and linear referencing

  • Set governance, lineage, and data-quality standards in Unity Catalog

  • Work with data engineers to build pipelines and review implementations for conformance

From the employer’s posting
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
Design the schema and unified data model for the platform
Model the data required by probabilistic risk models, ensuring every required input attribute has a defined source, transformation path, and data-quality expectation.
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.
Define cataloging, classification, and metadata standards in Unity Catalog and establish expectations for lineage coverage across the data estate.
Work directly with data engineers to translate architectural designs into production pipelines and review implementations for conformance.

What you’ll bring

All qualifications

Core experience

  • 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.
  • Practical experience with change data capture (CDC), slowly changing dimensions (SCD), schema evolution, and data-quality frameworks.

Preferred experience

  • Experience with at least one major cloud platform; Azure experience preferred.
  • Experience designing geospatial data models and working with GIS tooling, spatial joins, and linear referencing.
  • Familiarity with pipeline or utility asset data, including inline inspection results, alignment sheets, facilities, and centerline geometry.
  • Experience with multi-tenant platforms, data residency requirements, or regulated environments.
Qualification wording
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.
Practical experience with change data capture (CDC), slowly changing dimensions (SCD), schema evolution, and data-quality frameworks.
Experience with at least one major cloud platform; Azure experience preferred.
Experience designing geospatial data models and working with GIS tooling, spatial joins, and linear referencing.
Familiarity with pipeline or utility asset data, including inline inspection results, alignment sheets, facilities, and centerline geometry.
Experience with multi-tenant platforms, data residency requirements, or regulated environments.

Benefits in the posting

Full benefits wording
  • Comprehensive health plan options, including medical, dental, and vision coverage.
  • 401(k) plan with company match.
  • Flexible PTO policy plus company-paid holidays.
  • Additional benefits, including life insurance, pet insurance, and employee discounts and perks programs.
  • Generous one-time work-from-home stipend to help you set up your home workspace.

From the employer’s posting.

Apply at Irth Solutions

Posting record

Report an error
Status in our records
Live
First seen by us
Sep 18, 202665 days ago
Recorded sightings
43
Last seen by us
Nov 21, 2026
Employer says posted
Sep 9, 2026

These dates show when we found the posting. Check the employer’s website to confirm it is still accepting applications.

How this job compares

Pay

$155K–$227K is typical

The middle half of what similar US postings state. This one doesn’t list pay.

From 3,272 postings in the last year. Stated ranges, not salaries paid.

Time since we first saw it

Day 65

Up longer than most. Similar jobs usually come down between day 8 and day 57.

At Irth Solutions, jobs usually come down by about day 43.

From 9,995 similar postings that came down, and 8 of Irth Solutions’s. Coming down is not always a hire.

Irth Solutions is hiring

3 open jobs

Open jobs by the week we first saw them, last 12 weeks.

  • Hiring has slowed
  • Takes jobs down at a usual pace
Hiring record

See how this role fits your experience

Add your resume and we’ll mark which of these tools you already use, and point out anything in the posting that could rule you out.

  • Python
  • SQL
  • Azure
  • Databricks
  • Delta Lake
  • PySpark
Where the posting names them
- 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.
- 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.
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
- 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.
- 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.

Your next step

Complete your application on apply.workable.com. The employer’s form will show what is required.

Applying through Workable

  • No account needed. You can import your resume to fill in the form, or skip that and fill it in yourself.

Already applied? Track this application

Job description

View original posting ↗

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.
  • Define data structures for inspection data, repair history, and external enrichment sources such as weather history, soil characteristics, and satellite-derived data.

3. Governance, Lineage & Data Quality

  • Define cataloging, classification, and metadata standards in Unity Catalog and establish expectations for lineage coverage across the data estate.
  • Establish data-quality rules, validation gates, and profiling standards, including processes for quarantining and remediating failures.
  • Define access-control patterns, including role-based and attribute-based access, tenant isolation, and appropriate handling of sensitive data.
  • Design for end-to-end traceability so that any risk output can be traced through every transformation back to its source record.

4. Implementation Partnership

  • Work directly with data engineers to translate architectural designs into production pipelines and review implementations for conformance.
  • Contribute hands-on to schema deployment, transformation logic, and optimization when it accelerates delivery.
  • Partner with application engineers and data scientists to determine how the data model is consumed through serving layers, feature stores, and APIs.
  • Support performance and cost optimization, including partitioning, clustering, file layout, and compute sizing.

5. Collaboration & Documentation

  • Participate in design reviews and architecture alignment sessions and defend design decisions using data and evidence.
  • Work with subject-matter experts to translate domain and regulatory requirements into concrete data structures and standards.
  • Maintain architecture documentation as the model evolves, treating stale or inaccurate documentation as a defect.

Requirements

Required Qualifications

  • 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.

Preferred Qualifications

  • 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.

Nice to Have

  • 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.

Success Metrics

Success in this role will be measured by:

  • A documented and implemented data model that supports every required risk-model input attribute with a clearly defined source and transformation path.
  • High lineage coverage and demonstrable traceability from risk outputs back to the originating source records.
  • Data engineers consistently able to build from the architecture and documentation without repeated clarification.
  • Reliable cross-product entity resolution across shared assets and entities.

Benefits

What We Offer

  • Join a dynamic, growing company with a strong reputation in its industry.
  • Competitive salary.
  • Comprehensive health plan options, including medical, dental, and vision coverage.
  • 401(k) plan with company match.
  • Flexible PTO policy plus company-paid holidays.
  • Additional benefits, including life insurance, pet insurance, and employee discounts and perks programs.
  • Generous one-time work-from-home stipend to help you set up your home workspace.
  • Company events and opportunities to connect, including monthly team lunches, volunteer outings, and quarterly gatherings.
  • Hybrid employees have access to complimentary snacks, beverages, and coffee at our Columbus, Ohio office.

Demand for Data Leadership roles

New Data Leadership postings at the employers we follow are up 8% over the last 6 weeks compared with the 6 before.

Weekly new Data Leadership postings at the same employers, from the week of August 17 to the week of November 9. The fewest in a week was 751, the most 1,165, and the latest week had 775.
August 17Last week

Each bar is one week of new postings. The darkest bars are the last 6 weeks.

Counted from the hiring pages we’ve followed for at least five weeks, so employers we add don’t look like growth. Updated weekly.

About the role

We file this job under Data Leadership, by the work the posting describes.

Data leaders run data teams or design how a company's data fits together. Managers hire, set priorities and answer for whether the data work pays off; architects choose the systems and the shape of the data.

Expect years of hands-on data work, experience leading people or projects, and the ability to explain tradeoffs to executives.

Unlike a senior engineer or analyst, most of a data leader's week goes to people, planning and decisions rather than building.

US government figures for computer and information systems managers

Median yearly pay, May 2025
$175,140
Expected change, 2025 to 2035
15.8% more jobsagainst 3.5% for all jobs

The government has no code for data leaders, so these figures are for the closest group, computer and information systems managers, which includes data processing and data operations managers.

Source: US Bureau of Labor Statistics, Occupational Employment and Wage Statistics (May 2025) and Employment Projections (2025 to 2035). Occupation code 11-3021.

Source details

View original posting ↗

Source notes

Source excerpts

Selected passages from the saved posting. Check the full description for conditions and exceptions.

Pay

No pay amount identified in the saved description.

Location & working pattern

United States

Data Architect – Insights (AI/ML) Location: Remote (US) Department: Insights (AI/ML) Reports to: Engineering Manager About the Role
More source context
- Company events and opportunities to connect, including monthly team lunches, volunteer outings, and quarterly gatherings. - Hybrid employees have access to complimentary snacks, beverages, and coffee at our Columbus, Ohio office.
Work authorization

No clear work-authorization passage found. Eligibility is unconfirmed.

Find answers in the posting

AI
How answers work

AI selects complete passages from this posting. Check them for conditions and exceptions.

Uses this posting and your question. No profile needed.