Ability to obtain and maintain a Public Trust determination.
Strong experience with PostgreSQL, including functions and complex SQL development.
Expertise in data warehousing, schema design, and reporting table development.
Experience in automating data processing and managing large-scale workflows.
Proficiency in database performance tuning and query optimization.
Knowledge of foreign tables and data integration techniques.
Responsibilities
Process and transform raw data into structured data warehouse schemas.
Design and maintain detailed reporting tables for Decennial and ECON workflows.
Build and optimize complex PostgreSQL functions and automated data routines.
Perform large-scale data aggregations and integrate data from multiple sources.
Implement and manage foreign tables and external data ingestion processes.
Optimize database performance through indexing and query tuning.
Collaborate with teams to translate data requirements into effective solutions.
Benefits
Medical Insurance
Vision Insurance
Dental Insurance
Life and AD&D Insurance
401(k) Savings Plan
Education and Professional Training
Flexible Spending Accounts (FSA)
Employee Referral and Merit Recognition Programs
Employee Assistance and Identity Theft Protection
Paid Holidays: 11 per year
Paid Time Off (PTO)
Disability Insurance
Full Job Description
Description
Job Title: ETL/Data Engineer
Location: Hybrid in Suitland, MD
Clearance: Public Trust; U.S. Citizenship Required
Summary
ActioNet 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.
Full-Time Employees are eligible to participate in our ActioNet's Benefits Program:
Medical Insurance
Vision Insurance
Dental Insurance
Life and AD&D Insurance
401(k) Savings Plan
Education and Professional Training
Flexible Spending Accounts (FSA)
Employee Referral and Merit Recognition Programs
Employee Assistance and Identity Theft Protection
Paid Holidays: 11 per year
Paid Time Off (PTO)
Disability Insurance
********Direct Applicants, only. No Agencies, No third-party recruiters, please********
About ActioNet, Inc
ActioNet, Inc. is a provider of information technology services to the federal government and commercial clients. The company offers a range of services, including software development, cybersecurity, cloud computing, and data analytics. ActioNet has been recognized for its work in the federal sector, and has received numerous awards for its performance and customer service. The company is headquartered in Rockville, Maryland, and has additional offices in Vienna, Virginia, and Honolulu, Hawaii.
