Wellington Steele and Associates

Data Architect

Location US-NY-Rochester

Overview

 

Title: Data Architect

Job Type: Full-Time Contractor Feb 22 – Jun 22 (Plan to extend through FY23)

Location: Primarily Virtual / Remote, periodic travel to Rochester, NY possible

 

Role: Leads the standard of a common business vocabulary, expresses strategic data requirements, drives high-level data model / ontologies, design and integration patterns, align with enterprise strategy and related business architectures, all in support of clinical operations and research business needs.

 

Required Skills :

  • Strong data warehouse experience in MSFT SQL Server and Integration Services.
  • Expert in data modeling and specifically dimensional modeling concepts and principles.
  • Demonstrated experience in leading data modeling requirements, design, development and unit / integrated testing in at least one large data warehousing initiative.
  • Demonstrated ability to iterate between logical and physical data models.
  • Strong experience in using standard data modeling tools and practices.
  • Strong experience in implementing DataMarts and ODSs (Operation Data Stores).
  • Strong experience in SQL Server performance tuning and optimization.
  • Strong experience in designing and implementing metadata management systems.
  • Strong experience in implementing a data lake / unstructured data processing.
  • Strong experience in designing and implementing security / access models.
  • Strong experience in applying information management principles and concepts.
  • Very strong applied experience in EPIC Caboodle, Clarity and related development tools.
  • Experience with clinical and/or revenue cycle data
  • Excellent communication skills, both written and spoken are a must.
  • Demonstrated ability to collaborate with other architects and lead resources.
  • Scrum/agile experience.

 

Preferred Skills :

  • Applied experience in implementing OMOP (Observational Medical Outcomes Partnership) CDM (Common Data Model) database and underlying data integration patterns
  • Experience implementing Denodo data virtualization at enterprise scale
  • Background in designing Virtual Data warehouse solutions, possible using the Denodo toolset.
  • Experience in both on-premise and cloud implementations a plus.
  • Strong experience in SQL Server environment sizing, installation, configuration required.
  • Version control tools
  • Clinical research or academic research environment experience
  • Experience in enterprise scheduler integration inside and outside of Microsoft platforms.
  • Experience in both full (batch) and incremental (trickle) ETL/ELT design patterns.

 

Nice To have Skills:

  • Basic understanding of HIPAA Privacy and Security – preferred
  • R / Python Programming – preferred.
  • Data quality/cleansing/standardization – preferred
  • Statistical analysis (SAS, SPSS, Matlab, R, Mathematica) – preferred

 

Education : Bachelor’s Degree

Experience : Minimum of 10 years in data warehousing

 

Options

Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
Share on your newsfeed