ETL​/Data Engineer

Clearance:
Public Trust; U.S. Citizenship Required

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.

• 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.

• 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.

• 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 !

Advanced and Managed IT Services

Agile Software Development

Dev Sec Ops

Cybersecurity

Health IT

C4

ISR & SIGINT

Data Center Engineering & Operations

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 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.

Actio Net is proud to be named a Top Workplace for 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.

As an Actio Neter, 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?

Actio Net is an…