Wellington Steele and Associates

Data Architect

Location US-NY-Rochester



Title: Data Architect

Job Type: Full-Time  

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



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