Data Warehouse Specialist
MKS2 Technologies15 days ago
Arlington, VA, USASenior
Responsibilities
- Develop organization-wide data policies, standards, processes, and governance strategies.
- Create reports and dashboards using Power BI.
- Perform data cleansing, standardization, quality assessment, and pattern and trend analysis.
- Plan and execute data migration and integration from legacy systems into modern databases.
- Assess data repositories for compliance with governance policies and standards.
- Create database queries using ANSI SQL or other programming languages.
- Analyze data from varied systems and formats and regularly audit databases.
- Maintain data integrity, standards, databases, and database objects.
- Provide enterprise data solutions and improve reporting capabilities.
- Create processes and reports to continuously monitor data quality.
- Collaborate with business users and IT partners to remediate identified gaps.
- Coordinate with team members to meet project milestones and deadlines.
Requirements
- Bachelor’s degree in a relevant discipline from an accredited institution.
- At least five 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 and SQL programming experience, such as ANSI SQL.
- Familiarity with reporting and ad-hoc analysis tools such as Tableau and Power BI.
- Knowledge of Master Data Management principles, data integration, data migration, and Microsoft Power Apps.
- Expert knowledge of Microsoft Office Suite, including Word, SharePoint, Excel, and PowerPoint.
- Strong communication, consultation, conflict resolution, negotiation, facilitation, problem-solving, and process-improvement skills.
- U.S. citizenship is required under the government contract.
- Must be able to obtain a Moderate Risk Background Investigation Public Trust T3; an active DoD Secret clearance or higher is preferred, with an investigation closure date less than five years old.
Benefits
- Full benefits during the initial six-month term.
- Hybrid work arrangement requiring onsite work in Arlington, Virginia, two days per week.
- Normal work hours are Monday through Friday, 7:00 a.m. to 4:00 p.m.
- Initial six-month term with potential conversion.
Tech Stack
Categories
Data Engineering
About MKS2 Technologies
Founded in 2008, MKS2 Technologies has helped Federal government customers design, implement and sustain mission-focused IT solutions focusing on cyber security support, enterprise application development, and instructional design and training. MKS2 is a Service-Disabled Veteran-Owned Small Business (SDVOSB) headquartered in Austin, Texas, with regional offices in Colorado Springs, CO, Monterey, CA, Portland, ME, and Washington, D.C. Our full-time staff works on Federal services contracts in 49 states, DC, and PR to providing mission-critical support to the Department of Veterans Affairs, The U.S. Army and the U.S. Navy.