Data Engineer (AWS PostgreSQL)

TL;DR

Data Engineer (AWS/PostgreSQL): Building and maintaining data infrastructure for a cloud-based federal case management system with an accent on data pipelines, materialized views, and AWS Aurora PostgreSQL. Focus on optimizing data workflows for analytics and ensuring compliance with federal security standards like FISMA and NIST.

Location: Remote (Must be authorized to work in the United States; U.S. citizenship and security clearance may be required)

Salary: $100,000 - $140,000

Company

hirify.global provides quality software to the federal space, focusing on building scalable solutions for government agencies.

What you will do

• Build and maintain data marts, materialized views, and data pipelines within an AWS Aurora PostgreSQL environment.
• Support data integration between the core system and downstream platforms, including MicroStrategy and enterprise reporting tools.
• Design and optimize data workflows that support analytics, reporting, and operational decision-making.
• Monitor data pipeline health and troubleshoot performance and data quality issues.
• Collaborate with engineering and product teams to support new data-driven features.
• Ensure compliance with federal data security requirements, including FISMA and NIST 800-53.

Requirements

• Strong proficiency in SQL and experience with PostgreSQL or similar relational databases.
• Experience building and maintaining data marts, materialized views, or ETL/ELT pipelines.
• Familiarity with AWS data services and cloud-based data infrastructure.
• Authorized to work in the United States (U.S. citizenship may be required for federal contract compliance).
• Bachelor's Degree.

Nice to have

• Experience integrating with enterprise reporting or BI tools such as MicroStrategy.
• Understanding of data security and governance in federal or regulated environments.

Culture & Benefits

• Fully remote work environment.
• Tech and education stipend.
• Comprehensive benefits package.
• Company match 401(k) plan.
• Flexible PTO and paid holidays.