Database Developer

Overview

Responsible for the design and development of Enterprise Data Warehouse components. Collaborates with business and technology departments to understand system data and its use and provides support around the data and how it is integrated within EDW platform. Provides guidance in data modeling and data warehouse design and provides guidance to define data architecture and ETL (extraction, transformation & loading) processes. Provides mentoring and assistance to analysts and develops a deep understanding of the data, its use, and the structure. Supports SAP WebIntelligence and other BI tools. Uses T-SQL against Clarity and EDW DBs to fulfill institutional data requests.

Responsibilities

• Works in a data warehouse environment which includes data design, database architecture, metadata, and repository creation.

• Assists in the development, maintenance, and support of the D-H enterprise data warehouse system and corresponding data marts.

• Troubleshoots, tunes and enhances existing data warehouse applications.

• Creates new or enhanced components of the data warehouse.

• Participates in the design, development and documentation of the reporting systems.

• Collaborates well within team and user groups structures.

• Manages project priorities and adheres to project timelines

• Performs other duties as required or assigned.

Qualifications

• Bachelor’s degree in Statistics, Health Informatics, Computer Science or related field is preferred.

• Bachelor's degree in above disciplines with 3 years of relevant experience or a Master's degree with 1 year of experience required.

• Minimum of 1 year of programming, data management, and/or analytics experience.

• Good written and verbal communication skills required.

• Able to write technical specifications and relay to non-technical individuals.

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

• Basic understanding of the healthcare data environment, security and clinical and business workflows.

• Knowledge of at least one SQL variants and at least one visualization tools like SAS VA, QlikView or WebI is preferred

• Familiarity with Agile framework is preferred.

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

• 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/Certifications

• None

• Remote:Fully Remote

• Area of Interest:Information Systems/Technology

• Pay Range:$81,723.20/Yr. - $130,769.60/Yr. (Based on 40 hours per week, otherwise pro rata)

• FTE/Hours per pay period:1.00 - 1.00 - 40 hrs/week

• Shift:Day

• Job ID:40915

Dartmouth Health offers a total compensation package that includes a comprehensive selection of benefits. Our Core Benefits include medical, dental, vision and life insurance, short and long term disability, paid time off, and retirement plans. Click here for information on these benefits and more:Benefits | DHMC and Clinics Careers

Dartmouth Health is an Affirmative Action and Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, or protected veteran status and will not be discriminated against on the basis of disability.

Dartmouth Hitchcock Medical Center and Dartmouth Hitchcock Clinics comply with applicable Federal civil rights laws and do not discriminate on the basis of race, color, national origin, age, disability, or sex. We do not exclude or treat people differently because of race, color, national origin, age, disability, or sex.