Senior Database Developer - Applications HDRS, Remote

Dartmouth Health - Lebanon, NH

Full-time

Lebanon, NH

Ambulatory Health Care Services

About the position

The position is responsible for the design and development of Enterprise Data Warehouse (EDW) components, collaborating with both business and technology departments to understand system data and its integration within the EDW platform. The role involves providing guidance in data modeling, data warehouse design, and defining data architecture and ETL processes. Additionally, it includes mentoring analysts and developing a deep understanding of data usage and structure, with a strong preference for experience in healthcare data and SQL programming.

Responsibilities

• Works in a data warehouse environment including 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.
• Provides direction and guidance to less experienced team members.
• Creates new or enhanced components of the data warehouse.
• Participates in the design, development, and documentation of the reporting systems.
• Demonstrates the ability to participate in multi-functional projects independently and act as the point of contact to drive initiatives.
• Exhibits strong project management skills, initiative, and the ability to handle meetings with all levels of management.
• Works independently to carry out departmental and institutional initiatives.
• Collaborates well and leads within team and user groups structures.
• Performs other duties as required or assigned.

Requirements

• Bachelor's degree in Statistics, Health Informatics, Computer Science or related field is preferred.
• Bachelor's degree in above disciplines with 5 years of relevant experience or a Master's degree with 3 years of experience required.
• Minimum of 3 years of programming, data management, and/or analytics experience.
• Requires hands-on proficiency in at least one - SQL Server, Oracle or SAS.
• Requires hands-on proficiency in at least one visualization tool like SAS VA, QlikView or Web.
• Familiarity with Agile framework is preferred.
• Demonstrated expertise in managing large and complex data sets.
• Strong understanding of the healthcare data environment, security, and clinical and business workflows.
• 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.
• 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.

Nice-to-haves

• 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.