Job Opportunities API

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 requirements.  AI Use in Hiring As part of our hiring process, this role may use artificial intelligence or automated tools to assist in reviewing and screening applications. These tools support, but do not replace, human judgment in hiring decisions. Role Type This is a backfill position. Compensation The salary range for this role is CAD $128-178k. This range reflects the base salary only and does not include any other compensation components. Any offers made are dependent on factors including and not limited to experience, skills, and location. Role Overview  The Senior Database Engineer is a key technical individual contributor who drives the design, development, and evolution of our data management platform. 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. You will champion data quality, performance, and scalability across cloud and on-premise environments - and bring deep expertise in pipeline integrity data to help Irth Solutions deliver unparalleled value to its customers.  Reporting Structure  The Senior Database Engineer will report directly to the Director of Engineering and will collaborate cross-functionally with development, QA, business intelligence, data science, and customer success teams.  Key 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.  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.  Development & Engineering Excellence  Implement enhancements to the existing data management platform, supporting new features from design through QA sign-off.  Write high-quality stored procedures, queries, and database migration scripts with a focus on performance and maintainability.  Diagnose and resolve database performance bottlenecks; partner with software engineers to address data-related issues and system design challenges.  Adopt and champion best practices in testing, data integrity validation, documentation, and agile development.  Maintain a reusable library of data model documents, templates, and technical guides.  Collaboration & Customer Engagement  Work directly with customers and subject matter experts to understand existing pipeline integrity data systems, pain points, and integration requirements.  Analyze customer GIS and third-party systems to plan and execute integrations with the Irth Solutions platform.  Partner with product managers, business analysts, and customer account executives during onboarding and support cases involving customer data.  Provide technical guidance to junior engineers and contribute to a culture of continuous improvement.  &nb