OverviewResponsible 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
