Data Engineer III

We’re Patriot Software - a remote-first, product-led tech company on a mission to make accounting and payroll fast, simple, and affordable for millions of American businesses. With 175+ team members across the U.S. and a collaborative office hub in Canton, Ohio, we’re building software that empowers the backbone of the American economy.

Creating great products starts with creating an environment where people thrive. That means connection, clarity, growth, high trust, and a culture where ideas move quickly and quality matters.

Our team lives by six core values that guide how we work, build, and serve:

• Be Customer Obsessed
  :
  We start with our customers and work backward to deliver exceptional value.
• Lead With Speed
  :
  We move fast, take smart risks, and stay ahead by acting boldly.
• Don’t Cut Corners
  :
  We own our technologies and operations to deliver a high-quality, end-to-end experience.
• Create a Better Us
  :
  We simplify, automate, spend wisely, and continuously improve.
• Follow The Golden Rule: We treat others with respect, invite feedback, and commit even when we disagree.
• Grow, Be a Leader
  :
  We expect leadership at all levels and pursue excellence as a high-accountability, high-trust team.

If this sounds like a place where you’d thrive, keep reading—your next opportunity might be here.

Summary:

• Job Status: Full-time
• Location: 100% Remote
• Position Type: Direct Hire; note, this is not a contract role
• Pay Range: $105K - $125K based on experience
• Shift: Monday through Friday, 8 am - 5 pm ET

Description

Are you passionate about designing scalable, high-performing data platforms that power mission-critical applications? Do you enjoy solving complex database challenges, optimizing performance, and building reliable systems that enable software engineers and business teams to move faster? If so, the Data Engineer III position at Patriot may be the perfect fit for you.

This role is ideal for an experienced data engineer who enjoys taking ownership of complex technical challenges while helping shape Patriot's data platform. You'll work closely with software engineers, analytics engineers, and business stakeholders to build scalable data solutions, optimize PostgreSQL environments, improve data pipelines, and ensure our data infrastructure remains secure, reliable, and highly available.

As a senior member of the team, you'll influence technical direction, mentor other engineers, establish engineering best practices, and help ensure Patriot's data ecosystem is built to support today's applications while preparing for future technologies, including AI-powered solutions.

What You’ll Be Doing:

• Design, build, and maintain scalable, reliable, and highly available PostgreSQL databases and supporting data infrastructure.
• Own complex data engineering initiatives from architecture through implementation, deployment, and long-term operational support.
• Design efficient relational data models that support transactional applications, integrations, reporting, and future business growth.
• Optimize database performance through query tuning, indexing strategies, execution plan analysis, partitioning, and server configuration.
• Troubleshoot complex production issues involving databases, replication, storage, infrastructure, and application performance.
• Design and maintain high availability, backup, disaster recovery, and business continuity solutions for critical data systems.
• Build and maintain data pipelines, ETL/ELT processes, and supporting infrastructure that move data reliably between operational systems and downstream consumers.
• Collaborate with software engineers to improve application performance through efficient schema design, ORM usage, and database access patterns.
• Serve as the subject matter expert for PostgreSQL and database technologies across multiple engineering teams.
• Evaluate and recommend database technologies, storage solutions, and cloud services that improve scalability, reliability, security, and operational efficiency.
• Develop cloud-native data solutions using AWS services such as RDS, Lambda, S3, Event Bridge, and related technologies.
• Improve observability by implementing monitoring, alerting, automation, and…