Senior Database Engineer

Irth Solutions

5d • Remote

About The Position

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.

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 - Microsoft Azure SQL and/or SQL Server strongly preferred.
• Databricks - experience with the Databricks Lakehouse platform for large-scale data engineering, Delta Lake.
• Python - scripting for data processing, automation, 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 modelling, 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 (e.g., CFR 192 & 195, ASME B31.8S).
• Experience working in agile/scrum software development environments.
• Excellent analytical and communication skills - able to translate complex data challenges into clear solutions.
• Self-directed and comfortable working remotely; willingness to travel to customer sites as required.

Nice To Haves

• Claude AI / Anthropic APIs - experience integrating large language models into data workflows, tooling, or internal applications.
• 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.
• Experience with cloud-native data services (Azure Data Factory, Synapse Analytics, or equivalent).
• Bachelor's degree in Computer Science, Engineering, or equivalent practical experience.

Responsibilities

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

Benefits

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

What This Job Offers

• Job Type: Full-time
• Career Level: Senior
• Education Level: Associate degree