Senior Database Engineer

Irth Solutions

Senior Database Engineer driving the design and evolution of data management platform at Irth Solutions. Collaborating across teams to ensure data quality and scalability in pipeline integrity.

Posted 6/17/2026full-timeRemote • 🇺🇸 United StatesSeniorWebsite

Tech Stack

Tools & technologies

AzureCloudETLPythonSQL

About the role

Key responsibilities & impact

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.

Requirements

What you’ll need

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

Benefits

Comp & perks

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.

ATS Keywords

✓ Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

SQLMicrosoft Azure SQLSQL ServerDatabricksPythondata modelingschema designquery performance tuningstored proceduresETL

Soft Skills

analytical skillscommunication skillsself-directedproblem-solvingcollaborationcustomer engagementtechnical guidancecontinuous improvementadaptabilityremote work

Certifications

Bachelor's degree in Computer ScienceBachelor's degree in Engineering