Job Description
Company: ActioNet, Inc.
Location: Suitland, MD
Workplace Type: Hybrid
Employment Type: Full-time
About the Role
ActioNet is seeking an ETL/Data Engineer to support high-volume data processing, warehousing, and reporting initiatives for Decennial and Economic Census (ECON) workflows. This role focuses on transforming raw data from staging environments into warehouse schemas and developing robust reporting detail tables for analytics and operational reporting.
What You’ll Do / Key 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.
- Optimize database performance through indexing strategies, query tuning, and execution plan analysis.
Requirements & Qualifications
- 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.
- Proficiency in database performance tuning, indexing strategies, and query optimization.
- Experience automating data processing and managing large-scale data workflows.
- U.S. citizenship required and ability to obtain a Public Trust determination.
Preferred / Bonus Qualifications (if applicable)
- Experience supporting high-volume government data programs or large-scale statistical data processing.
- Experience optimizing PostgreSQL environments for large datasets and demanding reporting workloads.
Benefits & Perks (if applicable)
- Medical Insurance, Vision Insurance, Dental Insurance, Life and AD&D Insurance, 401(k) Savings Plan, Education and Professional Training, Flexible Spending Accounts (FSA), Paid Holidays (11 per year), PTO, Disability Insurance.
ActioNet is an equal-opportunity employer and values inclusion at our company. We do not discriminate based on race, religion, color, national origin, gender, sexual orientation, age, marital status, veteran status, or disability status.