Browse JobsCareer BlogJob Search ResourcesAI Interview PreparationWorkzil HomeJob ListingsPricing PlansContact UsCreate AccountHiring SolutionsSecurity & PrivacyAffiliate ProgramFree CV BuilderAI CV ReviewerFree Resume BuilderAI Resume ReviewerSalary CalculatorSalary Comparison ChartsLayoff TrackerLayoff NewsHiring Trends 2026Startup Funding TrackerCompany Expansion TrackerVisa Sponsorship CompaniesBest Companies to Work ForBlog ArticlesCareer ResourcesAI Interview PrepTerms of ServicePrivacy PolicyCookie PolicyPost a JobAI Candidate ScreeningEmployer PricingEnterprise SolutionsJobs in New YorkJobs in San FranciscoJobs in AustinJobs in SeattleJobs in ChicagoJobs in Los AngelesJobs in BostonJobs in DenverJobs in AtlantaJobs in MiamiJobs in DallasJobs in Washington DCJobs in San JoseJobs in RaleighJobs in NashvilleSoftware Engineer JobsData Scientist JobsProduct Manager JobsData Analyst JobsUX Designer JobsFrontend Developer JobsDevOps Engineer JobsMarketing Manager JobsFinancial Analyst JobsCybersecurity Analyst JobsSoftware Engineer Salary GuideData Scientist SalaryProduct Manager SalaryUX Designer SalaryDevOps Engineer SalaryCloud Architect SalarySoftware Engineer Salary CalculatorData Scientist Salary CalculatorProduct Manager Salary CalculatorSoftware Engineer Salary San FranciscoSoftware Engineer Salary New YorkData Scientist Salary SeattleProduct Manager Salary AustinDevOps Engineer Salary CalculatorUX Designer Salary CalculatorSoftware Engineer Interview QuestionsProduct Manager Interview QuestionsData Scientist Interview QuestionsUX Designer Interview QuestionsFrontend Developer Interview QuestionsRemote Software Engineer JobsRemote Product Manager JobsRemote Data Analyst JobsRemote UX Designer JobsRemote Frontend Developer JobsElectrician JobsPlumber JobsHVAC Technician JobsRegistered Nurse JobsTruck Driver JobsWarehouse Worker JobsCarpenter JobsWelder JobsRestaurant Manager JobsConstruction Manager JobsDental Hygienist JobsReal Estate Agent JobsElectrician Salary GuidePlumber Salary GuideRegistered Nurse SalaryTruck Driver SalaryHVAC Technician SalaryWelder Salary GuideElectrician Interview QuestionsNursing Interview QuestionsTruck Driver Interview QuestionsRestaurant Manager Interview QuestionsLayoffs 2026Layoffs 2025Layoffs 2024Layoffs 2023Google LayoffsMeta LayoffsAmazon LayoffsMicrosoft LayoffsSoftware Engineer Resume BuilderData Scientist Resume BuilderProduct Manager Resume BuilderRegistered Nurse Resume BuilderMarketing Manager Resume BuilderTechnology Industry JobsFinance Industry JobsHealthcare Industry JobsConstruction & Trades JobsRetail & E-Commerce JobsSoftware Engineer vs Data ScientistSoftware Engineer vs Product ManagerData Scientist vs Data AnalystFrontend vs Backend DeveloperProduct Manager vs Project ManagerElectrician vs Plumber
    WorkzilWorkzil
    Find Jobs
    Pricing
    Sign inGet Started
    • Find Jobs
    • Companies
    • AI Interview Prep
    • For Employers
    • Intelligence
    • Pricing
    • Support
    • Free Tools
      • CV / Resume Builder
      • CV / Resume Reviewer
      • Salary Calculator
      • Salary Comparison
    • Company Intelligence
      • Layoff Tracker
      • Hiring Trends
      • Funding Tracker
      • Expansion News
      • Visa Sponsorship
      • Layoff News
    • Career Research
      • Best Companies
      • Industry Guides
      • Compare Roles
      • Salary Guides
      • Interview Questions
      • Remote Jobs
    • Resources
      • Blog
      • Resources
      • Community
    • Post a Job
    • Sign Up
    • Sign In
    • Contact
    WorkzilWorkzil
    Find Jobs
    Pricing
    Sign inGet Started
    • Find Jobs
    • Companies
    • AI Interview Prep
    • For Employers
    • Intelligence
    • Pricing
    • Support
    • Free Tools
      • CV / Resume Builder
      • CV / Resume Reviewer
      • Salary Calculator
      • Salary Comparison
    • Company Intelligence
      • Layoff Tracker
      • Hiring Trends
      • Funding Tracker
      • Expansion News
      • Visa Sponsorship
      • Layoff News
    • Career Research
      • Best Companies
      • Industry Guides
      • Compare Roles
      • Salary Guides
      • Interview Questions
      • Remote Jobs
    • Resources
      • Blog
      • Resources
      • Community
    • Post a Job
    • Sign Up
    • Sign In
    • Contact
    Skip to main content
    Search jobsRemoteInterview practice
    What is WorkzilSign inGet started
    JobsArlingtonData Warehousing Specialist, (SME) · AGILE DEFENSE, INC
    A
    AGILE DEFENSE, INC200-500 employees

    Data Warehousing Specialist, (SME)

    Arlington, VA · First seen Nov 15, 2026

    Pay
    Pay not published
    Where
    Arlington, VA
    Level
    Not stated
    Posted
    Nov 15, 2026
    The source did not publish a date

    About the role

    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 Location: Hybrid 2 days per week, Arlington, VA Clearance Level: Must be able to obtain and maintain a Public Trust Clearance which requires U.S. Citizenship Job Description SUMMARY 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. • Assess data repositories, databases, and related processes for compliance with established data governance policies, standards, and best practices, and recommend corrective actions to address gaps in governance, stewardship, and quality management. • Develop, maintain, and optimize database queries, scripts, and data extraction routines using ANSI SQL and other applicable programming or scripting languages to support reporting, analysis, data integration, and operational requirements. • Conduct recurring audits of databases and data assets to verify data integrity, enforce data standards, and ensure information remains accurate, complete, reliable, and fit for business use. • Support the development and implementation of enterprise data solutions that improve reporting capabilities, enhance visibility into organizational performance, and promote consistent use of trusted data across the enterprise. • Maintain current databases, tables, views, stored procedures, and other database objects, while supporting ongoing performance, reliability, and availability of data warehouse and reporting environments. • Collaborate closely with project teams, business users, data owners, and IT partners to identify data-related issues, define remediation strategies, and implement both manual and automated solutions to resolve data quality and process gaps. • Identify opportunities to improve current data management, reporting, and governance processes by recommending more efficient workflows, stronger controls, and scalable technical solutions that support long-term organizational objectives. • Develop and implement monitoring processes, metrics, and reporting mechanisms to continuously measure, track, and improve data quality, while providing stakeholders with visibility into data health, compliance, and remediation progress. • Coordinate effectively with cross-functional team members and stakeholders to ensure project milestones, deliverables, and deadlines are achieved in alignment with mission requirements and program priorities. Education and Background • Bachelor’s degree in a relevant discipline from an accredited institution of higher learning. • 5+ years of experience with data architecture, data management, data analysis, IT process reengineering, systems analysis, design, and implementation, and data modeling Required Skills • Hands-on experience with: • Data migration/integration of multiple data sources into a single repository. • Data Analysis • SQL programming language (e.g., ANSI SQL) • Familiarity with: • Reporting/ad-hoc analysis tools such as Tableau, Power BI • Knowledge of: • Master Data Management principles • Data Integration and Data Migration • Microsoft Power Apps • Expert knowledge of: • MS Office Suite (Word, SharePoint, Excel, and PowerPoint) • Excellent communication, consultation, conflict resolution, negotiation, and facilitation skills. • Ability to: • • Contribute to creating, refining, and documenting team business processes (e.g., in SOPs, design documents, process diagrams, etc.) in a highly flexible environment. • Be flexible and able to thrive in a time-sensitive environment to meet strict deadlines with sudden and unpredictable needs. • Independently synthesize unstructured feedback from stakeholders and consider relevant data to present quality business solutions. • Proven problem-solving skills with demonstrated ability to think out of the box and generate creative solutions; ability to break a complex problem down into its component parts and arrive at the appropriate solution in a timely fashion. • Positive attitude, averse to the status quo, always looking to improve current processes and procedures; ability to see opportunities for change, capitalize on them, and implement them when appropriate for the benefit of the organization. • A self-starter with a strong work ethic who sets high standards for self and others and demonstrates enthusiasm for the mission of the team. • Please note that pursuant to a government contract, this specific position requires U.S. Citizenship.
    Apply on the employer's siteAI interview

    Opens the employer's application page in a new tab.

    AI interview

    Practise this interview with AI

    A mock interview for this exact role, with feedback you can act on.

    Workzil

    Workzil is one cycle: find work, read the market behind it, and hire. Every number names its source and its date.

    Back to Workzil

    Workzil sites

    • WorkzilWhat we do: one cycle, from finding work to hiring.
    • Workzil JobsOpen roles with real posting dates and published pay.
    • Workzil MarketPay and hiring for your role and place, with sources.
    • Workzil EmployersCompany pages with live roles, claimed by work email.
    © 2026 WorkzilPrivacyTerms