Data Modeler - Englewood, CO
Posted by: "Kathy Garrett" kathy.garrett@futurestep.com recruit516
Date: Wed Oct 15, 2008 1:08 pm ((PDT))
Catholic Health Initiatives is a national nonprofit health
organization with headquarters in Denver. We are a faith-based
system that includes 77 hospitals; 40 long-term care, assisted- and
residential-living facilities; and two community health-services
organizations in 20 states. Together, our facilities provided almost
$480 million in community benefit in the 2007 fiscal year, including
services for the poor, free clinics, education and research. With
approximately 68,000 employees and annual revenues of $7.7 billion,
our system ranks as the nation's second-largest Catholic health care
system.
RESPONSIBILITIES:
-Transforms business requirements into conceptual logical data
models and identifies data sharing opportunities.
-Participates in design of the data warehouse staging layers and
data marts.
-Participates in the development and maintenance of the meta data
repository.
-Analyzes database and business systems in order to perform data
modeling(high level conceptual business/data models, entity-
relationship logical data models, and detailed physical database
design models).
-Provides guidance to development applications by applying knowledge
of data warehouse design, development, and implementation concepts
including operational data stores and data marts (logical and
physical).
-Builds and maintains logical and physical data models and process
change requests to those models to support application design,
enhancements and performance improvements.
-Manages data models and associated Database Definition Language
(DDL) scripts through the development lifecycle using source code
control tools.
-Reviews reporting/analytical requirements and/or existing SQL
queries and develop dimensional models that simplify the SQL
required to perform OLAP analysis.
-Defines dimensional models in a semantic layer and develop SQL to
define views to expose data stored in 3NF modeled tables in the
dimensional views.
REQUIREMENTS/SKILLS:
-Bachelor degree in computer science or related technical field
required.
-5+ years of experience in data administration activities and
logical and physical data modeling required.
-May substitute an equivalent combination of education and
experience.
-Experience with performance tuning of analytical data systems
-Experience in creating designs for enterprise warehouses, data
marts, data cubes preferred.
-Knowledge of data elements used in healthcare provider systems
strongly preferred.
-Knowledge of best practices in logical and physical database design
required.
