Back to jobs

Senior Software Engineer, Database Engineer

North America · United States · United States

Live, first seen by us 59 days ago
Pay
$200,000–220,000/year · BaseAnnual period assumed — pay source
Individual pay is determined by skills, qualifications, experience, and location. The compensation details listed in this posting reflect the US base salary only. The estimated base salary range for this role is $200,000 - $220,000 Additionally, this role may be eligible to participate in TRM’s equity plan.
Read the full posting
Work setting
Remote — work setting source
Location type: Remote
From the employer’s posting
Employment
Full-time — employment source
Employment type: Full-time
From the employer’s posting
Team
R&D › Engineering › Software Engineering — team source
Department: R&D › Engineering › Software Engineering
From the employer’s posting

What you’ll work on

Full posting
  • Tune query performance, index design and schemas on petabyte-scale Postgres/Citus

  • Find and ship storage and compute cost cuts using AI-assisted analysis

  • Build agentic automation for routine database operations like pgbouncer provisioning and disk scaling

  • Manage CDC pipelines (PeerDB, Fivetran, Debezium) and debug replication failures

  • Migrate workloads off first-gen infrastructure and prototype new data stores

From the employer’s posting
owning query tuning, index design, and schema optimization on petabyte-scale Postgres/Citus
Cut storage and compute costs materially by using AI-assisted analysis
building agentic automation for routine database operations, such as self-serve pgbouncer provisioning, disk scaling, and blue-green deployments
Keep real-time data flowing by managing CDC pipelines (PeerDB, Fivetran, Debezium)
migrating workloads off first-gen infrastructure and prototyping new data stores with AI-accelerated spikes

Before you apply

Employer’s visa record
5 H-1B petitions approved in fiscal 2024 and 2025For the employer as a whole. This posting doesn’t say whether the role is sponsored. US Citizenship and Immigration Services.
Sponsorship
Visa sponsorship not confirmed — sponsorship source
Will you now or in the future require visa sponsorship?
From the employer’s application form
Apply at TRM Labs

Posting record

Report an error
Status in our records
Live
First seen by us
Sep 23, 202659 days ago
Recorded sightings
114
Last seen by us
Nov 22, 2026

These dates show when we found the posting. Check the employer’s website to confirm it is still accepting applications.

How this job compares

Pay

Higher than most similar jobs

$200K–$220K against $127K–$189K, the middle half of what similar US postings state.

From 2,448 postings in the last year. Stated ranges, not salaries paid.

Time since we first saw it

Day 59

Up longer than most. Similar jobs usually come down between day 6 and day 56.

At TRM Labs, jobs usually come down by about day 45.

From 14,770 similar postings that came down, and 14 of TRM Labs’s. Coming down is not always a hire.

TRM Labs is hiring

23 open jobs

Open jobs by the week we first saw them, last 12 weeks.

  • Data Engineer hiring has slowed
  • Its jobs tend to stay up a long time
Hiring record

See how this role fits your experience

Add your resume and we’ll mark which of these tools you already use, and point out anything in the posting that could rule you out.

  • Python
  • SQL
  • Airbyte
  • Fivetran
  • PostgreSQL
  • Go
Where the posting names them
- Fluency with database profiling (pganalyze or equivalent) to interpret metrics and logs, including using LLMs to summarize performance findings - Production automation experience in Python or Go, including agentic automation of routine database tasks; Postgres extension development is a plus - Daily use of AI coding tools (Claude, Copilot) to accelerate development and produce higher-quality output faster, with the judgment to know when to trust or reject AI output
- 5–8 years building and operating production PostgreSQL (Citus, Aurora, AlloyDB, or equivalent distributed Postgres) - Deep SQL optimization skills (Explain Plans, CTEs, window functions, partitioning, index design, query-planner behavior in distributed environments), increasingly paired with AI-assisted query analysis - Hands-on experience with CDC tools (PeerDB, Fivetran, Debezium, Datastream, Airbyte) and comfort using AI tooling to debug replication failure modes
- Deep SQL optimization skills (Explain Plans, CTEs, window functions, partitioning, index design, query-planner behavior in distributed environments), increasingly paired with AI-assisted query analysis - Hands-on experience with CDC tools (PeerDB, Fivetran, Debezium, Datastream, Airbyte) and comfort using AI tooling to debug replication failure modes - Fluency with database profiling (pganalyze or equivalent) to interpret metrics and logs, including using LLMs to summarize performance findings
- Protect data integrity and latency by driving agentic validation of database changes before they reach production - Keep real-time data flowing by managing CDC pipelines (PeerDB, Fivetran, Debezium) and using AI tooling to debug replication failures faster - Shape the next-generation platform by migrating workloads off first-gen infrastructure and prototyping new data stores with AI-accelerated spikes
The impact you will have: - Keep customer-facing APIs fast and available at five-nines by owning query tuning, index design, and schema optimization on petabyte-scale Postgres/Citus, directly determining whether product teams can serve data in real time - Cut storage and compute costs materially by using AI-assisted analysis (pganalyze paired with Claude) to detect compression and data-model opportunities, then shipping validated changes to production
What we're looking for: - 5–8 years building and operating production PostgreSQL (Citus, Aurora, AlloyDB, or equivalent distributed Postgres) - Deep SQL optimization skills (Explain Plans, CTEs, window functions, partitioning, index design, query-planner behavior in distributed environments), increasingly paired with AI-assisted query analysis

