Data Warehousing Specialist, SME (IMC00874)

Innovative Management Concepts, Inc.; Arlington (VA); Hybrid; USD 120,000 - 130,000; Full time

Benefits offered by this job

401(k) with 3% match

Paid time off

Health insurance

Dental and vision insurance

Life insurance

Job summary

Innovative Management Concepts, Inc. (IMC) seeks a Data Warehousing Specialist, SME in Arlington, VA, hybrid work. You will support a government project, developing data policies, standards, and a governance framework while ensuring data quality and security.

Requirements include a Bachelor’s degree, 5+ years in data architecture and management, ANSI SQL, Tableau/Power BI, and DoD clearance or ability to obtain MBIs; U.S. citizenship required.

Qualifications

• 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
• Hands-on experience with data migration/integration of multiple data sources into a single repository, data analysis, and 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, and Microsoft Power Apps.
• Expert knowledge of MS Office Suite (Word, SharePoint, Excel, and PowerPoint).
• Excellent communication, consultation, conflict resolution, negotiation, and facilitation skills.
• Pursuant to a government contract, this specific position requires U.S. Citizenship.
• Must have an active DoD Secret clearance or higher to establish reciprocity for Moderate Risk Background Investigation (MBI) Public Trust T3 case type. Investigation closure date MUST be less than five years old.

Responsibilities

• Perform data cleansing and standardization (e.g., removing duplicates, sanitization), assessing data quality, and eliminating irrelevant data to identify and interpret data patterns and trends.
• Plan and execute data migration strategies from legacy systems to modern databases.
• Assess data repositories for compliance with data governance policies and standards.
• Create database queries using ANSI SQL or other programming languages.
• Analyze data from various systems and formats and audit databases regularly to maintain data quality.
• Ensure data integrity and data standards within databases.
• Provide enterprise data solutions and enhance reporting capabilities.
• Maintain current databases and database objects.
• Coordinate with other team members to reach project milestones and deadlines.
• Identify areas for improvement in the current process.
• Collaborate and work with business users and IT partners to remediate identified gaps, using both manual and automated solutions.
• Recommend processes and create reports to continuously monitor data quality.

Skills

Data architecture

Data management

Data analysis

IT process reengineering

Systems analysis

Data modeling

ANSI SQL

Tableau

Power BI

Master Data Management

Data integration

Power Apps

MS Office

Communication

Documentation

Education

Bachelor’s degree

Tools

Tableau

Power BI

SQL

MS Office

SharePoint

Power Apps

Job description

Data Warehousing Specialist, SME (IMC00874)

Location:

Arlington, VA - Hybrid

Travel Required:

Minimal

Level/Salary Range:

$120,000 - $130,000

Position Type:

Full-Time

Date Posted:

Fri, 10/02/2026 - 12:00

Posting Expires:

Mandatory Job Requirements:

• Pursuant to a government contract, this specific position requires U.S. Citizenship
• Prefer active DoD Secret clearance or higher, able to obtain Moderate Risk Background Investigation (MBI) if not

Email Subject Line: (OSI) Data Warehousing Specialist, SME (IMC00874)

This position will support a project providing business case and business process analysis for a large government agency and will be responsible for developing and creating organization-wide data policies, standards, and processes, and for oversight and strategy execution of the data governance and data quality framework.

Work Location:Hybrid in Arlington, VA.

Basic Required Qualifications and Skills: Note: These are mandatory items that all candidates must have when submitting an application to IMC for this position. Please ensure that your submission addresses each of these requirement items. Candidates without these required elements will not be considered.

• 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
• Hands-on experience with data migration/integration of multiple data sources into a single repository, data analysis, and 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, and Microsoft Power Apps.
• Expert knowledge of MS Office Suite (Word, SharePoint, Excel, and PowerPoint).
• Excellent communication, consultation, conflict resolution, negotiation, and facilitation skills.
• Able to:
  • Contribute to creating, refining, and documenting team business processes (e.g., .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.
• Pursuant to a government contract, this specific position requires U.S. Citizenship.
• Must have an active DoD Secret clearance or higher to establish reciprocity for Moderate Risk Background Investigation (MBI) Public Trust T3 case type. Investigation closure date MUST be less than five years old.

Essential Duties and Responsibilities: This position will include, but is not limited to, the following tasks:

• Perform data cleansing and standardization (e.g., removing duplicates, sanitization), assessing data quality, and eliminating irrelevant data to identify and interpret data patterns and trends.
• Plan and execute data migration strategies from legacy systems to modern databases.
• Assess data repositories for compliance with data governance policies and standards.
• Create database queries using ANSI SQL or other programming languages.
• Analyze data from various systems and formats and audit databases regularly to maintain data quality.
• Ensure data integrity and data standards within databases.
• Provide enterprise data solutions and enhance reporting capabilities.
• Maintain current databases and database objects.
• Coordinate with other team members to reach project milestones and deadlines.
• Identify areas for improvement in the current process.
• Collaborate and work with business users and IT partners to remediate identified gaps, using both manual and automated solutions.
• Recommend processes and create reports to continuously monitor data quality.

Salary and Benefits Information: Please see the salary information listed at the beginning of this document, which is not a guarantee of compensation or salary. All salaries will be based on relevant experience, geographic location, and position and/or contractual requirements, which could fall outside of the listed range.

Full-time positions at IMC are eligible to participate in any or all of the benefit programs offered, including 401(k) with a 3% employer match, paid time off, paid holidays, FSA spending, dental, vision, health insurance, company-sponsored AD&D,and life insurance.Additional voluntary benefits are offered,such as voluntary life, AD&D, accident, critical illness, hospital,and pet insurance. Benefits are subject to change. Positions at IMC may also be eligible for a bonus and/or other incentives.

Innovative Management Concepts, Inc. (IMC), a Service-Disabled Veteran-Owned Small Business, provides a broad range of information technology IT services to government and commercial customers by placing a high priority on modernization, enhancing business processes through technology, and creating efficiencies through automation. Since its founding in 1989, IMC has offered solutions and expertise in: IT operations and maintenance, data management, cyber security, systems and network engineering and administration, cloud/hosting services, software development, website services, software quality assurance and testing (including IV&V), and project management. IMC is certified in International Organization for Standardization (ISO) 9001 Quality Management, ISO 27001 Information Technology Security Management, ISO 20000 Information Technology Service Management, and ISO 14001 Environmental Management System. Committed to continuous improvement and information security, IMC has beenappraised at level 3 of the CMMI Institute’s Capability Maturity Model Integration for both Development and Services and we are CMMC Level 2 (Ver 2.0) compliant. Find out more about IMC at www.imcva.com .

We are an equal opportunity employer, and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, protected veteran status, or any other characteristic protected by law.

First name

Last name

Email address

Phone number

Resume One file only.
2 MB limit.
Allowed types: txt rtf pdf doc docx odt ppt pptx odp xls xlsx ods.