Under minimal supervision, is responsible for designing, managing and updating the logical data models for the data warehouse and business intelligence solution. Will require the ability to define and apply the design standards to be used in creating extensible data models in support of a multi-tiered data warehouse with the aid of commercial data modeling tools. Ability to evaluate source systems data models, profile source system data content, and capture associated metadata as part of the design process will be crucial to this role.
Education 1. Bachelor's degree. Computer Science, Information Systems, Information Management preferred.
Experience 1. Three years of experience in the analysis, design, documentation, build and maintenance of complex data models in a data warehouse environment required. 2. Strong background in health care source systems evaluation and data profiling.
Knowledge, Skills and Abilities 1. Expertise in relational and dimensional data model design for Data Warehouse and Business Intelligence environments, including the ability to design and execute data models using industry best practice approaches for extensibility, ease of use, and performance in the Microsoft SQL Server / BI Stack environment. 2. Expertise in source systems data structures, transaction systems processing events, and change data capture practices. 3. Expertise in problem-solving with the ability to profile and analyze various data sources leading to solutions to complex data related issues. 4. Ability to translate business needs into technical solutions. Expertise in communicating and collaborating on the design and physical implementation of data models with the Data Architect and Database Administrator. 5. Other data warehousing and business intelligence skills include working knowledge of: SDLC practices, BI reporting concepts, server and database environment management, data warehouse and BI architecture, data cleansing and data quality management, ETL processing, data governance, master data management. 6. Working knowledge of Managed Care information systems including QNXT and associated health care specific subject areas for Medical and Pharmacy Claims, Membership, Enrollment, Providers, etc. is strongly preferred.
Computers and Technology 1. Data Modeling software (i.e. ER Studio, Erwin), Microsoft SQL Server
All job applicants for safety-sensitive positions must pass a pre-employment drug test, once a conditional offer of employment has been made.
Denver Health is an integrated, efficient, high-quality academic health care system that is considered a model for the nation. The Denver Health system includes the Rocky Mountain Regional Level I Trauma Center, a 525-bed acute care medical center, Denver's 911 emergency medical response system, 8 family health centers, 15 school-based health centers, the Rocky Mountain Poison and Drug Center, the Denver Public Health Department, an HMO, and The Denver Health Foundation.
As Colorado's primary safety net institution, Denver Health is a mission-driven organization that has provided more than $3.3 billion in care for the uninsured in the last ten years. Denver Health is a leader in performance and quality improvements and remains financially secure, in part, due to its nationally recognized implementation of lean principles in healthcare. Denver Health is a major resource to the community, serving approximately 185,000 individuals and 67,000 children a year.
Located just south of downtown Denver, Denver Health is just minutes away from many of the cultural and recreational activities Denver has to offer.
We strongly support diversity in the workforce and Denver Health is an equal opportunity employer (EOE).
"Denver Health is committed to provide equal treatment and equal employment opportunities to all applicants and employees. Denver Health is an Equal Opportunity Employer and does not discriminate against any employee or applicant for employment because of race, color, sex, age, national origin, religion, sexual orientation, gender identity, status as a veteran, and basis of disability or any other federal, state or local protected class."