Senior Database Developer

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, playing a crucial role in the integration and management of data within the EDW platform. The individual will collaborate closely with both business and technology departments to gain a comprehensive understanding of system data and its applications. This role involves providing support around data integration, data modeling, and data warehouse design, as well as defining data architecture and ETL (Extract, Transform, Load) processes. The candidate will also be expected to mentor and assist analysts, fostering a deep understanding of the data, its usage, and its structure. In this role, the individual will work within a data warehouse environment that encompasses data design, database architecture, metadata management, and repository creation. Responsibilities include assisting in the development, maintenance, and support of the D-H enterprise data warehouse system and its corresponding data marts. The candidate will troubleshoot, tune, and enhance existing data warehouse applications, providing direction and guidance to less experienced team members. Additionally, the role involves creating new or enhanced components of the data warehouse and participating in the design, development, and documentation of reporting systems. The position requires a demonstrated ability to participate in multi-functional projects independently, acting as the point of contact to drive initiatives. Strong project management skills, initiative, and the ability to conduct meetings with all levels of management are essential. The candidate will work independently to carry out departmental and institutional initiatives while collaborating effectively within team and user group structures. Other duties may be assigned as required.

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.
• 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.
• Demonstrated ability to participate in multi-functional projects independently and act as the point of contact to drive initiatives.
• 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 tools 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.