Data Warehousing Specialist (SME)

Job overview

The Data Warehousing Specialist (SME) role is hybrid in Arlington, VA, with two days per week onsite. Compensation is $132,000–$144,000 per year. Agile Defense supports a large federal agency’s business-case and business-process analysis initiatives and describes its mission as supporting important national missions through advanced technology integration. The specialist leads enterprise data policies, standards, governance, and quality practices. The role develops reporting and data solutions, improves data integrity and usability, and helps stakeholders make informed decisions using trusted data.

What you'll do

• Lead development and delivery of enterprise reporting solutions and Power BI dashboards
• profile, cleanse, standardize, and validate data
• analyze structured and unstructured data and communicate findings
• plan and execute data migrations
• assess repositories and processes for governance compliance
• develop and optimize SQL queries, scripts, and extraction routines
• audit databases and data assets
• maintain database objects and support data warehouse performance and availability
• collaborate with business users, data owners, and IT partners on remediation
• recommend process and technical improvements
• develop monitoring, metrics, and reporting for data quality and compliance
• coordinate project milestones and deliverables.

What we're looking for

Skills & competencies

data warehousing specialist

sme

hybrid

arlington va

agile defense

data governance

data quality

power bi

ansi sql

data migration

federal agency support

$132k–$144k

Work arrangement

• Weekend coverage required

Benefits & perks

• Health insurance
• life insurance
• paid time off
• holiday pay
• short- and long-term disability
• retirement benefits
• learning and development opportunities
• optional benefit elections.

Why this role

Requires U.S. citizenship and ability to obtain and maintain Public Trust clearance. Requires a relevant bachelor’s degree and five or more years of related experience.

About the employer

Agile Defense is hiring for this role. Industry: Computer Systems Design Services. Sector: 54.