AI Engineering Support with Security Clearance

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

Benefits offered by this job

401K

PTO

Health insurance

Dental insurance

Vision insurance

Life insurance

Disability insurance

Job summary

LTC Solutions, LLC is seeking an AI Engineer / Research Analyst to deliver mid-level data engineering, BI, and analytics support to HQMC, I&L, and GPN programs. The role focuses on automated data pipelines, secure datasets, and enterprise reporting in a hybrid Pentagon setting.

The candidate will develop scalable data architectures, apply AI-ready data workflows, and collaborate with government data owners, system admins, and analytics teams to enable predictive analytics and executive

Qualifications

• Experience supporting Department of Defense data engineering, BI, data governance, ETL/ELT, and enterprise analytics for operational decision-making.
• U.S. Citizen with Active Secret security clearance and CAC eligibility.
• Bachelor's degree in Computer Science, Data Science, Information Systems, Software Engineering, Data Engineering, Business Analytics, Mathematics, or related field.
• 4–7 years of experience in DoD data engineering, BI, analytics, or enterprise information management.
• Experience designing and developing ETL/ELT processes.
• Experience writing complex SQL queries and reusable scripts.
• Experience using Python, SQL, and data transformation libraries for automation and data prep.
• Experience developing secure data pipelines and authoritative datasets for reporting.
• Experience supporting enterprise data governance, metadata management, and data quality initiatives.
• Knowledge of DoD cybersecurity requirements, secure data handling, and records management.

Responsibilities

• Develop and maintain automated ETL/ELT processes supporting GPN analytics and enterprise reporting.
• Create and optimize complex SQL queries, stored procedures, and reusable scripts for recurring data collection and reporting.
• Develop secure, reusable data pipelines for analytics, AI, BI, and executive reporting.
• Validate, cleanse, normalize, and integrate structured and unstructured data from multiple Government systems.
• Implement data quality controls, validation routines, reconciliation processes, and metadata documentation.
• Support development of enterprise BI architectures, reporting databases, and visualization back-ends.
• Prepare datasets for predictive analytics, ML models, and operational research by senior engineers.
• Collaborate with Government stakeholders to define data standards, rules, dictionaries, and governance policies.
• Ensure compliance with DoW, USMC, DoD cybersecurity and governance standards.
• Document database structures, transformation logic, workflows, and data lineage for sustainment.
• Troubleshoot data quality issues, integration challenges, and reporting inconsistencies.
• Support secure data architectures to improve availability, reliability, and performance of analytics.
• Coordinate with AI Engineers, Data Analysts, BI developers, Government personnel, and system admins for enterprise analytics.
• Participate in CM, version control, testing, deployment, and continuous improvement of engineering solutions.
• Perform additional data engineering, BI, analytics, automation, and governance duties as needed.

Skills

Python

SQL

Power BI

Tableau

Azure Data Factory

Azure Synapse Analytics

Databricks

Snowflake

Data Governance

RMF / DoD cybersecurity

Education

Bachelor's degree in Computer Science

Master's degree in Data Science

Tools

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

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

POSITION DESCRIPTION

Location: Pentagon, Arlington, VA (Hybrid) Status: Contingent Hire – Full-Time – Hybrid Clearance: Active Top Secret/SCI Clearance Required

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

• Demonstrated experience supporting Department of Defense data engineering, business intelligence, data governance, automated data pipelines, and enterprise analytics supporting operational decision‑making.
• 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.