Irth

Irth

Irth Solutions is a leading provider of SaaS cloud-based asset protection solutions that focus on damage prevention, risk analysis, and network infrastructure resilience. With nearly three decades of experience, Irth Solutions offers a wide range of fe...

Diversified Telecommunication Services
51-250
Founded 1985

Description

  • Design and develop scalable data models and database architectures for pipeline integrity datasets.
  • Establish and enforce data standards, processes, and procedures across teams and products.
  • Drive the evolution of the CIM Data Model to meet current and future customer requirements.
  • Implement enhancements to the data management platform from design through QA sign-off.
  • Write stored procedures, queries, and database migration scripts with a focus on performance and maintainability.
  • Diagnose and resolve database performance bottlenecks and other data-related system issues.
  • Partner with software engineers, product managers, business analysts, QA, and customer-facing teams on data and integration needs.
  • Work directly with customers and subject matter experts to understand existing systems, pain points, and integration requirements.
  • Analyze customer GIS and third-party systems and plan integrations with the Irth Solutions platform.
  • Provide technical guidance to junior engineers and contribute to continuous improvement.

Requirements

  • 5+ years of experience in database engineering, data architecture, or a closely related technical role.
  • Expert-level proficiency in SQL and relational database systems, with Microsoft Azure SQL and/or SQL Server strongly preferred.
  • Experience with Databricks Lakehouse platform and Delta Lake for large-scale data engineering.
  • Experience with Python for scripting, data processing, automation, and ETL pipelines.
  • Significant hands-on experience with pipeline integrity data, including ILI, PODS, GIS platforms (APDM, UPDM), corrosion & CP databases, and field NDE data.
  • Deep knowledge of data modeling, schema design, indexing strategies, and query performance tuning.
  • Experience with stored procedures, views, triggers, and database automation.
  • Familiarity with pipeline integrity business processes and regulations such as CFR 192 & 195 and ASME B31.8S.
  • Experience working in agile/scrum software development environments.
  • Excellent analytical and communication skills with the ability to translate complex data challenges into clear solutions.
  • Self-directed and comfortable working remotely, with willingness to travel to customer sites as required.
  • Preferred: experience integrating Claude AI / Anthropic APIs into data workflows, tooling, or internal applications.
  • Preferred: familiarity with agentic AI for autonomous data analysis, anomaly detection, or decision support.
  • Preferred: experience with Power BI or SSRS for dashboards and reports.
  • Preferred: experience with cloud-native data services such as Azure Data Factory or Synapse Analytics.
  • Bachelor's degree in Computer Science, Engineering, or equivalent practical experience.

Benefits

  • Competitive compensation commensurate with experience.
  • Remote-first culture with a collaborative, innovative team.
  • Opportunity to work on technically challenging, industry-defining problems in pipeline safety and integrity management.
  • Direct impact on a platform trusted by pipeline operators across North America.
  • An environment that values initiative, creativity, and continuous learning.

Interested in this position?

Apply directly on the company website

Apply Now

Similar Roles

Data Migration Engineer (SQL Server / TSQL)

Cresteo 51-200 information technology & services

Cresteo is hiring a Data Migration Engineer to own end-to-end SQL Server data migrations from legacy schemas into reconciled, production-ready data for US-based clients and international teams.

JSON SQL Server
14 hours, 29 minutes ago

Senior Software Engineer - Storage Engine - Elasticsearch

Elastic 1K-5K Internet Software & Services

Elastic is seeking a Senior Software Engineer for the globally distributed Elasticsearch Storage Engine team to improve core storage and query technologies for observability workloads.

CI/CD Elasticsearch GitHub Java MongoDB PostgreSQL Prometheus Solr
1 day, 13 hours ago

Senior Software Developer - Storage Engine - Elasticsearch

Elastic 1K-5K Internet Software & Services

Elastic is hiring a Senior Software Engineer for its globally distributed Elasticsearch Storage Engine team to improve core storage and query technologies for observability workloads.

CI/CD Elasticsearch GitHub Java MongoDB PostgreSQL Prometheus Solr
1 day, 13 hours ago

Principal Software Developer - Storage Engine - Elasticsearch

Elastic 1K-5K Internet Software & Services

Elastic is hiring a Principal Software Developer for its globally distributed Elasticsearch Storage Engine team to shape the core storage and query engine for observability workloads.

CI/CD Elasticsearch GitHub Java MongoDB PostgreSQL Prometheus Solr
1 day, 14 hours ago

You're on a roll! Sign up now to keep applying.

Sign Up

Already have an account? Log in

Used by 14,729+ remote workers