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

Staff Engineer, Query Optimization

MongoDB 1K-5K Internet Software & Services

MongoDB is hiring a senior engineer for its Server Query Optimization team to help build and evolve the core query lifecycle for a distributed document database.

AWS Azure C++ GCP MongoDB
3 days, 15 hours ago

Veeva Clinical Database Programmer

Celerion 251-1K Pharmaceuticals

Celerion is hiring a full-time remote Veeva Clinical Database Programmer to support clinical research by building, validating, and administering EDC databases for client study projects.

SQL
3 days, 16 hours ago

Data Governance Lead

AHEAD 1K-5K IT Services

AHEAD is seeking a hands-on Data Governance Lead to build and operate governance within its Data Platform Team, embedding controls across data products, pipelines, and platform services.

Kafka Snowflake
6 days, 16 hours ago

Data Governance Senior Advisor

Pathward 251-1K Diversified Financial Services

Pathward is hiring a Data Governance professional to define and maintain enterprise data policies, standards, and stewardship practices that improve data quality, compliance, and business alignment.

1 week 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