ETL /Data Engineer

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.

ActioNet 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, ActioNet is the premier Trusted Innogrator!

Core Capabilities:

• Advanced and Managed IT Services

• Agile Software Development

• DevSecOps

• Cybersecurity

• Health IT

• C4ISR & SIGINT

• Data Center Engineering & Operations

• Engineering & Installation

Why ActioNet?

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

• Commitment to Employees: We are committed to making ActioNet a great place to work and continue to invest in our ActioNeters.

• Commitment to Customers: We are committed to our customers by driving and sustaining Service Delivery Excellence.

• Commitment to Community: We are committed to giving back to our community, helping others, and making the world a better place for our next generation.

ActioNet is proud to be named a Top Workplacefor the twelfth year in a row (2014 - 2025). We have a 98% customer retention rate. We are passionate about the inspirational missions of our customers, and we entrust our employees and teams to deliver exceptional performance to enable the safety, security, health, and well-being of our nation.

What's in It ForYou?

As an ActioNeter, you get to be part of an exceptional team and a corporate culture that nurtures mutual success for our customers, employees, and communities. We give you the tools to be successful; all you need to do is bring your best ideas, your energy, and a desire to develop your skills, experience, and career. Are you ready to make a difference?

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.

Full-Time Employees are eligible to participate in our ActioNet’sBenefits 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

ActioNet is an equal opportunity employer and value inclusion at our company. We do not discriminate on the basis ofrace, religion, color, national origin, gender, sexual orientation, age, marital status, veteran status, or disability status.

********Direct Applicants, only.No Agencies, No third-party recruiters, please********