AI Engineering Support US Citizens only, active TS/SCI clearance required

LTC Solutions LLC

$100K — $120K *
Aerospace & Defense
Less than 5 years of experience
Job Overview by Ladders

Qualifications

  • Active Top Secret/SCI Clearance required
  • Bachelor's degree in a related discipline
  • 4-7 years supporting DoD data engineering and analytics
  • Experience in automated ETL/ELT process development
  • Proficient in SQL and Python for data preparation
  • Knowledge of data governance and quality control
  • Experience with business intelligence tools such as Power BI or Tableau

Responsibilities

  • Develop and maintain ETL/ELT processes for GPN analytics
  • Optimize SQL queries and scripts for automation
  • Create secure data pipelines for analytics and reporting
  • Cleanse and integrate data from various Government systems
  • Implement enterprise data quality controls and documentation
  • Support business intelligence architecture and visualization environments
  • Collaborate with stakeholders on data standards and governance

Benefits

  • Hybrid work environment with on-site support at the Pentagon
  • Collaboration with senior analytics leadership
  • Opportunity to work on high-impact defense projects
  • Access to advanced tools and technologies in data engineering
  • Engagement with various DoD organizational stakeholders
Full Job Description
POSITION DESCRIPTION: AI Engineering Support Location: Pentagon, Arlington, VA (Hybrid) Status: Contingent Hire - Full-Time - Hybrid Clearance: Active Top Secret/SCI Clearance Required MUST HAVE: Demonstrated experience supporting Department of Defense data engineering, business intelligence, data governance, automated data pipelines, and enterprise analytics supporting operational decision-making. Position Summary The AI Engineer / Research Analyst provides mid-level data engineering, business intelligence, and applied analytics support to Headquarters Marine Corps (HQMC), Installations and Logistics (I&L), and the Global Positioning Network (GPN) Program. Working in a hybrid capacity supporting the Pentagon, the position develops and maintains data extraction, transformation, validation, and integration processes that convert raw operational data into secure, authoritative datasets supporting advanced analytics and executive decision-making. The AI Engineer supports enterprise data engineering activities by developing automated queries, reusable data pipelines, data quality processes, and business intelligence solutions while ensuring compliance with Department of War (DoW), U.S. Marine Corps (USMC), and Department of Defense cybersecurity, records management, and data governance requirements. Working under the direction of senior analytics leadership, the position supports the development of scalable data architectures that enable predictive analytics, dashboard development, artificial intelligence, and operational reporting. The position collaborates with Headquarters Marine Corps organizations, Government data owners, system administrators, and analytics personnel to improve data accessibility, quality, security, and enterprise reporting capabilities. Required Qualifications 3 U.S. Citizen with an Active Secret security clearance and ability to obtain a CAC card. 3 Bachelors degree in Computer Science, Data Science, Information Systems, Software Engineering, Data Engineering, Business Analytics, Mathematics, or a related discipline. 3 Four (4) to seven (7) years of experience supporting Department of Defense data engineering, business intelligence, database development, analytics, or enterprise information management. 3 Experience designing and developing automated data extraction, transformation, and loading (ETL/ELT) processes. 3 Experience writing complex SQL queries and developing reusable database scripts. 3 Experience using Python, SQL, and data transformation libraries for automation and data preparation. 3 Experience developing secure data pipelines and preparing authoritative datasets for reporting and analytics. 3 Experience supporting enterprise data governance, metadata management, and data quality initiatives. 3 Working knowledge of Department of Defense cybersecurity requirements, secure data handling procedures, and records management practices. 3 Experience supporting business intelligence environments using Power BI, Tableau, Microsoft Fabric, or similar reporting platforms. 3 Strong analytical, technical writing, communication, and organizational skills. Preferred Qualifications 3 Masters degree in Data Science, Information Systems, Computer Science, Software Engineering, Business Analytics, or a related discipline. 3 Experience supporting Headquarters Marine Corps, Department of the Navy, Joint Staff, or other Department of Defense headquarters organizations. 3 Experience designing enterprise data warehouses, reporting architectures, or business intelligence platforms. 3 Experience with Azure Data Factory, Microsoft Fabric, Databricks, Snowflake, or equivalent enterprise data engineering platforms. 3 Experience supporting DevSecOps, CI/CD pipelines, Git, or Azure DevOps. 3 Familiarity with artificial intelligence and machine learning data preparation techniques. 3 Experience implementing enterprise data governance frameworks and data catalog solutions. 3 Knowledge of DoD Zero Trust Architecture, RMF, and cybersecurity compliance requirements. Primary Duties 3 Develop and maintain automated data extraction, transformation, validation, and loading (ETL/ELT) processes supporting GPN analytics and enterprise reporting. 3 Create and optimize complex SQL queries, stored procedures, and reusable scripts that automate recurring data collection and reporting activities. 3 Develop secure, reusable data pipelines that prepare authoritative datasets for analytics, artificial intelligence, business intelligence, and executive reporting. 3 Validate, cleanse, normalize, and integrate structured and unstructured data from multiple Government information systems. 3 Implement enterprise data quality controls, validation routines, reconciliation processes, and metadata documentation to improve data integrity. 3 Support development and maintenance of enterprise business intelligence architectures, reporting databases, and visualization back-end environments. 3 Prepare datasets supporting predictive analytics, machine learning models, simulation activities, and operational research efforts performed by senior AI engineers and data scientists. 3 Collaborate with Government stakeholders to define data standards, business rules, data dictionaries, and governance policies. 3 Ensure compliance with Department of War (DoW), U.S. Marine Corps (USMC), Department of Defense cybersecurity policies, records management requirements, and enterprise data governance standards. 3 Document database structures, transformation logic, automated workflows, technical procedures, and data lineage supporting long-term sustainment. 3 Assist with troubleshooting data quality issues, system integration challenges, and reporting inconsistencies. 3 Support implementation of secure data architectures that improve availability, reliability, scalability, and performance of analytical systems. 3 Coordinate with AI Engineers, Data Analysts, Business Intelligence developers, Government personnel, and system administrators to support enterprise analytics initiatives. 3 Participate in configuration management, version control, testing, deployment, and continuous improvement of enterprise data engineering solutions. 3 Perform additional data engineering, business intelligence, analytics, automation, and governance duties necessary to accomplish contract requirements. Preferred Technical Skills 3 Python 3 SQL 3 Power BI 3 Tableau 3 Microsoft Fabric 3 Azure Data Factory 3 Azure Synapse Analytics 3 Databricks 3 Snowflake 3 PostgreSQL 3 Microsoft SQL Server 3 Git 3 Azure DevOps 3 ETL/ELT Development 3 Data Warehousing 3 REST APIs 3 JSON/XML 3 Data Governance 3 Metadata Management 3 Data Lineage 3 RMF 3 Zero Trust Architecture

Similar Jobs

More Jobs at LTC Solutions LLC

More Aerospace & Defense Jobs

Find similar AI Engineering Support US Citizens only, active TS/SCI clearance required jobs: