AI Engineering Support with Security Clearance

LTC Solutions, L.L.C.; Arlington (VA); Hybrid; USD 90,000 - 130,000; Full time

Benefits offered by this job

401K

PTO

Health

Dental

Vision

Life

Disability Insurance

Job summary

LTC Solutions, LLC seeks an AI Engineer / Research Analyst to support HQMC, I&L, and GPN programs. Hybrid role at the Pentagon, developing and maintaining ETL/ELT pipelines, secure data architectures, and analytics for predictive insights and executive reporting.

The role requires DoD data governance, cybersecurity compliance, and collaboration with government stakeholders to enable scalable analytics, dashboards, and data-driven decision making.

Qualifications

• U.S. Citizen with an Active Secret security clearance and CAC access.
• Bachelor's degree in Computer Science, Data Science, Information Systems, Software Engineering, Data Engineering, Business Analytics, Mathematics, or a related discipline.
• Four (4) to seven (7) years of experience supporting DoD data engineering, BI, database development, analytics, or enterprise information management.
• Experience designing and developing automated ETL/ELT processes.
• Experience writing complex SQL queries and developing reusable database scripts.
• Experience using Python, SQL, and data transformation libraries for automation and data preparation.
• Experience developing secure data pipelines and preparing authoritative datasets for reporting and analytics.
• Experience supporting enterprise data governance, metadata management, and data quality initiatives.
• Working knowledge of DoD cybersecurity requirements, secure data handling procedures, and records management practices.
• Experience supporting BI environments using Power BI, Tableau, Microsoft Fabric, or similar tools.
• Strong analytical, technical writing, communication, and organizational skills.

Responsibilities

• Develop and maintain automated ETL/ELT processes for GPN analytics and enterprise reporting.
• Create and optimize complex SQL queries, stored procedures, and reusable scripts for data collection and reporting.
• Develop secure, reusable data pipelines for analytics and executive reporting.
• Validate, cleanse, normalize, and integrate data from multiple Government information systems.
• Implement data quality controls and metadata documentation to improve data integrity.
• Support development of enterprise BI architectures, reporting databases, and visualization back-ends.
• Prepare datasets supporting predictive analytics, ML models, and optimization efforts.
• Collaborate with Government stakeholders to define data standards, rules, dictionaries, and governance policies.
• Ensure compliance with DoW, USMC, DoD cybersecurity policies and governance standards.
• Document database structures, transformation logic, automated workflows, and data lineage.
• Assist with troubleshooting data quality issues, integration challenges, and reporting inconsistencies.
• Support secure data architectures to improve availability, reliability, and performance of analytics systems.
• Coordinate with AI Engineers, Data Analysts, BI developers, Government personnel, and system admins to support analytics initiatives.
• Participate in configuration management, version control, testing, deployment, and continuous improvement of data engineering solutions.
• Perform additional data engineering, BI, analytics, automation, and governance duties to fulfill contract requirements.

Skills

SQL

Python

ETL/ELT

Data governance

Data quality

BI tooling

Cybersecurity compliance

Data modeling

Analytical writing

Education

Bachelor's degree in CS/DS/IS/SE/DA/Math

Master's degree (preferred)

Tools

Power BI

Tableau

Microsoft Fabric

Azure Data Factory

Azure Synapse

Databricks

Snowflake

PostgreSQL

MS SQL Server

Git

Azure DevOps

Job description

LTC Solutions, LLC is a small business with a huge commitment to supporting our employees and providing quality services to our government clients. Our employees have an entrepreneurial spirit, a passion for excellence, and a proactive approach to providing the best possible solutions to our clients. If you are committed to building excellent client relationships, providing consistent superior-quality work, and taking initiative to understand your clients’ needs, we would like to meet you! LTC offers a dynamic team setting and generous benefits (including 401K, PTO, and Health, Dental, Vision, Life and Disability Insurance).

• 401K
• PTO
• Health
• Dental
• Vision
• Life
• Disability Insurance

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.

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

• U.S. Citizen with an Active Secret security clearance and ability to obtain a CAC card.
• Bachelor's degree in Computer Science, Data Science, Information Systems, Software Engineering, Data Engineering, Business Analytics, Mathematics, or a related discipline.
• Four (4) to seven (7) years of experience supporting Department of Defense data engineering, business intelligence, database development, analytics, or enterprise information management.
• Experience designing and developing automated data extraction, transformation, and loading (ETL/ELT) processes.
• Experience writing complex SQL queries and developing reusable database scripts.
• Experience using Python, SQL, and data transformation libraries for automation and data preparation.
• Experience developing secure data pipelines and preparing authoritative datasets for reporting and analytics.
• Experience supporting enterprise data governance, metadata management, and data quality initiatives.
• Working knowledge of Department of Defense cybersecurity requirements, secure data handling procedures, and records management practices.
• Experience supporting business intelligence environments using Power BI, Tableau, Microsoft Fabric, or similar reporting platforms.
• Strong analytical, technical writing, communication, and organizational skills.

Preferred Qualifications

• Master's degree in Data Science, Information Systems, Computer Science, Software Engineering, Business Analytics, or a related discipline.
• Experience supporting Headquarters Marine Corps, Department of the Navy, Joint Staff, or other Department of Defense headquarters organizations.
• Experience designing enterprise data warehouses, reporting architectures, or business intelligence platforms.
• Experience with Azure Data Factory, Microsoft Fabric, Databricks, Snowflake, or equivalent enterprise data engineering platforms.
• Experience supporting DevSecOps, CI/CD pipelines, Git, or Azure DevOps.
• Familiarity with artificial intelligence and machine learning data preparation techniques.
• Experience implementing enterprise data governance frameworks and data catalog solutions.
• Knowledge of DoD Zero Trust Architecture, RMF, and cybersecurity compliance requirements.

Primary Duties

• Develop and maintain automated data extraction, transformation, validation, and loading (ETL/ELT) processes supporting GPN analytics and enterprise reporting.
• Create and optimize complex SQL queries, stored procedures, and reusable scripts that automate recurring data collection and reporting activities.
• Develop secure, reusable data pipelines that prepare authoritative datasets for analytics, artificial intelligence, business intelligence, and executive reporting.
• Validate, cleanse, normalize, and integrate structured and unstructured data from multiple Government information systems.
• Implement enterprise data quality controls, validation routines, reconciliation processes, and metadata documentation to improve data integrity.
• Support development and maintenance of enterprise business intelligence architectures, reporting databases, and visualization back‑end environments.
• Prepare datasets supporting predictive analytics, machine learning models, simulation activities, and operational research efforts performed by senior AI engineers and data scientists.
• Collaborate with Government stakeholders to define data standards, business rules, data dictionaries, and governance policies.
• 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.
• Document database structures, transformation logic, automated workflows, technical procedures, and data lineage supporting long‑term sustainment.
• Assist with troubleshooting data quality issues, system integration challenges, and reporting inconsistencies.
• Support implementation of secure data architectures that improve availability, reliability, scalability, and performance of analytical systems.
• Coordinate with AI Engineers, Data Analysts, Business Intelligence developers, Government personnel, and system administrators to support enterprise analytics initiatives.
• Participate in configuration management, version control, testing, deployment, and continuous improvement of enterprise data engineering solutions.
• Perform additional data engineering, business intelligence, analytics, automation, and governance duties necessary to accomplish contract requirements.

Preferred Technical Skills

• Python
• SQL
• Power BI
• Tableau
• Microsoft Fabric
• Azure Data Factory
• Azure Synapse Analytics
• Databricks
• Snowflake
• PostgreSQL
• Microsoft SQL Server
• Git
• Azure DevOps
• ETL/ELT Development
• Data Warehousing
• REST APIs
• JSON/XML
• Data Governance
• Metadata Management
• Data Lineage
• RMF
• Zero Trust Architecture

LTC Solutions is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or veteran status.