Your next step

Complete your application on jobs.ashbyhq.com. The employer’s form will show what is required.

Applying through Ashby

  • No account needed. “Autofill from resume” at the top of the form fills the key fields from your file.

Already applied? Track this application

Job description

View original posting ↗

Build a Safer World.

TRM Labs provides AI-powered intelligence solutions that help public and private sector agencies investigate and disrupt crime. TRM's platforms enable investigators to trace illicit activity, build cases, and construct operating pictures of threat networks. Leading agencies and businesses worldwide rely on TRM to make the world safer and more secure.

The Data Platform team builds and owns highly available, scalable data infrastructure for TRM's products and services. As a Senior Software Engineer on Data Infrastructure (RDBMS), you will develop, operate, and scale the relational database systems that serve data at petabyte scale, helping build a safer financial system for billions of people. This role is uniquely broad at TRM: you own the serving layer end to end, from query performance to cost to availability, on infrastructure that product teams depend on every day.

The impact you will have:

  • Keep customer-facing APIs fast and available at five-nines by owning query tuning, index design, and schema optimization on petabyte-scale Postgres/Citus, directly determining whether product teams can serve data in real time

  • Cut storage and compute costs materially by using AI-assisted analysis (pganalyze paired with Claude) to detect compression and data-model opportunities, then shipping validated changes to production

  • Remove team toil by building agentic automation for routine database operations, such as self-serve pgbouncer provisioning, disk scaling, and blue-green deployments, so any engineer can run them safely

  • Protect data integrity and latency by driving agentic validation of database changes before they reach production

  • Keep real-time data flowing by managing CDC pipelines (PeerDB, Fivetran, Debezium) and using AI tooling to debug replication failures faster

  • Shape the next-generation platform by migrating workloads off first-gen infrastructure and prototyping new data stores with AI-accelerated spikes

  • Raise the whole team's leverage by codifying your workflows into AI-native runbooks and internal tooling that teammates reuse

What we're looking for:

  • 5–8 years building and operating production PostgreSQL (Citus, Aurora, AlloyDB, or equivalent distributed Postgres)

  • Deep SQL optimization skills (Explain Plans, CTEs, window functions, partitioning, index design, query-planner behavior in distributed environments), increasingly paired with AI-assisted query analysis

  • Hands-on experience with CDC tools (PeerDB, Fivetran, Debezium, Datastream, Airbyte) and comfort using AI tooling to debug replication failure modes

  • Fluency with database profiling (pganalyze or equivalent) to interpret metrics and logs, including using LLMs to summarize performance findings

  • Production automation experience in Python or Go, including agentic automation of routine database tasks; Postgres extension development is a plus

  • Daily use of AI coding tools (Claude, Copilot) to accelerate development and produce higher-quality output faster, with the judgment to know when to trust or reject AI output

  • A track record of using AI-assisted analysis to drive measurable cost or performance improvements in production database systems

About the Team:

  • The Data Platform team is distributed, not distant. We operate async-first across US and Canada working hours with intentional synchronous touchpoints when speed demands it

  • We own the petabyte-scale data infrastructure that powers TRM's products. The scope is large, the mission is real, and the work is technically demanding

  • Team culture is product-focused, customer-focused, coaching-oriented, scrappy when needed, and process-oriented when executing against OKRs

  • You will work alongside senior engineers who care deeply about their craft and hold high standards for code quality, operational excellence, and cross-team communication

Team Operating Rhythms:

  • Distributed, not distant: most collaboration happens async in Slack, Notion, and GitHub, and meetings are purposeful and minimal

  • Primary timezone overlap across US and Canada working hours; our north star is no IC spending more than 3–4 hours per week in meetings

  • Written-first culture: technical specs and decision docs drive alignment before code

On Call Requirements:

  • ⚠️ On Call Requirements — Pending Regional Compliance Review. This role carries an on-call rotation (approximately once every 15 days; each shift is a 24-hour window across 2 days). On-call is clear to proceed for United States; the Canada portion requires People Ops / Deel provincial confirmation before this section is finalized and posted. See the On-Call Compliance note in the Post-Fill Summary.

Learn about TRM Speed in this position:

  • Within 30 days, eliminate a single point of failure by shipping self-serve scaling automation (pgbouncer provisioning, disk resizing) that any teammate can run, freeing senior engineering time

  • Within the first quarter, identify a compression opportunity with AI-assisted analysis, validate it with a proof of concept, and ship it to production for a measurable storage-cost reduction with zero availability impact

  • Within 90 days, coordinate a schema change across three product-engineering teams in parallel and deliver the platform changes ahead of a product deadline so a customer feature ships on time

The following represents the expected range of compensation for this role:

  • Individual pay is determined by skills, qualifications, experience, and location. The compensation details listed in this posting reflect the US base salary only.

  • The estimated base salary range for this role is $200,000 - $220,000

  • Additionally, this role may be eligible to participate in TRM’s equity plan.

  • Please note – we factor in the different costs for geographies outside the United States.

Work Week Travel: This role requires participation in in-person R&D work weeks, typically 1–2 times per quarter, at a TRM hub or other designated location. Work weeks may be scheduled with as little as 14 days’ notice, and some roles may require additional travel based on team and cross-functional needs. TRM coordinates and covers approved travel, lodging, and workspace. Accommodations are available for legitimate caregiving, health, immigration, and similar constraints.

Application Instructions

If you’re interested in joining TRM, we encourage you to apply directly. Every application is reviewed by our Talent team.

Before applying, review the job description carefully and highlight the experience and impact that best demonstrate the required qualifications. Please also provide thoughtful and accurate answers to the application questions, as these will be used to evaluate your skills and qualifications for the role.

If you send your resume directly to someone at TRM, we can’t guarantee it will reach the appropriate hiring team. Applying directly is the best way to ensure your application will be considered.

Interviewing with TRM

Our process is designed to understand how you think, solve problems, and deliver impact, while allowing you to evaluate TRM. Most interview processes include a case study, an AI skills assessment, and a Leadership Principles interview.

  • Recruiter Intro: Qualifications, motivations, and alignment with the role.

  • Hiring Manager: Deep dive into your relevant experience, skills, and impact.

  • First Round: 1–2 interviews focused on the skills most critical to the role.

  • Final Round: Hands-on case study. This is usually a panel-style session where we go deeper into your craft, problem-solving, and alignment with TRM.

  • References: Former colleagues who can provide insight into your work and impact.

  • Offer: Congrats! Your recruiter will present the offer and compensation details.

  • Welcome to TRM: We're excited to build a safer world with you!

Your recruiter will share your specific interview plan and preparation guidance along the way.

AI Fluency at TRM

AI fluency is a baseline expectation at TRM.

We believe AI meaningfully changes how top performers operate. We expect every team member to use AI to accelerate and reimagine their craft, not just automate surface tasks.

At TRM, AI fluency means you are among the top 10 percent of operators in your function in how you apply AI to:

  • Accelerate repeatable workflows

  • Structure and solve problems

  • Improve output quality

  • Increase speed and leverage

You will be evaluated on applied AI fluency during the interview process.

Life at TRM

We are building a safer world. That promise shows up in how we work every day.

TRM moves FAST. We are a high-velocity, high-ownership team that expects clarity, follow-through, and impact. People who thrive here are energized by hard problems, experimentation, and continuous feedback. If something takes months elsewhere, it will ship here in days.

Our work sits at the intersection of AI, national security, and fighting crime. The problems are complex, the stakes are real, and the environment evolves quickly. The pace and intensity of the work reflect the importance of the mission. As a result, the way we operate requires a high level of ownership, adaptability, collaboration, and creative problem-solving.

At TRM, you should expect:

  • Priorities and targets to change quickly

  • Operating with a high degree of ambiguity

  • A high level of personal ownership and accountability

  • Close collaboration across teams and functions

  • Frequent, high-touch communication

  • Creative problem-solving and out-of-the-box thinking

  • A pace that rewards urgency, adaptability, and outcomes

This environment is energizing for people who enjoy building, solving hard problems, and making progress in situations that are not always fully defined. It also requires thriving in ambiguity, adjusting course as new information emerges, and maintaining focus and positivity in a fast-moving and intense environment.

We also recognize that this style of operating is not for everyone. If you are primarily optimizing for predictability or a consistently balanced workload, we encourage you to use the interview process to pressure-test whether this environment is truly the right fit. We want teammates who thrive here, not just survive here.

If you are excited by meaningful problems, motivated by ambitious goals, and energized by working alongside mission-driven colleagues, there is a good chance you will find TRM to be an exceptional place to grow and contribute.

Leadership Principles

