Data Warehousing Specialist, SME

Posted: 2026-10-07

About Agile Defense   At Agile Defense we know that action defines the outcome and new challenges require new solutions. That’s why we always look to the future and embrace change with an unmovable spirit and the courage to build for what comes next.   Our vision is to bring adaptive innovation to support our nation's most important missions through the seamless integration of advanced technologies, elite minds, and unparalleled agility—leveraging a foundation of speed, flexibility, and ingenuity to strengthen and protect our nation’s vital interests.

Requisition #: 1918 Job Title: Data Warehousing Specialist, SME Clearance Level: Must be able to obtain and maintain a Public Trust Clearance which requires U.S. Citizenship

Agile Defense is an award-winning and growing company with an immediate need for a skilled, confident, and energetic Data Warehousing Specialist, SME to support a large federal agency through business case and business process analysis initiatives. This role is responsible for leading the development and implementation of organization-wide data policies, standards, and processes that strengthen enterprise data management practices. The Data Warehousing Specialist provides strategic oversight and execution of the agency’s data governance and data quality framework, ensuring data assets are managed effectively, consistently, and in alignment with mission and operational objectives. The ideal candidate brings strong analytical and communication skills, expertise in data governance and quality management, and the ability to operate effectively in a complex, fast-paced government environment.

JOB DUTIES AND RESPONSIBILITIES

The Data Warehousing Specialist (SME) will support the following areas:

- Lead the design, development, and delivery of enterprise reporting solutions and interactive dashboards using Power BI, enabling stakeholders to access meaningful insights, monitor key performance indicators, and support data-driven decision-making across the organization.

- Perform comprehensive data profiling, cleansing, standardization, and validation activities, including the removal of duplicate, incomplete, outdated, or irrelevant data, to improve overall data quality, usability, and consistency across systems and reporting platforms.

- Analyze structured and unstructured data from multiple systems, databases, and file formats to identify trends, anomalies, and patterns, while translating findings into actionable recommendations for business and technical stakeholders.

- Plan, coordinate, and execute data migration efforts from legacy systems to modern database environments, ensuring data is accurately mapped, transformed, validated, and transitioned with minimal disruption to operations.