[rmiug-jobs] Digest Number 4477
Manager, Data Warehouse, Englewood, CO
Posted by: "Kathy Garrett" kathy.garrett@futurestep.com recruit516
Date: Tue Apr 15, 2008 3:00 pm ((PDT))
Catholic Health Initiatives is looking for a Manager, Data Warehouse
to help build and grow its Business Intelligence group. Qualified
and interested candidates should apply online at
www.catholichealthinit.org.
Manager, Data Warehous
Key Functions:
-Manages enterprise data warehouse team responsible for architecting
and populating the data warehouse.
-Responsible for working with business areas to prioritize internal
data needs and develop data acquisition plan for external data.
Responsibilities:
-Manages day-to-day operations of the data warehouse team that
maintains the warehouse and user data marts.
-Coordinates resources assigned to the data warehouse team.
-Responsible for facilitating, and planning warehouse design
meetings.
-Owns data acquisition process and improvements needed to meet
evolving customer needs.
-Coordinates activities with other project teams and workgroups.
-Manages changes impacting data acquisition as identified by BI
governance team and/or data owners.
-Maintains a positive customer-centric environment.
-Coordinates data standards, common data definitions and standard
data management practices across all One IT groups that have
operational data responsibilities.
-Provides management to staff and assistance in hiring decisions,
performance management, coaching and career development.
-Provides mentoring to staff as a means to develop job satisfaction
and coordinates cross training opportunities with other technical
support groups.
-Will require some on-call coverage responsibilities.
Education:
-Bachelor of Science degree in Information Technology or related
technical field required.
Experience:
-7+ years total IT/data warehouse solutions experience required.
-Strong understanding of the data warehouse technical infrastructure
including security, data base administration, ETL environment
administration required.
-3 years data project management experience in a complex, multi-
function, multi-entity environment required.
-3-4 years in supervisory role, mentoring technical staff and
defining and improving development and support processes.
-May substitute an equivalent combination of education and
experience.
-Demonstrated knowledge of data modeling concepts and software
development life cycle processes and methodologies.
-Proficient in programming needed to develop enterprise data
warehouse solutions and knowledge of RDBMS such as Oracle.
-MS Project, Word, Excel, PowerPoint, Project, Visio skills
required.
-Strong interpersonal, written and verbal communication skills.
-Ability to effectively work in a large, geographically diverse
system.
Additional Responsibilities:
-Collaborates with internal BI team as well as BI governance team
and data source owners to ensure timely development of solutions
that load, extract and provide information for the reporting
environment in a timely and effective manner.
-Collaborates with operations team (DBA, SA) and integration
services to maintain optimal system performance.
-Works with enterprise architecture group to integrate data
warehouse into enterprise architecture.
-Demonstrates a commitment to service, organization values and
professionalism through appropriate conduct and demeanor at all
times adheres to and exhibits our core values:
-Reverence: Having a profound spirit of awe and respect for all
creation, shaping relationships to self, to one another and to God
and acknowledging that we hold in trust all that has been given to
us.
-Integrity: Moral wholeness, soundness, uprightness, honesty and
sincerity as a basis of trustworthiness.
-Compassion: Feeling with others, being one with others in their
sorrows and joys, rooted in the sense of solidarity as members of
the human community.
-Excellence: Outstanding achievement, merit, virtue; continually
surpassing standards to achieve/maintain quality.
-Maintains confidentiality and protects sensitive data at all times
-Adheres to organizational and department specific safety standards
and guidelines
-Works collaboratively and supports efforts of team members
-Demonstrates exceptional customer service and interacts effectively
with physicians, patients, residents, visitors, staff and the
broader health care community
Catholic Health Initiatives is an equal opportunity employer.
________________________________________________________________________
3. BI Customer Support Analyst - Englewood, CO
Posted by: "Kathy Garrett" kathy.garrett@futurestep.com recruit516
Date: Tue Apr 15, 2008 3:00 pm ((PDT))
Catholic Health Initiatives currently has two BI Customer Support
Analyst positions available. Qualified and interested candidates
should apply online at www.catholichealthinit.org
Job Summary:
This position is responsible for coordinating with the help desk in
resolving customer support issues with data warehouse.
Essential Duties:
-Performs the customer service operation for the BI environment.
-Provides level 2 support.
-Escalates to other BI staff, as needed, for level 3 support.
-Support user technical support issues as well as usage questions.
-Will require some on-call coverage responsibilities
Education:
-2 year Associate's technical IT degree required.
-Bachelors degree preferred.
-May substitute an equivalent combination of education and
experience.
Experience:
-1-3 years experience working with customer support for IT-related
services required.
-Strong organizational and analytical skills.
-Understanding of the BI technical infrastructure including
security, databases, ETL and reporting environments strongly
preferred.
-MS Project, Word, Excel, PowerPoint, Project, Visio skills
required.
-Strong interpersonal, written and verbal communication skills.
-Ability to effectively work in a large, geographically diverse
system.
Additional Responsibilities:
-Demonstrates a commitment to service, organization values and
professionalism through appropriate conduct and demeanor at all
times.
-Adheres to and exhibits our core values:
-Reverence: Having a profound spirit of awe and respect for all
creation, shaping relationships to self, to one another and to God
and acknowledging that we hold in trust all that has been given to
us.
-Integrity: Moral wholeness, soundness, uprightness, honesty and
sincerity as a basis of trustworthiness.
-Compassion: Feeling with others, being one with others in their
sorrows and joys, rooted in the sense of solidarity as members of
the human community.
-Excellence: Outstanding achievement, merit, virtue; continually
surpassing standards to achieve/maintain quality.
-Maintains confidentiality and protects sensitive data at all times.
-Adheres to organizational and department specific safety standards
and guidelines.
-Works collaboratively and supports efforts of team members.
-Demonstrates exceptional customer service and interacts effectively
with physicians, patients, residents, visitors, staff and the
broader health care community.
Catholic Health Initiatives is an equal opportunity employer.
________________________________________________________________________
4. BI Reports Developer - Englewood, CO
Posted by: "Kathy Garrett" kathy.garrett@futurestep.com recruit516
Date: Tue Apr 15, 2008 3:00 pm ((PDT))
Catholic Health Initiatives is currently seeking a BI Reports
Developer to join its growing BI team. Qualified and interested
candidates please apply online at www.catholichealthinit.org
Job Summary:
This position gathers requirements, designs and develops operational
reports using approved reporting tools (e.g., Business Objects).
Essential Duties:
-Works with business users to define reporting requirements.
-Creates functional and technical specifications for developing
reporting solutions.
-Designs and develops operational reports using Business Objects and
other approved tools, as appropriate for the request.
-Designs and develops dashboards and scorecards for One IT
leadership and governance committees.
-Implements security in the reports based on the user roles and
access privileges.
-Develop test cases to test report solutions.
-Develops reporting documentation.
Education:
-2 year Associate's Technical IT degree
-Bachelor's degree preferred
-May substitute an equivalent combination of education and
experience.
Experience:
-3+ years of experience using reporting tools (Business Objects,
others – TBD) in data warehouse environment required.
-Knowledge of good report design required.
-Ability to translate user reporting requirements into report
solutions required.
Additional Responsibilities:
-Demonstrates a commitment to service, organization values and
professionalism through appropriate conduct and demeanor at all
times.
-Adheres to and exhibits our core values:
-Reverence: Having a profound spirit of awe and respect for all
creation, shaping relationships to self, to one another and to God
and acknowledging that we hold in trust all that has been given to
us.
-Integrity: Moral wholeness, soundness, uprightness, honesty and
sincerity as a basis of trustworthiness.
-Compassion: Feeling with others, being one with others in their
sorrows and joys, rooted in the sense of solidarity as members of
the human community.
-Excellence: Outstanding achievement, merit, virtue; continually
surpassing standards to achieve/maintain quality.
-Maintains confidentiality and protects sensitive data at all times.
-Adheres to organizational and department specific safety standards
and guidelines.
-Works collaboratively and supports efforts of team members.
-Demonstrates exceptional customer service and interacts effectively
with physicians, patients, residents, visitors, staff and the
broader health care community.
Catholic Health Initiatives is an Equal Opportunity Employer.
________________________________________________________________________
8. BI Data Administrator - Englewood, CO
Posted by: "Kathy Garrett" kathy.garrett@futurestep.com recruit516
Date: Tue Apr 15, 2008 7:06 pm ((PDT))
Catholic Health Initiatives is seeking a BI Data Administrator to
join its growing BI group. Qualified and interested candidates
should apply online to www.catholichealthinit.org.
Job Summary:
This position oversees development of standard data definitions
across One IT. This position will ensure the quality of data within
the meta data repository and as related to testing plans and data
cleansing.
Essential Duties:
-Leads efforts to standardize data definitions and ensure
consistency across CHI.
-Maintains and publishes data definitions and business rules within
the meta data repository.
-Develops data cleansing solutions for data quality issues.
-Develops project and testing plans and testing strategies related
to data quality.
-Builds and maintains the data dictionary and meta data repository.
Education:
-Bachelor degree in computer science or related technical field
required.
-May substitute an equivalent combination of education and
experience.
Experience:
-3 to 5 years experience as a data administrator in data warehouse
environment required.
-Experience with data dictionary tools and documenting metadata for
warehouse environments.
-Experience with data standardization projects.
-Knowledge of data elements used in healthcare provider environment
strongly preferred.
Additional Responsibilities:
-Demonstrates a commitment to service, organization values and
professionalism through appropriate conduct and demeanor at all
times.
-Adheres to and exhibits our core values:
-Reverence: Having a profound spirit of awe and respect for all
creation, shaping relationships to self, to one another and to God
and acknowledging that we hold in trust all that has been given to
us.
-Integrity: Moral wholeness, soundness, uprightness, honesty and
sincerity as a basis of trustworthiness.
-Compassion: Feeling with others, being one with others in their
sorrows and joys, rooted in the sense of solidarity as members of
the human community.
-Excellence: Outstanding achievement, merit, virtue; continually
surpassing standards to achieve/maintain quality.
-Maintains confidentiality and protects sensitive data at all times.
-Adheres to organizational and department specific safety standards
and guidelines.
-Works collaboratively and supports efforts of team members.
-Demonstrates exceptional customer service and interacts effectively
with physicians, patients, residents, visitors, staff and the
broader health care community.
Catholic Health Initiatives is an equal opportunity employer.
________________________________________________________________________
9. BI Test Analyst - Englewood, CO
Posted by: "Kathy Garrett" kathy.garrett@futurestep.com recruit516
Date: Tue Apr 15, 2008 7:06 pm ((PDT))
Catholic Health Initiatives is currently seeking a BI Test Analyst
to join their growing BI team. Qualified and interested candidates
should apply online at www.catholichealthinit.org.
Job Summary:
This position creates and refines test plans and test scripts based
on requirements.
Essential Duties:
-Facilitates test case and test script walk-throughs with analysts
and developers.
-Performs manual and automated test execution of the test scripts.
-Reviews automated test results and identifies, analyzes and reports
bugs.
-Provides testing for multi-layer data warehouses.
-Develops and executes test plans and test cases and assists with
preparing testing estimates.
-Create standard test environment to ensure quality through testing
process and improved productivity through standardized testing
processes (wherever possible).
Education:
-2 year Associate's technical IT degree
-May substitute an equivalent combination of education and
experience.
Experience:
-2-3 years experience in testing data warehouses required.
-Displays expertise in testing methodologies and specific
application functionality.
-Experience in logical and physical database design.
-Strong experience with SQL and ETL Development Tools.
-Database knowledge (Oracle, SQL, Teradata, Access).
-Knowledge of key data warehousing processes.
-Ability to effectively manage time, prioritize work, multi-task
across many assignments without reminders or prompting from
management.
-Writes and presents high quality deliverables, reports, and other
documents for internal and/or external audiences.
-Demonstrates awareness of industry trends and best practices in QA
methodology.
-Understands the difference between Operational Systems and
Analytical systems.
-Champion for Data Quality.
-Experience with ad-hoc query tools (Crystal Reports, Business
Objects, SAS, or other).
-Ability to understand and apply system/desktop tools.
Additional Responsibilities:
-Demonstrates a commitment to service, organization values and
professionalism through appropriate conduct and demeanor at all
times.
-Adheres to and exhibits our core values:
-Reverence: Having a profound spirit of awe and respect for all
creation, shaping relationships to self, to one another and to God
and acknowledging that we hold in trust all that has been given to
us.
-Integrity: Moral wholeness, soundness, uprightness, honesty and
sincerity as a basis of trustworthiness.
-Compassion: Feeling with others, being one with others in their
sorrows and joys, rooted in the sense of solidarity as members of
the human community.
-Excellence: Outstanding achievement, merit, virtue; continually
surpassing standards to achieve/maintain quality.
-Maintains confidentiality and protects sensitive data at all times.
-Adheres to organizational and department specific safety standards
and guidelines.
-Works collaboratively and supports efforts of team members.
-Demonstrates exceptional customer service and interacts effectively
with physicians, patients, residents, visitors, staff and the
broader health care community.
Catholic Health Initiatives is an equal opportunity employer.
________________________________________________________________________
10. Data Modeler - Englewood, CO
Posted by: "Kathy Garrett" kathy.garrett@futurestep.com recruit516
Date: Tue Apr 15, 2008 7:06 pm ((PDT))
Catholic Health Initiatives is currently seeking a Data Modeler to
join its growing BI team. Qualified and interested candidates
please apply online at www.catholichealthinit.org.
Job Summary:
This position designs logical and physical data models to support
the data warehouse and data marts as part of the Data Acquisition
and Delivery process.
Essential Duties:
-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.
Education:
-Bachelor of Science degree in Computer Science or a related
technical field required.
-May substitute an equivalent combination of education and
experience.
Experience:
-5+ years of experience in data administration activities and
logical and physical data modeling required.
-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.
Additional Responsibilities:
-Demonstrates a commitment to service, organization values and
professionalism through appropriate conduct and demeanor at all
times.
-Adheres to and exhibits our core values:
-Reverence: Having a profound spirit of awe and respect for all
creation, shaping relationships to self, to one another and to God
and acknowledging that we hold in trust all that has been given to
us.
-Integrity: Moral wholeness, soundness, uprightness, honesty and
sincerity as a basis of trustworthiness.
-Compassion: Feeling with others, being one with others in their
sorrows and joys, rooted in the sense of solidarity as members of
the human community.
-Excellence: Outstanding achievement, merit, virtue; continually
surpassing standards to achieve/maintain quality.
-Maintains confidentiality and protects sensitive data at all times.
-Adheres to organizational and department specific safety standards
and guidelines.
-Works collaboratively and supports efforts of team members.
-Demonstrates exceptional customer service and interacts effectively
with physicians, patients, residents, visitors, staff and the
broader health care community.
Catholic Health Initiatives is an equal opportunity employer.
________________________________________________________________________
11. ETL Developer - Englewood, CO
Posted by: "Kathy Garrett" kathy.garrett@futurestep.com recruit516
Date: Tue Apr 15, 2008 7:07 pm ((PDT))
Catholic Health Initiatives is currently seeking an ETL Developer to
join its growing BI team. Qualified and interested candidates
please apply online to www.catholichealthinit.org.
Job Summary:
This position analyzes, designs, builds, tests and implements
routines to load and maintain the data warehouse using source to
target maps and identifying transformation rules.
Essential Duties:
-Develops Extract-Transform-Load documentation.
-Designs multidimensional data models.
-Defines physical database structures.
-Designs and writes ETL scripts using a variety of tools and custom
database procedures.
-Performs data analysis and profiling.
-Works closely with client personnel to design and implement
scalable and high-performance data warehouse load procedures.
-Configures ETL within client environments.
-Conducts performance load testing.
-Assures that ETL deliverables are completed on-time and within
budget.
Education:
-Bachelor's Science degree in computer science or related technical
field required.
-May substitute an equivalent combination of education and
experience.
Experience:
-4 years experience in a highly critical Operational Data Warehouse
environment working to develop and apply effective solutions for
major Data
-Warehouse applications required.
-Familiar with Informatica and Online Analytical Processing.
-Knowledge of leading practices in loading and maintaining data in
complex data warehouse environments required.
Additional Responsibilities:
-Demonstrates a commitment to service, organization values and
professionalism through appropriate conduct and demeanor at all
times.
-Adheres to and exhibits our core values:
-Reverence: Having a profound spirit of awe and respect for all
creation, shaping relationships to self, to one another and to God
and acknowledging that we hold in trust all that has been given to
us.
-Integrity: Moral wholeness, soundness, uprightness, honesty and
sincerity as a basis of trustworthiness.
-Compassion: Feeling with others, being one with others in their
sorrows and joys, rooted in the sense of solidarity as members of
the human community.
-Excellence: Outstanding achievement, merit, virtue; continually
surpassing standards to achieve/maintain quality.
-Maintains confidentiality and protects sensitive data at all times.
-Adheres to organizational and department specific safety standards
and guidelines.
-Works collaboratively and supports efforts of team members.
-Demonstrates exceptional customer service and interacts effectively
with physicians, patients, residents, visitors, staff and the
broader health care community.
Catholic Health Initiatives and its organizations are Equal
Opportunity Employers
