Data Architect / Engineer with Security Clearance

Key Responsibilities

• Conceptualize and design high-impact use cases that turn raw, unstructured data (web pages, PDFs, free-text fields, etc) into actionable insights—acting as the “solutions architect” for each product by defining what to extract, how it will be used downstream, and documenting the business value.
• Write & maintain Python 3 scripts that pull data from Excel/CSV/JSON/Markdown sources, SAM.gov API, and internal documents.
• Run locally hosted LLMs (Ollama or LM Studio) to generate deterministic summaries, classifications, and other natural-language enrichments.
• Prompt engineering: design, test, version, and document prompts that consistently produce the required output format (JSON, short summary, tags).
• Build and update Power BI dashboards; configure the on-premises data gateway for scheduled refreshes.
• Generate PDF/Word/HTML deliverables as needed using open source libraries.

Data Documentation

Ability to write clear and comprehensive documentation for datasets, workflows, scripts, and dashboards to ensure reproducibility and knowledge sharing.

Data Cleaning and Transformation

Develop robust pipelines to clean, preprocess, and transform raw data into usable formats for analysis and reporting.

Data Modeling and Analytics

Create and maintain data models to support analytics and reporting needs, ensuring scalability and performance optimization.

Ideal Candidate Qualifications

• Experience writing Python 3 scripts to pull data from multiple sources
• Experience building Power BI dashboards
• Experience in data architecture, data engineering, or AI/ML engineering
• Bachelor's in Computer Science, Data Science, Engineering, Mathematics
• Minimum 5 years of experience in data architecture, data engineering, or AI/ML engineering
• DoD or national security environment experience
• Currently holds an active Secret security clearance
• Experience running locally hosted LLMs (Ollama or LM Studio) to generate deterministic summaries, classifications, and other natural-language enrichments

About the Role

Operating in support of the Office of the Assistant Chief of Staff for Strategic Communications (G9), Innovation & Strategic Relationships Team, this role is responsible for designing, implementing, and maintaining enterprise data infrastructure and AI/ML pipelines that enable data-driven decision-making and industry capabilities analysis.

Schedule

Hybrid role, 75% onsite.

Benefits

The Lockwood Group offers a comprehensive and generous benefits package including medical, dental, and vision insurance for the employee and/or families, basic life insurance for the employee plus an option to purchase short- and long-term disability, and eligibility to enroll in the company's 401k plan. Employees accrue paid time off and holidays, and additional voluntary options include supplemental insurance plans. The Lockwood Group is committed to non-discrimination and equal employment opportunity.