Data Architect / Data Engineer

The Lockwood Group; Rockaway Township (NJ); Hybrid; USD 120,000 - 170,000; Full time

Benefits offered by this job

Medical, dental, and vision insurance

401k plan with employer match

Paid time off and holidays

Life insurance and disability options

Voluntary supplemental options

Job summary

The Lockwood Group is seeking a data architecture/engineering specialist to design, implement, and maintain enterprise data infrastructure and AI/ML pipelines for DEVCOM-AC at Picatinny Arsenal, NJ. The role focuses on data transformation, modeling, and actionable analytics to support decision-making and capabilities analysis.

The position is hybrid (75% onsite at Picatinny Arsenal) and requires U.S. citizenship with an active Secret clearance preferred.

Qualifications

• Bachelor's degree in Computer Science, Data Science, Engineering, or Mathematics.
• Minimum 5 years of experience in data architecture, data engineering, or AI/ML engineering.
• Experience with Python 3 scripts to pull data from multiple sources.
• Experience building Power BI dashboards.
• Experience with DoD or national security environments.

Responsibilities

• Conceptualize and design use cases turning raw data into actionable insights.
• Write and maintain Python scripts to pull data from multiple sources.
• Run locally hosted LLMs to generate summaries and enrichments.
• Design, test, and document prompts for output formats (JSON, summaries, tags).
• Build and update Power BI dashboards and configure data gateway.
• Generate PDF/Word/HTML deliverables using open source libraries.
• Document datasets, workflows, scripts, and dashboards for reproducibility.
• Develop robust data cleaning, transformation, and modeling pipelines.

Skills

Python scripting

Power BI dashboards

Data architecture

Data modeling

AI/ML pipelines

LLM usage

Education

Bachelors in CS/DS/Engineering/Math

Tools

Power BI

Ollama/LM Studio

SAM.gov API

Python tooling

Job description

Provide data architecture/engineering support to the U.S. Army Combat Capabilities Development Command – Armaments Center (DEVCOM-AC) Headquarters and its subordinate directorates located at Picatinny Arsenal, NJ. 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.

***Must be US Citizen, prefer active Secret clearance. Hybrid role, 75% onsite work at Picatinny Arsenal, NJ ***

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
• Data architecture, data modeling, data 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 an active Secret security clearance.
• Experience running locally hosted LLMs (Ollama or LM Studio) to generate deterministic summaries, classifications, and other natural-language enrichments.

Why Join The Lockwood Group

The Lockwood Group offers a comprehensive and generous benefits package.

• 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
• employees are eligible to enroll in the company's 401k plan
• employees will also accrue paid time off and holidays
• additional voluntary options include supplemental insurance plans

Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, pregnancy, genetic information, disability, status as a protected veteran, or any other protected category under applicable federal, state, and local laws.