Sign up to access all features of our service.
  • Job search
  • Favorites
  • Create a CV
    New
  • Salaries
  • Subscriptions

Data Warehousing Specialist, (SME)

$132k - $144k

Agile Defense

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 . $132,000 - $144,000 a year In addition, Agile Defense invests in its employees beyond just compensation. Agile's benefits offerings include, dependent upon position, Health Insurance, Life Insurance, Paid Time Off, Holiday Pay, short-term and long-term Disability, Retirement and Learning and Development opportunities as well as other optional benefit elections. Our Core Values Employees of Agile Defense are our number one priority, and the importance we place on our culture here is fundamental. Our culture is alive and evolving, but it always stays true to its roots. Here, you are valued as a family member, and we believe that we can accomplish great things together. Agile Defense has been highly successful in the past few years due to our employees and the culture we create together. What makes us Agile? We call it the 6Hs, the values that define our culture and guide everything we do. Together, these values infuse vibrancy, integrity, and a tireless work ethic into advancing the most important national security and critical civilian missions. It's how we show up every day. It's who we are. Happy - Be Infectious. Happiness multiplies and creates a positive and connected environment where motivation and satisfaction have an outsized effect on everything we do. Helpful - Be Supportive. Being helpful is the foundation of teamwork, resulting in a supportive atmosphere where collaboration flourishes, and collective success is celebrated. Honest - Be Trustworthy. Honesty serves as our compass, ensuring transparent communication and ethical conduct, essential to who we are and the complex domains we support. Humble - Be Grounded. Success is not achieved alone, humility ensures a culture of mutual respect, encouraging open communication, and a willingness to learn from one another and take on any task. Hungry - Be Eager. Our hunger for excellence drives an insatiable appetite for innovation and continuous improvement, propelling us forward in the face of new and unprecedented challenges. Hustle - Be Driven. Hustle is reflected in our relentless work ethic, where we are each committed to going above and beyond to advance the mission and achieve success. Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities We may use artificial intelligence (AI) tools to support parts of the hiring process, such as reviewing applications, analyzing resumes, or assessing responses and identifying potential inconsistencies or verification signals in application materials based on available information. These tools assist our recruitment team but do not replace human judgment. Final hiring decisions are ultimately made by humans. If you would like more information about how your data is processed, please contact us. Apply for this job Agile Defense

