Data Architect - US Army Support

WisEngineering•Dover, NJ

10d•Onsite

About The Position

WisEngineering is seeking a highly technical Data Analyst / Data Architect to support an upcoming opportunity for Department of Defense programs at Picatinny Arsenal. This is not a traditional business analyst role; it requires a hands-on technical professional who can maintain localized AI infrastructure, engineer data pipelines, and build robust business intelligence dashboards. You will bridge the gap between system administration, data engineering, and applied AI. Your primary focus will be supporting locally hosted Large Language Models (LLMs), identifying and scraping web data to enrich these models, performing system administration duties for the AI environment, and building tracking metrics and reports for leadership.

Requirements

U.S. Citizenship REQUIRED due to DoD security clearance requirements
Ability to obtain and maintain a security clearance, if required.
Proficient in Python (for data manipulation and web scraping) and Power BI (for advanced DAX data modeling and visualization).
Hands-on experience configuring and managing Ollama, LM Studio, and open-source models like Gemma.
Strong familiarity with Microsoft Lists, SharePoint, and Power Platform integration.
Proven ability to scrape web data and clean unstructured text/data formats (PDFs, APIs, free-text).
Bachelor’s degree in Computer Science, Data Science, Information Technology, or a related technical field, paired with 3+ years of relevant technical experience (or equivalent combined education and experience).

Nice To Haves

Military Experience

Responsibilities

Serve as the technical point of contact for locally hosted LLM environments utilizing Ollama and LM Studio, specifically supporting the Gemma model family.
Perform troubleshooting and optimization for the local AI/LLM setup.
Actively identify external and internal data gaps needed to train or ground the LLM.
Write and maintain Python web-scraping scripts to safely harvest relevant web data.
Create and maintain data models to support analytics and reporting needs, ensuring scalability and performance optimization.
Ability to write clear and comprehensive documentation for datasets, workflows, scripts, and dashboards to ensure reproducibility and knowledge sharing.
Ensure all data ingestion, scraping, and LLM querying adhere to strict DoD guidelines.
Conceptualize and design high‑impact use cases that turn raw, unstructured data (web pages, PDFs, free‑text fields, etc) into actionable insights.
Develop, test, and refine complex prompts to extract deterministic summaries, classifications, and research insights from the LLM.
Utilize the localized LLM environment to conduct deep-dive research and generate automated intelligence reports for program stakeholders.
Generate PDF/Word/HTML deliverables as needed using open source libraries.
Design, build, and maintain high-impact performance metrics and interactive dashboards using Microsoft Power BI.
Configure and maintain Microsoft Lists and Excel/SharePoint environments to track program data, ensuring seamless integration with Power BI.
Write and maintain Python 3 scripts to pull, clean, and transform data from varied sources (Excel, CSV, JSON, Markdown, APIs, and scraped web content) into structured data models.