Under Development Features: Talent Bank/Pool, VMS Intigration, Analytics, Social Integration, Reports, API Integration, Resource and Timesheets Management, Company Admin

Healthcare Database Architect (420 views)

must reside in Boston post-Covid  
July 23, 2021

**** Direct Client Requirement*****

Title                                    : Healthcare Database Architect 

Location                             : Remote, must reside in Boston post-Covid  

Rate                                    : DOE /If your experience and skills match call us immediately for submission

Duration                             : Long term

Interview Type                   : Skype or Phone

Job Type                            : W2

Experience                        : 10 Years

Job Description:

The Consultant will work on the Data Cleanup and Standardization project Goal of the project is to consolidate the data from multiple data sources on multiple platforms into one single SQL Server instance which will become the Operational Datastore (ODS). This project is part of a larger program to modernize all the IT environment. The Senior Consultant will work closely with the staff, the IT Application Manager, ETL Developer/s and a Senior IT Project Manager as well as a Business Analysts to analyze and document the current data sources and generate work instructions for the ETL Developer/s.

Job Duties:

  • Create and maintain an inventory of all data sources in use.
  • Create and maintain a data dictionary for all data sources
  • Design data/table structure on a staging environment
  • Translate business rules and requirements into design specifications for data standardization, normalization/de-normalization, access security…
  • Create a data model and Data Dictionary for all data domains/entities (Birth, Death, Fetal Death, Marriage, Divorce, Providers, Morgues….) on the ODS
  • Translate requirements and business rules into instructions for ETL programmer and SQL developers to write the transition scripts
  • Write test plans and acceptance criteria

Education and Experience:

  • Bachelor’s degree in Computer Science, Computer Information Systems, Information Management or equivalent work experience
  • Proven track record of designing and implementing complex and large scale Enterprise Databases
  • 10+ years of:
    • designing relational database
    • creating conceptual, logical and physical data models
    • documenting databases using Entity Relationship Models and Data Dictionaries
    • writing SQL scripts
    • working in a software development environment
  • Deep understanding of database concepts, data domain concepts, security concepts, Normal Forms, Data Warehousing…
  • Eliciting and writing requirements, design specifications and work instructions for developers
  • Strong Project Management and leadership skills
  • Working through ambiguity
  • Communicating clearly with technical and non-technical stakeholders


  • CDMP or similar certification
  • Hands on experience with ETL tools and processes
  • Familiarity with AWS hosting
  • Experience working in a healthcare environment
  • Experience working with PHI

Position Keywords: ETL programmer,SQL,AWS hosting,CDMP or similar certification,SQL Server instance

Pay Rate: DOE /If your experience and skills match call us immediately for submission

Job Duration: 12 Months

% Travel Required: None

Job Posted by: Consulting Services

Job ID: OOJ - 3404

Don't have time now?
Get a reminder in your inbox