Johns Hopkins University

Service extract, transform, and load (ETL) requests from the clinical research community for data from our information systems such as and Epic Clarity, Epic Data Warehouse, Sunrise Clinical Manager, CaseMix/DataMart, and EPR2020.. Research informatics support for EPIC, i.e. Cogito data warehouse validation process and data element evaluation for ACO; Continue maintain and support for CRU Online and gSurvey application, build extra reporting and exporting; excel spreadsheet functions for both application for large dataset output; Enhance ICTR Connection request/management system for allowing multiple review scoring sheets and multiple versions for request form.. Ongoing development of online ICTR evaluation/survey tolls and IRB Survey system, Clinical research network investigator information registration form.. This engineer will access systems which contain data for about 5M patients for Johns Hopkins Hospital, Johns Hopkins Bayview Medical Center, Johns Hopkins Community Physicians, Howard County General Hospital, Sibley Memorial Hospital, and Suburban Hospital.. This may include documentation of having two (2) MMR vaccines; two (2) Varicella vaccines; or antibody status to these diseases from laboratory testing.

sr software engineer

We are seeking a Sr. Software Engineer.
Specific Duties & Responsibilities
Service extract, transform, and load (ETL) requests from the clinical research community for data from our information systems such as and Epic Clarity, Epic Data Warehouse, Sunrise Clinical Manager, CaseMix/DataMart, and EPR2020.
This includes the ability to meet with researchers to understand their needs, write a specification that reflects the work to be done, extract data from the appropriate source systems, transform the data to meet the customers' needs, package the data into the appropriate format for transmittal, and set up recurring ETL jobs.
This position will also work on i2b2 as needed. I2b2 is a tool which allows researchers to use a drag and drop user interface to explore deidentified data for research use.
Research informatics support for EPIC, i.e. Cogito data warehouse validation process and data element evaluation for ACO; Continue maintain and support for CRU Online and gSurvey application, build extra reporting and exporting; excel spreadsheet functions for both application for large dataset output; Enhance ICTR Connection request/management system for allowing multiple review scoring sheets and multiple versions for request form.
Trials at Hopkins search engine query not only from depository database but also from clinicaltrials.gov; Centralized JHED login for all applications through ICTR web server, secured with cross site scripting prevention as well as log monitor mechanisms.
Ongoing development of online ICTR evaluation/survey tolls and IRB Survey system, Clinical research network investigator information registration form.
ICTR utility report and email list report; Real-time, on-demand, linked utilization and financial reporting, providing overall budgetary expenditures on yearly grant awards.
Data sharing with current and future institutional databases (e.g., eiRB, EPIC), eiRB feed.
Registry service for ICTR annual events, such as Henrietta Lacks Memorial Lecture and Introduction to Clinical Research Course; Database design services for ICTR supported principal investigators and their study team.
Roles & Interactions
The Sr. Software Engineer will take their primary direction for day-to-day tasks from the ICTR Informatics Project Manager.
They will often interact with their research community customers, including principal investigators, physicians, research nurses, study coordinators, and research data managers to help solve their data needs.
They will also work closely with research informaticians. Specific systems, applications, projects for which the position isresponsible.
This position is responsible for all ICTR Informatics extraction projects tracked in our JIRA system. These projects vary from month to month but in general include extracting, transforming, and loading data.
They must have a good understanding of at least one of our primary information systems (Epic, SCM, EPR) and will be expected to learn the data infrastructure of the remaining applications.
Scale/size of area, project and/or systemsupported.
This engineer will access systems which contain data for about 5M patients for Johns Hopkins Hospital, Johns Hopkins Bayview Medical Center, Johns Hopkins Community Physicians, Howard County General Hospital, Sibley Memorial Hospital, and Suburban Hospital.
Required & Preferred skills specific toposition.
This position requires 4 or more years of experience as a Microsoft SQL server data analysis, with experience in TSQL, SSIS and stored procedure development.
This position requires mastery of clinical data in at least one of the following systems: Epic, Sunrise Clinical Manager, EPR2020, CaseMix/DataMart.
In addition to the technical skills listed, this position requires previous demonstration of good teamwork skills, the ability to write clear requirements and design documents, and the ability to be successfully in direct customer-facing interactions.
On Call Requirements
This position does not currently have on call requirements, however, on call could be introduced in the future to support i2b2.
If that were to occur, then they would share on call responsibilities with teammates, being on call 24x7 about 1 week per month and receiving the standard IT@JH stipend for this service. Primary Purpose
Participate in the development of solutions using extensive programming/analytical expertise for long-term projects to include maintenance, modification or development of applications/solutions.
General Responsibilities
Apply system analysis techniques and procedures to gather and then translate business requirements into high level functional/technical specifications and designs.
Research technology developments and measure their impact on existing standards and application architectures. Coordinate & provide experienced leadership to strategic planning, design, implementation, and verification of software, software system models, platform software advancement and product software.
Serve as a technical resource for the development team working on highly complex applications.
May be required to use technical expertise to install/maintain specialized areas of OS and related software.
Create, review & implement automated facilities that result in cost reduction, operating efficiency and increased user satisfaction.
Work Complexity
Work is complex and varied in nature.
Define and discern key aspects of a problem and develops an integrated solution within a broad technical and business context.
May provide guidance/training to more junior staff.
Recognized expert internally within a discipline. Leadership
Is expected to lead as a technical expert and to participate with senior business leaders to affect change in the environment.
Is a resource/mentor for others within and beyond the organization.
Life Cycle Skills
Serves as project leader for moderate and large projects.
Will be responsible for a significant function/phase of the largest projects.
Degree Of Independence Supervision
Generally, works independently.
Responsible for general oversight of any size project.
Examples are not readily available in existing code or online.
Experience and broad principles guide development.
Serve as a resource to more junior staff.
Training and Mentoring
Participate in a training program jointly developed with their manager/supervisor to gain technical and soft skills.
Serve as technical consultant for both internal and external areas.
Mentor lower-level IT personnel as well as user community with their expert knowledge of the application.
Authority
May oversee work of more junior staff / be a team leader. Minimum Qualifications
Bachelor's Degree.
Six years of related experience.
Additional education may substitute for required experience and additional related experience may substitute for required education, to the extent permitted by the JHU equivalency formula. Preferred Qualifications
Skills and experience that are highly preferred but not required are: use of SSRS, i2b2.
Classified Title: Sr. Software Engineer
Role/Level/Range: ATP/04/PF
Starting Salary Range: Min $84,700 - Max $148,300 Annually ($97.880 targeted; Commensurate with experience)
Employee group: Full Time
Schedule: M-F, 8:30 am - 5:00 pm
Exempt Status:Exempt
Location:Remote
Department name: SOM ICTR Inst Clin Translational Resrch
Personnel area: School of Medicine
Total Rewards
The referenced salary range is based on Johns Hopkins University's good faith belief at the time of posting. Actual compensation may vary based on factors such as geographic location, work experience, market conditions, education/training and skill level. Johns Hopkins offers a total rewards package that supports our employees' health, life, career and retirement. More information can be found here:
Please refer to the job description above to see which forms of equivalency are permitted for this position. If permitted, equivalencies will follow these guidelines:
JHU Equivalency Formula: 30 undergraduate degree credits (semester hours) or 18 graduate degree credits may substitute for one year of experience. Additional related experience may substitute for required education on the same basis. For jobs where equivalency is permitted, up to two years of non-related college course work may be applied towards the total minimum education/experience required for the respective job. **Applicants who do not meet the posted requirements but are completing their final academic semester/quarter will be considered eligible for employment and may be asked to provide additional information confirming their academic completion date. The successful candidate(s) for this position will be subject to a pre-employment background check. Johns Hopkins is committed to hiring individuals with a justice-involved background, consistent with applicable policies and current practice. A prior criminal history does not automatically preclude candidates from employment at Johns Hopkins University. In accordance with applicable law, the university will review, on an individual basis, the date of a candidate's conviction, the nature of the conviction and how the conviction relates to an essential job-related qualification or function.
The Johns Hopkins University values diversity, equity and inclusion and advances these through our key strategic framework, the .
Accommodation Information
If you are interested in applying for employment with The Johns Hopkins University and require special assistance or accommodation during any part of the pre-employment process, please contact the Talent AcquisitionOffice at .For TTY users, call via Maryland Relay or dial 711.For more information about workplace accommodations or accessibility at Johns Hopkins University, please visit .
Johns Hopkins has mandated COVID-19 and influenza vaccines, as applicable. The COVID-19 vaccine does not apply to positions located in the State of Florida. Exceptions to the COVID and flu vaccine requirements may be provided to individuals for religious beliefs or medical reasons. Requests for an exception must be submitted to the JHU vaccination registry. For additional information,applicants for SOM positions should visit and all other JHU applicants should visit.
The following additional provisions may apply, depending on campus.Your recruiter will advise accordingly.
The pre-employment physical for positions in clinical areas, laboratories, working with research subjects, or involving community contact requires documentation of immune status against Rubella (German measles), Rubeola (Measles), Mumps, Varicella (chickenpox), Hepatitis B and documentation of having received the Tdap (Tetanus, diphtheria, pertussis) vaccination. This may include documentation of having two (2) MMR vaccines; two (2) Varicella vaccines; or antibody status to these diseases from laboratory testing. Blood tests for immunities to these diseases are ordinarily included in the pre-employment physical exam except for those employees who provide results of blood tests or immunization documentation from their own health care providers. Any vaccinations required for these diseases will be given at no cost in our Occupational Health office.
Note: Job Postings are updated daily and remain online until filled. #J-18808-Ljbffr

START NEW SEARCH