Data Warehouse Architect

Creative Solutions Services, LLC; Richmond (VA); On-site; USD 120,000 - 180,000; Full time

Job summary

Creative Solutions Services, LLC is seeking a Data Warehouse Architect to design the data model and manage ingestion, cleansing, and processing of clinical data in a Richmond, VA onsite setting. The role focuses on building a cohesive, longitudinal data framework across multiple source systems.

The candidate will identify data elements, coordinate data extracts, and implement robust cleansing pipelines, ensuring data quality and accessibility for analytics and reporting within the Client Data

Qualifications

• Experience in data architecture and data processing for healthcare data.
• Experience with Oracle Health (Cerner) systems or similar health data sources.
• Familiarity with Google BigQuery and cloud data platforms.
• Proficiency in Python programming and data tooling is desirable.

Responsibilities

• Design conceptual and logical data frameworks to support a clinical data domain.
• Identify common data elements across disparate source systems.
• Develop plans to merge data into a longitudinal framework regardless of origin.
• Coordinate data extracts/exports with origin source systems.
• Define and implement data cleansing and processing routines.

Skills

Data Architecture

Data Processing

Oracle Health (Cerner)

Google BigQuery

Python

Google Cloud Infrastructure

Tools

Python

Google Cloud Infrastructure

Oracle Health (Cerner)

Job description

Title: Data Warehouse Architect

Location: Richmond,VA (Onsite)

Duration: 5 Months

Interview type: Web Cam Interview Only

Job Description:

This position will act in support of the Client Data Management Team to ingest, clean, and process clinical data. This will include, but not be limited to, the following activities:

• Designing the conceptual and logical frameworks required to support the idea of a "clinical data domain"
• Identifying common data elements between multiple disparate origin source data systems
• Devising and implementing a plan to merge data into a cohesive, longitudinal data framework regardless of origin
• Coordinating data extracts / exports with the origin source data systems
• Defining and implementing data cleansing / processing routines

Required Skills:

• Data Architecture
• Data Processing
• Oracle Health (formerly Cerner)
• Google BigQuery - Highly Desired
• Python - Desired
• Google Cloud Infrastructure - Desired