ETL & Data Engineer: PostgreSQL Warehouse Expert

ActioNet, Inc.; Suitland (MD); On-site; USD 110,000 - 150,000; Full time

Benefits offered by this job

Medical Insurance

Vision Insurance

Life and AD&D Insurance

401(k) Savings Plan

Education and Professional Training

Flexible Spending Accounts (FSA)

Employee Referral and MeritRecognition

Employee Assistance and Identity Theft

Paid Holidays: 11 per year

PTO

Disability Insurance

Job summary

ActioNet is seeking an ETL/Data Engineer to support high-volume data processing, warehousing, and reporting for Decennial and ECON workflows. The role focuses on transforming raw data into warehouse schemas and developing detailed reporting tables for analytics and operations.

Strong PostgreSQL development, data aggregation, and multi-source data integration are essential. The ideal candidate will optimize performance, manage external data ingestion, and design analytics-driven data structures

Qualifications

• Ability to obtain and maintain a Public Trust clearance.
• Strong experience with PostgreSQL including functions and stored procedures.
• Demonstrated expertise in data warehousing, including schema design and reporting tables.
• Experience automating data processing and managing large-scale data workflows.
• Proficiency in database performance tuning, indexing strategies, and query optimization.
• Experience with large-scale data aggregation and blending data from multiple sources.
• Knowledge of foreign tables, external data ingestion, and data integration techniques.
• Ability to design analytics-driven data structures that support complex reporting requirements.
• Strong analytical, troubleshooting, and problem-solving skills.

Responsibilities

• Process and transform raw data from staging environments into structured data warehouse schemas.
• Design, develop, and maintain detailed reporting tables to support Decennial and ECON data workflows.
• Build and optimize PostgreSQL functions, stored procedures, and automated data processing routines.
• Perform large-scale data aggregations and integrate data from multiple sources for reporting/analytics.
• Implement and manage foreign tables and external data ingestion processes.
• Optimize database performance through indexing, query tuning, and execution plan analysis.
• Develop scalable, reliable data processing solutions for high-volume workloads.
• Collaborate with technical teams to translate data and reporting requirements into database solutions.
• Identify performance bottlenecks and implement improvements for efficiency and scalability.

Skills

PostgreSQL

Data Warehousing

ETL

SQL Development

Performance Tuning

Data Integration

External Data Ingestion

Analytics-Driven Design

Job description

ActioNet is seeking an ETL/Data Engineer to support high-volume data processing, warehousing, and reporting for Decennial and ECON workflows. The role focuses on transforming raw data into warehouse schemas and developing detailed reporting tables for analytics and operations.

Strong PostgreSQL development, data aggregation, and multi-source data integration are essential. The ideal candidate will optimize performance, manage external data ingestion, and design analytics-driven data structures