Vacancy posted 2 days ago
Similar jobs that could be interesting for youBased on the Data Warehousing Specialist, (SME) in Arlington, VA vacancy
  •  ...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... 
    Suggested
    2 days per week

    agile-defense

    Arlington, VA
    8 days ago
  • $87k - $175k

    Washington, DCAdministrative and Logistics Support /Full Time On-Site /On-siteHR Data Analytics & Reporting Specialist (HRDARS) - SME Work Location: Washington, DC Employment Type: Full-Time, Expert-Level Department: Administrative and Logistics Support CGS is seeking... 
    Suggested
    Full time

    CONTACT GOVERNMENT SERVICES

    Washington DC
    3 days ago
  •  ...Data Warehouse Subject Matter Expert (SME) 100% on-site Secret Clearance required. Position Summary The Data Warehouse Subject Matter Expert (SME) provides senior-level technical leadership in the design, development, optimization, and support of enterprise... 
    Suggested
    For contractors
    Work at office

    Nationwide IT Services, Inc.

    Arlington, VA
    1 hour ago
  • $112k - $179k

     ...we’re keeping people around the world safe and secure.ResponsibilitiesPeraton is seeking a talented, experienced Data Engineer, Subject Matter Expert (SME) to join our Federal Strategic Cyber program supporting a federal law enforcement customer in Washington, DC.Location... 
    Suggested
    Contract work
    Temporary work
    Shift work

    Peraton Corporation

    Washington DC
    12 hours ago
  • $146k - $234k

     ...people around the world safe and secure.ResponsibilitiesPosition OverviewWe are seeking an experienced Data Management and Governance Specialist / Subject Matter Expert (SME) to support a classified U.S. Government contract within the Intelligence Community (IC). The... 
    Suggested
    Contract work
    Temporary work
    Shift work

    Peraton Corporation

    Washington DC
    20 hours ago
  • $103.8k - $218.1k

    Job Title: Data Science and Data Visualization Subject Matter Expert (SME)Job Category: Information TechnologyTime Type: Full timeMinimum Clearance Required to Start: TS/SCI with PolygraphEmployee Type: RegularPercentage of Travel Required: NoneType of Travel: None* *... 
    Contract work
    Work experience placement
    Flexible hours

    CACI International

    Chantilly, Fairfax County, VA
    3 days ago
  •  ...attack our mission with a comprehensive understanding of the data available and required; skilled research, design,...  ...Qualifications VNE, LLC is looking for a TS/SCI Cleared Data Warehousing Specialist, Journeyman level Minimum Qualifications: Education: High School... 
    Temporary work
    Work at office
    Flexible hours

    Vickers and Nolan Enterprises

    Reston, VA
    2 days ago
  • $185k - $200k

     ...Redhorse Corporation. We are a solution-driven company delivering data insights and technology solutions to customers with missions...  ...seeking an executive-level Data Scientist Subject Matter Expert (SME) to provide high-impact advisory and technical services to the National... 
    Full time
    Contract work

    Redhorse Corporation

    Washington DC
    6 days ago
  •  ...Redhorse Corporation. We are a solution-driven company delivering data insights and technology solutions to customers with missions...  ...seeking an executive-level Data Scientist Subject Matter Expert (SME) to provide high-impact advisory and technical services to the National... 
    Full time

    redhorsecorp

    Washington DC
    8 days ago
  •  ...Job Summary Electrical commissioning specialists on this team lead and perform commissioning on data center projects, covering QA/QC and functional performance testing and equipment and system start-up to deliver a safe, functional environment that meets design requirements... 
    For contractors
    Work visa

    HKA Enterprises

    Arlington, VA
    29 days ago
  • $22 - $26 per hour

     ...Data Specialist Location: Arlington, VA Schedule: 40 hours per week Contract Length: Approximately 3 months Start Date: ASAP Pay: $22-$26hr Position Overview We are hiring several Data Specialists to support a large-scale data migration and... 
    Contract work
    Temporary work
    Local area
    Immediate start

    LHH

    Arlington, VA
    14 days ago
  •  ...collaboratively to achieve project goals and make your vision a reality. Job Description What are we looking for? The Data Visual Specialist works with public health scientists, geospatial analysts, web developers, and program leadership to create and publish data... 
    Local area
    Remote work

    DRT Strategies

    Arlington, VA
    20 hours ago
  •  ...Position Overview: Arrowpoint is seeking a Junior Data Integration Specialist to support the FBI’s National Data Exchange (N-DEx) ecosystem. In this remote role, you will help modernize data ingestion processes by leveraging vendor solutions and performing foundational... 
    Full time
    Remote work

    MorphWorks

    Washington DC
    8 days ago
  • $77.6k - $176k

     ...Job Number: R0253075 Data Visualization Specialist The Opportunity: Design, develop, test, deploy, and maintain interactive dashboards, reports, and visualizations using Microsoft Power BI and Tableau. Create executive-level reporting products that communicate... 
    Full time
    Contract work
    Part time
    Local area
    Remote work

    Booz Allen Hamilton

    Arlington, VA
    20 hours ago
  • $98k - $163k

     ...Job Family : Data Science Consulting Travel Required : Up to 10% Clearance Required : Ability to Obtain Public Trust...  ...performance analytics. Tableau certification (Tableau Desktop Specialist, Certified Data Analyst) and/or Microsoft Certified: Power BI... 
    Temporary work
    Flexible hours

    Guidehouse

    Arlington, VA
    3 days ago
  •  ...Job Description: Data Visualization Specialist for HRM INFO LLC's End Client Anywhere in US - Remote Only. Skills: Data Engineering or Data Management experience., Qlik, AWS environment (AWS certifications preferred), UI Design and End User Engagement Security... 
    Full time
    Remote work

    HRM INFO LLC

    Washington DC
    20 hours ago
  •  ...timely hiring should authorization be granted. The successful candidate will have a proven track record of leading grants management data analysis and reporting tasks, as well as serving as the primary data / system point of contact between the functional and technical... 
    Full time
    Work at office
    Local area
    Monday to Friday
    Night shift

    Guardians of Honor LLC

    Washington DC
    3 days ago
  • $95.6k - $188.4k

     ...new digital ventures, and fuel growth through innovation. Work You’ll Do As a Project Analytics & Insights Engineer III on the AI & Data team, you will design and develop AI enabled solutions to process unstructured data using client approved tools such as Azure AI... 
    Local area

    Deloitte

    Rosslyn, VA
    3 days ago
  • $112k - $179k

     ...peraton.com to learn how we’re keeping people around the world safe and secure.ResponsibilitiesWe are seeking an experienced Data Analytics Specialist to support a classified government contract. The successful candidate will provide technical leadership in the design,... 
    Contract work
    Temporary work
    For contractors
    Shift work

    Peraton Corporation

    Washington DC
    4 days ago
  •  ...Transportation, Federal and State Government Agencies. Learn More About ProSidian Consulting at DescriptionProSidian Seeks a Data Management Specialist - Senior - Transition and Economic Development headquartered near Northern Virginia, Washington, D.C., Maryland Area to... 
    Full time
    Temporary work
    For contractors
    Work at office
    Flexible hours

    Prosidian Consultng

    Washington DC
    4 days ago
  • $72.7k - $149.2k

    Job Title: Data Specialist IIJob Category: Information TechnologyTime Type: Full timeMinimum Clearance Required to Start: DOJ MBIEmployee Type: RegularPercentage of Travel Required: NoneType of Travel:* * *The Opportunity:Work in the District’s Litigation Support Unit,... 
    Contract work
    For contractors
    Work experience placement
    Immediate start
    Flexible hours

    CACI International

    Washington DC
    1 day ago
  • $118.3k - $207.1k

     ...best and most innovative solution leaders, then Jacobs is where you belong. As a Commissioning Specialist on our team, you will participate in onsite activities to support Data Center Commissioning projects. You will have the opportunity to lead and perform all... 
    Full time
    For contractors
    Remote work

    Jacobs

    Arlington, VA
    4 days ago
  • $95k - $125k

    OverviewWe are seeking a Data Governance Specialist to help design, implement, and operationalize data governance practices across a modern, cloud-based data ecosystem. This role focuses on enabling effective data use through strong metadata management, data cataloging... 

    Steampunk

    McLean, VA
    1 day ago
  •  ...Transportation, Federal and State Government Agencies. Learn More About ProSidian Consulting at DescriptionProSidian Seeks a Data Management Specialist - Junior - Transition and Economic Development headquartered near Northern Virginia, Washington, D.C., Maryland Area to... 
    Full time
    Temporary work
    For contractors
    Work at office
    Flexible hours

    Prosidian Consultng

    Washington DC
    4 days ago
  • $87.1k - $130.7k

    Job Family:Data Science (DAN)Travel Required:Up to 10%Clearance Required:Active SecretWhat You Will Do:Guidehouse is seeking a highly motivated Data Scientist to provide analytical and technical support to the Defense Advanced Research Projects Agency (DARPA). The ideal... 
    Full time
    Flexible hours

    Guidehouse

    Arlington, VA
    3 days ago
  • DescriptionThe Vanguard 2.2.1 contract is seeking a Data Governance Analyst to support the data analysis and reporting capability for the Data Analytics and Assessment Unit (DAAU) within the Bureau of Information Resource Management at the Department of State. The team... 
    Contract work
    Work at office
    Local area
    Remote work

    Science Applications International Corporation

    Washington DC
    4 days ago
  • $91.1k - $179.5k

     ...strategy, operations, process design, and technology as we partner with clients to transform finance.Deloitte is seeking a Data and Technology Specialist, Project to support a client project with data and information technology services. In this role, you will analyze... 
    Local area

    Deloitte

    Rosslyn, VA
    4 days ago
  •  ...Job Description Job Description Data Architect/Data Steward/SME Secret clearance required. 100% on-site Nationwide IT Services, NIS...  ...stewardship, analysis, migration, modeling, integration, warehousing, database design, and cloud best practices. The SME... 
    For contractors
    Work at office

    Nationwide IT Services

    Arlington, VA
    5 days ago
  • DRT Strategies is hiring a Data Visual Specialist in Arlington, Virginia, to create and publish innovative data visualizations to aid public health analyses. The position requires collaboration with experts to design effective communications through visual data. Ideal... 

    DRT Strategies

    Arlington, VA
    1 day ago
  • Delaware Nation Industries seeks a detail‑oriented records specialist to support the Office of Alumni Affairs. You will manage alumni records...  ...for the Exchange Alumni platform. Responsibilities include data uploads to ACES, deduplication, program tracking, and collaboration... 
    Work at office

    Delaware Nation Industries

    Washington DC
    1 day ago

Do you want to receive more vacancies?

Subscribe and receive similar vacancies to Data Warehousing Specialist, (SME). Be the first to apply!