Data Engineer (AI & Automation)

Reston, VA
Full Time
Experienced

About the Role

IsI Enterprises is seeking a Data Engineer to join our new AI & Automation team. You will build the data foundation that powers AI-driven automation across our Security Control, Managed Services, and Managed Security Services business units. Working alongside the AI Solutions Architect and AI Software Engineer, you will own and evolve our Snowflake data platform and the AWS infrastructure around it, designing the pipelines and models that turn fragmented operational data (ticketing, compliance, telemetry, documentation) into trusted, secure, AI-ready datasets.
Because we serve Defense Industrial Base customers, you will treat security and data governance as first-class requirements, not afterthoughts.

Key Responsibilities

Data Pipeline Development
Design, build, and maintain scalable batch and streaming pipelines that ingest data from internal platforms, SaaS tools, cloud environments, and customer systems. Build reliable ETL/ELT processes with automated testing, validation, and monitoring. Model data in Snowflake (raw, curated, and consumption layers) so it is consistent, documented, and reusable across business units.
Snowflake Platform & AWS Infrastructure
Administer and optimize the Snowflake platform, including warehouses, roles and role-based access control, masking and data protection policies, network policies, scheduled tasks, and cost monitoring. Design, deploy, and maintain the supporting AWS infrastructure (e.g., S3, Lambda, ECS, IAM, networking, and secrets management) using Terraform as infrastructure as code. Integrate Snowflake and AWS logging with security monitoring tools such as Microsoft Sentinel.
AI & Automation Enablement
Partner with the AI Solutions Architect and AI Software Engineer to prepare data for LLM and automation use cases, including retrieval pipelines (RAG), embeddings and vector stores, and structured feature sets. Build the integrations that let AI-driven workflows read from and write back to operational systems. Support evaluation and observability of AI workflows through logging and quality metrics.
Security-First Data Engineering
Embed secure data practices into every pipeline, including encryption in transit and at rest, least-privilege access, secrets management, data classification, and audit logging. Enforce data segregation and handling requirements for sensitive and controlled information (e.g., CUI). Support CMMC, NIST SP 800-171, and related compliance obligations through documented, auditable data flows.
Data Quality, Reliability, and Operations
Monitor pipeline health, performance, and cost in production, and remediate failures quickly. Implement data quality checks, lineage, and alerting. Optimize storage and compute for performance and cost efficiency.
Collaboration and Process
Work with business unit stakeholders to understand operational problems and translate them into data requirements. Contribute through pull requests, code reviews, and agile ceremonies. Write clear technical documentation, including data dictionaries and architecture diagrams, and be prepared to defend design choices to the team. Leverage AI tooling to accelerate development and delivery.

Qualifications

  • As part of your work at ISI, you will potentially have access to sensitive information from the federal government. Pursuant to applicable regulations, ISI requires that all candidates for this role present proof of U.S. citizenship before hire.
  • Ability to obtain and maintain a U.S. Secret clearance
  • 4+ years of experience designing, building, and operating data pipelines in production
  • Strong proficiency in SQL and Python
  • Experience with relational databases, specifically PostgreSQL
  • Hands-on experience with Snowflake, including data modeling, RBAC, masking policies, and performance and cost optimization
  • Experience designing, deploying, and operating AWS infrastructure (e.g., S3, Lambda, ECS, IAM, VPC networking)
  • Hands-on experience with Terraform for infrastructure as code
  • Experience with workflow orchestration (e.g., Airflow, Dagster, Prefect) and transformation tooling (e.g., dbt)
  • Experience building integrations with REST APIs and third-party SaaS platforms
  • Experience using AI tooling such as Claude, Codex, or an equivalent service to develop enterprise software
  • Familiarity with version control (Git) and CI/CD practices
  • Excellent problem-solving and analytical skills with keen attention to detail
  • Ability to work independently and collaboratively in a fast-paced Agile environment
  • Strong communication and interpersonal skills, with the ability to interact effectively with team members at all levels

Preferred Qualifications

  • Bachelor's degree in computer science, data engineering, or a related technical field, or equivalent work or military experience
  • Experience preparing data for LLM applications, including RAG pipelines, embeddings, and vector databases (e.g., pgvector, OpenSearch, Pinecone)
  • Experience with AWS data services such as Glue, Athena, RDS, and Kinesis, and with AWS GovCloud
  • Experience with Snowflake features such as Snowpark, Cortex, scheduled tasks, and Snowflake-to-SIEM log integration
  • Experience with containerization (Docker, Kubernetes) and CI/CD for infrastructure deployments
  • Experience with streaming technologies (e.g., Kafka, Kinesis)
  • Familiarity with data governance, lineage, and cataloging practices
  • Familiarity with security frameworks and compliance requirements such as CMMC, NIST SP 800-171, DFARS, or FedRAMP
  • Experience working with data from security, IT service management, or MSP tooling (e.g., SIEM, ticketing, PSA/RMM platforms)

