Patriot Software, LLC Logo

Patriot Software, LLC

Data Engineer III

Posted An Hour Ago
Remote
Hiring Remotely in USA
105K-125K Annually
Senior level
Remote
Hiring Remotely in USA
105K-125K Annually
Senior level
Design, build, and operate scalable PostgreSQL databases and cloud-native data infrastructure. Build and maintain ETL/ELT pipelines, optimize query and server performance, ensure high availability and disaster recovery, improve observability, troubleshoot production issues, guide schema and application design, evaluate database technologies, and mentor junior engineers to support reliable, secure data-driven applications.
The summary above was generated by AI
Let Us Introduce Ourselves

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.

What We Believe In

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 Title: Data Engineer III
  • Job Status: Full-time 
  • Location: 100% Remote
  • Compensation: Salaried (Exempt)
  • 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, EventBridge, and related technologies.
  • Improve observability by implementing monitoring, alerting, automation, and operational tooling for Patriot's data platform.
  • Identify technical debt and proactively improve database architecture before issues become operational challenges.
  • Review database changes, migrations, and application designs to ensure long-term maintainability, scalability, and performance.
  • Guide engineering teams on best practices for database design, query optimization, and efficient data access.
  • Mentor Level I and II Data Engineers through pairing, design reviews, code reviews, and technical coaching.
  • Communicate technical decisions through design documents, architecture reviews, technical discussions, and cross-functional collaboration.
  • Support secure and responsible data management by promoting best practices for governance, compliance, privacy, and secure adoption of modern technologies, including AI.
  • Support Patriot's values through leadership, collaboration, and customer-focused decision-making.

Please note: this is a sample of your responsibilities. You'll need to adapt quickly as priorities evolve to support an exceptional customer experience.

What You’ll Need: 

  • Bachelor's degree in Computer Science, Information Systems, Data Engineering, or equivalent professional experience.
  • 4-7 years of professional experience in Data Engineering, Database Engineering, or Software Engineering with significant database responsibilities.
  • Advanced expertise with PostgreSQL, including:
  • Utilizes software engineering principles for data engineering projects 
  • Strong understanding of relational database design, normalization, data modeling, and schema design.
  • Experience designing and supporting highly available, fault-tolerant production database environments.
  • Experience building and maintaining ETL/ELT pipelines and data integration solutions.
  • Professional experience with SQL and at least one programming language such as Python, C#, Go, or similar.
  • Experience with AWS cloud services such as RDS, Lambda, S3, EventBridge, IAM, and CloudWatch.
  • Strong understanding of ORM technologies and how application design impacts database performance.
  • Ability to debug complex problems across applications, databases, and cloud infrastructure.
  • Strong understanding of software architecture and how data platforms support scalable application development.
  • Ability to work independently, prioritize competing work, and make sound technical decisions with minimal oversight.
  • Excellent communication, collaboration, and mentoring skills.
  • Passion for continuous learning and improving engineering practices.
  • Consistent, reliable high-speed internet access.
  • Dedicated, quiet workspace free from distractions.

Work Requirements:

  • This role requires sitting or standing for extended periods (8+ hours) while working on a computer, including prolonged screen time and extended, repetitive use of a keyboard and mouse.
  • To deliver a professional customer experience, this role requires a workspace that supports focused, distraction-free work and clear, quiet audio during scheduled hours. If you require a reasonable accommodation to meet this need, please let us know.
  • Maintain reliable, high-speed internet access sufficient to support video, chat, and email-based work

Patriot Software is committed to providing reasonable accommodations to qualified individuals with disabilities. If you require an accommodation during the application or interview process, or to perform the essential functions of this role, please note this on your application, and a member of our People Operations team will follow up with you.

Nice to Have: 

  • Experience with data warehousing technologies and modern analytical data platforms.
  • Experience with workflow orchestration tools such as Airflow, Dagster, dbt, or similar technologies.
  • Experience with event-driven architectures, streaming technologies, or messaging platforms.
  • Experience administering additional database technologies beyond PostgreSQL.
  • Experience supporting AI, machine learning, or large language model workloads through scalable data infrastructure.
  • Experience designing and supporting event-driven data architectures using technologies such as Redpanda, Apache Kafka, Debezium, or similar streaming and change data capture (CDC) platforms 
  • Familiarity with data governance, metadata management, and data cataloging.
  • Experience in AWS/RDS cost optimization 
  • Experience working in financial technology or other regulated industries.
  • Experience leading cross-functional technical initiatives or serving as a technical lead.

Location & Commitments:

  • Full-time, direct-hire, 100% remote role
  • Open to candidates residing in and legally authorized to work in the United States
  • Not open to applicants residing in: Alaska, California, Hawaii, Washington D.C.
  • Core hours: 8 am–5 pm EST, Monday–Friday
  • Some flexibility is required during busy seasons or critical “right-now” moments
Equal Opportunity

Patriot is an equal opportunity employer. We do not discriminate against any employee or job applicant on the basis of race, color, gender, national origin, age, religion, creed, disability or sex.

More Reasons to Love Patriot

Great products start with great people—which is why we invest in our team so they can do their best work. In addition to a culture that encourages innovation and ownership, our full-time employees enjoy a comprehensive suite of benefits that help our team thrive inside and outside of work. Learn more about our opportunities and benefits on our Careers page.

Are you ready to take the next step in your career?

--

Ready to take the next step in your career? We’d love to meet you.

Privacy Notice
To protect the privacy of our customers and employees, please do not include sensitive Personally Identifiable Information (PII)—such as Social Security Numbers, Dates of Birth, or W-2s—when submitting your application.

Use of AI in the Hiring Process
Thank you for your interest in Patriot Software! To support a fair and efficient hiring process, we use AI-powered tools to assist with resume screening, note-taking, and interview insights. These tools help us evaluate candidates consistently and in compliance with EEOC and all applicable laws.

AI tools do not make hiring decisions—all decisions are made by our human hiring team. All applicants are evaluated based on their qualifications, skills, and experience.

By submitting your application, you acknowledge the following:

AI Usage
  • AI may analyze an applicant's video, including facial expressions, as part of assessing position fit.
  • AI tools may be used during interviews for note-taking, evaluating responses, and generating interview summaries.
On-Camera Video Interviews
  • All interviews are conducted via video with cameras on to maintain compliance and security standards.
  • Patriot is a camera-on company for all video interactions.
Photo Capture for Security
  • If selected to interview, you may be asked to provide or have a photo captured.
  • This photo is used only to verify that the same candidate is present throughout all interview stages.
  • Photos are not shared externally, used for any other purpose, or stored after the interview process. They are securely disposed of once the process is complete.
Privacy & Data Use
  • Any photos are used solely for candidate verification.
  • Geolocation tools may be used only to verify your location and ensure interview integrity.
  • All geolocation use is limited to security and compliance needs and follows all applicable privacy laws.

Similar Jobs

25 Days Ago
Remote or Hybrid
USA
125K-150K Annually
Senior level
125K-150K Annually
Senior level
Healthtech • HR Tech • Software
Build and maintain production-grade data pipelines and ELT processes using Python, SQL, Airflow, and dbt within AWS. Design optimized schemas in PostgreSQL and Redshift, leverage AI/LLMs to improve development, automation, testing, and data quality, and scale infrastructure for large healthcare datasets.
Top Skills: Amazon RedshiftApache AirflowAws FargateAws GlueAws LambdaCloudFormationDbtGithub CopilotLarge Language ModelsPostgresPythonSQLTerraform
20 Days Ago
Remote
South Carolina, USA
Senior level
Senior level
Healthtech • Professional Services • Biotech • Pharmaceutical
Provide senior-level data engineering for analytics: resolve complex technical issues, build decision-support reports and dashboards, lead projects, prepare and integrate data, coach staff, and ensure high-quality analytics to support academic, research, and healthcare goals.
Top Skills: Epic
20 Hours Ago
Remote
United States
183K-205K Annually
Senior level
183K-205K Annually
Senior level
Artificial Intelligence • Big Data • eCommerce • Fashion • Information Technology • Natural Language Processing • Data Privacy
Design, build, and maintain scalable ETL/data pipelines across distributed systems. Ensure data quality, integrity, security, and high availability. Monitor and optimize pipeline performance, perform root cause analysis, document systems, collaborate with global teams, and participate in on-call rotations to support production data systems.
Top Skills: AirflowAmazon RedshiftAws EmrAws S3FlinkHivePrestoSparkSQL

What you need to know about the Colorado Tech Scene

With a business-friendly climate and research universities like CU Boulder and Colorado State, Colorado has made a name for itself as a startup ecosystem. The state boasts a skilled workforce and high quality of life thanks to its affordable housing, vibrant cultural scene and unparalleled opportunities for outdoor recreation. Colorado is also home to the National Renewable Energy Laboratory, helping cement its status as a hub for renewable energy innovation.

Key Facts About Colorado Tech

  • Number of Tech Workers: 260,000; 8.5% of overall workforce (2024 CompTIA survey)
  • Major Tech Employers: Lockheed Martin, Century Link, Comcast, BAE Systems, Level 3
  • Key Industries: Software, artificial intelligence, aerospace, e-commerce, fintech, healthtech
  • Funding Landscape: $4.9 billion in VC funding in 2024 (Pitchbook)
  • Notable Investors: Access Venture Partners, Ridgeline Ventures, Techstars, Blackhorn Ventures
  • Research Centers and Universities: Colorado School of Mines, University of Colorado Boulder, University of Denver, Colorado State University, Mesa Laboratory, Space Science Institute, National Center for Atmospheric Research, National Renewable Energy Laboratory, Gottlieb Institute

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account