Senior Database Engineer

This is a fully remote position, open to applicants in United States.

📋 Description

• Create and develop robust, scalable data models and database architectures to store and analyze pipeline integrity datasets, including ILI, PODS, GIS (APDM/UPDM), corrosion & CP data, and field NDE data.

• Set and uphold data standards, processes, and procedures across teams and products.

• Propel the advancement of the CIM Data Model to fulfill current and future customer needs.

• Implement improvements to the existing data management platform, supporting new features from design through to QA sign-off.

• Craft high-quality stored procedures, queries, and database migration scripts with an emphasis on performance and maintainability.

• Identify and resolve database performance bottlenecks; collaborate with software engineers to tackle data-related issues and system design challenges.

• Promote and advocate best practices in testing, data integrity validation, documentation, and agile development.

• Maintain a reusable repository of data model documents, templates, and technical guides.

• Engage directly with customers and subject matter experts to comprehend existing pipeline integrity data systems, challenges, and integration needs.

• Evaluate customer GIS and third-party systems to strategize and execute integrations with the Irth Solutions platform.

• Collaborate with product managers, business analysts, and customer account executives during onboarding and support cases involving customer data.

• Provide technical mentorship to junior engineers and foster a culture of continuous improvement.

⛳️ Requirements

• Over 5 years of experience in database engineering, data architecture, or a closely related technical field.

• Expert-level knowledge in SQL and relational database systems, particularly Microsoft Azure SQL and/or SQL Server.

• Experience with the Databricks Lakehouse platform for large-scale data engineering and Delta Lake.

• Proficient in Python for scripting related to data processing, automation, and ETL pipelines.

• Extensive hands-on experience with pipeline integrity data, including ILI, PODS, GIS platforms (APDM, UPDM), corrosion & CP databases, and field NDE data.

• Strong understanding of data modeling, schema design, indexing strategies, and query performance tuning.

• Experience with stored procedures, views, triggers, and database automation.

• Knowledge of pipeline integrity business processes and regulations (e.g., CFR 192 & 195, ASME B31.8S).

• Experience in agile/scrum software development environments.

• Exceptional analytical and communication skills - capable of translating complex data challenges into clear solutions.

• Self-motivated and comfortable working remotely; open to traveling to customer sites as needed.

• Experience with Claude AI / Anthropic APIs, integrating large language models into data workflows, tooling, or internal applications.

• Familiarity with Agentic AI, building or collaborating with AI agents for autonomous data analysis, anomaly detection, or decision support in engineering or integrity management contexts.

• Proficient with Power BI or SQL Server Reporting Services (SSRS) for creating analytical dashboards and reports.

• Experience with cloud-native data services such as Azure Data Factory, Synapse Analytics, or equivalent.

• Bachelor’s degree in Computer Science, Engineering, or equivalent practical experience.

🏝️ Benefits

• Engage with technically challenging, industry-defining issues in pipeline safety and integrity management.

• Enjoy a remote-first culture with a collaborative and innovative team environment.

• Make a direct impact - your contributions shape a platform relied upon by pipeline operators across North America.

• Thrive in an environment that encourages initiative, creativity, and ongoing learning.

• Receive competitive compensation commensurate with your experience.