What We Offer

  • $130,000–$150,000 annual salary range
  • Remote work
  • A casual, friendly, and relaxed work environment
  • Professional growth encouragement and support
  • Medical, Dental, and Vision insurance with FSA and HSA options
  • PTO, 11 Paid Holidays, Paid Parental & Military Leave, and more
  • Life & Disability Insurance
  • 401K with match
Industrial Security Integrators, LLC ("IsI") is an equal opportunity employer committed to affirmative action and diversity in the workplace. It is the policy of IsI to provide Equal Employment Opportunities (EEO) to Employees and Applicants, without regard to race, color, religion, sex, age, marital status, citizenship status, national origin, sexual orientation, gender identity, veteran status or disability or any other factor protected by law and to provide advancement opportunities for minorities, women, disabled individuals, and veterans. IsI is stronger and more effective when our workforce includes highly qualified individuals with diverse backgrounds, cultures, and traditions.
Share

Apply for this position

Required*
We've received your resume. Click here to update it.
Attach resume or Paste resume
Attach resume as .pdf, .doc, .docx, .odt, .txt, or .rtf (limit 5MB) or Paste resume

Paste your resume here or Attach resume file

Invitation for Job Applicants to Self-Identify as a U.S. Veteran
  • A “disabled veteran” is one of the following:
    • a veteran of the U.S. military, ground, naval or air service who is entitled to compensation (or who but for the receipt of military retired pay would be entitled to compensation) under laws administered by the Secretary of Veterans Affairs; or
    • a person who was discharged or released from active duty because of a service-connected disability.
  • A “recently separated veteran” means any veteran during the three-year period beginning on the date of such veteran's discharge or release from active duty in the U.S. military, ground, naval, or air service.
  • An “active duty wartime or campaign badge veteran” means a veteran who served on active duty in the U.S. military, ground, naval or air service during a war, or in a campaign or expedition for which a campaign badge has been authorized under the laws administered by the Department of Defense.
  • An “Armed forces service medal veteran” means a veteran who, while serving on active duty in the U.S. military, ground, naval or air service, participated in a United States military operation for which an Armed Forces service medal was awarded pursuant to Executive Order 12985.
Veteran status


Voluntary Self-Identification of Disability
Voluntary Self-Identification of Disability Form CC-305
OMB Control Number 1250-0005
Expires 07/31/2029
Why are you being asked to complete this form?

We are a federal contractor or subcontractor. The law requires us to provide equal employment opportunity to qualified people with disabilities. We have a goal of having at least 7% of our workers as people with disabilities. The law says we must measure our progress towards this goal. To do this, we must ask applicants and employees if they have a disability or have ever had one. People can become disabled, so we need to ask this question at least every five years.

Completing this form is voluntary, and we hope that you will choose to do so. Your answer is confidential. No one who makes hiring decisions will see it. Your decision to complete the form and your answer will not harm you in any way. If you want to learn more about the law or this form, visit the U.S. Department of Labor’s Office of Federal Contract Compliance Programs (OFCCP) website at www.dol.gov/ofccp.

How do you know if you have a disability?

A disability is a condition that substantially limits one or more of your “major life activities.” If you have or have ever had such a condition, you are a person with a disability. Disabilities include, but are not limited to:

  • Alcohol or other substance use disorder (not currently using drugs illegally)
  • Autoimmune disorder, for example, lupus, fibromyalgia, rheumatoid arthritis, HIV/AIDS
  • Blind or low vision
  • Cancer (past or present)
  • Cardiovascular or heart disease
  • Celiac disease
  • Cerebral palsy
  • Deaf or serious difficulty hearing
  • Diabetes
  • Disfigurement, for example, disfigurement caused by burns, wounds, accidents, or congenital disorders
  • Epilepsy or other seizure disorder
  • Gastrointestinal disorders, for example, Crohn's Disease, irritable bowel syndrome
  • Intellectual or developmental disability
  • Mental health conditions, for example, depression, bipolar disorder, anxiety disorder, schizophrenia, PTSD
  • Missing limbs or partially missing limbs
  • Mobility impairment, benefiting from the use of a wheelchair, scooter, walker, leg brace(s) and/or other supports
  • Nervous system condition, for example, migraine headaches, Parkinson’s disease, multiple sclerosis (MS)
  • Neurodivergence, for example, attention-deficit/hyperactivity disorder (ADHD), autism spectrum disorder, dyslexia, dyspraxia, other learning disabilities
  • Partial or complete paralysis (any cause)
  • Pulmonary or respiratory conditions, for example, tuberculosis, asthma, emphysema
  • Short stature (dwarfism)
  • Traumatic brain injury
Please check one of the boxes below:

PUBLIC BURDEN STATEMENT: According to the Paperwork Reduction Act of 1995 no persons are required to respond to a collection of information unless such collection displays a valid OMB control number. This survey should take about 5 minutes to complete.

You must enter your name and date
Human Check*