Patriot Software

Patriot Software

Patriot Software LLC offers affordable and easy-to-use online accounting and payroll software for small and medium-sized American businesses. With a passion for supporting small businesses, Patriot Software provides simple yet powerful software solutio...

Professional Services
51-250
Founded 2002

Description

  • Design, build, and maintain scalable, reliable, highly available PostgreSQL databases and supporting data infrastructure.
  • Own complex data engineering initiatives from architecture through implementation, deployment, and long-term support.
  • Design relational data models for transactional applications, integrations, reporting, and future growth.
  • Optimize database performance through query tuning, indexing, execution plan analysis, partitioning, and server configuration.
  • Troubleshoot production issues involving databases, replication, storage, infrastructure, and application performance.
  • Build and maintain HA, backup, disaster recovery, and business continuity solutions for critical data systems.
  • Develop and support ETL/ELT pipelines and data integration infrastructure.
  • Collaborate with software engineers to improve application performance through schema design, ORM usage, and data access patterns.
  • Serve as the PostgreSQL subject matter expert across engineering teams and guide database best practices.
  • Evaluate database technologies, storage options, and cloud services to improve scalability, reliability, security, and efficiency.
  • Develop cloud-native data solutions using AWS services such as RDS, Lambda, S3, and EventBridge.
  • Improve observability through monitoring, alerting, automation, and operational tooling.
  • Review database changes, migrations, and application designs for maintainability, scalability, and performance.
  • Mentor junior data engineers through pairing, design reviews, code reviews, and technical coaching.
  • Communicate technical decisions through design documents, architecture reviews, and cross-functional discussions.

Requirements

  • 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.
  • 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.
  • Experience with data warehousing technologies and modern analytical data platforms (preferred).
  • Experience with workflow orchestration tools such as Airflow, Dagster, dbt, or similar technologies (preferred).
  • Experience with event-driven architectures, streaming technologies, or messaging platforms (preferred).
  • Experience administering additional database technologies beyond PostgreSQL (preferred).
  • Experience supporting AI, machine learning, or large language model workloads through scalable data infrastructure (preferred).
  • Experience designing event-driven data architectures using Redpanda, Apache Kafka, Debezium, or similar CDC platforms (preferred).
  • Familiarity with data governance, metadata management, and data cataloging (preferred).
  • Experience in AWS/RDS cost optimization (preferred).
  • Experience working in financial technology or other regulated industries (preferred).
  • Experience leading cross-functional technical initiatives or serving as a technical lead (preferred).
  • Open to candidates residing in and legally authorized to work in the United States.
  • Not open to applicants residing in Alaska, California, Hawaii, or Washington D.C.
  • Core hours are 8 am–5 pm EST, Monday–Friday.
  • Some flexibility is required during busy seasons or critical moments.

Benefits

  • $105K - $125K salary range based on experience.
  • 100% remote work arrangement.
  • Full-time direct-hire position.
  • Salaried exempt compensation.
  • Comprehensive benefits package for full-time employees.
  • Opportunity to work at a product-led company with a culture of ownership and innovation.

Interested in this position?

Apply directly on the company website

Apply Now

Similar Roles

(1521) Senior Data and Insight Engineer

Nortal 251-1K Internet Software & Services

Nortal is hiring a Data and Insight Engineer to support data-driven decision-making by building and optimizing data workflows for a global, remote team serving US clients.

Apache Airflow AWS GCP Python Snowflake
2 hours, 42 minutes ago

Senior Data Engineer II, AI Native

Life360 251-1K Family Services

Life360 is hiring a Senior Data Engineer II to help build and maintain its next-generation data platform and data lakehouse supporting real-time analytics, experimentation, and machine learning.

Apache Airflow Apache Spark AWS Azure CI/CD Databricks dbt Elasticsearch GCP GitHub Actions LLM Machine Learning Presto Python Snowflake SQL Terraform Trino
2 hours, 42 minutes ago

AWS Cloud Data Engineer

Casino Cash Trac Internet Software & Services

AWS Data Engineer at CCT, supporting casino operations analytics by building and maintaining secure, scalable AWS-based data infrastructure and pipelines.

AWS AWS CDK DynamoDB
3 hours, 12 minutes ago

Sr. Data Engineer (Snowflake)

Apply Digital 251-1K Professional Services

APPLY is seeking a Data Engineer to design and support cloud-based data platforms for consumer and entertainment brands across analytics and operational use cases.

Apache Airflow Contentful Dagster Databricks dbt Feature Engineering GCP Looker Machine Learning Power BI Python Segment Snowflake SQL Tableau Terraform
3 hours, 12 minutes ago

You're on a roll! Sign up now to keep applying.

Sign Up

Already have an account? Log in

Used by 14,729+ remote workers