Senior Database Developer
About the role
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 the EDW platform. Provides guidance in data modeling and data warehouse design as well as guidance to define data architecture and ETL processes. 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 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.
Responsibilities
- Provide mentoring and assistance to analysts and develop a deep understanding of the data, its use, and the structure.
- Demonstrate ability to participate in multi-functional projects independently and act as the point of contact to drive initiatives.
- Apply strong project management skills, initiative, and the ability to handle meetings with all levels of management.
- Work independently to carry out departmental and institutional initiatives.
- Collaborate well and lead within team and user group structures.
- Perform 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 the 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.
- Hands-on proficiency in at least one of: SQL Server, Oracle, or SAS.
- Hands-on proficiency in at least one visualization tool such as 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 other statistical software packages desired.
Skills
- Excellent interpersonal skills and strong organizational skills, 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.