Skip to main content

This job has expired

Analyst Programmer 2

Employer
Case Western Reserve University
Location
Case Main Campus

View more

Administrative Jobs
Technology, Analysts & Programming
Employment Type
Full Time
Institution Type
Four-Year Institution

Job Details

Job Title: Analyst Programmer 2
Location: Case Main Campus
Regular/Temporary: Regular
Full/Part Time: Full-Time
Job ID: 7811
Job Description

POSITION OBJECTIVE

Working under general supervision, the Biomedical and Patient-Centric Data Modeler and Extract-Transform-Load (ETL) Specialist will be an integral member of the Cleveland Institute for Computational Biology (CICB) Informatics team in 1) understanding multiple biomedical and other patient-centric data models, 2) creating new data models to accommodate new types of biomedical and other patient-centric data, 3) creating ETL scripts to integrate biomedical and other patient-centric data into both existing and newly created data models, 4) creating thorough data dictionaries and data schema to support poorly documented data models and new data models, 5) writing SQL queries against existing, newly created, and combined relational data models and 6) producing training materials for other member of the CICB Translation Informatics Team and external customers and collaborators.

ESSENTIAL FUNCTIONS

    Use existing skills in data modeling to learn the Observational Health Data Sciences and Informatics (OHDSI) Observational Medical Outcomes Partnership (OMOP) Common Data Model (CDM) as well as other patient-centric data models (e.g. PCORnet). Fill in the gaps in the existing publically available documentation. Understand how healthcare data extracted from Electronic Medical Records and other feeder systems fits into the CDM. Develop an understanding of how data is extracted, transformed and loaded from electronic medical records and other feeder systems into the OHDSI OMOP CDM. Determine where other models of biomedical and patient-centric data could also be extracted-transformed-loadedinto the OMOP CDM. Thoroughly document all scripts involved with the ETL mapping. (20%)Create new data models and linkages. Look at biomedical (and other) data models that do not currently fit in the OMOP CDM and develop a model by which linkages between models could be created. Based on project requirements, develop new data models according to CICB standards to accommodate data sources where no model has been defined (e.g. data is currently housed in disparate spreadsheets, lab notebooks, etc.). (10%)Develop data dictionaries and database scheme that can be read, used, and understood by both technical and non-technical personnel, including medical clinicians. Specify tools to help automate this task where necessary. (10%)Write and thoroughly document SQL queries against relational data models, such as the OMOP CDM, in order to satisfy business requirements and research use cases. (10%)Gain familiarity on the data models and functionality in other CICB supported and vendor supplied technologies such as OnCore Enterprise, Labmatrix and APEX. Determine when these technologies are not an applicable solution to user requirements and articulate this clearly to CICB leadership. Create meta-data around all CICB databases (i.e. clinical trials, registries, biobanks) that can be forwarded to the CICB web content manager on a regular basis. (10%)With assistance from UTech, understand the deployment and utilization rules related to the University Secure Research Environment (SRE). Become familiar with the HIPAA Privacy and Security rules and follow appropriate privacy and security procedures when developing data models. (10%)Attend team meetings where business requirements are presented and database solutions are discussed. Propose solutions where no obvious course of action is present. Incorporate requirements, standards and best practices for naming conventions, security, availability, extensibility, scalability, portability, and performance optimization into designs. (10%)Explain and discuss technical problems and proposed solutions competently with research investigators, other developers on team, and staff from other departments (especially UTech). Report project status to manager for all completed and ongoing projects (by email or written report); ensure assigned project documentation is up-to-date and reflects current operations. Present aspects of projects or applications to technical and non-technical audiences. Develop thorough solution documentation - develop and write adequate documentation for users, developers and managers to easily understand, install, configure, use, support and modify data models (e.g. manuals, reports, intranet or extranet web pages, emails, diagrams, data dictionaries, metrics, videos, etc). Document relevant standards, policies and procedures in clear, concise, user-friendly format (eg, data feeds, interfaces, test plans). Create documentation for other groups to better understand and evaluate data models (eg. security, privacy, and IRB forms, grant applications, slides for presentations, etc). (10%)Maintain and enhance relevant technical skills up-to-date through classes, self-study, practice and collaboration with other groups (internal and external) and always deploy best practices in work performed. Learn statistical methods and tools such as R and Shiny. Become familiar with medical coding as it pertains to the OMOP Common Data Model. Become well versed in GIS tools and technologies. Periodically monitor data models to detect errors, data problems and performance issues; interview users to determine where optimizations can be made to the existing workflow through the enhancement data model(s). Promote continuous quality improvement of data. Track issues (data defects) uncovered during data model validation and testing; make plans to correct problems encountered during testing; evaluate proposed fixes for adherence to project goals. Respond quickly and professionally to users reporting problems; exemplifying exceptional customer service. Resolve production problems; support other developers in resolving problems. Guide, assist and train users in creating queries and reports. Strive to understand user goals and reasons for particular requests. Recognize and communicate when queries and reports cannot be produced with the available data. Provide possible alternatives to achieve goals. (10%)

