Data Warehousing Specialist, (SME)

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

• 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

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

Compensation: USD 132,000 – 144,000 per year salary