Data Warehousing & Governance SME — Hybrid, Arlington VA

Innovative Management Concepts, Inc.; Arlington (VA); Hybrid; USD 120.000 - 130.000; Vollzeit

Benefits dieser Stelle

401(k) with 3% match

Paid time off

Health insurance

Dental and vision insurance

Life insurance

Zusammenfassung

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.

Qualifikationen

• 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.

Aufgaben

• 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.

Kenntnisse

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

Ausbildung

Bachelor’s degree

Tools

Tableau

Power BI

SQL

MS Office

SharePoint

Power Apps

Jobbeschreibung

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.