We hire and grow against three leadership principles. They’re the standards for how we operate, treat each other, and make decisions.

  • Impact-Oriented Trailblazer: We put customers first and move with speed, focus, and adaptability. We treat every plan like an experiment – test, ship, measure, and iterate quickly.

  • Master Craftsperson: We care deeply about our craft. We balance speed with high standards, own outcomes end‑to‑end, and invest in getting better everyday.

  • Inspiring Colleague: We add clarity and energy, not noise. We bring humility, candor, and a one‑team mindset — giving and receiving feedback to make the team stronger.

Join our Mission

At TRM, we care deeply about our craft. We are looking for individuals who want their work to matter, who experiment with speed and rigor, and who take pride in building a safer world for billions of people. If you’re excited by TRM’s mission but don’t check every box, we encourage you to apply — we hire for slope, judgment, and the will to learn fast.

TRM is a Series C company with $220M in total funding, backed by Goldman Sachs, Bessemer, Y Combinator, Thoma Bravo, and others. Headquartered in San Francisco, TRM operates as a distributed-first company with hubs in Los Angeles, San Francisco, New York, Washington D.C., London, and Singapore.

Privacy Policy and Additional Information

By submitting your application, you agree to allow TRM Labs to process your personal information in accordance with our Privacy Policy.

We collect the information you provide (such as your resume, work history, and contact details) solely for the purpose of evaluating your candidacy for current and future roles at TRM.

Because our hiring cycles for certain positions may span 24 to 36 months, we retain your personal information for up to 36 months from the date of your application. After that period, your data is deleted unless a different retention period is required or permitted by law.

If you are located in the European Economic Area, the United Kingdom, or another jurisdiction with applicable data protection laws, you have the right to access, correct, or request deletion of your personal data at any time before that period ends. To exercise any of these rights, contact us at privacy@trmlabs.com.

To notify TRM Labs that you believe this job posting is non-compliant, please submit a report through this form. No response will be provided to inquiries unrelated to job posting compliance.

The use of AI tools of any kind (including but not limited to notetakers, interview assistants, and real-time coaching tools such as Otter.ai, Fireflies, Fathom, Cluey, or similar) during TRM interviews is not permitted without prior approval from TRM. TRM uses its own internal tools for note-taking to ensure a consistent and confidential experience for all candidates.

We are committed to providing reasonable accommodations to applicants with disabilities, and requests can be made via this form.

Recruitment agencies

TRM Labs does not accept unsolicited agency resumes. Please do not forward resumes to TRM employees. TRM Labs is not responsible for any fees related to unsolicited resumes and will not pay fees to any third-party agency or company without a signed agreement.

Demand for Data Engineer roles

New Data Engineer postings at the employers we follow are up 13% over the last 6 weeks compared with the 6 before.

Weekly new Data Engineer postings at the same employers, from the week of August 17 to the week of November 9. The fewest in a week was 845, the most 1,344, and the latest week had 1,007.
August 17Last week

Each bar is one week of new postings. The darkest bars are the last 6 weeks.

Counted from the hiring pages we’ve followed for at least five weeks, so employers we add don’t look like growth. Updated weekly.

About the role

We file this job under Data Engineer, by the work the posting describes.

Data engineers build and run the pipelines that copy data out of apps and outside services into a warehouse or lake, and fix them when a source changes or a load fails.

Expect SQL, Python, a cloud platform, a scheduler such as Airflow, and often tools for large data such as Spark or Kafka.

An analytics engineer works one step later, turning the raw data a data engineer lands into clean tables people can query.

US government figures for database architects

Median yearly pay, May 2025
$139,500
Expected change, 2025 to 2035
9.4% more jobsagainst 3.5% for all jobs

The government has no code for data engineers, so these figures are for the closest group, database architects, which includes data integration and data warehousing specialists.

Source: US Bureau of Labor Statistics, Occupational Employment and Wage Statistics (May 2025) and Employment Projections (2025 to 2035). Occupation code 15-1243.

Source details

View original posting ↗

Source notes

Source excerpts

Selected passages from the saved posting. Check the full description for conditions and exceptions.

Pay
Individual pay is determined by skills, qualifications, experience, and location. The compensation details listed in this posting reflect the US base salary only. The estimated base salary range for this role is $200,000 - $220,000 Additionally, this role may be eligible to participate in TRM’s equity plan.
Location & working pattern

United States

Working pattern and location restrictions need checking in the full posting.

Work authorization
- Please note – we factor in the different costs for geographies outside the United States. Work Week Travel: This role requires participation in in-person R&D work weeks, typically 1–2 times per quarter, at a TRM hub or other designated location. Work weeks may be scheduled with as little as 14 days’ notice, and some roles may require additional travel based on team and cross-functional needs. TRM coordinates and covers approved travel, lodging, and workspace. Accommodations are available for legitimate caregiving, health, immigration, and similar constraints. Application Instructions

Find answers in the posting

AI
How answers work

AI selects complete passages from this posting. Check them for conditions and exceptions.

Uses this posting and your question. No profile needed.