Database Administrator Architect (FT) Remote Opportunity

Posted 11 days ago United States Salary undisclosed
Before you apply - make sure the job is legit.

Attempting to apply for jobs might take you off this site to a different website not owned by us. Any consequence as a result for attempting to apply for jobs is strictly at your own risk and we assume no liability.

Job Description

Database Administrator Architect (FT) Remote Opportunity

**Lebanon, NH, USA**

Information Systems/Technology

Post Date May 03, 2021

Requisition # 190003TI

**_We are seeking a talented_** **_SQL server Database Administrator_** **_to maintain and support enterprise data warehouse. He/she will be responsible for the implementation, configuration, maintenance, and performance of critical SQL Server RDBMS systems, to ensure the availability and consistent performance of our data warehouse applications. This is a "hands-on" position requiring solid technical skills, as well as excellent interpersonal and communication skills._**

**_The successful candidate will be responsible for the development and sustainment of the SQL Server Warehouse, ensuring its operational readiness (security, health and performance), executing data loads, and performing data modeling in support of SQL developers. Knowledge of Health Catalyst platform is preferred but not required._**

**_This position will be mostly remote but location is limited to New Hampshire and Vermont._**


Develops, manages and updates data models, including physical and logical models of the data warehouse, data mart and staging area, and the source systems. Designs conceptual and logical models for the data warehouse or data mart. Evolves models to meet new and changing business requirements.


1. Responsible for the overall design of the enterprise data warehouse data/information architecture, which maps to the enterprise architecture and balances the need for access against security and performance requirements.

2. Focuses on enterprise wide data modeling and database design.

3. Defines data/information architecture standards, policies and procedures for the organization, structure, attributes and nomenclature of data elements, and applies accepted data content standards to technology projects.

4. Facilitates consistent business analysis, data acquisition and access analysis and design, Database Management Systems optimization, archiving and recovery strategy, load strategy design and implementation, security and change management at the enterprise level.

5. Translates strategic requirements into a usable enterprise information architecture, which may include an enterprise data model, associated metadata model, common business vocabulary, ontologies and taxonomies to be used to guide enterprise solution development and achieve consistency of information assets across the application portfolio.

6. Develops a metadata management and repository strategy to manage all enterprise information architecture project artifacts.

7. Expert knowledge of EDW concepts. Responsible for ETL, security, network integration, hardware and application maintenance.

8. Ensures existing data/information assets are identified, stewarded and leveraged across the enterprise.

9. Performs other duties as required or assigned.

**Minimum Qualifications:**

ü Master's degree in Statistics, Health Informatics, Computer Science or related field is preferred.

ü Master's degree in above disciplines with 7 years of relevant experience is required.

ü Minimum of 7 years of programming, data management, and/or analytics experience.

ü Demonstrated expertise in managing large and complex data sets.

ü Direct experience managing and analyzing healthcare data, experience with national health survey data and complex survey design methods strongly desired.

ü Proficiency with Microsoft Office (Excel, Access, Word, Outlook etc.) required.

ü Expert Knowledge of SQL variants, SSIS, Talend and familiarity with Health Catalyst EDW platform are preferred.

ü Knowledge of RDBMS/SQL relational databases as well as non-relational databases and/or knowledge of other statistical software packages desired.

ü Advanced understanding of clinical workflows, healthcare terminology, and revenue management data is preferred.

ü Excellent interpersonal skills and strong organizational skills required, including the ability to work effectively with diverse groups.

ü Able to work independently with minimal supervision and maximum collaboration in a team environment.

ü Able to set priorities, handle multiple assignments and deadlines, and display excellent judgment while operating in a flexible and professional manner.

**Required Licensure/Certification Skills:**

ü None