Data Warehouse Specialist

MKS2 Technologies•Arlington, VA

11d•Hybrid

About The Position

The Data Warehouse Specialist will support a project providing business case and business process analysis for a large government agency. The role develops and creates organization-wide data policies, standards, and processes and provides oversight and strategy execution for the data governance and data quality framework. The position includes creating Power BI reports and dashboards, analyzing and improving data quality, planning and executing migrations from legacy systems, maintaining databases, and delivering enterprise data solutions and enhanced reporting. The role works with business users, IT partners, and project team members to address data and process gaps and meet project milestones. The position requires U.S. citizenship and the ability to obtain a Moderate Risk Background Investigation (MBI).

Requirements

Bachelor’s degree in a relevant discipline from an accredited institution.
At least 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 migrating and integrating multiple data sources into a single repository.
Hands-on data analysis experience.
Experience with SQL programming, such as ANSI SQL.
Familiarity with reporting and ad-hoc analysis tools such as Tableau or Power BI.
Knowledge of Master Data Management principles, data integration and migration, and Microsoft Power Apps.
Expert knowledge of MS Office Suite, including 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 in a flexible environment.
Ability to adapt and thrive in a time-sensitive environment with strict deadlines and unpredictable needs.
Ability to synthesize unstructured stakeholder feedback independently and use relevant data to present quality business solutions.
Proven problem-solving skills, creative thinking, and ability to break complex problems into component parts and reach timely solutions.
Positive, improvement-oriented attitude and ability to identify, pursue, and implement appropriate process changes.
Self-starter with a strong work ethic who sets high standards and demonstrates enthusiasm for the team’s mission.
U.S. citizenship, required pursuant to a government contract.
Must be able to obtain a Moderate Risk Background Investigation (MBI).

Nice To Haves

Active DoD Secret clearance or higher, preferred to establish reciprocity for a Moderate Risk Background Investigation (MBI) Public Trust T3 case type.
Investigation closure date less than five years old.

Responsibilities

Create reports and dashboards using Power BI.
Cleanse and standardize data, assess data quality, remove irrelevant data, and 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 regularly audit databases 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 team members to reach project milestones and deadlines.
Identify areas for improvement in current processes.
Collaborate with business users and IT partners to remediate identified gaps using manual and automated solutions.
Recommend processes and create reports to continuously monitor data quality.
Perform other duties as assigned.