"The contents of this electronic mail message and any attachments are confidential ... delete this message without disclosing its contents to anyone."
Love the confidentiality notice!
_______________________________________________________________________________________
You can make a difference in the lives of millions of people by being part of an organization that's helping improve health care in Colorado! The Colorado Regional Health Information Organization (CORHIO) offers a fast-paced and collaborative environment in which you will expand your skills among colleagues who value your expertise, energy and willingness to tackle new projects. In the role of Database Developer/DBA you will be responsible for the data warehouse for CORHIO.
CORHIO Overview:
CORHIO is a 501(c)(3) nonprofit organization with a fee for services sales model. www.corhio.org
Our Mission: To facilitate health information exchange to improve care for all Coloradans.
Our Vision: Shared health information for all individuals in every Colorado community promoting the right care at the right time and place.
CORHIO is an organization whose mission is to facilitate health information exchange to improve the care of all Coloradans. Created in 2007, CORHIO serves everyone including consumers, employers, doctors, hospitals, nursing homes, pharmacies, home health agencies, health plans and local health information exchanges that are interested in improving the health of all Coloradans through the use of health information technology.
CORHIO accomplishes this through two main activities: 1) convening/collaborating within and among communities in Colorado and 2) providing secure/confidential technical services in communities. CORHIO receives generous financial support from The Colorado Health Foundation, the State of Colorado, and US Government ARRA funding in the short term. Over the longer term, CORHIO is developing a sustainability model based on fees for services provided. Former Colorado Governor Bill Ritter, Jr. designated CORHIO as the AARA Qualified State-Designated entity for Health Information Exchange.
Position Overview:
The Database Developer/DBA will be responsible for the developing, managing and maintaining the data warehouse for CORHIO. The role will ensure that data is available for use in a variety of ways for the health information exchange. In addition, as part of the Innovation Team at CORHIO, this position will contribute input on new technology opportunities. The Database Developer/DBA will report to the Innovation Development Director and interact with other CORHIO teams.
Responsibilities:
* Data warehouse design including creating clinical data marts to be used as a source for clinical reports.
* Create integration packages and ETL jobs to facilitate the ingest and delivery of clinical and non-clinical data from source to destination systems.
* Create complex SQL statements in order to retrieve data, insert data and modify data in an efficient manner.
* Analyze and provide feedback on existing internal and external data driven solutions.
* Design storage indexes and tables to facilitate simple and complex data driven applications.
* Day-to-day maintenance and administration of SQL server environments including user administration, back-up and recovery, and performance monitoring.
Skills/Qualifications:
* Mid to senior level experience with database technologies
* Healthcare experience helpful
* Data Modeling experience with industry best practices
* Knowledge and experience with Microsoft SSRS or similar software
* Knowledge and experience with Microsoft SSIS or similar software
* Experience with installing, maintaining and developing Microsoft SQL server 2008/2012/2014 Standard and Enterprise
* Competency with T-SQL, CLR and XP command as well as stored procedures and functions
* Competency with data table partitioning and storage strategies for data in an RDBMS
* Understanding of Microsoft Windows server 2008/2012
Work Environment:
* Typical office setting; the CORHIO office is in the Cherry Creek area of Denver, near the intersection of Colorado Blvd. and Cherry Creek Drive South. Opportunities to work from home part-time are available.
Total Compensation:
CORHIO offers a competitive salary and benefits package. Using a CORHIO provided annual cafeteria plan allowance, employees may elect from various benefit offerings and tailor a package to best suit their individual needs. CORHIO employees are eligible to participate in the organization's 403(b) plan and are additionally provided with paid time off, short and long term disability and life insurance. Note: No relocation monies are available.
To Apply:
Please email resume, cover letter, salary history, and 3 references to hiring@corhio.org (please include position title in the subject line). No phone calls please. ABSOLUTELY NO RECRUITERS!
CORHIO is an equal opportunity employer (EOE). CORHIO may, at its discretion, conduct a background check on any workforce member and/or require job candidates to successfully complete a background check as a condition of employment.
Amelia Reinkensmeyer
Human Resources Director
CORHIO - Colorado Regional Health Information Organization
Office 720-285-3219
Cell - 303-250-7040
areinkensmeyer@corhio.org
4500 Cherry Creek S. Dr., Suite 820
Denver, CO 80246
CONFIDENTIALITY NOTICE: The contents of this electronic mail message and any attachments are confidential, possibly privileged and intended for the addressee(s) only. Only the addressee(s) may read, disseminate, retain or otherwise use this message. If received in error, please immediately inform the sender and then delete this message without disclosing its contents to anyone.
