[Remote] Senior Database Engineer

Note: The job is a remote job and is open to candidates in USA. Irth Solutions, a leading provider of enterprise-wide SaaS solutions, is seeking a Senior Database Engineer to drive the design and evolution of their data management platform. The role involves collaborating with various teams to shape database architecture and ensure data quality and performance across cloud and on-premise environments.ResponsibilitiesDesign 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 dataEstablish and enforce data standards, processes, and procedures across teams and productsDrive the evolution of the CIM Data Model to meet current and future customer requirementsImplement enhancements to the existing data management platform, supporting new features from design through QA sign-offWrite high-quality stored procedures, queries, and database migration scripts with a focus on performance and maintainabilityDiagnose and resolve database performance bottlenecks; partner with software engineers to address data-related issues and system design challengesAdopt and champion best practices in testing, data integrity validation, documentation, and agile developmentMaintain a reusable library of data model documents, templates, and technical guidesWork directly with customers and subject matter experts to understand existing pipeline integrity data systems, pain points, and integration requirementsAnalyze customer GIS and third-party systems to plan and execute integrations with the Irth Solutions platformPartner with product managers, business analysts, and customer account executives during onboarding and support cases involving customer dataProvide technical guidance to junior engineers and contribute to a culture of continuous improvementWork on technically challenging, industry-defining problems in pipeline safety and integrity managementRemote-first culture with a collaborative, innovative teamDirect impact - your work shapes a platform trusted by pipeline operators across North AmericaAn environment that values initiative, creativity, and continuous learningSkills5+ years of experience in database engineering, data architecture, or a closely related technical roleExpert-level proficiency in SQL and relational database systems - Microsoft Azure SQL and/or SQL Server strongly preferredDatabricks - experience with the Databricks Lakehouse platform for large-scale data engineering, Delta LakePython - scripting for data processing, automation, ETL pipelinesSignificant hands-on experience with pipeline integrity data including ILI, PODS, GIS platforms (APDM, UPDM), corrosion & CP databases, and field NDE dataDeep knowledge of data modelling, schema design, indexing strategies, and query performance tuningExperience with stored procedures, views, triggers, and database automationFamiliarity with pipeline integrity business processes and regulations (e.g., CFR 192 & 195, ASME B31.8S)Experience working in agile/scrum software development environmentsExcellent analytical and communication skills - able to translate complex data challenges into clear solutionsSelf-directed and comfortable working remotely; willingness to travel to customer sites as requiredClaude AI / Anthropic APIs - experience integrating large language models into data workflows, tooling, or internal applicationsAgentic AI - familiarity with building or working alongside AI agents for autonomous data analysis, anomaly detection, or decision support within engineering or integrity management contextsPower BI or SQL Server Reporting Services (SSRS) for building analytical dashboards and reportsExperience with cloud-native data services (Azure Data Factory, Synapse Analytics, or equivalent)Bachelor's degree in Computer Science, Engineering, or equivalent practical experienceBenefitsRemote-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.Company OverviewCompanies in the energy, gas utility, electric utility, municipality, contract locator, telecom and media industries have trusted Irth to enhance the resilience of their critical network infrastructure with our market-leading SaaS cloud-based technology for managing 811 tickets, land rights, and risk. It was founded in 1985, and is headquartered in Columbus, Ohio, USA, with a workforce of 51-200 employees. Its website is http://www.irthsolutions.com/.