← All roles

Data Warehousing Specialist, (SME)

Agile Defense· Corporate – Operations & Program Management
Apply on company site
Hybrid (Arlington, VA)$132k - $144kRegularPosted 1w ago

About the role

Data Warehousing Specialist, SME to lead data governance, data quality, and enterprise data management initiatives for a large federal agency, with responsibilities spanning reporting, data profiling, migration, governance, and data integration in a government environment.

Responsibilities

  • Lead the design, development, and delivery of enterprise reporting solutions and interactive dashboards using Power BI
  • Perform comprehensive data profiling, cleansing, standardization, and validation activities
  • Analyze structured and unstructured data to identify trends and translate findings into actionable recommendations
  • Plan, coordinate, and execute data migration efforts from legacy systems to modern databases
  • Assess data repositories for compliance with governance policies and recommend corrective actions
  • Develop, maintain, and optimize database queries and data extraction routines using ANSI SQL and other languages
  • Conduct recurring audits of databases to verify data integrity and standards
  • Support development and implementation of enterprise data solutions to improve reporting capabilities
  • Maintain current databases, tables, views, stored procedures, and other objects for reliability
  • Collaborate with project teams and stakeholders to address data issues and implement solutions
  • Identify opportunities to improve data management, reporting, and governance processes
  • Develop and implement monitoring processes and metrics to track data quality and governance progress
  • Coordinate with cross-functional teams to ensure milestones and deadlines are met

Qualifications

  • Bachelor’s degree in a relevant discipline
  • 5+ years of experience with data architecture, data management, data analysis, IT process reengineering, systems analysis, design, and implementation, and data modeling

Skills

Required:Data migration/integrationData AnalysisSQL (ANSI SQL)MS Office Suite
Nice to have:Tableau, Power BIMaster Data ManagementData Integration and Data MigrationMicrosoft Power Apps

Benefits

  • Health Insurance
  • Life Insurance
  • Paid Time Off
  • Holiday Pay
  • short-term and long-term Disability
  • Retirement and Learning and Development opportunities
  • other optional benefit elections
Last updated Oct 21, 2026. Interested? Apply on the company site.

About Agile Defense

Always Evolving

Agile Defense delivers advanced capabilities and solutions tailored to the most critical national security and civilian missions.

national securitycivilian missionsinnovationcapabilitiessolutions
Company profileWebsite

More open roles at Agile Defense