Data Warehouse Specialist

mks2technologies; Arlington (VA); Híbrido; USD 68.000 - 97.000; Jornada completa

Descripción de la vacante

MKS2 Technologies, LLC in Arlington, VA seeks a Data Warehouse Specialist to support a government project. You will develop organization-wide data policies, oversee data governance and quality, and create enterprise reporting using Power BI and SQL.

Required are a bachelor’s degree and 5+ years in data architecture, management, analysis, and migration. DoD clearance or eligibility preferred; on-site work two days per week with full benefits during the initial term.

Formación

• Bachelor's degree in a relevant discipline from an accredited institution.
• 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.
• Experience with data analysis and SQL programming.
• Familiarity with Tableau and Power BI reporting tools.
• Knowledge of Master Data Management, data integration and data migration, and Microsoft Power Apps.
• Proficient with MS Office (Word, SharePoint, Excel, PowerPoint).
• Strong communication, consultation, and problem-solving skills.
• Ability to document processes and create SOPs and design documents.
• Capable of working in a fast-paced, time-sensitive environment.
• Self-starter with strong work ethic and a focus on mission.

Responsabilidades

• Create reports/dashboards leveraging Power BI.
• Perform data cleansing and standardization to identify data patterns.
• Plan and execute data migration strategies from legacy systems.
• Assess data repositories for compliance with governance standards.
• Create database queries using ANSI SQL or other languages.
• Analyze data from various systems and audit databases for quality.
• Ensure data integrity and consistency across databases.
• Provide enterprise data solutions and enhance reporting capabilities.
• Maintain current databases and objects.
• Collaborate with team members to meet milestones and deadlines.
• Identify process improvements and remediate gaps with IT partners.

Conocimientos

Data architecture

Data management

Data analysis

IT process reengineering

Systems analysis

Design and implementation

Data modeling

Data migration/integration

SQL

Tableau

Power BI

Power Apps

MS Office Suite

Communication skills

Documentation

Educación

Bachelor's degree in a relevant discipline

Herramientas

Tableau

Power BI

Power Apps

Descripción del empleo

MKS2 Technologies, LLC, an award-winning high growth small business, creates innovative and customer-centric technology solutions in the areas of Cyber Security, Instructional Design and Training, Software Engineering and IT Support Services to improve the security and well-being of our clients. Our commitment to excellence and our "Mission First" orientation has resulted in steady growth and an expanding client base across government agencies. We have employees nationwide and for the past three consecutive years were named one of the fastest growing Veteran-owned companies in the nation. Please take a moment to browse through our website and learn more about what it means to serve with MKS2.

Data Warehouse Specialist

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.

Pay Rate: $60.09 per hour with full benefits during the initial six-month term. $130K upon conversion.

Work Location: Hybrid - Employees must be on site in Arlington, VA two days per week. Normal hours M-F, 7am - 4pm.

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

Please note that pursuant to a government contract, this specific position requires U.S. Citizenship.

Prefer to 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 . Must be able to obtain Moderate Risk Background Investigation (MBI) regardless.

Essential Duties and Responsibilities

• Create reports/dashboards leveraging Power BI.
• 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 proces