Data Engineer

Company Overview:

The Intelligence and Security Associates (ISA) is a Virginia-based SBA certified Service-Disabled Veteran-Owned Small Business. ISA is a proud V3-certified employer, with one in two ISA employees having served in the U.S. military. Additionally, ISA holds a General Services Administration (GSA) Multiple Award Schedule (MAS) contract, and One Acquisition Solution for Integrated Services + (OASIS+) Total Small Business Pool Contract Vehicle.

Originally founded as an education and training company, ISA continues a 20-plus-year tradition of providing value creation for our clients, delivering unique solutions tailored to their specific challenges across a broad range of national security issues and competencies.

Our highly qualified subject matter professionals, data and technical experts, and our seasoned senior leaders specialize in national security and intelligence delivery services for the Department of War (DoW), the Intelligence Community (IC), and other federal and commercial entities. Our extensive Program of Work includes broad areas of Mission Engineering and Systems Integration, Strategic Advantage and Warfighter Support, and Operational Enablers to federal government and commercial entities across the defense and national security sectors.

Job Description:

The Information Security Manager is a crucial mid-to-senior level role responsible for protecting ISA's corporate and client-facing information technology systems, ensuring rigorous regulatory compliance, and managing physical security infrastructure. In our organization, this professional serves as the primary Lead for Cybersecurity Maturity Model Certification (CMMC) compliance, actively performs Information System Security Manager (ISSM) duties for accredited networks, and oversees the comprehensive security administration and physical management of our Sensitive Compartmented Information Facility (SCIF).

Work Model:

Our people-first culture prioritizes the benefits of flexibility and collaboration. Consistent with government and industry standards that support a more fulsome return to in-office culture, ISA supports our clients and provides a working environment that promotes professional development opportunities through peer engagement and face-to-face mentoring. The ability to meet across teams at the office and cross-pollinate information is critical to our success.

Responsibilities:

The Data Engineer provides hands-on design, development, and maintenance of ETL/ELT pipelines and data infrastructure supporting ISA's data programs, while also supporting project performance, resource planning, and risk mitigation. They design and manage data structures across hybrid on-premises and cloud database environments, build and monitor automated pipelines, and ensure data models are optimized for downstream analytics and reporting platforms. The Data Engineer collaborates with cross-functional teams of analysts, project managers, and scientists, ensuring that technical solutions adhere to government data governance and security protocols, and serves as the primary technical point of contact for clients regarding pipeline status, technical roadblocks, and delivery.

Duties:

Designs, builds, tests, and maintains robust, scalable, and highly automated ETL/ELT pipelines to ingest data from diverse sources.

Ensures data models and pipelines are optimized to support seamless integration with business analytics platforms such as Power BI and Tableau.

Monitors and tunes data pipelines and database queries to ensure optimal performance, reliability, and data availability.

Works efficiently across hybrid environments, leveraging both on-premises databases (e.g., SQL Server, Oracle, PostgreSQL) and cloud data warehouses (e.g., Snowflake, Amazon Redshift, Google BigQuery, or Azure Synapse).

Implements data validation, error handling, and monitoring to ensure high data quality, accuracy, and security across all systems.

Collaborates with analysts, project managers, and business stakeholders to understand reporting needs and translates them into scalable data solutions.

Implements data quality checks and validation processes to ensure ongoing accuracy and reliability of production data.

Continuously improves pipeline efficiency, scalability, and maintainability through automation and best practices.

Embodies and reinforces ISA's culture and mission-focused delivery approach.

Other Duties:

The Intelligence and Security Associates, LLC jobs

Data Engineer