Data Warehouse Architect 2

Mbi Llc; Richmond (VA); On-site; USD 90,000 - 140,000; Full time

Job summary

Mbi Llc is seeking a data management professional to support the VDH Data Management Team in ingesting, cleaning, and processing clinical data. The role includes designing frameworks for a clinical data domain and devising plans to merge data into a cohesive longitudinal data framework from diverse origins.

The candidate will coordinate data extracts with source systems and define robust data cleansing and processing routines to ensure data quality across the longitudinal dataset.

Qualifications

• 5+ years of data processing experience.
• 3+ years of Oracle Health (Cerner) experience.
• 2+ years of Google BigQuery experience (highly desired).

Responsibilities

• Ingest, clean, and process clinical data.
• Design conceptual and logical frameworks required to support the idea of a "clinical data domain".
• Merge data into a cohesive, longitudinal data framework regardless of origin.
• Coordinate data extracts / exports with the origin source data systems.
• Define and implement data cleansing / processing routines.

Skills

Data Processing

Tools

Oracle Health (Cerner)

Google BigQuery

Python

Job description

Responsibilities

• Act in support of the VDH Data Management Team to ingest, clean, and process clinical data.
• Design conceptual and logical frameworks required to support the idea of a "clinical data domain".
• Devise and implement a plan to merge data into a cohesive, longitudinal data framework regardless of origin.
• Coordinate data extracts / exports with the origin source data systems.
• Define and implement data cleansing / processing routines.

Qualifications

• Data Processing – 5+ years of experience (required).
• Oracle Health (formerly Cerner) – 3+ years of experience (required).
• Google BigQuery – 2+ years of experience (highly desired).
• Python – 5+ years of experience (highly desired).