Irth Solutions

Irth Solutions

Senior Database Engineer

Canada · Senior

Sponsorship not specifiedDetected 21 days ago
PythonSQLDatabricksAzureData AnalysisData EngineeringData ScienceData VisualizationLLMsAgentic AIAgileCustomer SuccessGISCommunicationCollaborationPipeline Integrity

About the role

  • About Irth Solutions Irth Solutions, a TPG portfolio company headquartered in Columbus, Ohio, is the leading provider of enterprise-wide SaaS solutions for critical network infrastructure. Serving the electric, energy, telecommunications, media, and pipeline industries for over 25 years, Irth blends geospatial data, business intelligence, and AI to deliver
  • 360-degree situational awareness across damage prevention, asset integrity, and land management. Our platform - trusted by Fortune 500 utilities, pipeline operators, and telecom providers - helps customers manage 811 tickets, pipeline integrity data, land rights, and risk, enabling them to improve resilience, reduce risk, and stay ahead of compliance

Responsibilities

  • Database Architecture & Design Design and develop robust, scalable data models and database architectures to house and analyze pipeline integrity datasets, including ILI, PODS, GIS (APDM/UPDM), corrosion & CP data, and field NDE data.
  • Drive the evolution of the CIM Data Model to meet current and future customer requirements.
  • Development & Engineering Excellence Implement enhancements to the existing data management platform, supporting new features from design through QA sign-off.
  • Diagnose and resolve database performance bottlenecks; partner with software engineers to address data-related issues and system design challenges.
  • Maintain a reusable library of data model documents, templates, and technical guides.
  • Partner with product managers, business analysts, and customer account executives during onboarding and support cases involving customer data.
  • Deep knowledge of data modelling, schema design, indexing strategies, and query performance tuning.
  • Agentic AI - familiarity with building or working alongside AI agents for autonomous data analysis, anomaly detection, or decision support within engineering or integrity management contexts.
  • Power BI or SQL Server Reporting Services (SSRS) for building analytical dashboards and reports.

Requirements

  • Databricks. experience with the Databricks Lakehouse platform for large-scale data engineering, Delta Lake.
  • Significant hands-on experience with pipeline integrity data including ILI, PODS, GIS platforms (APDM, UPDM), corrosion & CP databases, and field NDE data.
  • Experience with stored procedures, views, triggers, and database automation.
  • willingness to travel to customer sites as required.
  • Experience with cloud-native data services (Azure Data Factory, Synapse Analytics, or equivalent).
  • Bachelor's degree in Computer Science, Engineering, or equivalent practical experience.

Nice to have

  • About Irth Solutions Irth Solutions, a TPG portfolio company headquartered in Columbus, Ohio, is the leading provider of enterprise-wide SaaS solutions for critical network infrastructure.
  • Working closely with the Director of Engineering, solution architects, software engineers, and customer-facing teams, you will shape the database architecture that underpins the AIP/CIM Data Model.
  • Establish and enforce data standards, processes, and procedures across teams and products.
  • Write high-quality stored procedures, queries, and database migration scripts with a focus on performance and maintainability.
  • Diagnose and resolve database performance bottlenecks
  • Adopt and champion best practices in testing, data integrity validation, documentation, and agile development.
  • Analyze customer GIS and third-party systems to plan and execute integrations with the Irth Solutions platform.
  • Provide technical guidance to junior engineers and contribute to a culture of continuous improvement.

Company info

  • Collaboration & Customer Engagement Work directly with customers and subject matter experts to understand existing pipeline integrity data systems, pain points, and integration requirements.

This listing is sourced directly from Irth Solutions's careers page and normalized into a canonical job model.