Data Architect

Overview:

Current provider and healthcare directories are often inaccurate, fragmented, burdensome to maintain, rarely support interoperable data exchange or public health reporting, and are overall costly to the health care industry. A potential solution to this deficit is developing a centrally managed single source of truth National Directory of Healthcare (NDH).

LMI is seeking an experienced Data Architect to support a team building this NDH. This directory will serve as a single source of truth for numerous stakeholders that may include: insurance companies, independent researchers, VA, CMS, CCIIO, OBRHI, and any other users interested in knowing information about providers. This position may be remote.

LMI: Innovation at the Pace of Need™

At LMI, we’re reimagining the path from insight to outcome at the new speed of possible. Combining a legacy of over 60 years of federal expertise with our innovation ecosystem, we minimize time to value and accelerate mission success. We energize the brightest minds with emerging technologies to inspire creative solutioning and push the boundaries of capability. LMI advances the pace of progress, enabling our customers to thrive while adapting to evolving mission needs.

• Oversees data architecture for large scale API and web application back end data store. Implements ETL processes to supply application data for usage in the web application. 
• Develop packages and scripts for system enhancements and interfaces. 
• Develops scripts to validate the various data on systems. Involve in writing queries to improve the database performance and availability. 
• Must use process through the ETL and refresh to identify, troubleshoot, and correct code problems. 
• Develop, implement, and execute a quality assurance program and quality control standards for all activities. Executes statement to create and update various tables and views utilize for testing of code on a database. 
• Establish database backup/recovery strategy using user-manage backup.  Engineer extensive database solutions and interfaces enabling performance of data requests. Develop reusable components for deployment in a traditional data warehouse environment. 
• Standardize database maintenance activities by standardizing directory structure, documentation of DBA activities. 
• Establish backup and recovery options and implement automation of many DBA utility functions. Document database design, data definition language, define data migration strategy between different products/versions and develop data migration procedures. 

• Minimum of 5 years’ experience designing, developing, and maintaining enterprise database systems. 
• Experience with cloud database development and implementation (AWS preferred).
• Bachelors Degree is required. 
• Understanding of data migration procedures for backup and restore as well as schema migration for existing data holdings.  
• Demonstrated experience with ETL pipeline design and implementation using open source products 
• Overseeing aspects of data governance and maintenance, modeling, and secure access. 
• Strong and robust understanding of SQL (MariaDB/MySQL, Postgres, MS SQL, or Oracle).  
• Demonstrated experience documenting database architecture and diagrams.