Senior Data Engineer - PostgreSQL & AWS (Remote)

Patriot Software; United States; Remote; USD 105,000 - 125,000; Full time

Job summary

Patriot Software is seeking a Data Engineer III to design and scale our PostgreSQL-based data platform in a 100% remote role. You will work with software engineers, analytics engineers, and business stakeholders to build reliable data infrastructure.

The ideal candidate has 4–7 years of experience in data or database engineering, strong SQL and Python (or similar), and hands-on AWS RDS/Lambda/S3 experience. You will mentor junior engineers and help improve observability and data quality.

Qualifications

• 4-7 years of professional experience in Data Engineering, Database Engineering, or Software Engineering with significant database responsibilities.
• Advanced expertise with PostgreSQL, including relational design, normalization, data modeling, and schema design.
• 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.

Responsibilities

• 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.

Skills

PostgreSQL

SQL

Data modeling

ETL/ELT pipelines

Python

C#

Go

Cloud architecture

Problem solving

Education

Bachelor’s degree in Computer Science, Information Systems, Data Engineering, or equivalent professional experience

Tools

AWS RDS

AWS Lambda

AWS S3

EventBridge

IAM

CloudWatch

Job description

Patriot Software is seeking a Data Engineer III to design and scale our PostgreSQL-based data platform in a 100% remote role. You will work with software engineers, analytics engineers, and business stakeholders to build reliable data infrastructure.

The ideal candidate has 4–7 years of experience in data or database engineering, strong SQL and Python (or similar), and hands-on AWS RDS/Lambda/S3 experience. You will mentor junior engineers and help improve observability and data quality.