The Most Complete SaaS Platform for Damage Prevention, Asset Protection and Risk Management
Senior Database Engineer
Location
United States
Posted
4 days ago
Salary
0
Seniority
Senior
Job Description
Senior Database Engineer
Irth Solutions
• 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.
Job 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.
- 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
- 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.
Related Guides
Related Job Pages
More Backend Engineer Jobs
Senior Revit API Developer
StratusBuilt Around People. Driven by Outcomes. Designed for P&C Insurance.
• Design, build, and ship features across our Revit add-ins and Revit-integrated desktop applications that connect our customers' Autodesk design environment to the Stratus platform. • Use AI-assisted development tooling (Claude Code, Cursor, Copilot, etc.) as a first-class part of the dev loop — writing tests for AI-generated changes and exercising clear judgment about when AI output is ready to ship. • Write production C#/.NET code against the Revit API: custom commands, panels, external events, document and transaction management, and integration with Autodesk model data. • Own and improve the publishing add-in that exports data from Revit into the Stratus Core application — including data mapping, fidelity, validation, and the error handling that keeps exports trustworthy. • Interface with the Stratus open API and understand our data export pipeline — including how data flows through our Azure ServiceBus and other backend services — to build and troubleshoot the integrations that move data out of Revit. • Solve the hard problems of desktop add-in development — Revit version compatibility, performance inside large models, the API threading model, and graceful degradation when the host environment misbehaves. • Build and manage the deployment of these desktop applications — installers (MSIs), versioning, and update mechanisms across customer environments. • Investigate and fix customer-reported bugs across the desktop applications, including the failure modes specific to Revit add-ins. • Collaborate with product leadership, engineering teams, and customer-facing teams to scope, design, and ship — grounding technical decisions in real design and fabrication workflows. • Implement and maintain automated testing for the desktop applications, and advocate for incremental, reliable delivery. • Stay current on the Autodesk Revit API and the broader Autodesk Platform Services ecosystem, and bring that judgment to how we build.
• Will work in the Front Trade System for credit (FTS Credit) • Responsible for ensuring system stability while modernizing the technology • Will be responsible for support, maintenance, developing new features and migrating on-premises systems to AWS Cloud.
• Desenvolver e manter microsserviços em Java, seguindo boas práticas de arquitetura e design de software • Implementar e integrar soluções de mensageria (assíncrona e orientada a eventos) • Projetar e consumir APIs REST e eventos de domínio • Atuar na especificação técnica das soluções, contribuindo com definições arquiteturais • Implementar práticas de observabilidade (logs, métricas e tracing) • Identificar e corrigir problemas de performance, concorrência e escalabilidade • Trabalhar de forma colaborativa com times de produto, QA e infraestrutura • Apoiar tecnicamente desenvolvedores menos experientes • Garantir aderência a padrões de segurança, versionamento e governança de serviços
Senior Back-end Developer
Farmácias app | Delivery | By GrupoSCProporcionamos acesso rápido à saúde e beleza, conectando farmácias e pessoas.
• Build, develop and maintain complex systems • Provide technical guidance to the development team • Solve high-level technical challenges • Collaborate with other technical leaders to shape the company's technical strategy • Promote development best practices and technical innovation.



