USMS - (OSI) Data Warehouse Specialist, SME

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: On-site in Arlington, VA, with normal hours M-F, 7am – 4pm. 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. · Create reports/dashboards leveraging Power BI. · 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. Basic Required Qualifications and Skills: · 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: o data migration/integration of multiple data sources into a single repository. o Data Analysis o SQL programming language (e.g., ANSI SQL) · Familiarity with: o Reporting/ad-hoc analysis tools such as Tableau, Power BI · Knowledge of: o Master Data Management principles o Data Integration and Data Migration o Microsoft Power Apps · Expert knowledge of: o MS Office Suite (Word, SharePoint, Excel, and PowerPoint) · Excellent communication, consultation, conflict resolution, negotiation, and facilitation skills. · Able to: o Contribute to creating, refining, and documenting team business processes (e.g., in SOPs, design documents, process diagrams, etc.) in a highly flexible environment. o Be flexible and able to thrive in a time-sensitive environment to meet strict deadlines with sudden and unpredictable needs. o 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. · Please note that 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. Inves…

View the full posting and apply