Data Management and Automation Specialist - NCR

LMI Consulting, LLC; Washington (District of Columbia); On-site; USD 151,000 - 179,000; Full time

Job summary

LMI seeks a Data Management and Automation Specialist to analyze, automate, and sustain administrative workflows for a Joint Staff element. The specialist builds data solutions, improves reporting, and keeps headquarters information accurate and accessible.

This on-site role in the National Capital Region requires an active TS/SCI clearance and occasional travel to commands, units, and industry locations.

Qualifications

• Bachelor's degree or equivalent in a related field and 4+ years in data management, BI, automation, or analytics.
• Hands-on experience with Microsoft Power BI, Power Automate, Power Apps, SharePoint, Excel or similar tools.
• Ability to translate business requirements into data models and automated workflows.
• Knowledge of data governance, access control, and data quality principles.
• Excellent written communication and ability to train users.

Responsibilities

• Analyze current administrative workflows to identify data gaps and opportunities for automation.
• Design, build, test, and maintain data management and automation solutions using Microsoft 365 tools.
• Develop dashboards, trackers, notifications, forms, and reports to improve visibility and reduce cycle time.
• Integrate data from multiple sources while preserving data lineage and access controls.
• Ensure data quality through validation, reconciliation, and issue tracking.

Skills

Data analytics

Workflow automation

Communication

Independent work

Education

Bachelor's degree in data analytics, information systems, computer science, business analytics, engineering, or related field

Tools

Power BI

Power Automate

Power Apps

SharePoint

Excel

Microsoft 365

Job description

Data Management and Automation Specialist - NCR

Job Locations: US-DC-Washington, DC

ID: 2026-14546

# of Openings: 1

Overview

LMI seeks a Data Management and Automation Specialist to analyze, automate, and sustain administrative workflows for a Joint Staff element. The specialist builds and maintain office data solutions, improve reporting, reduce manual workload, and keep headquarters information accurate and accessible. The ideal candidate pairs strong data discipline with practical automation skills and translates user needs into reliable, secure, easy-to-use solutions. This position requires on-site support in the National Capital Region and an active Top Secret/Sensitive Compartmented Information (TS/SCI) clearance. The position requires periodic travel to supported commands, operational units, exercises, test events, and industry locations.

LMI is a new breed of digital solutions provider dedicated to accelerating government impact with innovation and speed. Investing in technology and prototypes ahead of need, LMI brings commercial-grade platforms and mission-ready AI to federal agencies at commercial speed.

Leveraging our mission-ready technology and solutions, proven expertise in federal deployment, and strategic relationships, we enhance outcomes for the government efficiently and effectively. With a focus on agility and collaboration, LMI serves the defense, space, healthcare, and energy sectors, helping agencies navigate complexity and outpace change. Headquartered in Tysons, Virginia, LMI is committed to delivering impactful results that strengthen missions and drive lasting value.

Responsibilities

• Analyze current administrative and force management workflows to identify data gaps, manual handoffs, duplicate effort, and opportunities for automation.
• Design, build, test, and maintain approved data management and workflow automation solutions using Microsoft 365, Power Platform, SharePoint, Excel, and other customer-authorized tools.
• Develop dashboards, trackers, automated notifications, approval workflows, forms, and reports that improve visibility and reduce administrative cycle time.
• Integrate data from multiple headquarters sources while preserving data lineage, access controls, classification markings, and authoritative-source relationships.
• Establish and execute data quality controls, including validation rules, reconciliation processes, duplicate detection, issue tracking, and routine accuracy reviews.
• Gather requirements from administrative, force management, security, facilities, supply, and executive support stakeholders and translate them into practical technical solutions.
• Document data definitions, solution architecture, business rules, standard operating procedures, user guides, and sustainment requirements.
• Provide user training, troubleshooting, and adoption support for developed solutions.
• Monitor solution performance, resolve defects, manage configuration changes, and coordinate updates with customer information technology and cybersecurity personnel.
• Prepare recurring and ad hoc analysis that supports manpower, workload, tasking, travel, facilities, supply, and headquarters decision-making.
• Support governance of shared data repositories, permissions, retention practices, and version control.
• Continuously improve solutions based on user feedback, changing mission requirements, and lessons learned.

Qualifications

Required Qualifications:

• Bachelor's degree in data analytics, information systems, computer science, business analytics, engineering, or a related field, or equivalent education and experience.
• Four or more years of experience in data management, business intelligence, workflow automation, application development, analytics, or a related discipline.
• Active TS/SCI clearance.
• Hands-on experience developing solutions with Microsoft Power BI, Power Automate, Power Apps, SharePoint, Excel, or comparable enterprise tools.
• Experience collecting and translating business requirements into data models, dashboards, automated workflows, and user‑facing solutions.
• Working knowledge of data quality, data governance, access control, records management, and configuration management principles.
• Ability to troubleshoot data and workflow issues, perform root‑cause analysis, and implement sustainable corrective actions.
• Strong written communication, documentation, customer engagement, and user training skills.
• Ability to work independently while coordinating effectively with administrative users, technical teams, and senior stakeholders.
• Proficiency with Microsoft 365 collaboration and productivity applications.

Desired Qualifications:

• Experience supporting the Joint Staff, a combatant command, a Service headquarters, or another Department of Defense organization.
• Experience with Dataverse, SQL, Python, application programming interfaces, or cloud-hosted data services.
• Experience developing solutions in classified or tightly controlled government environments.
• Microsoft Power BI, Power Platform, data analytics, Agile, or related professional certification.

Target salary range: $151,000 - $179,000

Disclaimer:

The salary range displayed represents the typical salary range for this position and is not a guarantee of compensation. Individual salaries are determined by various factors including, but not limited to location, internal equity, business considerations, client contract requirements, and candidate qualifications, such as education, experience, skills, and security clearances.

Job Locations

US-DC-Washington, DC

LMI is an Equal Opportunity Employer

LMI is committed to the fair treatment of all and to our policy of providing applicants and employees with equal employment opportunities. LMI recruits, hires, trains, and promotes people without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, pregnancy, disability, age, protected veteran status, citizenship status, genetic information, or any other characteristic protected by applicable federal, state, or local law. If you are a person with a disability needing assistance with the application process, please contact [e-mail]

Colorado Residents: In any materials you submit, you may redact or remove age-identifying information such as age, date of birth, or dates of school attendance or graduation. You will not be penalized for redacting or removing this information.