ETL​/Data Engineer

Position: ETL /Data Engineer
Description

Job Title:

ETL/Data Engineer

Location:

Hybrid in Suitland, MD Clearance:
Public Trust; U.S. Citizenship Required Summary Actio Net  is seeking a ETL/Data Engineer to support high-volume data processing, warehousing, and reporting initiatives for Decennial and Economic Census (ECON) workflows. This role will focus on transforming raw data from staging environments into warehouse schemas and developing robust reporting detail tables to support analytics and operational reporting. The ideal candidate has strong PostgreSQL development skills, experience with large-scale data aggregation and multi-source data integration, and expertise in database performance tuning and optimization.

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 complex PostgreSQL functions, stored procedures, and automated data processing routines.

Perform large-scale data aggregations and integrate data from multiple sources to support reporting and analytics requirements.

Implement and manage foreign tables and external data ingestion processes.

Optimize database performance through indexing strategies, query tuning, and execution plan analysis.

Develop scalable, reliable, and efficient data processing solutions to support high-volume workloads.

Collaborate with technical teams and stakeholders to translate data and reporting requirements into effective database solutions.

Identify performance bottlenecks and implement improvements to data processing efficiency, scalability, and reliability.

Required Qualifications U.S. citizenship required.

Ability to obtain and maintain a Public Trust determination.

Strong experience with PostgreSQL, including functions, stored procedures, and complex SQL development.

Demonstrated expertise in data warehousing, including schema design, data transformation, and reporting table development.

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.

Preferred Qualifications Experience supporting high-volume government data programs or large-scale statistical data processing.

Familiarity with Decennial Census or Economic Census data workflows.

Experience optimizing PostgreSQL environments for large datasets and demanding reporting workloads.

Experience developing scalable data warehouse solutions in complex enterprise environments.

Actio Net is a CMMI-DEV Level 4, CMMI-SVC Level 4, ISO 20000, ISO 27001, ISO 9001, HDI-certified, woman-owned IT Solutions Provider with strong qualifications and expertise in Agile Software Engineering, Cloud Solutions, Cyber Security and IT Managed Services.
With 26+ years of stellar past performance, Actio Net is the premier Trusted Innogrator!

Core Capabilities:

Advanced and Managed IT Services Agile Software Development Dev Sec Ops Cybersecurity Health  ITC4

ISR & SIGINTData Center Engineering & Operations Engineering & Installation Why Actio Net?

At Actio Net, our Passion for Quality is at the heart of everything we do:

Commitment to Employees:
We are committed to making Actio Net a great place to work and continue to invest in our Actio Neters.

Commitment to Customers:
We are committed to our customers by driving and sustaining Service Delivery…