NONESSENTIAL FUNCTIONS

Perform other duties as assigned.

CONTACTS

Department: Daily contact with department chairs, faculty, staff, managers, and research staff.

University: Moderate contact with faculty and administration.

External: Occasional contact with vendors and suppliers.

Students: Frequent contact with undergraduate and graduate students to provide technical support.

SUPERVISORY RESPONSIBILITY

No staff supervisory responsibility.

QUALIFICATIONS

Education/Experience: Associate’s degree in business, computer science, healthcare information technology or related field and 2 years progressive experience or Bachelor’s degree in business, computer science, healthcare information technology or related field and no experience. Experience in healthcare, biostatistics/epidemiology, or other medical research discipline preferred.

REQUIRED SKILLS

    Experience in database design/modelingKnowledge of extract-transform-load (ETL) tools and methods (i.e., DTS, DataStage).Experience in SQL and writing queries against complex database structures. Experience in best practices in computer science and rapid software development methodologies (i.e., AGILE).Experience and/or certification in at least one programming language (i.e., C# or Java, Python).Experience and/or certification using Oracle, MySQL or equivalent relational database technologies.Scripting development experience (Python, Perl, Ruby).Familiarity with source code management tools (Git, Mercurial).Must be organized to effectively manage multiple projects and shifting priorities.Maintain confidentiality as required and appropriate.Possess professional image, attitude and have a customer service focus.Ability to meet consistent attendance. Ability to interact with colleagues, supervisors and customers face-to-face.

WORKING CONDITIONS

Working conditions are typical of an office environment and computer rooms.


var RichTextValue = PTRTEFillcache('https://employment.case.edu/psp/ERECRUIT_newwin/EMPLOYEE/HRMS/c/HRS_HRAM.HRS_APP_SCHJOB.GBL','PT_RTE_IMG_DB_LOC','record://PTRTDB','HRS_SCH_PSTDSC_DESCRLONG$0','1');var TextAreaObject = document.getElementById('HRS_SCH_PSTDSC_DESCRLONG$0');if (typeof(TextAreaObject) != 'undefined' && TextAreaObject != null) TextAreaObject.innerHTML = RichTextValue;Diversity Statement

In employment, as in education, Case Western Reserve University is committed to Equal Opportunity and Diversity. Women, veterans, members of underrepresented minority groups, and individuals with disabilities are encouraged to apply.

.


var RichTextValue = PTRTEFillcache('https://employment.case.edu/psp/ERECRUIT_newwin/EMPLOYEE/HRMS/c/HRS_HRAM.HRS_APP_SCHJOB.GBL','PT_RTE_IMG_DB_LOC','record://PTRTDB','HRS_SCH_PSTDSC_DESCRLONG$1','1');var TextAreaObject = document.getElementById('HRS_SCH_PSTDSC_DESCRLONG$1');if (typeof(TextAreaObject) != 'undefined' && TextAreaObject != null) TextAreaObject.innerHTML = RichTextValue;Reasonable Accommodations

Case Western Reserve University provides reasonable accommodations to applicants with disabilities. Applicants requiring a reasonable accommodation for any part of the application and hiring process should contact the Office of Inclusion, Diversity and Equal Opportunity at 216-368-8877 to request a reasonable accommodation. Determinations as to granting reasonable accommodations for any applicant will be made on a case-by-case basis.

.


var RichTextValue = PTRTEFillcache('https://employment.case.edu/psp/ERECRUIT_newwin/EMPLOYEE/HRMS/c/HRS_HRAM.HRS_APP_SCHJOB.GBL','PT_RTE_IMG_DB_LOC','record://PTRTDB','HRS_SCH_PSTDSC_DESCRLONG$2','1');var TextAreaObject = document.getElementById('HRS_SCH_PSTDSC_DESCRLONG$2');if (typeof(TextAreaObject) != 'undefined' && TextAreaObject != null) TextAreaObject.innerHTML = RichTextValue;

Organization

Working at Case Western Reserve University

Case Western Reserve University is among the nation's leading research institutions. Founded in 1826 and shaped by the unique merger of the Case Institute of Technology and Western Reserve University, Case Western Reserve is distinguished by its strengths in educationresearch, service and experiential learning. Located in Cleveland's University Circle, we offer nationally recognized programs in the arts and sciencesdental medicineengineeringlawmanagementmedicinenursing and social sciences.

Student enrollment exceeds 9,800 students, forty percent of whom are undergraduatesFacultyand students hail from more than 90 countries, with academic interests that reach every region of the world. Case Western Reserve, with the support of individuals, corporations and foundations, aids nearly 100 designated research centers.

As a service-oriented institution dedicated to civic leadership, Case Western Reserve seeks individually and collectively to prepare our students to improve the human condition and to direct the benefits of discovery toward a better society. This effort is not limited to the university's classrooms, laboratories, librariesresidence halls and athletic fields, but includes partnerships with many other institutions. We build these partnerships believing that our ability to improve the human condition should begin in our own community.

Case Western Reserve University remains Ohio's top-ranked school among the nation's premier national universities, as ranked by U.S. News & World Report and is the only Ohio institution ranked in the top 50 nationally. We promote a culture of inquiry marked by rigor, creativity, curiosity, innovation, respect, sensitivity and open communication of ideas.

The university supports interdisciplinary partnerships in education and research with numerous faculty holding joint appointments in more than one Case Western Reserve school or department, as well as at neighboring institutions. These relationships launched many of the unique pairings of science, business and liberal arts into the centers and programs that enhance the undergraduate and graduate experience at the university. Our dual degree programs enrich the educational experience for those students who choose to balance the technical requirements of engineering or the sciences with a strong interest in the humanities.

With more than $375 million in research funding annually, the university attracts outstanding undergraduate and graduate students along with renowned faculty whose research has made significant contributions to the way we live and work. Case Western Reserve counts 15 Nobel laureates among our alumni and current and former faculty, including the first American scientist to ever receive the prize.

Our students' experiences in cultural institutions, clinics, social service agencies and industry are not viewed as “extra-curricular,” but create the learning experience that defines a Case Western Reserve education. The university's service programs in the Cleveland Municipal School District have impacted more than 145,000 students with more than 43 signature programs. The university has launched more than 580 community partnerships on the local, national and international levels. Annually the university sponsors Case for Community Day, an event where hundreds of Case Western Reserve employees and students lend their time and talent to targeted community development projects in the Greater Cleveland area.

Our alumni number more than 110,000 and constitute a “who's who” of every profession. Alumni represent one of the university's strongest resources, playing a vital role in campus life through their work as advisors, mentors, friends and advocates.

Get job alerts

Create a job alert and receive personalized job recommendations straight to your inbox.

Create alert