Data Warehouse Architect 2 (Short Term)

**Job Title**: Data Warehouse Architect 2 (Short Term) **Work Type**: Onsite **Location**: Richmond, VA 23219 **Start Date**: 08/03/2026 **End Date**: 01/22/2027 **Industry Category**: Information Technology / Government Healthcare **Employment Type**: 1099 Contract **Requisition ID**: 806713 **Overview** We are seeking a Data Warehouse Architect 2 to support the Data Management Team in building and advancing enterprise clinical data capabilities. This position will play a key role in designing clinical data architecture, integrating data from multiple source systems, and developing scalable processes for cleansing, transforming, and organizing healthcare data into a unified longitudinal data framework. **Application** Applications will be reviewed as received. Candidates must: - Be legally authorized to work in the United States without employer sponsorship, now or in the future. - Physically reside within the United States for the duration of the assignment in accordance with Commonwealth of Virginia security policies. - Provide a valid candidate email address with submission. - Successfully complete a webcam interview as part of the selection process. **Job Description** The Data Warehouse Architect 2 will support the Virginia Department of Health Data Management Team by designing and implementing enterprise clinical data solutions that improve data quality, accessibility, and long-term usability. This role is responsible for creating clinical data models, integrating data from multiple healthcare systems, coordinating data extraction activities, and developing data processing and cleansing routines that enable reliable reporting and analytics across the organization. **Responsibilities** **Data Architecture & Design** - Design conceptual and logical data models to support an enterprise clinical data domain. - Develop scalable data architecture that enables longitudinal clinical data management across multiple source systems. - Define data standards and integration strategies to improve consistency and usability. **Data Integration & Processing** - Identify and map common data elements across disparate healthcare source systems. - Design and implement processes to merge data into a unified clinical data framework. - Coordinate data extraction and export activities with source system owners. - Develop and implement data cleansing, transformation, and processing routines to improve data quality. **Collaboration & Operational Support** - Partner with the VDH Data Management Team to support enterprise data initiatives. - Work with stakeholders to ensure clinical data is accurately integrated and maintained. - Support ongoing improvements to clinical data management processes and architecture. **Minimum Qualifications** - 5 years of experience in Data Architecture. - 5 years of experience in Data Processing. - 3 years of experience working with Oracle Health (formerly Cerner). - Must be legally authorized to work in the United States without employer sponsorship, now or in the future. - Must physically reside within the United States for the duration of the assignment. - Must complete a webcam interview as a condition of consideration. **Preferred Qualifications** - 5 years of experience with Python. - 2 years of experience with Google BigQuery. - 2 years of experience with Google Cloud Infrastructure. **Compensation** This is a 1099 Contract role. **Pay Rate:** $55 – $75 per hour **Schedule** - Assignment Start Date: August 3, 2026 - Assignment End Date: January 22, 2027 - Assignment Duration: Approximately 5 months and 20 days - Full-time onsite assignment **Work Location** - Richmond, VA - This position is fully onsite.